Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 06:01 am EST
Geeklog Forums
GUS: gl_gus_userstats.MYD
Status: offline
knuff
Forum User
Full Member
Registered: 12/17/04
Posts: 340
Location:Sweden
Hi SQL experts,
I have a problem with the GUS table.
This is what happened.
> Upgraded to 1.14 a while ago.
> Disabled all the plugins, since I ran in error with one of the plugins and I disabled them all.
> Activated the ones I needed, included GUS, but forgot SPAM-X
> All worked fine for a few weeks.
> HIT by trackback SPAM
> Enabled SPAM-X and cleaned the Trackbacks out.
> All looked fine, and the next morning, site down, SWL error occured.
hu 22 Dec 2005 08:59:39 CET - 1016: Can't open file: 'gl_gus_userstats.MYD'. (e
rrno: 145). SQL in question: INSERT INTO gl_gus_userstats SET uid='1', username=
'Anonymous', ip='85.255.114.132', host='85.255.114.132', date='2005-12-22', time
='8:59:39', referer='', query_string='', request='POST', page='trackback.php', u
a_id='2620'
Disabled the GUS plugin, and all works fine.
Did a quick search on Google, and advice seems to be to REPAIR the table, however using phpmyadmin I see the table is in use.
gl_gus_userstats Browse ... Empty in use
What do you suggest on how to fix it ?
Second little related bug, most probably already fixed in cvs, if you have trackback and delete them, the counter under the article is not reset.
Example: If you look on the main page you see
Post a comment
Comments (0) Trackbacks (181)
However there are no more trackbacks.
Best Regards,
Boris
Vanrillaer.com - our Family Portal
I have a problem with the GUS table.
This is what happened.
> Upgraded to 1.14 a while ago.
> Disabled all the plugins, since I ran in error with one of the plugins and I disabled them all.
> Activated the ones I needed, included GUS, but forgot SPAM-X
> All worked fine for a few weeks.
> HIT by trackback SPAM
> Enabled SPAM-X and cleaned the Trackbacks out.
> All looked fine, and the next morning, site down, SWL error occured.
Text Formatted Code
hu 22 Dec 2005 08:59:39 CET - 1016: Can't open file: 'gl_gus_userstats.MYD'. (e
rrno: 145). SQL in question: INSERT INTO gl_gus_userstats SET uid='1', username=
'Anonymous', ip='85.255.114.132', host='85.255.114.132', date='2005-12-22', time
='8:59:39', referer='', query_string='', request='POST', page='trackback.php', u
a_id='2620'
Disabled the GUS plugin, and all works fine.
Did a quick search on Google, and advice seems to be to REPAIR the table, however using phpmyadmin I see the table is in use.
gl_gus_userstats Browse ... Empty in use
What do you suggest on how to fix it ?
Second little related bug, most probably already fixed in cvs, if you have trackback and delete them, the counter under the article is not reset.
Example: If you look on the main page you see
Post a comment
Comments (0) Trackbacks (181)
However there are no more trackbacks.
Best Regards,
Boris
Vanrillaer.com - our Family Portal
12
11
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by knuff: Second little related bug, most probably already fixed in cvs, if you have trackback and delete them, the counter under the article is not reset.
Example: If you look on the main page you see
Post a comment
Comments (0) Trackbacks (181)
However there are no more trackbacks.
Example: If you look on the main page you see
Post a comment
Comments (0) Trackbacks (181)
However there are no more trackbacks.
How did you delete the Trackbacks? If you use the "delete" link, the counter should be updated properly.
bye, Dirk
12
16
Quote
Status: offline
knuff
Forum User
Full Member
Registered: 12/17/04
Posts: 340
Location:Sweden
Quote by Dirk:
How did you delete the Trackbacks? If you use the "delete" link, the counter should be updated properly.
bye, Dirk
How did you delete the Trackbacks? If you use the "delete" link, the counter should be updated properly.
bye, Dirk
Hi Dirk, I used the Mass Delete Feature for Trackback from SPAM-X
Quote by asmaloney:
If by that you mean Geeklog 1.4b, GUS isn't supported on that, so I don't know if it works or not...
- Andy
If by that you mean Geeklog 1.4b, GUS isn't supported on that, so I don't know if it works or not...
- Andy
Hi Andy, it use to work fine, just that table that needs fixing.
Not sure how it happened though.
Happy NY,
Boris
Vanrillaer.com - our Family Portal
15
13
Quote
All times are EST. The time is now 06:01 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content