Traceback Traceback (most recent call last): File "/usr/bin/cubicweb-ctl", line 4, in <module> run(sys.argv[1:]) File "/home/arthur/src/public/cubicweb/cubicweb/cwctl.py", line 1001, in run CWCTL.run(args) File "/home/arthur/src/public/cubicweb/logilab/common/clcommands.py", line 134, in run sys.exit(command.main_run(args, rcfile)) File "/home/arthur/src/public/cubicweb/logilab/common/clcommands.py", line 263, in main_run self.run(args) File "/home/arthur/src/public/cubicweb/cubicweb/server/serverctl.py", line 363, in run createdb(helper, source, dbcnx, cursor) File "/home/arthur/src/public/cubicweb/cubicweb/server/serverctl.py", line 290, in createdb dbencoding=source['db-encoding'], **kwargs) File "/home/arthur/src/public/cubicweb/logilab/database/mysql.py", line 223, in create_database cursor.execute(self.sql_create_database(dbname, dbencoding)) File "/usr/lib/pymodules/python2.7/MySQLdb/cursors.py", line 166, in execute self.errorhandler(self, exc, value) File "/usr/lib/pymodules/python2.7/MySQLdb/connections.py", line 35, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.ProgrammingError: (1064, '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 \'"mydatabse" CHARACTER SET utf8\' at line 1') | |
| priority | normal |
|---|---|
| type | bug |
| appeared in | <not specified> |
| done in | <not specified> |
| closed by | <not specified> |


#87112 Mysql create database fails on SQL syntax
Comments
-
2012/01/10 14:58, written by alutz
| reply to this comment
(add comment)replacing " by ` on either side of the database name seems to work but I don't know if it is the correct fix