Ikonboard 2 into Vbulletin 2.3.2

[SimonB]

I keep getting mysql errors everytime I try and import the Ikonboard msg board into the Vbulletin one, this is what I get;

Database error in vBulletin Control Panel 2.3.2:
Invalid SQL: INSERT INTO userfield
	  (userid,field1,field2,field3,field4,importuserid,isnew)
	  VALUES
	  ('73',
	  '',
	  '',
	  '',
	  '',
	  '1',1
	  )
mysql error: Duplicate entry '73' for key 1
mysql error number: 1062

Can anyone help me out? As I am abit baffled by it. Sorry if I have duplicated a thread, I couldn't find one similar to the problem I am having!

Thanks, in advance!

[Steve Machol]

It means that userid already exists. Did you run the import script once before?

[SimonB]

It did that or something very similar when I ran it from scratch though. That's what I didnt get. I will fresh install VB and post whatever the error it gives me.

[SimonB]

Ok, this was the error. When importing in the forums, posts etc

Warning: file(/home/mywebsite/cgi-bin/forum2/list.cgi): failed 
to open stream: Permission denied in /home/mywebsite/www/amb/
importers/bbimport_ib2.php on line 373
Warning: Variable passed to each() is not an array or object 
in /home/mywebsite/www/amb/importers/bbimport_ib2.php on line 374

Obviously the path isnt true, for security purposes. But the CHMOD settings should be right for the ikonboard stuff. Any ideas as to why it's giving up the ghost?

Thanks for any help!

[Steve Machol]

I'm really not familiar with IB or this import script. However the IB database needs to have the same db user as the vB database.

[SimonB]

Ikonboard 2 didn't run on a database, it was cgi. Flat files etc.

[Steve Machol]

The IB files are on the same server, right? Are you using the complete and exact path to the files in the import settings?

[SimonB]

Same server, exact paths.

[Steve Machol]

Well it's giving you a 'Permission denied' error which usually indicates the path is wrong or the directory and/or files in that directory have the wrong permissions. Check the permissions.

If you still have this problem, fill out a support ticket at:

http://www.vbulletin.com/members/support_form.php

Be sure to include the login info to your Admin CP, phpMyAdmin and telnet/ssh.