Warning: The author of this contribution does not provide support for it anymore.

phpBB mChat

500 Error and database errors - phpBB mChat

500 Error and database errors

by wads24 » Fri May 19, 2017 3:24 pm

I had to remove this extension because I was having several issues. It was causing 500 errors after updating to the newest version.


Your phpBB Version: 3.2.0
Your phpBB Type: Standard phpBB
Extensions installed: Yes
Your knowledge: Beginner

What have you done before the problem was there?
I was getting a 500 error, and I ready a post saying to try to disable the extension, and delete data, and do a fresh install. When I clicked on install enable I got the below error in phpBB admin

What have you already tried to solve the problem?


Description and Message
Your phpBB Version: 3.2.0
Your phpBB Type: Standard phpBB
Extensions installed: Yes
Your knowledge: Beginner

What have you done before the problem was there?
I was getting a 500 error, and I ready a post saying to try to disable the extention, and delete data, and do a fresh install.

What have you already tried to solve the problem?


Description and Message
Error wrote:The installation has been aborted.
There are remnant modules from the mChat MOD for phpBB 3.0.x in the database. The mChat extension does not work correctly with these modules present.
You need to entirely uninstall the mChat MOD before being able to install the mChat extension. Specifically, the modules with the following IDs need to be deleted from the cbrt_modules table: 511, 512, 508


I tried it again and got another error.
General Error
SQL ERROR [ mysqli ]

Duplicate entry 'mchat_whois' for key 'PRIMARY' [1062]

SQL

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('mchat_whois', 1, 0)

BACKTRACE

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

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

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

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

FILE: [ROOT]/phpbb/config/db.php
LINE: 161
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/config/db.php
LINE: 122
CALL: phpbb\config\db->set_atomic()

FILE: [ROOT]/phpbb/db/migration/tool/config.php
LINE: 59
CALL: phpbb\config\db->set()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\migration\tool\config->add()

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

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

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 436
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: 185
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 197
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: 514
Joined: Fri Jun 10, 2005 4:44 am
Name: James

Re: 500 Error and database errors

by RMcGirr83 » Fri May 19, 2017 3:36 pm

The errors pretty much tell you what the problem is/are. You have remnants of the 3.0 mChat mod within your database.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact: