User Merge

Error during merge - User Merge

Error during merge

by dingus33 » Sun Jan 06, 2019 4:36 am

phpBB: 3.2.2
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()
can someone please help?

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?

thanks guys
Last edited by dingus33 on Sun Jan 06, 2019 4:52 am
User avatar
dingus33
Registered User
Posts: 136
Joined: Fri Sep 29, 2017 11:11 am
Contact:

Re: Error during merge

by dingus33 » Sun Jan 06, 2019 4:51 am

after investigating further, it seems like the old user's posts were successfully assigned to the new user.

HOWEVER:
  • the old user's account was not deleted, and the new user's registration date was not modified.
  • viewing the users' profiles, it seemed like the new user's post count was updated (correct combined post count), but the old user's was unchanged.
  • also, when searching a user's post from their profile i.e. search.php?author_id=foobar&sr=posts, the results were not as expected.
    for old user: old user's posts appeared in the results, but they had been correctly assigned to the new user.
    for new user: only new user's post appeared (old user's posts were absent).
however, after clearing the board cache, resynchronizing statistics, and resynchronizing post counts (all 3 of these tools are in the general tab of ACP), the issues with the two accounts' post counts and searching their posts are now resolved.
the new user shows the correct combined post count, the old user shows 0 posts, and searching their posts from their profiles gives the correct results.

do you think it's likely that simply deleting the old user will bring this to a happy conclusion? or would you be leery?

thanks again
User avatar
dingus33
Registered User
Posts: 136
Joined: Fri Sep 29, 2017 11:11 am
Contact:

Re: Error during merge

by tojag » Sat Jan 12, 2019 10:50 pm

I used it today on my forum v.3.2.4 php7.11 and everything was ok. No errors, no problems.
Thanks for this extension.
User avatar
tojag
Registered User
Posts: 408
Joined: Thu Aug 07, 2014 8:00 am
Location: Warsaw, Poland, EU
Name: Gregory