Support Forum
Support Forum
Broken DB tables and plugin tables optimization
Mr Papa
Simi Valley, CA
SP Master
Free Members
Offline
May 25, 2017 - 10:09 pm
whats confusing is that its trying to create a new sfmembers row of data, but it already exists... actually, its a duplicate key... can you check in your db using phpmyadmin or other and show what the indexes are in a screenshot? something like this
Visit Cruise Talk Central and Mr Papa's World
Yellow Swordfish
Glinton, England
SP Master
Offline
May 26, 2017 - 3:54 am
My suspicion arises from the error reports attached in post #10. When a repair operation fails - and I have never seen that happen before - then who knows what could have been written to the DB incorrectly. The table in question was probably in a bad state for quite a while. It seems entirely possible to me that keys have been written to the btree that are not indexed properly (so Mr Papa's question above is important).
 |
YELLOW
SWORDFISH
|
All RSSForum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
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: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626