Er.. Impex goes.. blank?

[Dorign]

Bah, 10 minutes into it and I'm already troubleshooting. Hehe, I <3 complicated things, but this time I have to ask questions.

I was doing the impex import thing.. I clicked on "Associate Users" and it said something about deleting user accounts. I clicked "back" and now I can't get back into Impex, everytime I go to "import / export" it just shoes me a blank template page (impex isn't loading on the template).

Erm.. help? :eek: :D

[Jake Bunce]

ImpEx is picky that way. If you interrupt the import process by going back in your browser then it won't let you back in.

You can start over again by deleting two entries from your database:

1) The record in the datastore table with the title "ImpExData".

2) The vbfields table.

You can use a program like phpmyadmin (http://www.phpmyadmin.net/) to do this, or you can run these queries on your database:

DELETE FROM datastore WHERE title = 'ImpExData'

DROP TABLE vbfields

If you use table prefixes then you need to change the table names to include the prefix.

[1996 328ti]

When I got an error message I found that I did not have the proper prefix in the config file. I corrected the config file and too found a blank screen when I went to import again.

I ran the query and got this message.

Error

SQL-query :

DELETE FROM datastore WHERE title = 'ImpExData' DROP TABLE vbfields

MySQL said:


#1064 - You have an error in your SQL syntax near 'DROP TABLE vbfields' at line 1

[1996 328ti]

Well perhaps I can be of use to someone else.
I did some more searching using 'blank impex' and found if I run the query

DELETE FROM datastore WHERE title='ImpExSession';

that might work. Well it did. Impex is now visible again.

[Jake Bunce]

I ran the query and got this message.

Error

SQL-query :

DELETE FROM datastore WHERE title = 'ImpExData' DROP TABLE vbfields

MySQL said:


#1064 - You have an error in your SQL syntax near 'DROP TABLE vbfields' at line 1

Those are two separate queries. You ran them in one line.