Posts merging

General error - Posts merging

General error

by wads24 » Wed Jan 09, 2019 5:19 am

I have a large forum with over 300k in posts and getting error... When trying to enable it times out...

Code: Select all

General Error
SQL ERROR [ mysqli ]

Lost connection to MySQL server during query [2013]

SQL

ALTER TABLE `phpbb_posts` ADD COLUMN `post_created` int(11) DEFAULT '0' NOT NULL

BACKTRACE

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

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1064
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1272
CALL: phpbb\db\tools\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 549
CALL: phpbb\db\tools\tools->sql_column_add()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 714
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 661
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 400
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 190
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 213
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
Thanks in advance for a reply.
User avatar
wads24
Registered User
Posts: 685
Joined: Fri Jun 10, 2005 4:44 am
Name: James

Re: General error

by rxu » Wed Jan 09, 2019 4:53 pm

300k DB is not that big to get error like that. There's a lot of reasons though. F.e. connect_timeout value and so on.
You can try sorting it out looking into the MySQL server's error log.
rxu
Extensions Development Team
Posts: 4018
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation

Re: General error

by wads24 » Sat Aug 24, 2019 6:33 am

rxu wrote:300k DB is not that big to get error like that. There's a lot of reasons though. F.e. connect_timeout value and so on.
You can try sorting it out looking into the MySQL server's error log.
Still couldn't find the error...
Thanks in advance for a reply.
User avatar
wads24
Registered User
Posts: 685
Joined: Fri Jun 10, 2005 4:44 am
Name: James