Digg this topic
Add to my del.icio.us php forum error |
|
|
|
|
|
Late(st) News | Zenith Picture Gallery | Most
Recent Community Topics | Tips, Tricks and Other Useful Stuff
  |
| php forum error |
 Mar 29 2008, 07:21 AM
Post
#1
|
|
 MaD_cOw has nothing on me at MODing!  Group: Moderators Posts: 916 Joined: 4-June 04 From: California Member No.: 1,362   |
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." |
 |
 
|
|
Mar 31 2008, 06:46 AM
Post
#2
|
|
 Boss, my code's compiling (xkcd)  Group: Admins Posts: 10,440 Joined: 19-September 01 Member No.: 1  |
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), "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 |
|
|
|
|
Mar 31 2008, 10:26 PM
Post
#3
|
||
|
MaD_cOw has nothing on me at MODing! Group: Moderators Posts: 916 Joined: 4-June 04 From: California Member No.: 1,362 |
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
-------------------- QUOTE("Richard Hammond - Top Gear") We're gonna to die now, that's it." |
|
|
|
|
|
|
Apr 1 2008, 03:39 PM
Post
#4
|
||
|
Boss, my code's compiling (xkcd) Group: Admins Posts: 10,440 Joined: 19-September 01 Member No.: 1 |
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 thumbnail(s)
-------------------- Things that I don't suck at: Photography (flickr, JPG Mag), "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 |
|
|
|
|
|
|
Apr 2 2008, 05:26 AM
Post
#5
|
|
|
MaD_cOw has nothing on me at MODing! Group: Moderators Posts: 916 Joined: 4-June 04 From: California Member No.: 1,362 |
Awesome. Thanks Ali. All better.
-------------------- QUOTE("Richard Hammond - Top Gear") We're gonna to die now, that's it." |
|
|
|
|
|
Lo-Fi Version | Time is now: 22nd May 2013 - 05:25 AM |
