SQL error in admin page

[Juana]

i have big problem . when i enter to my admin page i got this error :

2: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
(/home/httpd/vhosts/tokeikedai.net.my/httpdocs/kedaikopi/Sources/Admin.php ln 75)


how to fix this problem ??

[mediman]

your log_clicks table is locked!

have you phpmyadmin installed?

medi

[[Unknown]]

REPAIR TABLE yabbse_log_clicks

Sometimes the table gets messed up, and then MySQL won't touch it until you repair it.

-[Unknown]

[mediman]

if you have not phpmyadmin installed, then rename the attached file to anything.php and place it in the yabbse folder (the same where Settings.php is) and run it once!

mediman

[Juana]

i have phpmyadmin in my hosting . when i click table yabbse_log_clicks , i got this msg :

Error

SQL-query :  

SHOW KEYS FROM `yabbse_log_clicks`


MySQL said:


Can't open file: 'yabbse_log_clicks.MYD'. (errno: 145)


how to do now ? give me an idea

[[Unknown]]

Errno 145 means MySQL locked it 'cuz it's broken.

You are going to need to repair it.

-[Unknown]

[Juana]

how to repair that error ? i have no nothing about that . please guide me

[mediman]

use the file i attached!

mediman

[Juana]

i have tried your attached file , here the result :

Your database contains 25! tables.
trying to optimize tables ...

optimize: yabbse_calendar .... 0.249 kb optimized
optimize: yabbse_log_floodcontrol .... 0.125 kb optimized
optimize: yabbse_log_online .... 1.66 kb optimized
optimize: yabbse_log_topics .... 10.5 kb optimized
optimize: yabbse_messages .... 152.234 kb optimized
optimize: yabbse_polls .... 2.301 kb optimized
optimize: yabbse_topics .... 0.195 kb optimized


7 tables optimized


after that i try enter to my admin page but still the same problem as i told you before. duhh

[mediman]

last chance

http://www.yabbse.org/jeffstools/RepairTables.zip

mediman