我正在尝试使用OpenX 2.8.10 AdServe创建一个新的视频广告,但收到以下错误:
PEAR Error
MDB2 Error: syntax error
_doQuery: [Error message: Could not execute statement]
[Last executed query: CREATE TABLE banner_vast_element_seq (id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (id)) TYPE=MYISAM]
[Native code: 1064]
[Native message: 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 'TYPE=MYISAM' at line 1]
PEAR Error
MDB2 Error: syntax error
[Error message: on demand sequence banner_vast_element could not be created]
PEAR Error
DB_DataObject Error: [mdb2_error: message="MDB2 Error: syntax error" code=-2 mode=callback callback=pearErrorHandler prefix="" info="[Error message: on demand sequence banner_vast_element could not be created] "] 有什么解决方案吗?我如何知道错误发生在哪个PHP类中(当我将TYPE=MyISAM更改为ENGINE=MyISAM时,它就起作用了)。
发布于 2013-04-11 02:36:12
该文件为/lib/pear/MDB2/Driver/Manager/mysql.php。在842行,将TYPE=更改为ENGINE=。
PS:这不是PHP的问题。
https://stackoverflow.com/questions/15930462
复制相似问题