Support Forum
Support Forum
Offline
Mr Papa said
so all fixed up now??
the website keeps going slow, I'm afraid it's still has to do with the tables. I'll let you know if he goes down again.
As for the profile updating I still get the "null" message I mentioned sometime ago.
When you try to edit something inside your profile (avatar, signature or password) you receive this null message. Any idea where I should go?
Offline
as to profile, please check when saving the data with the browser console open....
do you have a link to your site so we can look for obvious conflicts?
Those last two errors dont make any sense.... it says you are trying to create a member that already exists... has this site been working before? did you try importing an old sp db into another wp site?? not sure how wp can try to create a new user where one already exists...
how many rows in the wp users table? how many rows in the sfmembers table?
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
as to profile, please check when saving the data with the browser console open....do you have a link to your site so we can look for obvious conflicts?
Those last two errors dont make any sense.... it says you are trying to create a member that already exists... has this site been working before? did you try importing an old sp db into another wp site?? not sure how wp can try to create a new user where one already exists...
how many rows in the wp users table? how many rows in the sfmembers table?
sorry for the late response
There are 13473 rows in the wp users table and 13467 in the sfmembers table.
Offline
the number of rows should be exact.. every time a wp user is added, a row is added to the sfmembers table... if you manually added or deleted users instead of through the wp api/ui, then problems can arise... in sfmembers, there is a pointer (id) to the row within the wp users table...
how many wp users listed on wp - users?
when you imported the db, was it empty? ie no existing wp users?
seems like a big mismatch in users which is very problematic... there are no sp users, only wp users... and we add our 'extra' data for the user in the sfmembers table...
so first step is to see which sfmembers tables, dont have a corresponding wp users entry - and vice versa...
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
the number of rows should be exact.. every time a wp user is added, a row is added to the sfmembers table... if you manually added or deleted users instead of through the wp api/ui, then problems can arise... in sfmembers, there is a pointer (id) to the row within the wp users table...how many wp users listed on wp - users?
when you imported the db, was it empty? ie no existing wp users?
seems like a big mismatch in users which is very problematic... there are no sp users, only wp users... and we add our 'extra' data for the user in the sfmembers table...
so first step is to see which sfmembers tables, dont have a corresponding wp users entry - and vice versa...
The db was empty when we imported it. It was eliminated and imported all over again. Nevertheless, the problems never presented until some months ago. Probably it started when we repaired the sfmembers table when it broke.
Offline
not sure a query would do it... you would probably need to write a small php script that looped through the wp users and checked for sfmembers... and find non matched ones... then repeat for the opposite...
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
not sure a query would do it... you would probably need to write a small php script that looped through the wp users and checked for sfmembers... and find non matched ones... then repeat for the opposite...
ok, what should I do when I'll find wpusers not included in the sfmembers table and viceversa?
Offline
I am coming late to this topic but it is worth mentioning that if any user tries to access the forum with a WP users record but no sfmembers record - then it will be automatically created at that point with default values.
 |
YELLOW
SWORDFISH
|
All RSS1 Guest(s)