sql error after some dummy made a bad update?

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
charliee
Registered User
Posts: 169
Joined: Sun Nov 06, 2011 2:49 am

sql error after some dummy made a bad update?

Post by 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()
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70432
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: sql error after some dummy made a bad update?

Post by KevC »

-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
charliee
Registered User
Posts: 169
Joined: Sun Nov 06, 2011 2:49 am

Re: sql error after some dummy made a bad update?

Post by charliee »

KevC wrote: โ†‘
Sat Apr 15, 2017 9:19 am
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?
User avatar
Lumpy Burgertushie
Registered User
Posts: 68550
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: sql error after some dummy made a bad update?

Post by 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
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
charliee
Registered User
Posts: 169
Joined: Sun Nov 06, 2011 2:49 am

Re: sql error after some dummy made a bad update?

Post by charliee »

Lumpy Burgertushie wrote: โ†‘
Sat Apr 15, 2017 9:13 pm
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.
User avatar
3Di
Former Team Member
Posts: 16149
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano 🇮🇹 Frankfurt 🇩🇪
Name: Marco
Contact:

Re: sql error after some dummy made a bad update?

Post by 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.
๐Ÿ†“ Free support for our extensions also provided here: phpBB Studio
๐Ÿš€ Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Want to compensate me for my interest? Donate
My development's activity ยบ PhpStorm's proud user ยบ Extensions, Scripts, MOD porting, Update/Upgrades
charliee
Registered User
Posts: 169
Joined: Sun Nov 06, 2011 2:49 am

Re: sql error after some dummy made a bad update?

Post by charliee »

3Di wrote: โ†‘
Sat Apr 15, 2017 9:34 pm
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.
User avatar
3Di
Former Team Member
Posts: 16149
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano 🇮🇹 Frankfurt 🇩🇪
Name: Marco
Contact:

Re: sql error after some dummy made a bad update?

Post by 3Di »

charliee wrote: โ†‘
Sat Apr 15, 2017 11:48 pm
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
charliee wrote: โ†‘
Sat Apr 15, 2017 4:52 am
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.
๐Ÿ†“ Free support for our extensions also provided here: phpBB Studio
๐Ÿš€ Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Want to compensate me for my interest? Donate
My development's activity ยบ PhpStorm's proud user ยบ Extensions, Scripts, MOD porting, Update/Upgrades
charliee
Registered User
Posts: 169
Joined: Sun Nov 06, 2011 2:49 am

Re: sql error after some dummy made a bad update?

Post by charliee »

3Di wrote: โ†‘
Sun Apr 16, 2017 1:38 am
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".
User avatar
3Di
Former Team Member
Posts: 16149
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano 🇮🇹 Frankfurt 🇩🇪
Name: Marco
Contact:

Re: sql error after some dummy made a bad update?

Post by 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.
๐Ÿ†“ Free support for our extensions also provided here: phpBB Studio
๐Ÿš€ Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Want to compensate me for my interest? Donate
My development's activity ยบ PhpStorm's proud user ยบ Extensions, Scripts, MOD porting, Update/Upgrades
Post Reply

Return to โ€œ[3.2.x] Support Forumโ€