PDA

View Full Version : Eve Import Problems



scottct1
Sat 17th Apr '04, 5:40pm
I am working with Jerry on this via the support system, but I need to get this working by the end of the weekend, so I figured I would post my problem here as well and maybe, just maybe someone else has had this problem and figured out a solution.

I am importing from Infopop's EVE system.

I able to go into the import screen and do steps 1 & 2 fine, however when I go to step 3 (Import Users) I get the following MySQL error

Database error in vBulletin:ImpEx Target 3.0.1:

Invalid SQL: UPDATE userfield SET field = '' WHERE userid = '2'
mysql error: Unknown column 'field' in 'field list'

mysql error number: 1054

Any ideas?

This is a unhacked VB 3.01 system. And the file check in step 1 shows no problems.

Thanks

Steve Machol
Sat 17th Apr '04, 8:04pm
What's the complete error, including the script info?

scottct1
Sat 17th Apr '04, 10:44pm
This is it. Again this is when you run the import users function. You get the screen that asks you how many you want to import at a time and if you want to dump the existing memebers list.

Database error in vBulletin:ImpEx Target 3.0.1:

Invalid SQL: UPDATE userfield SET field = '' WHERE userid = '2'
mysql error: Unknown column 'field' in 'field list'

mysql error number: 1054

Date: Saturday 17th of April 2004 04:20:57 PM
Script: http://beta.dishretailer.com/impex/index.php
Referer: http://beta.dishretailer.com/impex/index.php
Username: Scott Greczkowski

Steve Machol
Sun 18th Apr '04, 12:38am
That's strange. I could not find this query in any of the Impex files:

UPDATE userfield SET field UPDATE userfield SET field

I would reupload the original Impex files, making sure you overwrite the ones on the server. If it's not that then fill out a support ticket so we can assign his to Jerry.

scottct1
Sun 18th Apr '04, 9:56am
I tired that and its still happening.

I do have a ticket open and last heard from Jerry yesterday Morning, however this problem is different then the one I first I reported. Should I open a new ticket for this problem? I do understand that it's the weekend and Jerry probably needs time off, but I need to get this working as well.

Thanks everyone!

Nemon
Sun 18th Apr '04, 12:57pm
The import scripts are seriosly bugged.

IPB importer is screwd aswell.

Steve Machol
Sun 18th Apr '04, 4:08pm
I do have a ticket open and last heard from Jerry yesterday Morning, however this problem is different then the one I first I reported. Should I open a new ticket for this problem?
I would just update the current ticket since presumably you have provided Jerry with the access he needs to investigate and fix this problem.

scottct1
Mon 19th Apr '04, 10:59am
Still have not heard back from Jerry (I understand he is busy)

Is it possible for Vbulletin to import the stuff for me?

Steve Machol
Mon 19th Apr '04, 2:57pm
At this time only Jerry can sort out these problems.

Ecron Daemon
Thu 22nd Apr '04, 8:55pm
I've the same problem testing the wbb importer. Any suggestion?

Steve Machol
Thu 22nd Apr '04, 10:13pm
I've the same problem testing the wbb importer. Any suggestion?
Yes. Start your own thread with all the relevant details.