User Merge: 1.0.4
this is my first time using this extension.
i selected two users, and i also chose the option to modify the registration date of the new user.
when i ran it, i encountered this error:
Code: Select all
General Error SQL ERROR [ postgres ] ERROR: syntax error at or near "LIMIT" LINE 4: LIMIT 1 OFFSET 0 ^  SQL UPDATE phpbb_privmsgs SET to_address = 'u_678' WHERE msg_id = 410 LIMIT 1 OFFSET 0 BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: msg_handler() FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 996 CALL: trigger_error() FILE: [ROOT]/phpbb/db/driver/postgres.php LINE: 194 CALL: phpbb\db\driver\driver->sql_error() FILE: [ROOT]/phpbb/db/driver/postgres.php LINE: 258 CALL: phpbb\db\driver\postgres->sql_query() FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 270 CALL: phpbb\db\driver\postgres->_sql_query_limit() FILE: [ROOT]/phpbb/db/driver/factory.php LINE: 321 CALL: phpbb\db\driver\driver->sql_query_limit() FILE: [ROOT]/ext/phpbbmodders/usermerge/acp/usermerge_module.php LINE: 327 CALL: phpbb\db\driver\factory->sql_query_limit() FILE: [ROOT]/ext/phpbbmodders/usermerge/acp/usermerge_module.php LINE: 106 CALL: phpbbmodders\usermerge\acp\usermerge_module->user_merge() FILE: [ROOT]/includes/functions_module.php LINE: 676 CALL: phpbbmodders\usermerge\acp\usermerge_module->main() FILE: [ROOT]/adm/index.php LINE: 82 CALL: p_master->load_active()
my board seems ok, but i don't think the merge was completely successful. i'm trying to investigate now.
i foolishly ran this on a production board.
what's the worst case scenario?
should i roll back my postgresql db with point-in-time recovery, or is this overkill? the longer i wait, the less realistic this solution becomes due to users making posts in the mean time.
is potential damage/bugs likely limited to the two users in question?