Archive for Before posting please check the "stickies" in the support forums.
Please ask questions in real English and not "txt". You will get a better response.
Please do not ask support questions via PMs.
  Forum Index -> PhpBB2 General Support
Spider Boy

Error when converting to phpBB3

I have been trying to convert our forum from phpbb2 to 3 and got through the whole process until the final step (Complete Conversion)

General Error
SQL ERROR [ mysql4 ]

Got a packet bigger than 'max_allowed_packet' bytes [1153]


DELETE FROM ph3bb3404_posts WHERE post_id IN (68 through to 465086 - too long to post)


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_admin.php
LINE: 698
CALL: dbal_mysql->sql_query()

FILE: includes/functions_admin.php
LINE: 1763
CALL: delete_posts()

FILE: install/install_convert.php
LINE: 1908
CALL: sync()

FILE: install/install_convert.php
LINE: 1203
CALL: install_convert->sync_forums()

FILE: install/install_convert.php
LINE: 549
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 404
CALL: install_convert->main()

FILE: install/index.php
LINE: 274
CALL: module->load()

Suspect it's related to the size of our forum, any idea what we can do?
Spider Boy

It does however appear to have worked

but I never saw the warning for search indexing from this guide so how do I know if it's worked properly?
Spider Boy

Was initially fine but now visiting the link gives this error

General Error
template->_tpl_load_file(): File index_body.html does not exist or is empty


FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/functions_template.php
LINE: 74
CALL: trigger_error()

FILE: [ROOT]/includes/template.php
LINE: 604
CALL: template_compile->_tpl_load_file()

FILE: [ROOT]/includes/template.php
LINE: 357
CALL: template->_tpl_load()

FILE: [ROOT]/includes/functions.php
LINE: 4912
CALL: template->display()

FILE: [ROOT]/index.php
LINE: 160
CALL: page_footer()
myff admin

There seem to be a few issues with the phpbb3 conversion going on at the moment.
I suggest hanging fire on it, and using any conversion facility with a new host should it come to that.
Spider Boy

Unfortunately we need phpbb3 before we can do anything.

If we're ok to try again then I will over the weekend.

Do you think it could be related to the number of posts and/or specific large threads we have on the forum?
myff admin

phpbb3 does come with import from phpbb2 as a rule, so import from phpbb2 makes more sense than converting here.

But yes it is probably a size issue.

So in a nutshell we are goosed as we can't upgrade here is that correct ?
myff admin

Anywhere that runs phpbb3 should be able to import a phpbb2 export.

ok thanks for your help . Forum Index -> PhpBB2 General Support
Page 1 of 1
Create your own free forum | Buy a domain to use with your forum