Jump to content


Photo
- - - - -

php forum error


  • Please log in to reply
4 replies to this topic

#1 everythingsbs

everythingsbs

    MaD_cOw has nothing on me at MODing!

  • Moderators
  • 916 posts
  • Location:California

  • United States

Posted 29 March 2008 - 07:21 AM

Hey,

I've checked and searched their forums, but have been unable to get help/figure it out.

I'm having an issue with my phpbb boards. When anyone tries to view a new post, they see the following error:

CODE
General Error
SQL ERROR [ mysql4 ]

Table 'p' is marked as crashed and should be repaired [1194]

SQL

SELECT p.post_id FROM phpbb_posts p WHERE p.topic_id = 1124 ORDER BY p.post_time ASC LIMIT 15

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 157
CALL: dbal_mysql->_sql_query_limit()

FILE: viewtopic.php
LINE: 871
CALL: dbal_mysql->sql_query_limit()


It seems as if there is only a bad table, but when I look, I'm unable to find it or figure out.

Thoughts?

Thanks guys.
QUOTE("Richard Hammond - Top Gear")
We're gonna to die now, that's it."

#2 usr.c

usr.c

    Boss, my code's compiling (xkcd)

  • Admins
  • 10,440 posts
  • Gender:Male
  • Interests:Software
    Soccer
    Photography
    RC cars
    Electronics

  • Nothing Selected

Posted 31 March 2008 - 06:46 AM

Hi, If you have PhpMyAdmin installed, then go to the above mentioned table in your database, click on the "Operations" tab and then click on "Repair". I used to get a similar error in the forums' sessions table whenever the server would crash.


Things that I don't suck at: Photography (flickr, JPG Mag), Skydiving, Splitting atoms, Flying a space shuttle
"Don't bail; the best gold is at the bottom of barrels of crap!" -Randy Pausch
I have people-skills goddamnit! What is wrong with you people!!! | www.skyrill.com

#3 everythingsbs

everythingsbs

    MaD_cOw has nothing on me at MODing!

  • Moderators
  • 916 posts
  • Location:California

  • United States

Posted 31 March 2008 - 10:26 PM

Hey Ali,

When looking in the Operations, I don't see an area that will let me repair. I'm probably missing something though.


Ryan

sql_error.jpg

QUOTE("Richard Hammond - Top Gear")
We're gonna to die now, that's it."

#4 usr.c

usr.c

    Boss, my code's compiling (xkcd)

  • Admins
  • 10,440 posts
  • Gender:Male
  • Interests:Software
    Soccer
    Photography
    RC cars
    Electronics

  • Nothing Selected

Posted 01 April 2008 - 03:39 PM

Try seeing if it shows up in the dropdown in the table view (see the attached image). If not, then you might have to get in touch with your webhost to give your user account the necessary privileges.

Attached Thumbnails

  • Picture_2.png



Things that I don't suck at: Photography (flickr, JPG Mag), Skydiving, Splitting atoms, Flying a space shuttle
"Don't bail; the best gold is at the bottom of barrels of crap!" -Randy Pausch
I have people-skills goddamnit! What is wrong with you people!!! | www.skyrill.com

#5 everythingsbs

everythingsbs

    MaD_cOw has nothing on me at MODing!

  • Moderators
  • 916 posts
  • Location:California

  • United States

Posted 02 April 2008 - 05:26 AM

Awesome. Thanks Ali. All better.

thumbsup.gif
QUOTE("Richard Hammond - Top Gear")
We're gonna to die now, that's it."




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users