Menu
▾
▴
web-erp-developers
|
From: Rafael C. <raf...@gm...> - 2014-04-05 16:39:27
|
Dear All: In Stocks.php and in StockClone.php, I got this error when I edit (Stocks.php) or clone (StockClone.php) a stock item, after I click the "Update" / "Insert New Item" button (Stocks.php / StockClone.php): Database Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AN)' at line 1 Database SQL Failure : The SQL that failed was SELECT descriptiontranslation, language_id FROM stockdescriptiontranslations WHERE stockid='2000000300030' AN) The company has 3 languages (Spanish -default-) and ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,". When I re-setup ItemDescriptionLanguages, I works,but in a second query the problem reappears. I think the problem is that the variable ItemDescriptionLanguages deletes. Any ideas to where to look for? Best regards, |
|
From: Rafael C. <raf...@gm...> - 2014-04-05 17:26:03
|
Hi Tim,
Thank you, very much. Yes, you are right. When $ItemDescriptionLanguages is
empty, *<pre>$sql = mb_substr($sql,0,mb_strlen($sql)-3) .
')';</pre>*deletes wrong.
I improved <pre>
*$sql = "SELECT descriptiontranslation, language_id FROM
stockdescriptiontranslations WHERE stockid='" . $StockID . "' AND (";
foreach ($ItemDescriptionLanguages as $DescriptionLanguage) { $sql
.= "language_id='" . $DescriptionLanguage ."' OR "; } $sql =
mb_substr($sql,0,mb_strlen($sql)-3) . ')';*
</pre>
with
<pre>
*$sql = "SELECT descriptiontranslation, language_id FROM
stockdescriptiontranslations WHERE stockid='" . $StockID . "'";*
</pre>
(if we want all DescriptionTranslation is not necessary to list each), but
main problem persist: somewhere $ItemDescriptionLanguages becomes empty (or
is not global?).
I appreciate if someone can give me an idea of where this variable is
loaded. I have reviewed Stocks.php, StockClone.php, SystemParameters.php
and SQL_CommonFunctions.inc, and so far I have not found anything that
tells me what can be the cause of $ItemDescriptionLanguages becomes empty.
Best regards, Rafael.
2014-04-05 11:06 GMT-06:00 Tim Schofield <tim...@gm...>:
> Hi Rafael,
>
> I can tell you what is happening but I cannot explain it .Line 937 of
> Stocks.php is as follows:
>
> $sql = "SELECT descriptiontranslation, language_id FROM
> stockdescriptiontranslations WHERE stockid='" . $StockID . "' AND (";
>
> and then there is a loop that is supposed to add some conditions:
>
> $sql .= "language_id='" . $DescriptionLanguage ."' OR ";
>
> and then finally the line
>
> $sql = mb_substr($sql,0,mb_strlen($sql)-3) . ')';
>
> removes the last 3 characters and (which is supposed to be 'OR ' that
> was added to the last condition) and then adds a closing bracket.
> However for some reason the loop is not adding anything and so then
> the last 3 characters added in 937 "D (" are being removed so your SQL
> ends with "AN)" which is obviously wrong, see the error message.
>
> You can verify what I am saying by putting an
>
> echo $sql;
>
> after line 941 but before the DB_query() function call.
>
> For this to happen $ItemDescriptionLanguages must be empty but I
> cannot tell you why. I have tried to force it to happen on my machine
> but cannot replicate it. Check the value of the config variable
> ItemDescriptionLanguages in the config table and see what that says.
>
> Thanks
> Tim
>
> On 5 April 2014 17:39, Rafael Chacón <raf...@gm...>
> wrote:
> > Dear All:
> >
> > In Stocks.php and in StockClone.php, I got this error when I edit
> > (Stocks.php) or clone (StockClone.php) a stock item, after I click the
> > "Update" / "Insert New Item" button (Stocks.php / StockClone.php):
> >
> > Database Error 1064 :
> > You have an error in your SQL syntax; check the manual that
> > corresponds to your MySQL server version for the right syntax to use
> > near 'AN)' at line 1
> > Database SQL Failure : The SQL that failed was
> > SELECT descriptiontranslation, language_id FROM
> > stockdescriptiontranslations WHERE stockid='2000000300030' AN)
> >
> > The company has 3 languages (Spanish -default-) and
> > ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
> >
> > When I re-setup ItemDescriptionLanguages, I works,but in a second
> > query the problem reappears.
> >
> > I think the problem is that the variable ItemDescriptionLanguages
> deletes.
> >
> > Any ideas to where to look for?
> >
> > Best regards,
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> --
> Course View Towers,
> Plot 21 Yusuf Lule Road,
> Kampala
> T +256 (0) 312 314 418
> M +256 (0) 752 963 325
> www.weberpafrica.com
> Twitter: @TimSchofield2
> Blog: http://weberpafrica.blogspot.co.uk/
>
|
|
From: gilberto d. s. a. <gs...@gm...> - 2014-04-05 18:10:52
|
do you use utf-8 or iso-8859-x . please confirm your translation (.po files) and .mo files. in pt-br, before revise all translation file, there are some incorrect code page chars. 2014-04-05 13:39 GMT-03:00 Rafael Chacón <raf...@gm...>: > Dear All: > > In Stocks.php and in StockClone.php, I got this error when I edit > (Stocks.php) or clone (StockClone.php) a stock item, after I click the > "Update" / "Insert New Item" button (Stocks.php / StockClone.php): > > Database Error 1064 : > You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use > near 'AN)' at line 1 > Database SQL Failure : The SQL that failed was > SELECT descriptiontranslation, language_id FROM > stockdescriptiontranslations WHERE stockid='2000000300030' AN) > > The company has 3 languages (Spanish -default-) and > ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,". > > When I re-setup ItemDescriptionLanguages, I works,but in a second > query the problem reappears. > > I think the problem is that the variable ItemDescriptionLanguages deletes. > > Any ideas to where to look for? > > Best regards, > > > ------------------------------------------------------------------------------ > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > -- gilberto dos santos alves +55.11.98646-5049 sao paulo - sp - brasil |
|
From: Rafael C. <raf...@gm...> - 2014-04-05 18:22:11
|
Hi, Gilberto: I use utf-8 as usual. In which files there are some incorrect code page chars? Best regards, Rafael. 2014-04-05 12:10 GMT-06:00 gilberto dos santos alves <gs...@gm...>: > do you use utf-8 or iso-8859-x . please confirm your translation (.po > files) and .mo files. in pt-br, before revise all translation file, there > are some incorrect code page chars. > > > 2014-04-05 13:39 GMT-03:00 Rafael Chacón <raf...@gm...>: > >> Dear All: >> >> In Stocks.php and in StockClone.php, I got this error when I edit >> (Stocks.php) or clone (StockClone.php) a stock item, after I click the >> "Update" / "Insert New Item" button (Stocks.php / StockClone.php): >> >> Database Error 1064 : >> You have an error in your SQL syntax; check the manual that >> corresponds to your MySQL server version for the right syntax to use >> near 'AN)' at line 1 >> Database SQL Failure : The SQL that failed was >> SELECT descriptiontranslation, language_id FROM >> stockdescriptiontranslations WHERE stockid='2000000300030' AN) >> >> The company has 3 languages (Spanish -default-) and >> ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,". >> >> When I re-setup ItemDescriptionLanguages, I works,but in a second >> query the problem reappears. >> >> I think the problem is that the variable ItemDescriptionLanguages deletes. >> >> Any ideas to where to look for? >> >> Best regards, >> >> >> ------------------------------------------------------------------------------ >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > > > > -- > gilberto dos santos alves > +55.11.98646-5049 > sao paulo - sp - brasil > > > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > |
|
From: gilberto d. s. a. <gs...@gm...> - 2014-04-05 18:25:58
|
please visuali confirme your .po for see characters that not have representative visual char, correct them and after that compile .mo and and make your tests. 2014-04-05 15:22 GMT-03:00 Rafael Chacón <raf...@gm...>: > Hi, Gilberto: > > I use utf-8 as usual. In which files there are some incorrect code page > chars? > > Best regards, Rafael. > > > > > 2014-04-05 12:10 GMT-06:00 gilberto dos santos alves <gs...@gm...>: > > do you use utf-8 or iso-8859-x . please confirm your translation (.po >> files) and .mo files. in pt-br, before revise all translation file, there >> are some incorrect code page chars. >> >> >> 2014-04-05 13:39 GMT-03:00 Rafael Chacón <raf...@gm...> >> : >> >>> Dear All: >>> >>> In Stocks.php and in StockClone.php, I got this error when I edit >>> (Stocks.php) or clone (StockClone.php) a stock item, after I click the >>> "Update" / "Insert New Item" button (Stocks.php / StockClone.php): >>> >>> Database Error 1064 : >>> You have an error in your SQL syntax; check the manual that >>> corresponds to your MySQL server version for the right syntax to use >>> near 'AN)' at line 1 >>> Database SQL Failure : The SQL that failed was >>> SELECT descriptiontranslation, language_id FROM >>> stockdescriptiontranslations WHERE stockid='2000000300030' AN) >>> >>> The company has 3 languages (Spanish -default-) and >>> ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,". >>> >>> When I re-setup ItemDescriptionLanguages, I works,but in a second >>> query the problem reappears. >>> >>> I think the problem is that the variable ItemDescriptionLanguages >>> deletes. >>> >>> Any ideas to where to look for? >>> >>> Best regards, >>> >>> >>> ------------------------------------------------------------------------------ >>> _______________________________________________ >>> Web-erp-developers mailing list >>> Web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>> >> >> >> >> -- >> gilberto dos santos alves >> +55.11.98646-5049 >> sao paulo - sp - brasil >> >> >> >> >> >> >> ------------------------------------------------------------------------------ >> >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > -- gilberto dos santos alves +55.11.98646-5049 sao paulo - sp - brasil |
|
From: Rafael C. <raf...@gm...> - 2014-04-05 18:51:39
|
Hi Gilberto, I am not sure if this is related with the SELECT Error in Stocks.php and StockClone.php. I am going to review the Spanish and French .po files. Best regards, Rafael. 2014-04-05 12:25 GMT-06:00 gilberto dos santos alves <gs...@gm...>: > please visuali confirme your .po for see characters that not have > representative visual char, correct them and after that compile .mo and and > make your tests. > > > 2014-04-05 15:22 GMT-03:00 Rafael Chacón <raf...@gm...>: > > Hi, Gilberto: >> >> I use utf-8 as usual. In which files there are some incorrect code page >> chars? >> >> Best regards, Rafael. >> >> >> >> >> 2014-04-05 12:10 GMT-06:00 gilberto dos santos alves <gs...@gm...>: >> >> do you use utf-8 or iso-8859-x . please confirm your translation (.po >>> files) and .mo files. in pt-br, before revise all translation file, there >>> are some incorrect code page chars. >>> >>> >>> 2014-04-05 13:39 GMT-03:00 Rafael Chacón <raf...@gm... >>> >: >>> >>>> Dear All: >>>> >>>> In Stocks.php and in StockClone.php, I got this error when I edit >>>> (Stocks.php) or clone (StockClone.php) a stock item, after I click the >>>> "Update" / "Insert New Item" button (Stocks.php / StockClone.php): >>>> >>>> Database Error 1064 : >>>> You have an error in your SQL syntax; check the manual that >>>> corresponds to your MySQL server version for the right syntax to use >>>> near 'AN)' at line 1 >>>> Database SQL Failure : The SQL that failed was >>>> SELECT descriptiontranslation, language_id FROM >>>> stockdescriptiontranslations WHERE stockid='2000000300030' AN) >>>> >>>> The company has 3 languages (Spanish -default-) and >>>> ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,". >>>> >>>> When I re-setup ItemDescriptionLanguages, I works,but in a second >>>> query the problem reappears. >>>> >>>> I think the problem is that the variable ItemDescriptionLanguages >>>> deletes. >>>> >>>> Any ideas to where to look for? >>>> >>>> Best regards, >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> _______________________________________________ >>>> Web-erp-developers mailing list >>>> Web...@li... >>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>>> >>> >>> >>> |
|
From: Rafael C. <raf...@gm...> - 2014-04-05 18:48:42
|
Hi Tim,
Thank you, very much. I am going to recheck GetConfig.php.
Best regards, Rafael.
---------- Forwarded message ----------
From: Tim Schofield <tim...@gm...>
Date: 2014-04-05 12:41 GMT-06:00
Subject: Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT
To: Rafael Emilio Chacon <raf...@gm...>
The variable is loaded in includes/GetConfig.php which loads the
entire config table into the session array in the form of
$_SESSION[confname]=confvalue;
Thanks
Tim
On 5 April 2014 18:25, Rafael Chacón <raf...@gm...> wrote:
> Hi Tim,
>
> Thank you, very much. Yes, you are right. When $ItemDescriptionLanguages
is
> empty, <pre>$sql = mb_substr($sql,0,mb_strlen($sql)-3) . ')';</pre>
deletes
> wrong.
>
> I improved <pre>
> $sql = "SELECT descriptiontranslation, language_id FROM
> stockdescriptiontranslations WHERE stockid='" . $StockID . "' AND (";
> foreach ($ItemDescriptionLanguages as $DescriptionLanguage) {
>
> $sql .= "language_id='" . $DescriptionLanguage ."' OR ";
> }
> $sql = mb_substr($sql,0,mb_strlen($sql)-3) . ')';
>
> </pre>
> with
> <pre>
> $sql = "SELECT descriptiontranslation, language_id FROM
> stockdescriptiontranslations WHERE stockid='" . $StockID . "'";
> </pre>
> (if we want all DescriptionTranslation is not necessary to list each),
but
> main problem persist: somewhere $ItemDescriptionLanguages becomes empty
(or
> is not global?).
>
> I appreciate if someone can give me an idea of where this variable is
> loaded. I have reviewed Stocks.php, StockClone.php, SystemParameters.php
and
> SQL_CommonFunctions.inc, and so far I have not found anything that tells
me
> what can be the cause of $ItemDescriptionLanguages becomes empty.
>
> Best regards, Rafael.
>
>
> 2014-04-05 11:06 GMT-06:00 Tim Schofield <tim...@gm...>:
>
>> Hi Rafael,
>>
>> I can tell you what is happening but I cannot explain it .Line 937 of
>> Stocks.php is as follows:
>>
>> $sql = "SELECT descriptiontranslation, language_id FROM
>> stockdescriptiontranslations WHERE stockid='" . $StockID . "' AND (";
>>
>> and then there is a loop that is supposed to add some conditions:
>>
>> $sql .= "language_id='" . $DescriptionLanguage ."' OR ";
>>
>> and then finally the line
>>
>> $sql = mb_substr($sql,0,mb_strlen($sql)-3) . ')';
>>
>> removes the last 3 characters and (which is supposed to be 'OR ' that
>> was added to the last condition) and then adds a closing bracket.
>> However for some reason the loop is not adding anything and so then
>> the last 3 characters added in 937 "D (" are being removed so your SQL
>> ends with "AN)" which is obviously wrong, see the error message.
>>
>> You can verify what I am saying by putting an
>>
>> echo $sql;
>>
>> after line 941 but before the DB_query() function call.
>>
>> For this to happen $ItemDescriptionLanguages must be empty but I
>> cannot tell you why. I have tried to force it to happen on my machine
>> but cannot replicate it. Check the value of the config variable
>> ItemDescriptionLanguages in the config table and see what that says.
>>
>> Thanks
>> Tim
>>
>> On 5 April 2014 17:39, Rafael Chacón <raf...@gm...>
>> wrote:
>> > Dear All:
>> >
>> > In Stocks.php and in StockClone.php, I got this error when I edit
>> > (Stocks.php) or clone (StockClone.php) a stock item, after I click the
>> > "Update" / "Insert New Item" button (Stocks.php / StockClone.php):
>> >
>> > Database Error 1064 :
>> > You have an error in your SQL syntax; check the manual that
>> > corresponds to your MySQL server version for the right syntax to use
>> > near 'AN)' at line 1
>> > Database SQL Failure : The SQL that failed was
>> > SELECT descriptiontranslation, language_id FROM
>> > stockdescriptiontranslations WHERE stockid='2000000300030' AN)
>> >
>> > The company has 3 languages (Spanish -default-) and
>> > ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
>> >
>> > When I re-setup ItemDescriptionLanguages, I works,but in a second
>> > query the problem reappears.
>> >
>> > I think the problem is that the variable ItemDescriptionLanguages
>> > deletes.
>> >
>> > Any ideas to where to look for?
>> >
>> > Best regards,
>> >
>> >
>> >
------------------------------------------------------------------------------
>> > _______________________________________________
>> > Web-erp-developers mailing list
>> > Web...@li...
>> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
|
|
From: Phil D. <ph...@lo...> - 2014-04-05 21:30:51
|
In Stocks.php - line 23
$ItemDescriptionLanguages =
explode(',',$_SESSION['ItemDescriptionLanguages']);
So in SystemParameters.php - we set a
confname='ItemDescriptionLanguages' to a comma separated list of locales
that we wish to maintain language descriptions for our items.
Perhaps your configuration has been messed up and this config option not
set for some reason.
Regards
Phil
Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz
On 06/04/14 04:39, Rafael Chacón wrote:
> Dear All:
>
> In Stocks.php and in StockClone.php, I got this error when I edit
> (Stocks.php) or clone (StockClone.php) a stock item, after I click the
> "Update" / "Insert New Item" button (Stocks.php / StockClone.php):
>
> Database Error 1064 :
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'AN)' at line 1
> Database SQL Failure : The SQL that failed was
> SELECT descriptiontranslation, language_id FROM
> stockdescriptiontranslations WHERE stockid='2000000300030' AN)
>
> The company has 3 languages (Spanish -default-) and
> ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
>
> When I re-setup ItemDescriptionLanguages, I works,but in a second
> query the problem reappears.
>
> I think the problem is that the variable ItemDescriptionLanguages deletes.
>
> Any ideas to where to look for?
>
> Best regards,
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
|
|
From: Rafael C. <raf...@gm...> - 2014-04-05 21:39:48
|
Hi Phil,
Thank you, very much. Yes, the problem was caused by this line:
$ItemDescriptionLanguages =
explode(',',$_SESSION['ItemDescriptionLanguages']);
$ItemDescriptionLanguages is an array, and
$_SESSION['ItemDescriptionLanguages']
is a vector (one dimension variable).
I am now testing the fix in Stocks.php and StockClone.php. No problem at
the moment...
Best regards, Rafael.
2014-04-05 15:30 GMT-06:00 Phil Daintree <ph...@lo...>:
>
> In Stocks.php - line 23
>
> $ItemDescriptionLanguages =
> explode(',',$_SESSION['ItemDescriptionLanguages']);
>
> So in SystemParameters.php - we set a
> confname='ItemDescriptionLanguages' to a comma separated list of locales
> that we wish to maintain language descriptions for our items.
>
> Perhaps your configuration has been messed up and this config option not
> set for some reason.
>
> Regards
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 06/04/14 04:39, Rafael Chacón wrote:
> > Dear All:
> >
> > In Stocks.php and in StockClone.php, I got this error when I edit
> > (Stocks.php) or clone (StockClone.php) a stock item, after I click the
> > "Update" / "Insert New Item" button (Stocks.php / StockClone.php):
> >
> > Database Error 1064 :
> > You have an error in your SQL syntax; check the manual that
> > corresponds to your MySQL server version for the right syntax to use
> > near 'AN)' at line 1
> > Database SQL Failure : The SQL that failed was
> > SELECT descriptiontranslation, language_id FROM
> > stockdescriptiontranslations WHERE stockid='2000000300030' AN)
> >
> > The company has 3 languages (Spanish -default-) and
> > ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
> >
> > When I re-setup ItemDescriptionLanguages, I works,but in a second
> > query the problem reappears.
> >
> > I think the problem is that the variable ItemDescriptionLanguages
> deletes.
> >
> > Any ideas to where to look for?
> >
> > Best regards,
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
|
|
From: ExsonQu <hex...@gm...> - 2014-04-06 01:48:35
|
*Hi, Rafael*
Thank you for your fix.
I've received the bug report several weeks before. I could not find the
reason just found that the system parameters cannot be updated.
Thanks again!
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Stocks-php-StockClone-php-Error-in-SELECT-tp4657327p4657338.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
|
From: Rafael C. <raf...@gm...> - 2014-04-07 14:29:12
|
Hi Exson, You are welcome! Best regards, Rafael. 2014-04-05 19:47 GMT-06:00 ExsonQu <hex...@gm...>: > *Hi, Rafael* > > Thank you for your fix. > I've received the bug report several weeks before. I could not find the > reason just found that the system parameters cannot be updated. > Thanks again! > > Best regards! > > Exson > > > > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Stocks-php-StockClone-php-Error-in-SELECT-tp4657327p4657338.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
|
From: Rafael C. <raf...@gm...> - 2014-05-26 07:01:25
|
Hi, I see other cases and I fixed, but I see two other problems: 1. On "config" table, for the field confname='ItemDescriptionLanguages', we have a coma (,) at the end in field confvalue (e.g. ''en_US.utf8,fr_FR.utf8," --last comma--). That causes that ItemDescriptionLanguagesArray has n+1 languages. How we fix this? 2. When there is no translated description field, it is not possible to update. We have to delete all translations and inset all the translations. Regards, Rafael. 2014-04-07 8:29 GMT-06:00 Rafael Chacón <raf...@gm...>: > Hi Exson, > > You are welcome! > > Best regards, Rafael. > > > 2014-04-05 19:47 GMT-06:00 ExsonQu <hex...@gm...>: > > *Hi, Rafael* >> >> Thank you for your fix. >> I've received the bug report several weeks before. I could not find >> the >> reason just found that the system parameters cannot be updated. >> Thanks again! >> >> Best regards! >> >> Exson >> >> >> >> >> >> >> -- >> View this message in context: >> http://weberp-accounting.1478800.n4.nabble.com/Stocks-php-StockClone-php-Error-in-SELECT-tp4657327p4657338.html >> Sent from the web-ERP-developers mailing list archive at Nabble.com. >> >> >> ------------------------------------------------------------------------------ >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > > |
|
From: Phil D. <ph...@lo...> - 2014-05-26 07:14:44
|
I think the last element is ignored or trapped in the Stocks.php script Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 26/05/14 19:01, Rafael Chacón wrote: > Hi, > > I see other cases and I fixed, but I see two other problems: > > 1. On "config" table, for the field > confname='ItemDescriptionLanguages', we have a coma (,) at the end in > field confvalue (e.g. ''en_US.utf8,fr_FR.utf8," --last comma--). That > causes that ItemDescriptionLanguagesArray has n+1 languages. How we > fix this? > > 2. When there is no translated description field, it is not possible > to update. We have to delete all translations and inset all the > translations. > > Regards, Rafael. > > > > > 2014-04-07 8:29 GMT-06:00 Rafael Chacón > <raf...@gm... <mailto:raf...@gm...>>: > > Hi Exson, > > You are welcome! > > Best regards, Rafael. > > > 2014-04-05 19:47 GMT-06:00 ExsonQu <hex...@gm... > <mailto:hex...@gm...>>: > > *Hi, Rafael* > > Thank you for your fix. > I've received the bug report several weeks before. I could > not find the > reason just found that the system parameters cannot be updated. > Thanks again! > > Best regards! > > Exson > > > > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Stocks-php-StockClone-php-Error-in-SELECT-tp4657327p4657338.html > Sent from the web-ERP-developers mailing list archive at > Nabble.com. > > ------------------------------------------------------------------------------ > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > <mailto:Web...@li...> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > > ------------------------------------------------------------------------------ > The best possible search technologies are now affordable for all companies. > Download your FREE open source Enterprise Search Engine today! > Our experts will assist you in its installation for $59/mo, no commitment. > Test it for FREE on our Cloud platform anytime! > http://pubads.g.doubleclick.net/gampad/clk?id=145328191&iu=/4140/ostg.clktrk > > > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X