FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  Who is OnlineWho is Online   Join! (free) Join! (free)  
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
  • Welcome
  • Guest

Error when converting to phpBB3

 
Post new topic   Reply to topic    myfreeforum.org Forum Index -> PhpBB2 General Support
View previous topic :: View next topic  
Author Message
Spider Boy
Novice
Novice
FLAG

Virtual Cash: 180

Joined: 18 Sep 2016
Posts: 13



Add Karma

rated by 0 members
Add Comment
Show Comments


online/offline
PostPosted: Fri Mar 24, 2017 3:17 pm    Post subject: Error when converting to phpBB3  Reply with quote

http://teeteeshorseracingforum.myfanforum.org

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]

SQL

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

BACKTRACE

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?
Back to top
View user's profile Send private message
Spider Boy
Novice
Novice
FLAG

Virtual Cash: 180

Joined: 18 Sep 2016
Posts: 13



Add Karma

rated by 0 members
Add Comment
Show Comments


online/offline
PostPosted: Fri Mar 24, 2017 3:19 pm    Post subject: Reply with quote

It does however appear to have worked

http://teeteeshorseracingforum.jeltz3.myfanforum.org/

but I never saw the warning for search indexing from this guide http://howtodoit.myfreeforum.org/...component=content&topicid=726 so how do I know if it's worked properly?
Back to top
View user's profile Send private message
Spider Boy
Novice
Novice
FLAG

Virtual Cash: 180

Joined: 18 Sep 2016
Posts: 13



Add Karma

rated by 0 members
Add Comment
Show Comments


online/offline
PostPosted: Fri Mar 24, 2017 3:25 pm    Post subject: Reply with quote

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

BACKTRACE

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()
Back to top
View user's profile Send private message
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92890

Joined: 22 May 2005
Posts: 32203



Add Karma

rated by 281 members
Add Comment
Show Comments


online/offline
PostPosted: Fri Mar 24, 2017 3:57 pm    Post subject: Reply with quote

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.
_________________

Family Friendly Shareware | | Web Design/Services | Free Forums
Back to top
View user's profile Send private message Visit poster's website
Spider Boy
Novice
Novice
FLAG

Virtual Cash: 180

Joined: 18 Sep 2016
Posts: 13



Add Karma

rated by 0 members
Add Comment
Show Comments


online/offline
PostPosted: Fri Mar 24, 2017 4:02 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92890

Joined: 22 May 2005
Posts: 32203



Add Karma

rated by 281 members
Add Comment
Show Comments


online/offline
PostPosted: Fri Mar 24, 2017 4:52 pm    Post subject: Reply with quote

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.
_________________

Family Friendly Shareware | | Web Design/Services | Free Forums
Back to top
View user's profile Send private message Visit poster's website
teetee
Apprentice
Apprentice
FLAG

Virtual Cash: 1040

Joined: 26 Jul 2012
Posts: 102


Location: West Sussex UK
Add Karma

rated by 1 members
Add Comment
Show Comments

teeteeshorseracingforum.
online/offline
PostPosted: Sat Mar 25, 2017 11:16 am    Post subject: Reply with quote

So in a nutshell we are goosed as we can't upgrade here is that correct ?
Back to top
View user's profile Send private message Visit poster's website
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92890

Joined: 22 May 2005
Posts: 32203



Add Karma

rated by 281 members
Add Comment
Show Comments


online/offline
PostPosted: Sat Mar 25, 2017 3:04 pm    Post subject: Reply with quote

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

Family Friendly Shareware | | Web Design/Services | Free Forums
Back to top
View user's profile Send private message Visit poster's website
teetee
Apprentice
Apprentice
FLAG

Virtual Cash: 1040

Joined: 26 Jul 2012
Posts: 102


Location: West Sussex UK
Add Karma

rated by 1 members
Add Comment
Show Comments

teeteeshorseracingforum.
online/offline
PostPosted: Sat Mar 25, 2017 7:33 pm    Post subject: Reply with quote

ok thanks for your help .

Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    myfreeforum.org Forum Index -> PhpBB2 General Support All times are GMT
Page 1 of 1
 
 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Card File  Gallery  Forum Archive
Powered by phpBB © 2001, 2005 phpBB Group
Create your own free forum | Buy a domain to use with your forum