Help Please Big Trouble

[dthomas]

All the sudden for no reason my board will not load. It just came to a hault. No changes were made etc. I am running 1.5.1RC and php 4.30 and the latest mysql on a windows 2000 advanced server.

I did notice when I go to mysql I see this when I click clicl_logs

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

I also had some of the yabbse info like latest post etc. showing on main page but now no page with yabbse info will completly load.

http://www.onlinephotographers.com

[David]

Use phpMyAdmin and repair that table.

[dthomas]

How do I repair a table?

[dthomas]

Well now I have messed things up good I was trying to repair the table and deleted it without knowing it. Is is possable to create a new 'yabbse_log_clicks table within the sql database? If so could someone explain what I do to insert one.  

[Spaceman-Spiff]

REPAIR TABLE `yabbse_log_clicks`

[dthomas]

I don't have the option to repair it since I deleted it. Also I never had the option before it was deleted because it could not open it always said in use.

What I need is the structure to build another one if someone could help like how many fields the field names etc

[[Unknown]]

CREATE TABLE {$db_prefix}log_topics (
 ID_MEMBER mediumint( unsigned NOT NULL default '0',
 ID_TOPIC mediumint( unsigned NOT NULL default '0',
 logTime int(10) unsigned NOT NULL default '0',
 notificationSent tinyint(4) unsigned NOT NULL default '0',
 PRIMARY KEY (ID_TOPIC, ID_MEMBER)
) TYPE=MyISAM;

-[Unknown]

[dthomas]

It's not the log_topics it is the log_clicks

[Spaceman-Spiff]

CREATE TABLE {$db_prefix}log_clicks (
 ip tinytext,
 logTime bigint(20) NOT NULL default '0',
 agent tinytext,
 toUrl tinytext,
 fromUrl tinytext,
 KEY logTime (logTime)
) TYPE=MyISAM;

it's a good idea to disable ClickLog, actually
it increases the forum preformance/speed, if u want to do that, u can comment out the function call in index.php and SSI.php, like:
//ClickLog();

[[Unknown]]

This modification would probably work better:

http://www.yabbse.org/community/index.php?board=158;action=display;threadid=20133

-[Unknown]