![]() |
|
Thread Tools |
#1
|
||||
|
||||
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:
I know that the1064 erro means that it did not understand the command sent to it. Ideas? No members have liked this post.
|
#2
|
|||
|
|||
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. The following members like this post: TheLastSuperman
|
#3
|
|||
|
|||
That is in the original unmodified vB 4.23. is this what you mean?
No members have liked this post.
|
#4
|
|||
|
|||
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. No members have liked this post.
|
#5
|
||||
|
||||
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.
__________________
Yet Another Awards System - Version 4.0.9 The following members like this post: TheLastSuperman
|
#6
|
|||
|
|||
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. The following members like this post: TheLastSuperman
|
#7
|
||||
|
||||
![]()
Originally Posted by squidsk
Great question!![]()
Originally Posted by justasiam
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! No members have liked this post.
|
![]() |
«
Previous Thread
|
Next Thread
»
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|
New To Site? | Need Help? |
All times are GMT. The time now is 20:19.