PDA

View Full Version : impex problems from php to vb 3.0



INFRAR3D
Fri 6th Aug '04, 1:38am
okay so....
i have tried just about everything to and couldn't connect the two servers, so i downloaded the php board and uploaded it to the vb server, heres the problem, when i try to go ahead import/export its just a blue screen...
im not localhosting it because gamespy doesnt allow that so they are both under the same host username password and database name... i choose phpbb2 clicked users and now i just have the blue screen...

very frustrating please help me out of this jam

Zachery
Fri 6th Aug '04, 1:53am
Run this query and make sure the info in your impexconfig.php is correct.


DELETE FROM datastore WHERE title='ImpExSession';
or

DELETE FROM PREFIX_datastore WHERE title='ImpExSession';
change PREFIX_ to your table prefix.

then try starting again.

INFRAR3D
Fri 6th Aug '04, 2:16am
i didn't put in a prefix

Steve Machol
Fri 6th Aug '04, 2:28am
The use the first query.

INFRAR3D
Fri 6th Aug '04, 2:08pm
i reinstalled the vb and tried everyting over.. i got the same problem, when i got to users there was an error because i had the wrong prefix for the phpboard, so then i changed it and refreshed... then i did what you said and this is what i got:

Invalid SQL: INSERT INTO vb3_vbfields VALUES (2,'forumid','SMALLINT','NO','access','forumid SMALLINT(5) UNSIGNED NOT NULL DEFAULT \'0\'','N','NULL','return true;')
mysql error: Duplicate entry '2' for key 1

Zachery
Fri 6th Aug '04, 4:19pm
You cannot just refresh a page in impex as it generaly will crash it, as impex has already carried out the step and logged it.

Run this query and start the import again.