Language related bug.

[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?

[tosalet]

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

[abolabo]

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.

[tosalet]

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

[abantecart]

Do you still have this error?

[tosalet]

Yes, no change.

[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?

[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

[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.

[abantecart]

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