As I enable the conference module, i get the below error msg. I am not sure that this is a bug or that i don't know what i am doing. I am new to Drupal; so, pls help.

user warning: 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 'SET utf8 */' at line 6 query: CREATE TABLE conference_decision ( pnid int(10) NOT NULL default '0', decision int(10) NOT NULL default '0', feedback longtext NOT NULL, PRIMARY KEY (`pnid`) ) TYPE=MyISAM /*!40100 DEFAULT CHARSET SET utf8 */; in C:\XamppDru\xampp\htdocs\dru\includes\database.mysql.inc on line 172.

Comments

mfh’s picture

mfh commented

Thanks for your bug report.
As a quick fix, you can edit in the file "conference.install" the line

) TYPE=MyISAM /*!40100 DEFAULT CHARSET SET utf8 */;"

(in the second db_query(...)) which should read:

) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"

I'll fix this today in the distrib.

mfh’s picture

mfh commented
Title: Enable conference » Enable conference - MyQSL error in conference.install
Assigned: Unassigned » mfh
Status: Active » Fixed

The bug is fixed (I hope - feel free to reopen the issue if not).

along the way, I added the planned conf_disable_access() in conf_uninstall()

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)