Joomla! Discussion Forums

Yesterday I was able to login in to my JOOMLA ADMINISTRATION today i keep tryin to login but a pg with redlines come and it syas:

DB function failed with error number 1036
Table 'jos_session' is read only SQL=INSERT INTO jos_session SET time = '1187818643', session_id = '5ec426093f6d73873794af0314920b2a', userid = 62, usertype = 'Super Administrator', username = 'admin'DB function failed with error number 1036
Table 'jos_session' is read only SQL=DELETE FROM jos_session WHERE userid = 62 AND username = 'admin' AND usertype = 'Super Administrator' AND session_id != '5ec426093f6d73873794af0314920b2a' AND guest = 1 AND gid = 0DB function failed with error number 1036
Table 'jos_messages' is read only SQL=DELETE FROM jos_messages WHERE date_time < '2007-08-15 17:37:23' AND user_id_to = 62



after tht pg  the url is changed to....

http://www.mysite.com/index.php?mosmsg= ... %20Expired

plz help ASAP

What version do you use?

Is your sessions.save_path directory writable?
You can use phpinfo(); to see the system specs: http://php.net/manual/en/function.phpinfo.php
The sessions.save_path is needed for storing the authentification sessions for the back-end. The front-end works with cookies.

Contact your host to make the sessions.save_path directory writable or
at Apache webservers it's possible to override the default session.save_path from php.ini, by using .htaccess.
See: http://forum.joomla.org/index.php/topic ... #msg562118

There is an admin session problem present in the J! 1.0.13 release.
For info and a solution, see: http://forum.joomla.org/index.php/topic,200725.0.html

This is the MESSAGE tht comes:

DB function failed with error number 1036
Table 'jos_session' is read only SQL=INSERT INTO jos_session SET time = '1187818643', session_id = '5ec426093f6d73873794af0314920b2a', userid = 62, usertype = 'Super Administrator', username = 'admin'DB function failed with error number 1036
Table 'jos_session' is read only SQL=DELETE FROM jos_session WHERE userid = 62 AND username = 'admin' AND usertype = 'Super Administrator' AND session_id != '5ec426093f6d73873794af0314920b2a' AND guest = 1 AND gid = 0DB function failed with error number 1036
Table 'jos_messages' is read only SQL=DELETE FROM jos_messages WHERE date_time < '2007-08-15 17:37:23' AND user_id_to = 62

Do you have phpMyAdmin access to your database?
If so you could try the following (but backup the current database first!):
Empty the jos_sessions table and try to login again.