PDA

View Full Version : Import from IPB2 problem



leeman
Sat 13th Nov '04, 1:47pm
When I try to run the import attatchments script i get this :


Database error in vBulletin:ImpEx Target 3.0.3:

Invalid SQL:

INSERT INTO vb3_attachment

(

importattachmentid, filename, filedata,

dateline, visible, counter, filesize,

postid, filehash, userid

)

VALUES

(

'5',

'037_G.jpg',

'ÿØÿà\0JFIF\0\0`\0`\0\0ÿÛ\0C\0

// EDITED OUT GAZILIONS OF MUMBO JUMBO //

Mysql error : Got a packet bigger then 'max_allowed_packet'



I'm migrating from IPB2.0 to VB 3.0.3

And the script just halts.

Zachery
Sat 13th Nov '04, 1:51pm
Well, as the error states, you are trying to import somthing larger than mysql can handel

you need to ask your host about upping the max_allowed_packet to 8 or 16 during the import.

leeman
Wed 17th Nov '04, 2:38pm
Well, as the error states, you are trying to import somthing larger than mysql can handel

you need to ask your host about upping the max_allowed_packet to 8 or 16 during the import.

I forgot to thank you.

That was the problem now site runs like a charm...

Jerry
Wed 17th Nov '04, 2:39pm
Go Zak :)



// EDITED OUT GAZILIONS OF MUMBO JUMBO //


I've got to use that in the code some where :D