The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Import problem
I installed Impex, went to import in CP, entered my customer number, and i got this:
There seems to have been a problem with the database. 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: Sunday 11th 2014f May 2014 05:54:28 AM Database: bargainf_vb4 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 ----------------------------------------------------------------------------- All that means nothing to me. Whats gone wrong and how do i fix it? |
#2
|
||||
|
||||
In the /upload/impex/ folder from the impex zip open the index.php file in notepad++ or similar and look at line 271:
PHP Code:
PHP Code:
|
#3
|
|||
|
|||
Still not working.
Here is the new message: There seems to have been a problem with the database. ImpEx Database error mysql error: Link-ID == false, connect failed mysql error: Date: Sunday 18th 2014f May 2014 07:49:28 AM Database: source MySQL error: -------------------------------------------------------------------------- When i uploaded the files to the host, i removed everything from the "system" folder except vb4 and phpbb3 as i am migrating a forum from phpbb3 to VB4. Did i remove more than i should have? Or should i remove vb4 too? |
#4
|
|||
|
|||
Bump.
|
#5
|
|||
|
|||
Anyone?
--------------- Added [DATE]1402031550[/DATE] at [TIME]1402031550[/TIME] --------------- Am i suppose to be editing the impexconfig file? Because the help files make no mention of this (that i can see) http://www.vbulletin.com/docs/html/main/impex_guide |
#6
|
||||
|
||||
Yes, you have to edit that config with your source database and the database you are importing too.
|
#7
|
||||
|
||||
They talk about editing the impex config file here - http://www.vbulletin.com/docs/html/i...rsion=40202500
|
#8
|
|||
|
|||
My new import problem of the day.
I got my old database over to my host, edited the config file with the locations of the old and new database, and gone to run the impex. When i run the first module "Check and update database" the first thing it says is: Warning: Declaration of phpBB3_001::init() should be compatible with ImpExModule::init(&$sessionobject, &$displayobject, &$Db_target, &$Db_source, $resume = false) in ..../impex/systems/phpBB3/001.php on line 146 I'm not sure exactly what this means, and have tried various edits in that 001.php file but i get an error when i run the module. If i don't do any edits to the 001.php file, and click on "check and update database" i get the following: Altering tables ImpEx will now Alter the tables in the vB database to include import id numbers. This is needed during the import process for maintaining references between the tables during an import. If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the original vB userid. moderator - importmoderatorid Completed usergroup - importusergroupid Completed ranks - importrankid Completed poll - importpollid Completed forum - importforumid Completed forum - importcategoryid Completed user - importuserid Completed style - importstyleid Completed thread - importthreadid Completed post - importthreadid Completed thread - importforumid Completed smilie - importsmilieid Completed pmtext - importpmid Completed avatar - importavatarid Completed customavatar - importcustomavatarid Completed customprofilepic - importcustomprofilepicid Completed post - importpostid Completed attachment - importattachmentid Completed pm - importpmid Completed usernote - importusernoteid Completed phrase - importphraseid Completed subscription - importsubscriptionid Completed subscriptionlog - importsubscriptionlogid Completed filedata - importfiledataid Completed Testing source against : phpBB3 ::3.0.3 Valid found tables : Possibly custom tables or incorrect prefix : acl_groups NOT found. acl_options NOT found. acl_roles NOT found. acl_roles_data NOT found. acl_users NOT found. attachments NOT found. banlist NOT found. bbcodes NOT found. bookmarks NOT found. bots NOT found. config NOT found. confirm NOT found. disallow NOT found. drafts NOT found. extension_groups NOT found. extensions NOT found. forums NOT found. forums_access NOT found. forums_track NOT found. forums_watch NOT found. groups NOT found. icons NOT found. lang NOT found. log NOT found. moderator_cache NOT found. modules NOT found. poll_options NOT found. poll_votes NOT found. posts NOT found. privmsgs NOT found. privmsgs_folder NOT found. privmsgs_rules NOT found. privmsgs_to NOT found. profile_fields NOT found. profile_fields_data NOT found. profile_fields_lang NOT found. profile_lang NOT found. ranks NOT found. reports NOT found. reports_reasons NOT found. search_results NOT found. search_wordlist NOT found. search_wordmatch NOT found. sessions NOT found. sessions_keys NOT found. sitelist NOT found. smilies NOT found. styles NOT found. styles_imageset NOT found. styles_template NOT found. styles_template_data NOT found. styles_theme NOT found. topics NOT found. topics_posted NOT found. topics_track NOT found. topics_watch NOT found. user_group NOT found. users NOT found. warnings NOT found. words NOT found. zebra NOT found. If you have all red tables, i.e. none correct this could possible be your table prefix : phpbb3_ Failed Check database permissions and connection, or table prefix to ensure its correct --------------------------------------------------------- So where have i gone wrong? Am i suppose to edit the 001.php file? Line 146 is empty. Exactly what would i copy and paste in there? I didn't want to move onto another module in case not having 001 done caused problems elsewhere. Thanks |
#9
|
||||
|
||||
Do you have a database prefix? Example -- Look at your tables and see if there is a prefix and be sure it is added in the Impex config.
You should not need to edit any of the impex files except the config.. What are you importing too and what are you importing from? Did you choose the right set up? |
#10
|
|||
|
|||
Not that i am aware of.
Quote:
Quote:
The only things i changed in the ImpExConfig.php file is the "target" and "source" parts. The only 2 system folders i uploaded was the phpbb3 and vb4 ones. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|