View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001786 | OXID eShop (all versions) | 6. ------ Setup ------- | public | 2010-04-23 11:54 | 2010-04-28 14:06 |
| Reporter | Moehlis | Assigned To | |||
| Priority | normal | Severity | tweak | Reproducibility | always |
| Status | resolved | Resolution | no change required | ||
| Summary | 0001786: setup cannot create database with special chars | ||||
| Description | when trying to create database called "OXID_ESHOP_EE_4.3.0_26948_SOURCE" while processing shop setup, will result in: FEHLER: (Tabellen)Probleme mit folgenden SQL Befehlen: ( create database OXID_ESHOP_EE_4.3.0_26948_SOURCE ): 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 '.3.0_26948_SOURCE' at line 1 | ||||
| Additional Information | solution may be just to add ` to the databasename in oxsetup.php:779 (CE rev 26948) is: if ( !$this->execSql( "create database ". $sDbName ) ) { should: if ( !$this->execSql( "create database `". $sDbName ."`" ) ) { | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
|
|
Reminder sent to: Moehlis Hello, this is not a bug. mysql does not support "." symbol in database names at all, thats why you get this error. escaping database name would not help in this case. according mysql documentation, database and table names cannot contain “/”, “\”, “.”, or other characters that are not allowed in file names. best regards, |
|
|
not a bug. more information about recommendations for database names can be found in mysql documentation at http://dev.mysql.com/doc/refman/5.0/en/identifiers.html |
