PDA

View Full Version : phpbb 2.0.22 ----> vb 3.6.4



peterpan 6003
Tue 30th Jan '07, 9:06pm
Type of import: clean
Source board system and version: phpbb2
Target version. : vb 3.6.4
Module issue occurred on. : trying to import?
Any SQL error reported. :"ImpEx Database errormysql error: Invalid SQL: SELECT * FROM phpbb_forums WHERE parent_id = 0

mysql error: Unknown column 'parent_id' in 'where clause'

mysql error number: 1054

Date: Tuesday 30th of January 2007 09:04:28 PM
Database: scott600_phpb3
MySQL error: Unknown column 'parent_id' in 'where clause'"

That is the error I got, I was trying to import members.

The reason I got vb was because the members wanted it. This is turning out to be such a hard thing to do. Are there any mods or impex people that have a service, where for some cash they will do the import for you?

If no, what can I do to fic this error. I have checked and all the files are the same as when I started.

Thanks

Steve Machol
Tue 30th Jan '07, 11:51pm
Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.

Jerry
Wed 31st Jan '07, 12:32am
Ensure you are using the phpBB2 and not the phpBB3 importer.

phpBB2 doesn't have a parent_id, phpBB3 does.

peterpan 6003
Wed 31st Jan '07, 7:52am
I am sure i am not using the phpbb3 imported.

I am using the phpbb2.

I sent in my support ticked and I gave all the info needed. I hope we can get it fixed. I have been up for 19 hours straight and I still can't get it to work.

Thanks for the help Jerry and Steve

Jerry
Wed 31st Jan '07, 12:10pm
Well that SQL is only in the phpBB3 importer so it must of been coming from there. I just checked the ticket that was assigned to me by Marco, logged on, clicked though all the modules without error and updated the counters, I couldn't reproduce the error, and your import looks ok.