PDA

View Full Version : Problem with importing from PHPbb

artvs
Tue 21st Nov '06, 6:34pm
Hello
During the import process I've got following error:

ImpEx Database errormysql error: Invalid SQL:
SELECT post_text,post_subject FROM cpfrm_posts_text
WHERE
post_id=


mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

mysql error number: 1064

Date: Wednesday 22nd of November 2006 01:23:21 AM
Database: u21293
MySQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

It occurs after successful import of ~2086 post.
It seems that it is because of missing post_id = 2087 in the table above.
Is there way to continue import from post_id=2088?
Thanks for the answer and sorry for my English.
Artyem
Steve Machol
Tue 21st Nov '06, 6:39pm
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.
artvs
Tue 21st Nov '06, 6:46pm
Steve, thanks for the fast answer.
Can you explain me what namely I should describe in detail?
Thanks,
Artyem
pedantic
Wed 22nd Nov '06, 6:10am
I got the same problem with ImpEx 1.72 and vB 3.6.3, altough the ImpEx is skipping post_ids serveral times before failing like this. :(

Last week I did a test Import with 1.70 to 3.6.2 with the same DB dump, no such problem. :(

I'll send you guys a ticket.
Jerry
Thu 23rd Nov '06, 5:52pm
Fixed in 1.73 which will be out in the next 24 hours.
artvs
Fri 24th Nov '06, 5:03am
Jerry, could you please show in member area number of the current version of ImpEx available for downloading? Like version of vbulletin.
Thanks,
Artyem.
Quenthel
Fri 24th Nov '06, 4:51pm
Well, I faced the same problem, and found out that there were some phpbb_post rows, that didn't had an association with the phpbb_post_text table.

Lacking referential integrity can lead to problems like these, but it was easy to solve. I just had to delete these orphan rows, and everything proceeded smoothly.
Jerry
Fri 24th Nov '06, 5:11pm
Jerry, could you please show in member area number of the current version of ImpEx available for downloading? Like version of vbulletin.
Thanks,
Artyem.

1.73 is out now and it handles the broken referential integrity in the phpBB2 database.
artvs
Fri 24th Nov '06, 5:27pm
Jerry, are you sure that impex archive is normal? I can see in it some strange files like moo.txt or test.txt but ImpEx folder is empty :(