View Issue Details

IDProjectCategoryView StatusLast Update
0003103OXID eShop (all versions)6. ------ Setup -------public2011-09-05 16:52
Status resolvedResolutionfixed 
PlatformOSCentos 5OS Version
Product Version 
Target VersionFixed in Version4.5.3 revision 39087 
Summary0003103: Installation error
DescriptionWhen do installation(creating datebase) get error:
ERROR: Issue while inserting this SQL statements: ( SET @@session.sql_mode = \'\'; ): 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

MYSQL 5.0.92
PHP 5.2.17-1
Apache 2.2.17
TagsNo tags attached.
PHP Versionany
Database Versionany



2011-08-26 09:33

reporter   ~0005120

Reminder sent to: aurjus


Sorry, but we cannot reproduce such error localy. Possible that this is very specific case and may depend on the OS and the MySQL configuration.
At first - could you please try one thing:
1. Just comment this line in the database.sql file (in setup/sql dir) and try to run this SQL if all further queries works.
2. Could you please check to what value the MySQL option session.sql_mode is set on your system (in my.cnf file)? And if there is some value set for it, try to set it to " " and then check if this SQL command works).

Best regards,


2011-08-31 08:30

reporter   ~0005148

Hi, I managed to reproduce the behaviour! You get this effect when you try to setup the shop with magic_quotes_runtime php.ini directive set ON. Needs to be fixed.