fnewpost' is marked as crashed

[goshalim]

Help please

I had my forum down doing some works.

Sudently i received this message .

What shall i do please...

database error in Subdreamer

Invalid SQL: SELECT COUNT(*) AS posts FROM fnewpost LIMIT 1
Error: Table './gorgino_canary/fnewpost' is marked as crashed and should be repaired Error number: 145
Date: Tuesday 14th 2009f July 2009 03:23:32 PM
File: http://www.canarybreeder.net/up/index.php

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(post.postid) as unread
FROM fnewpost as post FORCE INDEX (dateline)
INNER JOIN fnewthread as thread USING (threadid)
INNER JOIN fnewforum AS forum USING (forumid)
LEFT JOIN fnewthreadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
LEFT JOIN fnewforumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
WHERE thread.forumid IN(03,6,27,50,5,28,21,83,69,70,36,22,4,71,91,92,93 ,94,19,14,15,13,52,57,63,53,59,54,60,55,61,56,62,5 8,38,10,11,25,74,41,76,73,40,75,42,49,12,39,78,43, 51,16,17,29,84,79,85,86,87,23,88,89,90,32,30,81,82 ) AND thread.forumid NOT IN(0) AND thread.visible IN (0,1,2)
AND post.dateline > IF(threadread.readtime IS NULL, 1247583694, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1247583694, forumread.readtime)
AND post.dateline > 1247583694
AND thread.lastpost > IF(threadread.readtime IS NULL, 1247583694, threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1247583694, forumread.readtime)
AND thread.lastpost > 1247583694;

MySQL Error : Table './gorgino_canary/fnewpost' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, July 14th 2009 @ 11:08:53 AM
Error Date : Tuesday, July 14th 2009 @ 11:08:55 AM
Script : http://canarybreeder.net/up/forum/
Referrer : http://www.canarybreeder.net/up/
IP Address : 62.152.16.169
Username : admin
Classname : vB_Database
MySQL Version : 5.1.30

[Lynne]

Go to admin cp > maintenance > repiar/optimize tables > select the fnewpost from the list > hit repair/optimize

[goshalim]

Hi Lynee it doent allow me at all to log as admin in the admin panel.

It gives me the same message

Any other way to find this ?? May be via FTP ?

[Lynne]

Then see this thread for other ways to repair your database - 3 ways to repair a database

[goshalim]

Hi Lynne again

Thank you for the reply

If you are so kind because i am not expert in programming
i have found the repair.php file in the admin directory and not in the vb zip file.

1. you need to upload repair.php from your vB zip file to your /admin directory and run this url

yourdomain.com/admin/repair.php?html=1&check=1

What i do not understand is where should i run thiw url , in my Browser ??

[Lynne]

Yes, you would put that url in your browser - changing yourdomain.com to your domain, of course. And, if you have your forums in a directory called /forums, then you would add that in there too - yourdomain.com/forums/admincp/repair.php....etc.

[Link14716]

As a general rule, pretty much any time you are asked to run a URL as opposed to a path or a file, it is asking you to run it in your browser.

[goshalim]

Thank you both , i did that but unfortunately its not working !!!!

As you can see http://www.canarybreeder.net/up/foru...html=1&check=1

its not working !!!!!


Its comes the admin panel but when i write my codes it shows me this message below


[QUOTE][Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(post.postid) as unread
FROM fnewpost as post FORCE INDEX (dateline)
INNER JOIN fnewthread as thread USING (threadid)
INNER JOIN fnewforum AS forum USING (forumid)
LEFT JOIN fnewthreadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
LEFT JOIN fnewforumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
WHERE thread.forumid IN(03,6,27,50,5,28,21,83,69,70,36,22,4,71,91,92,93 ,94,19,14,15,13,52,57,63,53,59,54,60,55,61,56,62,5 8,38,10,11,25,74,41,76,73,40,75,42,49,12,39,78,43, 51,16,17,29,84,79,85,86,87,23,88,89,90,32,30,81,82 ) AND thread.forumid NOT IN(0) AND thread.visible IN (0,1,2)
AND post.dateline > IF(threadread.readtime IS NULL, 1247639932, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1247639932, forumread.readtime)
AND post.dateline > 1247639932
AND thread.lastpost > IF(threadread.readtime IS NULL, 1247639932, threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1247639932, forumread.readtime)
AND thread.lastpost > 1247639932;

MySQL Error : Table './gorgino_canary/fnewpost' is marked as crashed and should be repaired
Error Number : 145
Request Date : Wednesday, July 15th 2009 @ 03:38:27 AM
Error Date : Wednesday, July 15th 2009 @ 03:38:28 AM
Script : http://www.canarybreeder.net/up/foru...n.php?do=login
Referrer : http://www.canarybreeder.net/up/foru...html=1&check=1
IP Address : 212.31.98.58
Username : admin
Classname : vB_Database
MySQL Version : 5.1.30/QUOTE]

[Link14716]

Do you have phpMyAdmin access anywhere? If so, run this query in the database.

REPAIR TABLE fnewpost;

[goshalim]

No i do not have .

Can i install such a programme from somewhere and then can run it ??

I made and i can download it for free .
But thinks in there are much too complicated .

Any assistance much appriciated .

Thanks