Table 's' marked as crashed

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
ab9db
Registered User
Posts: 212
Joined: Tue Apr 22, 2003 5:57 pm
Location: Swindon, UK
Contact:

Table 's' marked as crashed

Post by ab9db »

Your board's URL: http://www.arsenal-land.co.uk/forum
Version of phpBB3: RC7
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)? update from RC6 (via other RC's)
Was this an install through your host? No
MODs you have installed: None
When the problem started: 8th November
SQL ERROR [ mysql4 ]

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

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Looked in phpMyAdmin, there is no table 's' ?

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: Table 's' marked as crashed

Post by karlsemple »

Table s???

your error states
SQL ERROR [ mysql4 ]

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

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
as such you need to run a repair in phpmyadmin on the phpbb_sessions table :)
Image

ab9db
Registered User
Posts: 212
Joined: Tue Apr 22, 2003 5:57 pm
Location: Swindon, UK
Contact:

Re: Table 's' marked as crashed

Post by ab9db »

Okay thanks, I still get table 's' appearing!

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: Table 's' marked as crashed

Post by karlsemple »

Ok try this
Jackal wrote:
  1. Create a fix.php file with the following:

    Code: Select all

    <?php
        
    define('IN_PHPBB', true);
    $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($phpbb_root_path . 'common.' . $phpEx);
    
    // Start session management
    $user->session_begin();
    $auth->acl($user->data);
    $user->setup();
    
    $page_title = 'phpBB Fix';
    
    $sql = " REPAIR TABLE $table_prefix" . "s";
    $db->sql_query($sql);
    
    ?>
  2. Upload the file to your board's root folder (the one with config.php)
  3. Run it by navigating to the file in your browser (ex. http://www.yoursite.com/phpBB3/fix.php)
  4. If any errors come up, post the report here.
  5. Be sure to delete the file; don't leave it on your server
The script should output nothing but a blank page but once you have run it try the board again :)
Image

Azaghan
Registered User
Posts: 2
Joined: Sat Oct 27, 2007 9:38 am

Re: Table 's' marked as crashed

Post by Azaghan »

What would happen if I repaired the entire database? Would it erase the information in the database? The reason I ask is the script seems to work but the problem comes back again soon thereafter. I assume the script is working, there are no errors and I didnt modify the script except to place an "m" where "s" is.

datkeoniguy
Registered User
Posts: 150
Joined: Sat Jan 24, 2004 8:11 pm

Re: Table 's' marked as crashed

Post by datkeoniguy »

I have the same problem in upgrading to RC8. My database prefix is phpbb3_ so do i need to change all instances of phpbb_ in the script below to _phpbb3

<?php

define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();

$page_title = 'phpBB Fix';


This becomes:

<?php

define('IN_PHPBB3', true);
$phpbb3_root_path = (defined('PHPBB3_ROOT_PATH')) ? PHPBB3_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb3_root_path . 'common.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();

$page_title = 'phpBB Fix';

Is this correct??

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29253
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: Table 's' marked as crashed

Post by Marshalrusty »

No, that's incorrect. The script Karl posted will work regardless of what table prefix you're using because it grabs that information from config.php (note the use of the $table_prefix variable in the query).
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

datkeoniguy
Registered User
Posts: 150
Joined: Sat Jan 24, 2004 8:11 pm

Re: Table 's' marked as crashed

Post by datkeoniguy »

Thanks, I got it fixed!

midwestmudboggers
Registered User
Posts: 10
Joined: Tue Feb 19, 2008 3:41 pm

Re: Table 's' marked as crashed

Post by midwestmudboggers »

where and how do you create a fix file? I am so lost on all of this! Sorry I am really lost

User avatar
jehzlau
Registered User
Posts: 218
Joined: Thu May 25, 2006 4:00 am
Location: Davao City
Name: Jehzeel Laurente
Contact:

Re: Table 's' marked as crashed

Post by jehzlau »

I encountered a problem in fix.php..

can you check this..

http://dostscholars.com/boards/fix.php

and this is the exact error:

Code: Select all

Fatal error: Call to a member function on a non-object in /home/dostscho/public_html/boards/fix.php on line 9

User avatar
jehzlau
Registered User
Posts: 218
Joined: Thu May 25, 2006 4:00 am
Location: Davao City
Name: Jehzeel Laurente
Contact:

Re: Table 's' marked as crashed

Post by jehzlau »

btw, it's fine now... :D I have removed the fix.php...

jayjayph
Registered User
Posts: 1
Joined: Tue Aug 25, 2009 6:29 am

Re: Table 's' marked as crashed

Post by jayjayph »

I am getting this error after running the script... Can anybody help me..
SQL ERROR [ mysqli ]

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

clight77
Registered User
Posts: 907
Joined: Sun May 11, 2003 11:09 pm

Re: Table 's' marked as crashed

Post by clight77 »

I had this issue just lately:
Table 'phpbb_sessions' is marked as crashed and should be repaired [1194]
,this fixed it for me.


Please try the following:This should work for all tables.

In cPanel X:

Open phpMyAdmin Select your database (e.g.: "mybb") > Scroll to the bottom of the page on the right, click "Check all" and then from the pull down box (should be to the right) that says "with selected" select "repair table".

It should then run and correct your problem.
I Follow Up On My Posts.
So Should Everybody...

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29253
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: Table 's' marked as crashed

Post by Marshalrusty »

Please note that the post you replied to was from 2009.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

Locked

Return to “[3.0.x] Support Forum”