Zikula Community

• acorletti
  
  

  • Rank: Registered User
  • Registered: May 18, 2009
  • Last visit: May 20, 2009
  • Posts: 2

  Posted: May 18, 2009 - 06:13 AM

  Hello,
  I Had a problem with free space in my HD Server, and then It is impossible logon in may web. the error (on te top of my web: www.porunlugarmejor.org) is: "Can't open file: 'zk_session_info.MYD".
  
  I yet probe with the "Mysql repair" but continue with the same error.
  
  What I can doit to reconstruct the Table or data base???

  • 
  •  
• larsneo
  
  

  • Rank: Software Foundation
  • Registered: Dec 31, 1969
  • Last visit: Oct 21, 2009
  • Posts: 3814

  Posted: May 18, 2009 - 06:29 AM

  please check the "Drop and Re-create the sessions table"-section at
  http://community.zik…nitialisationFailed
  
  --
  regards from germany
  ..::[Zikula Application Framework]::.. ..::[SEO-Blog]::.. ..::[CMS Sicherheit]::..

  • 
  •  
• dits
  
  

  • Rank: Developer
  • Registered: Feb 17, 2005
  • Last visit: May 21, 2010
  • Posts: 684

  Posted: May 18, 2009 - 06:41 AM

  Hi acorletti,
  
  See this is you first post here. Welcome. The data stored in the session info table are important, but not critical. If you empty this table all your users will be logged out, but no content will be lost.
  
  You do have access to your database through phpMyAdmin? And you did try a repair on the table? If that did not solve the problem I would recommend to drop and recreate the table (you can export the structure and recreate the table without any content using phpMyAdmin). What best to do depends a bit on how critical the contents of the session table are. For an intranet with 2,000 logged in employees I would suggest trying to rescue the contents of the table. For a site with only a few registered users I would probably just drop and recreate the table.

  • 
  •  
• acorletti
  
  

  • Rank: Registered User
  • Registered: May 18, 2009
  • Last visit: May 20, 2009
  • Posts: 2

  Posted: May 20, 2009 - 07:58 PM

  Hello,
  
  I read all notices to this table, I reaper it, I drop and recreate with the follow Structure:
  
  CREATE TABLE IF NOT EXISTS `zk_session_info` (
  `pn_sessid` varchar(40) NOT NULL default ,
  `pn_ipaddr` varchar(32) NOT NULL default ,
  `pn_lastused` datetime default '1970-01-01 00:00:00',
  `pn_uid` int(11) default '0',
  `pn_remember` tinyint(4) NOT NULL default '0',
  `pn_vars` longtext NOT NULL,
  PRIMARY KEY (`pn_sessid`)
  ) TYPE=MyISAM?;
  
  
  But the problem continue. Now the banner in my web is different, Now the banner is:
  
  Unknown column 'pn_remember' in 'field list' SELECT pn_sessid AS "sessid",pn_ipaddr AS "ipaddr",pn_lastused AS lastused",pn_uid AS "uid",pn_remember AS "remember",pn_vars AS "vars" FROM zk_session_info WHERE pn_sessid='701b645f3496a81e199aee6b54f8018b'
  
  I don`t know what is this problem

  • 
  •  
• dits
  
  

  • Rank: Developer
  • Registered: Feb 17, 2005
  • Last visit: May 21, 2010
  • Posts: 684

  Posted: May 20, 2009 - 08:20 PM

  Please execute the SELECT statement in phpMyAdmin and see if it gives an error there.

  • 
  •  
•  
•  

Users on-line

• rgasch

This list is based on users active over the last 60 minutes.