Upgrade to MySQL 5.1 makes Joomla! 1.5 crash?

[a_isings]

Happy New Year!

Several Joomla! sites I set up are hosted at worldwidemart.com.
When accessing my Joomla 1.5 sites I've been getting the following error:

jtablesession:: Store Failed
DB function failed with error number 1034
Incorrect key file for table 'jos_session'; try to repair it SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '72266e7e5b1585e003e6c23ec84ee91a','1262480539','','0','1','0' )

Websites affected include:
http://www.efiproduce.com
http://www.gr8-consulting.com
http://www.ivgna.org
http://www.kbbcuracao.com
http://www.tulalives.org

Note: The websites affected are all running Joomla! 1.5. My Joomla 1.X Websites all seem to work just fine.

The support staff of my host responded as follows:
"We upgraded to MySQL 5.1. Does Joomla have a workaround?"

So my questions are has anyone experienced the same issue and solved it?
And, does Joomla have a "work around"?

Thanks for thinking with me.

[dhuelsmann]

Joomla should work just fine with mysql 5.1. Try using phpMyAdmin to repair your database.

[a_isings]

@dhuelsmann:

Thanks for your advice. I tried to repair and all I got was:

Your SQL query has been executed successfully
ivgnaorg_jo151.jos_session repair Error Incorrect key file for table 'jos_session'; try to...
ivgnaorg_jo151.jos_session repair error Corrupt

Kindly refer to the attachment.

Any other avenues to explore?

[dhuelsmann]

Try running this in the sql window of PHPMyAdmin

Code: Select all

DROP TABLE IF EXISTS `jos_session`;
CREATE TABLE IF NOT EXISTS `jos_session` (
`username` varchar(50) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
`client_id` tinyint(3) unsigned NOT NULL default '0',
`data` longtext,
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)
) 

[a_isings]

@dhuelsmann

OK thanks that solved(?) one problem.
On to the next?

Thank you for your efforts so far!

[dhuelsmann]

Try to run repair on the table first.

[Tonie]

If you search for the error on the Internet, you will see this is a known issue when migrating from 5.0 to 5.1. This is more of a Mysql than a specific Joomla issue, also because it's directly caused by the Mysql upgrade. I would ask support to give you a workaround, since your sites won't run any more and it is their upgrade that caused this.

[a_isings]

@dhuelsmann

I did and the result is attached.

Still very grateful.

[a_isings]

If you search for the error on the Internet, you will see this is a known issue when migrating from 5.0 to 5.1. This is more of a Mysql than a specific Joomla issue, also because it's directly caused by the Mysql upgrade. I would ask support to give you a workaround, since your sites won't run any more and it is their upgrade that caused this.

I agree, but also loathe all hell breaking loose with my customers tomorrow.

Thanks for the support though!

[dhuelsmann]

http://mirrors.dotsrc.org/mysql/doc/ref ... ables.html

[a_isings]

@dhuelsmann:

Thanks

[rickymuchtar]

http://mirrors.dotsrc.org/mysql/doc/ref ... ables.html

The link is broken i think, but i found other link:
http://dev.mysql.com/doc/refman/5.1/en/ ... ables.html

But to be honest, I don't understand what should i do.
I already did REPAIR TABLE (db_name) and I got same response as above.
But after that, I still don't know what to do..
please advice.. thank you

[rickymuchtar]

Try running this in the sql window of PHPMyAdmin

Code: Select all

DROP TABLE IF EXISTS `jos_session`;
CREATE TABLE IF NOT EXISTS `jos_session` (
`username` varchar(50) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
`client_id` tinyint(3) unsigned NOT NULL default '0',
`data` longtext,
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)
) 

I try running the sql above, but the result:
"Missing value in the form"

Is there anyone help me please?