PDA

View Full Version : Import from Yabb Gold

chrisg13
Mon 2nd Jan '06, 3:11pm
Hi,
I am attempting to import data from Yabb Gold SP 1.3.1 into VBulletin 3.5.2 and am getting the following error message on Module 1:

ImpEx Database errormysql error: Invalid SQL:
INSERT INTO usergroup
(
importusergroupid, title, description,
usertitle, passwordexpires, passwordhistory,
pmquota, pmsendmax, pmforwardmax,
opentag, closetag, canoverride,
ispublicgroup, forumpermissions, pmpermissions,
calendarpermissions, wolpermissions, adminpermissions,
genericpermissions, genericoptions, attachlimit,
avatarmaxwidth, avatarmaxheight, avatarmaxsize,
profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize
)
VALUES
(
'69',
'Imported Users',
'',
'',
0,
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)

mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1
mysql error number: 1366
Date: Monday 02nd of January 2006 01:49:53 PM


Note: I am not clear on the exact path Impex is looking when it asks: "Full Path to YaBB uploads folder" as I do not have any folders labeled upload within Yabb. I have changhed this path to several different things but always get the same mysql error.

Thank you in advance for your assistance.
Steve Machol
Mon 2nd Jan '06, 3:18pm
The is the path to wherever your YaBB attachments are located.
chrisg13
Mon 2nd Jan '06, 3:24pm
attachments?
Steve Machol
Mon 2nd Jan '06, 3:29pm
Yes, attachments.
chrisg13
Mon 2nd Jan '06, 3:46pm
What do you mean by attachments? The messages?
Steve Machol
Mon 2nd Jan '06, 3:52pm
Attachments to the posts, i.e., uploaded files.
chrisg13
Mon 2nd Jan '06, 4:01pm
OK, I believe I have entered the correct paths but I am still getting the same SQL error message in the original post. Any thoughts?
Steve Machol
Mon 2nd Jan '06, 4:03pm
My guess is that either there's something wrong with your YaBB database or the info in your ImpExConfig.php file is wrong. I would check both of these out.
Jerry
Mon 2nd Jan '06, 4:05pm
What MySQL version are you using as I belive it may be a default value issue with the insert.
floydian1
Sun 14th May '06, 2:17am
What ARE you guys talking about?

What ATTACHMENTS to the posts?

Can you give me some kind of an example... give me something to look for?

I keep getting this error on modualy 5... but it doesn't matter cause nothing seems to be coming over anyway.

Fatal error: Call to undefined function: get_yabb2_forum_details() in /home/indianaa/public_html/forums/impex/systems/yabb_gold/005.php on line 115

Please help... I am losing my hair on this one.
Lerner's Permit
Sat 20th May '06, 1:17am
I don't have any uploads and so have no idea what the path would be. The path to my yabb files is /home/usrname/public_html/cgi-bin/yabb/, but where would uploads go?

I've searched this forum and found the same question three times, but no answers. Can you please post an answer?

Thanks in advance
Colin F
Sat 20th May '06, 5:47am
Fatal error: Call to undefined function: get_yabb2_forum_details() in /home/indianaa/public_html/forums/impex/systems/yabb_gold/005.php on line 115

This was a bug in ImpEx. Please redownload the newest files and use these.
Lerner's Permit
Sat 20th May '06, 12:41pm
I don't have any uploads and so have no idea what the path would be. The path to my yabb files is /home/usrname/public_html/cgi-bin/yabb/, but where would uploads go? I answered my own question and so I thought I'd post the answer here for others. I used the same path as for my yabb files and it worked fine.