vb.org Archive - mysql error number: 1064

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

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

- - mysql error number: 1064 (https://vborg.vbsupport.ru/showthread.php?t=322435)

mysql error number: 1064

I have new installation of vB 4.2.3 and just installed impex so I can import from my old vB 4.0.2 (I think that is the version). Anyway, I configued the ImpExConfig.php to have the database info for the source and target and double-checked the info.
When I click on the "import" link in my ACP, and put in my customer number, I get the following error:

Code:

ImpEx Database error



mysql error: Invalid SQL: CREATE TABLE impexerror (

errorid bigint(20) unsigned NOT NULL auto_increment,

errortype varchar(10) NOT NULL default '',

classnumber varchar(3) NOT NULL default '',

importid bigint(20) NOT NULL default 0,

error varchar(250) default 'NULL',

remedy varchar(250) default 'NULL',

PRIMARY KEY (errorid)

) 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



mysql error number: 1064



Date: Thursday 21st 2016f April 2016 10:41:42 PM

Database: HidingPlaceForums

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

I know that the1064 erro means that it did not understand the command sent to it.

Ideas?

Open up the file where the error is occurring and remove all occurrences of "TYPE=MyISAM".

That is in the original unmodified vB 4.23. is this what you mean?

Well the error is related to creating tables for Impex so I assume you have to modify one of the Impex files where it attempts to create the required table structure.

Wait why are using impex to upgrade an old version of vb to a new one instead of just running the built in upgrade scripts.

Dave, that solved the problem, thank you.

Squidsk, I was trying to a fresh new forum, then decided that I still needed some of the posts from the old one and decided that importing is the better solution.

Quote:

Originally Posted by squidsk (Post 2569386)

Wait why are using impex to upgrade an old version of vb to a new one instead of just running the built in upgrade scripts.

Great question!

Quote:

Originally Posted by justasiam (Post 2569393)

Back when vB4 first came out and many didn't read the upgrade documentation... they bombed their sites, literally... it was a fiasco back then! Long story short the reason why squid ask that is because all of us know you should only use impex to import posts from one vBulletin to another as a last resort. What you should have done and anyone reading this in the future should do is to simply upgrade the site instead of importing. Once done upgrading simply delete what you don't need and then you're set. Using impex in such a way as you've done will yield results yes, however there's a number of factors involved that could potentially cause issues immediately or later down the road.

Upgrading then deleting what you don't need is a much better alternative.

X vBulletin 3.8.12 by vBS Debug 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01039 seconds Memory Usage 1,727KB 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)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: