sql error after some dummy made a bad update?

[charliee]

Support Request Template
What version of phpBB are you using? phpBB 3.2.0
What is your board's URL? www.plantswap.se
Who do you host your board with? one.com
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.0.11
What extensions do you have installed? Tapatalk
Lightbox
viglink

Trying to install board3 version modified to work with phpbb 3.2
What styles do you currently have installed? Prosilver + prosilver customized
What language(s) is your board currently using? Primary Swedish secondary english
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
What username can be used to view this issue? N/A, requires admin access
What password can be used to view this issue? -
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Used to run phpbb 3.0.11 running just fine until some dummy decided to update to phpbb 3.2 without removing old mods
Please describe your problem. Removed almost all old files so the forum is running on fresh code, removed some modules from acp and ucp, now trying to install some extensions.
Generated by SRT Generator


Without my knowlede some dummy decided to update the forum from 3.0.11 to 3.2 without any preparations like removing old mods and now im stuck with making it work again.
I have deleted most old files and installed a fresh copy of 3.2 and on a user level it works fine including attached images and files.

I tried to install some extensions, tapatalk worked right away after i had uploaded the files it was already activated.
Lightbox installed just fine but now im trying to install board3, a version modified to work with phpbb 3.2, at first i got an error about a missing module ACP_CAT_DOT_MODS, i added the module manually and now i get a sql error, board3 installs just fine on a fresh copy of phpbb3 with a new database.

Anyone got a clue whats wrong? what i need to do to fix the sql error?
Regards
Charliee




Return to the index page
General Error
SQL ERROR [ mysqli ]

Table 'plantswap_se.phpbb3_portal_modules' doesn't exist [1146]

SQL

SELECT module_id FROM phpbb3_portal_modules WHERE module_classname = '\\board3\\portal\\modules\\clock'

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]/ext/board3/portal/migrations/v210_rc1.php
LINE: 36
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: board3\portal\migrations\v210_rc1->add_clock_setting()

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: 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()

[KevC]

Try this
https://3di.space/32/viewtopic.php?f=3&t=22

[charliee]

Try this
https://3di.space/32/viewtopic.php?f=3&t=22

Unfortunately didnt make a difference, still getting the sql error.
Modules deleted: 0
Permissions deleted: 1
Config values deleted: 12
phpbb3_mods table dropped

Then i tried to install mchat and this came up.
Information
The installation as 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 phpbb3_modules table: 241

When i try to access the extention tab in acp this comes up
General Error
Module not accessible
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/includes/functions_module.php
LINE: 565
CALL: trigger_error()
FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()




Anything else i can try?

[Lumpy Burgertushie]

for some reason, that modission tool does not remove all the mchat references from the database.

probablly the best thing to do would be to go back to your 3.0 state by replacing your files and database with the backups made before the upgrade began.

then, start over and do the upgrade properly. go to 3.1 first and then to 3.2 is how I like to do it.


if you do not have those backups, then you will need to go into the database using phpmyadmin or whatever and remove all of the tables and anything else that says mchat on it.

make a backup of the database before you start or you WILL be sorry if anything should go wrong.

then, be very careful about what you do in the database. only delete/remove things that have mchat in the title.

luck,
robert

[charliee]

probablly the best thing to do would be to go back to your 3.0 state by replacing your files and database with the backups made before the upgrade began.

Would mean losing 4-5 months :/

make a backup of the database before you start or you WILL be sorry if anything should go wrong.

Im using xammp so i can work locally without fear of breaking anything.

[3Di]

Modission tool does not remove all database changes from MODs, it is not a database cleaner.

the modules with the following IDs need to be deleted from the phpbb3_modules table: 241

Go into your DB, modules_table, and delete the module with ID 241.
Make a backup first and delete the cache after.

[charliee]

Modission tool does not remove all database changes from MODs, it is not a database cleaner.

the modules with the following IDs need to be deleted from the phpbb3_modules table: 241

Go into your DB, modules_table, and delete the module with ID 241.
Make a backup first and delete the cache after.

Problem lies somewhere else, no module with id 241 exists in table modules.

[3Di]

Problem lies somewhere else, no module with id 241 exists in table modules.

Ofcourse, there are 206 entries for phpBb 3.2.0 in the MODULES_TABLE, modission tool left only those, which belongs to a virgin 3.2.0.

The issue should lie into your files, since

Removed almost all old files so the forum is running on fresh code

this part isn't clear, check your includes/acp/info/ folder and look if there is something related to mchat.

I would suggest to delete all of your phpBB files EXCEPT for the following:

config.php
The /ext/ directory
The /images/ directory
The /files/ directory
The /store/ directory

Upload the contents of the 3.2.x Full Package (EXCEPT for config.php) into your forum's directory.

ANd purge the cache.

[charliee]

config.php
The /ext/ directory
The /images/ directory
The /files/ directory
The /store/ directory

That is what i have done, i ran a search on a recent backup and got zero hits on "mchat".

[3Di]

You mentioned you added a module manually etc.. not sure what you did but in some cases is not so easy to fix something that went wrong from the start. Needs time etc.. etc.