PDA

View Full Version : Getting error when using Anon Mod


Elixar
02-19-2014, 01:57 PM
https://vborg.vbsupport.ru/showthread.php?t=177694

Database error in vBulletin 4.2.2:

Invalid SQL:

CREATE TABLE forumsfo_anonymous_log (
logid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT(10) UNSIGNED NOT NULL,
dateline INT(10) UNSIGNED NOT NULL,
postid INT(10) UNSIGNED NOT NULL,
threadid INT(10) UNSIGNED NOT NULL,
forumid SMALLINT(5) UNSIGNED NOT NULL,
PRIMARY KEY (logid)
) 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 9
Error Number : 1064
Request Date : Wednesday, February 19th 2014 @ 03:56:12 PM
Error Date : Wednesday, February 19th 2014 @ 03:56:12 PM
Script : *
Referrer : *
IP Address : *
Username : *
Classname : vB_Database
MySQL Version : 5.5.35-cll

vBNinja
02-19-2014, 02:02 PM
Open the xml in a file editor, find "TYPE=MYISAM", delete it, save the file
Then import it again

Lynne
02-19-2014, 10:57 PM
If you have any further questions about the modification (or any modification), then you need to ask in the modification/style thread. That is where the support for modification/style is - not out here in the main forums. Please note that if a modification/style is unsupported (or even if it says it is supported), you may be on your own if you chose to install it.

Elixar
02-20-2014, 01:42 AM
Sorry Lynne about that, wasn't too sure. :)

Solved. ;)