Joomla Templates Club 406,261 posts

[anaivelisse Friend anaivelisseJoin date: May 2008Posts: 155Downloads:0Uploads:13 Thanks: 27 Thanked: 18 times in 1 posts]

#131029

My dabadase crashed and I need help to repair thta table. How can I do that….

This is the message I’ve got::eek:

jtablesession::Store Failed
DB function failed with error number 1194
Table ‘jos_session’ is marked as crashed and should be repaired

[Menalto Friend MenaltoJoin date: May 2007Posts: 4736Downloads:0Uploads:43 Thanks: 2 Thanked: 531 times in 361 posts]

#260748

You have phpmyadmin? If so its easy
Login to phpMyAdmin
1.select the database.
2.In the main window you see all tables. Check the boxes next to the tables you need to repair.
3.At the bottom of the window right below the end of the tables there is a drop down menu. Choose “Repair Table”
This should hopefully fix it, if it does, remember to do a BACKUP….

[anisjolly Friend anisjollyJoin date: April 2008Posts: 661Downloads:0Uploads:15 Thanks: 33 Thanked: 96 times in 55 posts]

#260749

Hi ana

Login to your site’s hostname. it should be something like mysql.thenameofyoursqlhostname

If you do not know how to do this, log into PHPMyAdmin and find the database and the table you’re having problems with.

once you can see the table structure, there will be a menu option called ‘Operations’ (in fact there will be 2 – one at the top and the bottom).

click on Operations and there should be a link on the page called ‘Repair Table’.

That should do the trick for you.

However, before you do this, please backup you database (even if one of the table’s is not working), just in case anything goes wrong with the repair.

Hope this helps.

[anisjolly Friend anisjollyJoin date: April 2008Posts: 661Downloads:0Uploads:15 Thanks: 33 Thanked: 96 times in 55 posts]

#260750

Menalto –

You beat me to the answer again!

I gotta type faster!

[anaivelisse Friend anaivelisseJoin date: May 2008Posts: 155Downloads:0Uploads:13 Thanks: 27 Thanked: 18 times in 1 posts]

#260850

Now I have this

jtablesession::store failed
DB function failed with error number 1054
Unknown column ‘client_id’ in ‘field list’ SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( ‘6d8df70df65b4b2b498788e0968ec45e’,’1216480621′,”,’0′,’1′,’1′ )

What should I do?

[mcseller Friend mcsellerJoin date: June 2006Posts: 45Downloads:0Uploads:3 Thanks: 2 Thanked: 4 times in 1 posts]

#260852

Hi ana,

can you reach your database by internet?

[anaivelisse Friend anaivelisseJoin date: May 2008Posts: 155Downloads:0Uploads:13 Thanks: 27 Thanked: 18 times in 1 posts]

#260855

Yes, I can.

Can you help me?

[mcseller Friend mcsellerJoin date: June 2006Posts: 45Downloads:0Uploads:3 Thanks: 2 Thanked: 4 times in 1 posts]

#260857

what kind of try have you done at the present?

[anaivelisse Friend anaivelisseJoin date: May 2008Posts: 155Downloads:0Uploads:13 Thanks: 27 Thanked: 18 times in 1 posts]

#260858

I tried to repair, to create a new one and to upload a back up with no success…I am about to drop it

[mcseller Friend mcsellerJoin date: June 2006Posts: 45Downloads:0Uploads:3 Thanks: 2 Thanked: 4 times in 1 posts]

#260859

and, please, say me what version of joomla you installed…

p.s.
try to understand I don’t speak/write English well 😮

[anaivelisse Friend anaivelisseJoin date: May 2008Posts: 155Downloads:0Uploads:13 Thanks: 27 Thanked: 18 times in 1 posts]

#260860

Actually, English is not my first language. I am using J 1.5.0.

[mcseller Friend mcsellerJoin date: June 2006Posts: 45Downloads:0Uploads:3 Thanks: 2 Thanked: 4 times in 1 posts]

#260861

Ana I also need to know if the crash has come after you installed any component/modules/plugin. If you did not install/modify nothing if you want you can send me by pv a text copy of your db so I can test this night.

[anaivelisse Friend anaivelisseJoin date: May 2008Posts: 155Downloads:0Uploads:13 Thanks: 27 Thanked: 18 times in 1 posts]

#260862

Mcseller-

The last thing I did was updating the Teline II template with the new version (1.4). After that, everything was OK. When I checked the site the next morning I got the message that the “jos_session” chrased. I have two db back ups. One is about three weeks old and one from today (even with the error). Can I send you the two files?

[mcseller Friend mcsellerJoin date: June 2006Posts: 45Downloads:0Uploads:3 Thanks: 2 Thanked: 4 times in 1 posts]

#260863

I can not promise nothing but I can tell you I will try this night. Send me those files!

[anaivelisse Friend anaivelisseJoin date: May 2008Posts: 155Downloads:0Uploads:13 Thanks: 27 Thanked: 18 times in 1 posts]

#260864

Can you send me an email. The text is too long for PM’s.

[Author]

Posts