Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Broken DB tables and plugin tables optimization
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 8, 2017 - 10:34 pm

so all fixed up now??

Avatar
Luca Urzi'
Member
sp_UserOfflineSmall Offline
May 9, 2017 - 11:43 am

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. 

Image Enlarger

When you try to edit something inside your profile (avatar, signature or password) you receive this null message. Any idea where I should go? 

Avatar
Luca Urzi'
Member
sp_UserOfflineSmall Offline
May 9, 2017 - 5:31 pm

More errors:

Image Enlarger

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 9, 2017 - 9:09 pm

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?

Avatar
Luca Urzi'
Member
sp_UserOfflineSmall Offline
May 23, 2017 - 2:35 pm

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.

I imported an old sp db into a new wp site 2 or 3 years ago, never ever I had such problems before.
 
I also checked the browser console while updating the profiles and no errors are detected even when the "null" message comes up.
 
Today the old "invalid request to the database" pops up every time you open a page of a thread. We keep optimizing the database everyday, but after a few days the problems return (fi: in the "new users" statistic in the bottom part of the forum there are often old users with "_1" after the username, then the url links to the old user and not a new one).
 
I'm willing to give you an access to my website so you can access the backend and tell me what to do. 
 
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 23, 2017 - 8:45 pm

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...

Avatar
Luca Urzi'
Member
sp_UserOfflineSmall Offline
May 24, 2017 - 8:46 am

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...  

We never deleted any user with api. I don't even remember deleting a user (apart from those spamming maybe) and even in that case I always used the backend wp-admin. 
In the wp_users there are 13473 users
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. 
If we need to verify the corresponding between wp users and vice versa, would you give us a query to do so?
 
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 24, 2017 - 9:21 pm

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...

Avatar
Luca Urzi'
Member
sp_UserOfflineSmall Offline
May 25, 2017 - 4:49 am

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? 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
May 25, 2017 - 3:05 pm

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.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17364
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625