News:

AbanteCart v1.4.2 is released.

Main Menu

Language related bug.

Started by tosalet, October 21, 2012, 07:47:52 AM

Previous topic - Next topic

tosalet

The cart works perfectly with all browsers on a PC as well as Chrome and  Skyfire on an iPad but it will not open at all using Safari on an iPad.

Error log shows the following:

2012-10-21 11:29:00 - database error:  AbanteCart core v.1.1.1 Error: 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 '' at line 1<br />Error No: 1064<br />INSERT INTO language_definitions (language_id,block,section,language_key,language_value,create_date) VALUES  in <b>/home/e25lapo/public_html/store/core/database/mysql.php</b> on line <b>86</b>

Any ideas? Thanks . . .

abantecart

Based on the error I see it is not browser related error and issue with database insert.

Do you get this error in Admin or Storefront? What page or task are you performing?
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

tosalet

The error occurs when accessing storefront "store/index.php?rt=index/home" but only when using Safari.

abolabo

Quote from: tosalet on October 21, 2012, 11:37:18 AM
The error occurs when accessing storefront "store/index.php?rt=index/home" but only when using Safari.
if you have v1.1.0 try to upgrade your Abantecart up to v.1.1.1.  It's just file replacing upgrade, without sql-changes.
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

tosalet

Thanks for the suggestion but I have already done that . . .

abantecart

Do you still have this error?
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

tosalet


abantecart

I tried my site in Ipad and no issues are found.

Can you post your full URL?
What gen of Ipad and version of OS do you have?
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

tosalet

iPad 2 running IOS6 and the cart is under construction at lapothecary.co.uk/store/index.php?rt=index/home.

I should also add that only Chrome and Atomic Web work correctly. It is only Safari that does not, but only on iPad - the PC version is fine.

Hope that helps . . .

abantecart

My best guess it can be related to language detection of the browser. Check what language do you have set in your Ipad.
If this is not English, it might

Let us know
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

tosalet

That is extraordinary! It was (not unnaturally since that is my home country) set to 'British English'. I have reset it to 'English' (presumably American) and it now works.

Well done . . . and thanks.  Now on to the next problem.

abantecart

We will address this issue in the next release.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

abantecart

#12
There are 2 small bugs that came up related to languages.
If you get error page or can not setup default non-eglish language you need to do below update of the file

NOTE: This will be fixed with next version 1.1.2

Update steps:
replace file core/lib/language.php with attached

Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Forum Rules Code of conduct
AbanteCart.com 2010 -