Members: 16,996
Threads: 38,846
Posts: 159,391
Online: 23

Newest Member: Kl_broka@rediffmail.com


Odoo.tv - Outdoor Television


Sedo - Domains kaufen und verkaufen das Projekt mambers.com steht zum Verkauf Besucherstatistiken von mambers.com etracker® Web-Controlling statt Logfile-Analyse
Old 23.04.2004, 10:25   #1 (permalink)
Baby Mamber
 
Join Date: Apr 2004
Location: switzerland
Posts: 3
padu is on a distinguished road
Default MYSQL error (errno: 145)

Hello,

I have 2 times an erno: 145 error in mysql withe the mos_session table.
I knaow how to solve it, my question is more if somebody else has the same prob and if anyone knows why ?
Tahnks
Padu
padu is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Old 23.04.2004, 17:31   #2 (permalink)
Professional Mamber
 
tonyskyday's Avatar
 
Join Date: Apr 2004
Location: Charlottesville, VA USA
Posts: 565
tonyskyday is on a distinguished road
Default Re: MYSQL error (errno: 145)

You may be getting this error for a couple of reasons, so we need more information:

What version of MySQL do you have?
What is the cookie lifetime set to in the Mambo configuration?
Do you have phpmyadmin or some similar db interface tool you can use to repair the mos_session table?

-Tony
tonyskyday is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old 25.04.2004, 17:44   #3 (permalink)
Baby Mamber
 
Join Date: Apr 2004
Posts: 13
james is on a distinguished road
Default Re: MYSQL error (errno: 145)

Hope you have buckup for every db file, you should delete mos_session from your mysql and upload the new one, if you dont have you can create one yourself in the notepad.
Here is how should looks, then drop the old one upload this one it will works.

#
# Table structure for table `mos_session`
#
DROP table IF EXISTS mos_session;
CREATE TABLE `mos_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',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_session`
#
james is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old 28.11.2004, 00:40   #4 (permalink)
Baby Mamber
 
Join Date: Nov 2004
Posts: 1
virstad is on a distinguished road
Default Re: MYSQL error (errno: 145)

Thanks for your rows. I noticed that my homepage hade these errors, followed your description and everything is OK again!

Cheers - Josef
virstad is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Non MySQL CMS Kumagoro Community Smalltalk 28 13.06.2007 08:42
experts pls help: mysql strange behavior coke Development Discussions 5 19.04.2004 20:10
Mysql Port Options titansking Mambo 4.5 Installation and Upgrades 13 17.04.2004 18:34
Converting MySQL tables from PHPKIT to MAMBO ? mrcina Mambo 4.5 'How Do I' Questions 2 09.04.2004 02:59


All times are GMT +2. The time now is 05:15.

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.1.0
A vBSkinworks Design
© Copyright 2004-2008 by Arthur Konze Webdesign.