2009-06-07, 06:20 PM
hi all
i have a forum set up and running phpbb3, and have just run the merge program to transfer it to mybb, however i get the following error when running the posts run, it gets right to the end and gets to the rebuilding counters bit and then gives the following error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT COUNT(aid) AS attachment_count FROM mybb_attachments a LEFT JOIN mybb_posts p ON (a.pid=p.pid) WHERE p.tid='3945'
there are 83,000 posts and i have installed mybb on my laptopn then ran the merge program and successfully merged fine on my laptop first ( i did this as a test run, as i had my backup of my forum on my laptop as well, as i do all my mods on there to test them out ) so figure it must be a problem with the hosting providers etc? ( i am with 1and1) is there a way to just run a backup from the successful convertion that i did on my laptop?and then dump it in etc? or restore from the admin panel?
cheers for any help
problem solved, i just bigdumpped it in lol
i have a forum set up and running phpbb3, and have just run the merge program to transfer it to mybb, however i get the following error when running the posts run, it gets right to the end and gets to the rebuilding counters bit and then gives the following error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT COUNT(aid) AS attachment_count FROM mybb_attachments a LEFT JOIN mybb_posts p ON (a.pid=p.pid) WHERE p.tid='3945'
there are 83,000 posts and i have installed mybb on my laptopn then ran the merge program and successfully merged fine on my laptop first ( i did this as a test run, as i had my backup of my forum on my laptop as well, as i do all my mods on there to test them out ) so figure it must be a problem with the hosting providers etc? ( i am with 1and1) is there a way to just run a backup from the successful convertion that i did on my laptop?and then dump it in etc? or restore from the admin panel?
cheers for any help
problem solved, i just bigdumpped it in lol