Impex stuck in a loop?

[NickGood]

I have got Impex to work well, I am re running it as per instructions.

It now appears to be stuck in a loop. If I select import/ export I get a screen with the import menu flashing and the speaker clicking. When I abort by selecting at the top of the screen 'Database cleanup & restart' I get this message.

Unable to add cookies, header already sent.
File: /home/cruise8/public_html/forums/impex/help.php
Line: 13

I tried 'repairing and optomising tables' as well as 'updating counters' before retrying but get back into the same loop again.

Any ideas?

[Steve Machol]

Reupload all the Impex files. Make sure you upload them in ASCII and overwrite the ones on the server.

[NickGood]

I did this I re-downloaded impex from vBulletin, put the configImpex.php file I'd saved in the Upload folder (which you sorted out for me thanks) and used SmartFTP to replace the existing folders. Im thinking is that your thinking is that the the impex php code has been corrupted.

I'd didnt seem to work, the same thing happened?

Q1 The only thing I can think of now is to uninstall the whole installation and re-install the lot but then I loose all the work I've done on my parameter set up. Any other ideas?

Q2 Associated with this, is there anyway of purging all the imported data off ones vBulletin database without removing/ corrupting the parameters set up as an Admin in vBulletin stored presumably on tables in that database....that is without being a My SQL guru, I have in mind a script that can be uploaded and run to effect this?

[Jerry]

I did this I re-downloaded impex from vBulletin, put the configImpex.php file I'd saved in the Upload folder (which you sorted out for me thanks) and used SmartFTP to replace the existing folders. Im thinking is that your thinking is that the the impex php code has been corrupted.

I'd didnt seem to work, the same thing happened?

Q1 The only thing I can think of now is to uninstall the whole installation and re-install the lot but then I loose all the work I've done on my parameter set up. Any other ideas?

Run this SQL via the admincp :
Import & Maintenance -> Execute SQL Query -> Manual Query.


DELETE FROM datastore WHERE title='ImpExSession';


Ensure that your user is set up to run SQL (includes/config.php at the bottom).

You may need a table prefix if your board has one so if its vb3_:



DELETE FROM vb3_datastore WHERE title='ImpExSession';


Then go back to impex, run the database cleanup and remove all the imported data and session.



Q2 Associated with this, is there anyway of purging all the imported data off ones vBulletin database without removing/ corrupting the parameters set up as an Admin in vBulletin stored presumably on tables in that database....that is without being a My SQL guru, I have in mind a script that can be uploaded and run to effect this?

The Database clean up link in impex, does exactly that.

[NickGood]

I tried this and got

When I ran >DELETE FROM datastore WHERE title='ImpExSession';<

I got:
>An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'cruise8_vbulletin.datastore' doesn't exist<

When I ran ><

>An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'cruise8_vbulletin.vb3_datastore' doesn't exist<

The database crusie8_vbulletin is there, I suspect that my sytax surrounding the way I am detailing the databas is wrong, any ideas?

I could have re installed the whole system by now but I want to resolve this issue because as per the instructions I want to run impex a goodly few times to check things out and I will likely keep hitting the same issue.

[Steve Machol]

What is your vB table prefix?

[NickGood]

Ah Bingo ....the prefix is 1

The database is made up of tables, the table against which the query is run is named 'datastore'. There may be a prefix added ,in my case giving '1datastore'. You can see what that perfix is using PhpMy Admin when you select the database against which your vBulletin Board is running and can see the list of tables. These all have the same prefix, again in my case 1.

Thus the query syntax in my case is

DELETE FROM 1datastore WHERE title='ImpExSession';

Thanks! I'm learning ....slowly