AlexSheer / phpBB3.2-STK

Support ToolKit For phpBB3.2.x
https://www.phpbbguru.net/community/viewtopic.php?f=64&t=42862
15 stars 13 forks source link

On 3.2.1, Database Cleaner on Reset Bots step #15

Closed Leinad4Mind closed 6 years ago

Leinad4Mind commented 6 years ago

[phpBB Debug] PHP : in file [ROOT]/phpbb/db/driver/driver.php on line 996:

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

FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 996 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]/includes/functions_user.php LINE: 287 CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/stk/includes/database_cleaner/database_cleaner_controller.php LINE: 122 CALL: user_add()

FILE: (not given by php) LINE: (not given by php) CALL: database_cleaner_controller->bots()

FILE: [ROOT]/stk/tools/support/database_cleaner.php LINE: 215 CALL: call_user_func()

FILE: [ROOT]/stk/index.php LINE: 293 CALL: database_cleaner->run_tool()

BACKTRACE

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

FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 996 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]/includes/functions_user.php LINE: 287 CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/stk/includes/database_cleaner/database_cleaner_controller.php LINE: 122 CALL: user_add()

FILE: (not given by php) LINE: (not given by php) CALL: database_cleaner_controller->bots()

FILE: [ROOT]/stk/tools/support/database_cleaner.php LINE: 215 CALL: call_user_func()

FILE: [ROOT]/stk/index.php LINE: 293 CALL: database_cleaner->run_tool()

Leinad4Mind commented 6 years ago

This was happening because I didnt had any kind of bots, and because I had 5 columns on users table with problems. So I guess there is nothing wrong here.

I had last_post_text and last_post_text_pm that needed a fix like this: ALTER TABLE phpbb_users CHANGE last_post_text last_post_text MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NULL; ALTER TABLE phpbb_users CHANGE last_post_text_pm last_post_text_pm MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NULL;

And it was user_profile and user_profile_bbcode_uid and user_profile_bbcode_bitfield (About Me MOD, that doesnt exist any kind of record anywhere except here: https://forum.dion-designs.com/viewtopic.php?f=27&t=8844) After discover that this was from about me mod, and after delete those since I will not need on 3.2, then this start to work.

Just so you can have all the info.