[filburt1]

Today at 02:12 PM Xelation said this in Post #10
when I ran install_usercomment.php I got this error when it tried to run the 3rd query.. what could be wrong?

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: ALTER TABLE "usergroup" ADD "candeleteusercomments"
SMALLINT(6) DEFAULT 0 NOT NULL
mysql error: 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 '"usergroup" ADD "candeleteusercomments"
SMALLINT(6) DEF

mysql error number: 1064

Date: Sunday 13th of April 2003 02:11:37 PM
Script: http://www.texeo.com/web/web/admin/i...es=1&styleid=1
Referer: http://www.texeo.com/web/admin/install_usercomment.php

Anybody else getting this?

Either way I updated the script with a query straight from PMA. Run this query:
[sql]
DROP TABLE usercomment;
[/sql]
Then re-run the install script.