Log in

View Full Version : fnewpost' is marked as crashed

goshalim
07-14-2009, 03:08 PM
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
07-14-2009, 03:14 PM
Go to admin cp > maintenance > repiar/optimize tables > select the fnewpost from the list > hit repair/optimize
goshalim
07-14-2009, 03:25 PM
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
07-14-2009, 03:29 PM
Then see this thread for other ways to repair your database - 3 ways to repair a database (http://www.vbulletin.com/forum/showthread.php?s=&threadid=44909)
goshalim
07-14-2009, 04:23 PM
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
07-15-2009, 02:33 AM
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
07-15-2009, 07:16 AM
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
07-15-2009, 07:39 AM
Thank you both , i did that but unfortunately its not working !!!!:(

As you can see http://www.canarybreeder.net/up/forum/admincp/repair.php?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/forum/login.php?do=login
Referrer : http://www.canarybreeder.net/up/forum/admincp/repair.php?html=1&check=1
IP Address : 212.31.98.58
Username : admin
Classname : vB_Database
MySQL Version : 5.1.30/QUOTE]
Link14716
07-15-2009, 07:44 AM
Do you have phpMyAdmin access anywhere? If so, run this query in the database.
REPAIR TABLE fnewpost;
goshalim
07-15-2009, 08:00 AM
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
Link14716
07-15-2009, 08:26 AM
Upload this PHP file to your forums directory and run it in your browser. Let me know the results.
goshalim
07-15-2009, 08:43 AM
Ok , I will upload this via FTP to the admin file of mu Vb .

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

www.canarybreeder.net/up/forum/admincp/table_repair.php?html=1&check=1

I understnd you correct ??
Link14716
07-15-2009, 08:46 AM
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.
goshalim
07-15-2009, 10:27 AM
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
Link14716
07-15-2009, 10:32 AM
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.
goshalim
07-15-2009, 11:02 AM
My friend you are a STAR

Thank you very very much !!!!!!

It worked and fixed !!!

Thanks again