Jump to content

Users listed as member_id

gabriel710

By gabriel710

    • CJ Duplicate Member Logger 1.0.2 Not A Bug Bug
 Share

Hi @Michael

With the new 1.0.3 version, I see some users listed as their member_id. I searched on the database, and these users don't exist. So, I guess, this is the new behavior for what, in the past, the app showed "Guest".

My best guest is that the app is logging users who are trying to register but don't finish their registration process, so the app ends up linking to non-existing users. As you know, IPS deletes incomplete registration attempts after 24 hours.

I believe this issue could be easily solved by adding a cronjob that deletes these records that point to non-existing users.

Cheers,

Gabriel.

 

cj-duplicate-numbers.png

 Share
Go to entries

User Feedback

Recommended Comments

Michael

Yes this is intended behavior. I should change the reports of whats been fixed, so instead of showing "guest" (as part of the confusion to why guest would show up), the member_id will display instead. you can remove these.

  • Like 1
Link to comment
Share on other sites
Michael

I've added in "Prune Non Members" in the acp for cjdml, when run a queue that will iterate over the cjdml table and try to load the members, if it can't (which indicates they no longer exist) it will remove them from cjdml and including any children accounts they might have attached to them. it processes 50 at a time, so it shouldn't be too taxing on your server, if it is, let me know and i'll bump the number down.

Link to comment
Share on other sites
Michael

i don't see how it could've done that...i still have that database you sent i think, i can send it back to you. I'll do some additional test on it, but when i ran it on my test db last night, it only delete the records that a member wasn't there for.

Link to comment
Share on other sites
gabriel710

Hi @Michael,

I've just logged in into my MySQL server and actually the table is still populated, and the number of records decreased to about 6,000, so about 2,000 records were deleted. However, in the ACP, nothing is shown, see screenshot.

I will send you the current table in private, meanwhile I am still trying to figure out what is going on.

duplicate-vanished.png

Link to comment
Share on other sites
Michael

sorry, i see in the code what happened. if you have a back up, you can restore from that? I'll get it fixed later tonight or tomorrow morning in 1.0.6.

  • Like 1
Link to comment
Share on other sites
gabriel710

Hi @Michael, I can restore the backup, but is the current database valid or the prune function actually deleted data it shouldn't? I ask you this because the backup may be a little bit outdated, and if the current data is still valid and this is only a PHP/front-end issue, we can leave it like that until you fix the plugin.

Link to comment
Share on other sites
Michael

the data is useless, as it deleted the parents, so its okay to drop/truncate the table and restore from there. and the problem is in the php code, so don't run it again till 1.0.6

  • Like 1
Link to comment
Share on other sites

×
×
  • Create New...