View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003103 | OXID eShop (all versions) | 6. ------ Setup ------- | public | 2011-07-30 11:21 | 2011-09-05 16:52 |
| Reporter | aurjus | Assigned To | |||
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| OS | Centos 5 | ||||
| Fixed in Version | 4.5.3 revision 39087 | ||||
| Summary | 0003103: Installation error | ||||
| Description | When 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 | ||||
| Tags | No tags attached. | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
|
|
Reminder sent to: aurjus Hi, 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, |
|
|
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. |
