vb.org Archive - vbadvance error

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

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

- - vbadvance error (https://vborg.vbsupport.ru/showthread.php?t=325468)

rockerzteam

08-02-2017 03:21 AM

vbadvance error

Code:

Database error in vBulletin 3.8.7:



Invalid SQL:



                CREATE TABLE IF NOT EXISTS adv_setting (

                        varname varchar(100) NOT NULL default '',

                        grouptitle varchar(50) NOT NULL default '',

                        value mediumtext NOT NULL,

                        defaultvalue varchar(250) NOT NULL default '',

                        optioncode mediumtext NOT NULL,

                        displayorder smallint(3) unsigned NOT NULL default '0',

                        serialize smallint(3) unsigned NOT NULL default '0'

                ) 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, August 2nd 2017 @ 12:16:23 AM

Error Date    : Wednesday, August 2nd 2017 @ 12:16:23 AM

Script        : http://www.xxxxxxxx.com/admincp/vbacmps_install.php

Referrer      : http://www.xxxxxxx.com/admincp/vbacmps_install.php

IP Address    :

Username      : Admin

Classname     : vB_Database

MySQL Version : 5.5.51-38.2

Brandon Sheley

08-02-2017 06:29 PM

<a href="http://www.vbadvanced.com/forum/showthread.php?42814-Database-error-on-install&p=197808#post197808" target="_blank">http://www.vbadvanced.com/forum/show...808#post197808</a>

rockerzteam

08-02-2017 08:42 PM

Thanks a million!

All times are GMT. The time now is 05:34 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00916 seconds Memory Usage 1,711KB 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 (3)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: