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.
Powered by vBulletin™ Version 4.0.0 Beta 4 Copyright © 2009 vBulletin Solutions, Inc. All rights