Log in

View Full Version : Import Attachment fails, ImpEx Database errormysql error...


hiker
12-19-2009, 05:50 PM
Hi everybody, I'm not getting any answers on the .com forum, so I hope I'm not out of line by posting this here.

I've started fresh, importing from a phpbb 2 forum with Impex. Each step has gone smoothly on the import modules, until the Attachments.

It runs through about 60+ attachments, and then gets to a .wmv file @ 800 kb in size, and then I see this error:

66.67% Attachment -> poison_spider_2.jpg
66.67% Attachment -> poison_spider_1.jpg
66.67% Attachment -> bumper.wmv

There seems to have been a problem with the database.

ImpEx Database errormysql error: Invalid SQL:
UPDATE attachment
SET
filedata = '0&²uŽfϦÙ......
(non legible text)
......filesize = 1929851
WHERE attachmentid = 174

mysql error: Got a packet bigger than 'max_allowed_packet' bytes

mysql error number: 1153

Date: Friday 18th 2009f December 2009 04:44:00 PM
Database: bogley_vbdevforum
MySQL error:

__________________________________________________ ________________

I've been able to import these attachments previously. I decided to start over because of an unrelated issue.

This happened the first time, I assumed it was because certain attachments were too big, so I removed them from the source files. The imports then proceeded perfectly. This recent .wmv attachment was able to import previously.

Any ideas would be appreciated. Thanks.

Lynne
12-19-2009, 06:16 PM
Impex problems need to be handled in the Impex forums on vb.com . I'm sure someone will get around to helping you, but you need to be patient.

hiker
12-19-2009, 06:22 PM
ok, thank you for the response. :)

By the way, I'm starting to think I might just pay for the installation. Could you direct me to that service?

Lynne
12-19-2009, 06:36 PM
Try vbulletin.com . That is their main page.