Page 1 of 1
membership tables
Posted: 2019-08-19 09:27
by bescott53
I have an issue where new members are being added to the members table but when the create records the records PK is not stored in the membership_userrecords table?
I have 180 users, is there a limit?
Re: membership tables
Posted: 2019-08-19 13:25
by onoehring
Hi bescott53,
in mysql there is no such limit. Did you change anything in the membership_userrecords table? I am thinking of some constraint.
Does the problem occur for all users (all groups) or is it specific?
Did you clean up your membership records from the admin area? Maybe this helps.
Olaf
Re: membership tables
Posted: 2019-08-20 09:07
by bescott53
Hi Olaf,no i didn't change anything and all other users are updating properly except the latest one?
Re: membership tables
Posted: 2019-08-20 09:11
by onoehring
Hi,
can you try to delete the latest user and recreate him - does the problem then still exist?
Olaf
Re: membership tables
Posted: 2019-08-20 09:22
by jsetzer
bescott53 wrote: ↑2019-08-20 09:07
all other users are updating properly except the latest one?
Can you see any difference between the last one and the others?
Perhaps that one has a very (!) long
memberID
or special characters in his/her name?
No other idea at the moment. For me the next step would be narrowing it down by adding some logging.
Best,
Jan
Re: membership tables
Posted: 2019-08-20 09:51
by bescott53
Olaf, I did recreate the user but no difference.
Jsetzer, there is a large custom 2 but not sure if that would cause an issue but i will change to see if this is the issue.