I am in the final steps of testing a new hack for ubbt to let moderators add users to selected groups, but I am getting some errors while creating a new table with the SQL Command box in the admin menu. The table is created correctly, and is usable, but gives the following error:
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\www.newoutriders.org\ubbthreads\mysql.inc.php on line 155
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\www.newoutriders.org\ubbthreads\mysql.inc.php on line 121
Anyone have any ideas? I am using this SQL command, which is copied from Max's Calendar 3.0 hack (which gives the same error btw)
code:
CREATE TABLE w3t_groupmods (
GM_Username varchar(30) NOT NULL,
GM_AddGroup tinyint(3) DEFAULT '3' NOT NULL,
GM_RemoveGroup varchar(1) NOT NULL,
KEY GM_Username (GM_Username)
);