Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 22 Apr 2016, 01:51
justasiam justasiam is offline
 
Join Date: Feb 2010
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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

Ideas?
Reply With Quote
  #2  
Old 22 Apr 2016, 01:58
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Open up the file where the error is occurring and remove all occurrences of "TYPE=MyISAM".
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 22 Apr 2016, 02:37
justasiam justasiam is offline
 
Join Date: Feb 2010
That is in the original unmodified vB 4.23. is this what you mean?
Reply With Quote
  #4  
Old 22 Apr 2016, 02:39
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
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.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #5  
Old 22 Apr 2016, 13:37
squidsk's Avatar
squidsk squidsk is offline
 
Join Date: Nov 2010
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.
Reply With Quote
  #6  
Old 22 Apr 2016, 15:31
justasiam justasiam is offline
 
Join Date: Feb 2010
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.
Reply With Quote
  #7  
Old 22 Apr 2016, 22:21
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
 
Join Date: Sep 2008
Real name: Michael Miller Jr
Cool

Originally Posted by squidsk View Post
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!

Originally Posted by justasiam View Post
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.
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.
__________________
Daddy Does Dios and Figs!
https://www.linkedin.com/in/thelastsuperman

Search - Use the search feature to find similar issues/answers.
Information - Include screenshots, copy/pasted error codes, url etc.
Fixed - Please return to your thread/post and let us know how it was fixed!
Thanks - For participating! Click the "Like" on a post if someone helped you!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 20:19.

Layout Options | Width: Wide Color: