fnewpost' is marked as crashed
 

Help please

I had my forum down doing some works.

Sudently i received this message .

What shall i do please...

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

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 ?

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

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.

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

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.

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.

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]

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

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

Upload this PHP file to your forums directory and run it in your browser. Let me know the results.

Ok , I will upload this via FTP to the admin file of mu Vb .

Then i am must run the url like this . correct ?

http://www.canarybreeder.net/up/foru...html=1&check=1

I understnd you correct ??

Put it in your root forum directory, not the admincp. Run it like this:

http://www.canarybreeder.net/up/forum/table_repair.php

It's a simple file that I wrote that will only run that one query to repair that table. It should give you a simple blank page. Check to see if everything is working again. If not, run it again. If it still isn't working, let me know.

You should probably delete the file from your forum directory after you are done with it as well.

Hi

I did that and i received this message

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'gorgino_canary'@'localhost' (using password: YES) in /home/gorgino/public_html/canarybreeder/up/forum/table_repair.php on line 5

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/gorgino/public_html/canarybreeder/up/forum/table_repair.php on line 6

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/gorgino/public_html/canarybreeder/up/forum/table_repair.php on line 7

Apparently I fail. Sorry.

I fixed that error, was using the username as the password. Whoops. Should work now. Let me know how it goes.

My friend you are a STAR

Thank you very very much !!!!!!

It worked and fixed !!!

Thanks again