Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

[Rafael C. <raf...@gm...>]

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
>