Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Build and Repair table error

Quote Reply
Build and Repair table error
 Hi,

Have you come accross this error before with Links SQL (Version: 2.1.2)?

I noticed the New Flag for links wasn't updating so modified a couple of links manually (using MySQLMan) to isNew = No.

Now whenever I run Repair tables or Build all the script stalls on:

Updating New Flags ...

Have tried REPAIR TABLE lsql_Links from the SQL Monitor and changing back the links isNew status without success.

Is this more likely to be a build.pm error or a corrupted table with mySQL?

Very interested in hearing your suggestions, thanks for your help.

Charlie



Comedy Quotes - Glinks 3.3.0, PageBuilder, StaticURLtr, CAPTCHA, User_Edit_Profile

Quote Reply
Re: [Chas-a] Build and Repair table error In reply to
Have you tried the "nph-build.cgi --repair --force=1 "

Regards

minesite
Quote Reply
Re: [minesite] Build and Repair table error In reply to
Cheers minesite!

I also sent a message to support and found out the ClickTrack table was corrupt.

Logging on a root SSH and running...

myisamchk - r /var/lib/mysql/DBNAME/lsql_ClickTrack.MYI

fixed it Cool



Comedy Quotes - Glinks 3.3.0, PageBuilder, StaticURLtr, CAPTCHA, User_Edit_Profile