vb.org Archive - Getting error when using Anon Mod

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Getting error when using Anon Mod (https://vborg.vbsupport.ru/showthread.php?t=308604)

Elixar

02-19-2014 01:57 PM

Getting error when using Anon Mod

https://vborg.vbsupport.ru/showthread.php?t=177694

Code:

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. ;)

All times are GMT. The time now is 01:22 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02147 seconds Memory Usage 1,714KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: