Is noone having major issues with this product with 4.1? I have sql errors constantly. I had issues installing the product and had to edit the DB create statements and remove the TYPE=MYSAM or whatever to get it to import.
Now when I try to delete forms I get:
Code:
atabase error in vBulletin 4.1.1:
Invalid SQL:
DELETE FROM formbits WHERE fid=1 AND userid = '1';
MySQL Error : Unknown column 'userid' in 'where clause'
Error Number : 1054
Request Date : Wednesday, February 2nd 2011 @ 03:19:20 PM
Error Date : Wednesday, February 2nd 2011 @ 03:19:21 PM
Here's the one I was talking about when I import the product
Code:
Database error in vBulletin 4.1.1:
Invalid SQL:
CREATE TABLE IF NOT EXISTS `forms` (
`fid` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`displayorder` int(10) NOT NULL,
`action` int(3) NOT NULL,
PRIMARY KEY (`fid`)
) TYPE=MyISAM;
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 'TYPE=MyISAM' at line 8
Error Number : 1064