[Solved] Italian Forum unreachable: SQL error

The place for discussions and decisions about the forum

[Solved] Italian Forum unreachable: SQL error

Postby paolopoz » Thu Aug 23, 2012 1:08 pm

I am the administrator for the italian forum. I always managed the forum only in the frontend, as for the backend I relied on TerryE, who set-up all things back when we started. I did not follow all the changes made after ASF get the management, so I am asking here for help, given that I don't know who is in charge for this kind of issues.

Since today (at least) trying to access the italian forum returns this error message:
Code: Select all   Expand viewCollapse view
General Error
SQL ERROR [ mysqli ]

Table './it/phpbb_it_sessions' is marked as crashed and last (automatic?) repair failed [144]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.


Can someone please help me or tell me who I need to get in touch?
Thank you.
Last edited by Hagar Delest on Thu Sep 27, 2012 8:24 am, edited 1 time in total.
Reason: tagged [Solved].
AOO 3.4.1 on Kubuntu
paolopoz
 
Posts: 7
Joined: Mon Oct 27, 2008 10:36 pm
Location: Italy

Re: Italian Forum unreachable: SQL error

Postby FJCC » Thu Aug 23, 2012 2:10 pm

I just sent an email to Imacat, the new administrator. She is in Taiwan, so it is ~20:00 there.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7257
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Italian Forum unreachable: SQL error

Postby TerryE » Thu Aug 23, 2012 5:10 pm

It's a one liner to repair the table -- if its repairable, but you need interactive access to the Forum server which I no longer have or want.

This used to be done nightly by the backup/maintenance script. Unfortunately finishing migrating this was still on my todo list when I gave up the admin role after one flaming too many by the Apache guys. AFAIK, this work has never been done. Sorry
Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.
TerryE
Volunteer
 
Posts: 1402
Joined: Sat Oct 06, 2007 10:13 pm
Location: UK

Re: Italian Forum unreachable: SQL error

Postby imacat » Thu Aug 23, 2012 8:48 pm

I suppose it is back now. Please check if it works fine.

The SQL table phpbb_it_session is corrupted. I zeroize the table (TRUNCATE) and it seems to work.
User avatar
imacat
Site Admin
 
Posts: 48
Joined: Sun May 20, 2012 1:13 am
Location: Taipei, Taiwan

Re: Italian Forum unreachable: SQL error

Postby paolopoz » Thu Aug 23, 2012 10:01 pm

It worked! Thanks!

Just to know... What is that table for? Could some kind of data be lost?
Is it possible to schedule some kind of table repair like TerryE said?
Sorry if I wrote something wrong, I am not an expert.
AOO 3.4.1 on Kubuntu
paolopoz
 
Posts: 7
Joined: Mon Oct 27, 2008 10:36 pm
Location: Italy

Re: Italian Forum unreachable: SQL error

Postby TerryE » Sun Aug 26, 2012 6:16 pm

I offered to go through what needs to be done to finish the migration of the batch script with Imacat. The offer is still open :-)

As to the session table, yes truncating it is fine. The worst consequence is that users will need to log on again to establish persistent sessions.
Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.
TerryE
Volunteer
 
Posts: 1402
Joined: Sat Oct 06, 2007 10:13 pm
Location: UK


Return to Forum Governance

Who is online

Users browsing this forum: No registered users and 1 guest