The Joomla! Forum ™

Download

Demo


Board index » Joomla! Older Version Support » Joomla! 1.5 » Performance - Joomla! 1.5

Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Security and Performance FAQs
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 
  Print view Previous topic | Next topic 
Author Message
mjkahngr
 Post subject: site crash relate to SQL
PostPosted: Tue Dec 06, 2011 8:30 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Oct 30, 2009 4:33 pm
Posts: 37
I'm running Joomla 1.5 and all sites on the server are working as expected except one which returns a blank page. When I attempt to log into the administrator section (we are using JSecure Authentication) we get the following error message.

jtablesession::store failed
DB function failed with error number 145
Table './site_table_name/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '2366037ec5d3ee252ca55f0ee781eaed','1323202575','','0','1','1' )

Can anyone guide me to instructions on how to repair the SQL data?

Thanks in advance.
Top
 Profile  
 
brian
PostPosted: Tue Dec 06, 2011 9:20 pm 
User avatar
Joomla! Exemplar
Joomla! Exemplar

Joined: Fri Aug 12, 2005 7:19 am
Posts: 9319
Location: Leeds, UK
You will need to use phpmyadmin which your host normally would provide as part of your hosting

http://www.siteground.com/tutorials/php ... tabase.htm

_________________
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/
Top
 Profile  
 
mjkahngr
PostPosted: Tue Dec 06, 2011 11:22 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Oct 30, 2009 4:33 pm
Posts: 37
Thank you Brian. It took a while, but I finally found the "with selected" drop down menu with the "repair table" function.
Top
 Profile  
 
brian
PostPosted: Tue Dec 06, 2011 11:24 pm 
User avatar
Joomla! Exemplar
Joomla! Exemplar

Joined: Fri Aug 12, 2005 7:19 am
Posts: 9319
Location: Leeds, UK
Glad to have helped.

(phpmyadmin interface is pretty ugly and to make it worse every host seems to have a different version installed and everything keeps moving)

_________________
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 


Board index » Joomla! Older Version Support » Joomla! 1.5 » Performance - Joomla! 1.5

Who is online

Users browsing this forum: No registered users and 4 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group