- Moderated by:
- Support
-
- rank:
-
Freshman
- registered:
- November 2002
- Status:
- offline
- last visit:
- 03.01.04
- Posts:
- 40
First off, I know this is a fairly common problem judging by the amount of forum coverage, I've searched and have a mozilla browser filled with tabs on possible solutions:
http://forums.postnu…itialisation+failed
http://forums.postnu…itialisation+failed
http://forums.postnu…itialisation+failed
http://forums.postnu…itialisation+failed
The solutions I've found have not worked so far....
To list a few... I am running PHP 4.3.1, MySQL 3.23.54, phpMyAdmin 2.4.0 and PN 7.2.3 on a clarkconnect (Redhat Linux 7.1) box ... I realize PN is now at 7.2.6 but don't know if upgrading correct my problem, I'm getting an error when I attemp to change the nuke_session_info table type from MYISAM to ISAM ...
Raliegh has helped me out of many a nightmare... please help again! Inforpro, you helped me at the beginning to, almost a year ago... come on folks! -
- rank:
-
Professional
- registered:
- December 1969
- Status:
- offline
- last visit:
- 17.06.04
- Posts:
- 2122
Well we're here to help. I am of course going to suggest you upgrade as the version you are using is less secure. I have had this error myself 4 times now since I put up my very first PostNuke site long ago. Those times I did have it happen, I ran repair from phpMyAdmin and it fixed it every time. I also run optimize all tables weekly.
--
Friends rock, bullshit walks -
- rank:
-
Freshman
- registered:
- November 2002
- Status:
- offline
- last visit:
- 03.01.04
- Posts:
- 40
How do you run repair from phpMyAdmin? Upgrading PN... what's involved? Thanks for your support Infopro, good hearing from you again. -
- rank:
-
Professional
- registered:
- December 1969
- Status:
- offline
- last visit:
- 17.06.04
- Posts:
- 2122
Good to see you too. :)
Not all of these options will be on your version of phpMyAdmin I don't think, you might want to upgrade that as well.
http://mswebdesign.com/fun/repairtables.gif
Click select all, then pick it from that drop down list.
There are a few tuts in the tutorials and solutions forum here that help to explain upgrading. Here is one of those threads by a guy I know.. ;)
http://forums.postnuke.com/index.php?name=PNphpBB2&file=viewtopic&t=5080
Good luck. :wink:
--
Friends rock, bullshit walks -
- rank:
-
Freshman
- registered:
- November 2002
- Status:
- offline
- last visit:
- 03.01.04
- Posts:
- 40
Thanks infopro, I'm going to download and install the latest phpMyAdmin, repair the DB tables, then go for the latest nuke.
The newest phpMyAdmin should make my site viewable again right?
Thanks! -
- rank:
-
Freshman
- registered:
- November 2002
- Status:
- offline
- last visit:
- 03.01.04
- Posts:
- 40
I have the latest phpMyAdmin running (2.5.3rc2) and ran repair but I still have issues with test.nuke_session_info .... It appears my nuke_session_info.MYD is corrupt. Can I get a replacement? -
- rank:
-
Professional
- registered:
- December 1969
- Status:
- offline
- last visit:
- 17.06.04
- Posts:
- 2122
You "could" try this. It's ripped straight from the default Phoenix-0.7.2.6.sql file.
(no guarantees though, so backup this first)
Code
# Table structure for table `nuke_session_info`
#
# Creation: Jun 15, 2003 at 09:41
# Last update: Jun 15, 2003 at 09:42
#
CREATE TABLE `nuke_session_info` (
`pn_sessid` varchar(32) NOT null default '',
`pn_ipaddr` varchar(20) NOT null default '',
`pn_firstused` int(11) NOT null default '0',
`pn_lastused` int(11) NOT null default '0',
`pn_uid` int(11) NOT null default '0',
`pn_vars` blob,
PRIMARY key (`pn_sessid`)
) TYPE=MyISAM;
#
# Dumping data for table `nuke_session_info`
#
INSERT INTO `nuke_session_info` VALUES ('8b4b52597d41a32e89783e5103c95a9f', '80.145.92.84', 1055706107, 1055706136, 2, 0x504e535672616e647c693a313237393333323539313b504e53566c616e677c733a333a22656e67223b504e53567569647c693a323b);
Go back to phpMyAdmin and click your DB (on left) Look on right for SQL and click. that should open a query window. Paste this in.
It should dump the old and load a fresh new one.
**again, this is just to see if this will fix you, no guarantees.**
--
Friends rock, bullshit walks -
- rank:
-
Registered User
- registered:
- August 2003
- Status:
- offline
- last visit:
- 30.08.03
- Posts:
- 1
I'm having the same problem as this guy, ("Session initialisation failed" on every page) and I tried what has been suggested before but I can not get it to work.
Here's my info:
PHP Version 4.3.0
System Linux junker.org 2.4.20 #2 Mon Dec 30 02:04:21 EST 2002 i686
Configure Command './configure' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-wddx' '--enable-discard-path' '--with-mysql' '--with-pgsql' '--with-zlib' '--enable-dbase' '--with-gd'
PostNuke Version 0.726 Phoenix
I was able to view the index page once, right after I installed, after that, nothing worked.
Any ideas? (BTW, I don't have access to the php.ini file) -
- rank:
-
Freshman
- registered:
- April 2003
- Status:
- offline
- last visit:
- 29.01.04
- Posts:
- 23
The solution you suggested worked.
I found "session initialization failed" on my PostNuke portal, rushed to the forums, did a search for it, found this thread, logged in my phpMyAdmin, dropped that nuke_session_info table and recreated by running the code as a query and its fixed.
I am hoping the problem will not repeat. Does any one know if the code infopro posted is a temporary fix or a permanent solution?
Keep up the good work, PostNuke team and volunteers! -
- rank:
-
Freshman
- registered:
- March 2002
- Status:
- offline
- last visit:
- 20.09.05
- Posts:
- 25
Another approach to resolve this issue.
- Goto your myphpadmin web console.
- In your website SQL table, select "nuke_session_info" then "repair table".
This will do the trick correcting your session.
Best regards,
TW
--
-----------------------------------------------------------
Hardworking.com - small business and home business owners.
-----------------------------------------------------------
