Problems with Nuke 7.8

New Member Joined: May 15, 2006 Posts: 2

I downloaded Nuke 7.8 version 2.3.1-rc1
I uploaded in using WS_FTP Pro. I did what the insturctions said to do. When I was finished I could not get nothing to work, I contacted my Webhosting provider and he help correct the problems but two.

First Problem. Forums:

When you click on the link this comes up:

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1054 Unknown column 'session_admin' in 'field list'

INSERT INTO nuke_bbsessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('8e5018248371b78de3352e30b659d561', '202', '1148089226', '1148089226', '18b2d6c4', '0', '1', '0')

Line : 203
File : sessions.php

Second Problem:

The News Story is not working either. I will submit a story but it will not publish it on the main page. Actually nothing happens. This is what I do.

Hit Submit Articles (Submit News_News),
Type in my title
select my topics
type the news/story
preview it
post it

everything is find up till the post. When I hit post the story is deleted.

I do not know anything about PHP Nuke. I copied the nuke.sql in text which can be found Only registered users can see links on this board! Get registered or login! my website can be found Only registered users can see links on this board! Get registered or login!

I have spent Thursday, friday, saturday, and sunday trying to figure this out. Even my webhost provider doesn't understand either.

Thank you for your help.

Sells PC To Pay For Divorce Joined: Posts: 5661

well maybe its better to download the ravennuke,follow the download link on the index here..
then read the install carefully...
its easy.....

Posted: Mon May 22, 2006 1:55 pm

What is the difference?

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

The error message tell alls:

Quote:

SQL Error : 1054 Unknown column 'session_admin' in 'field list'

That means that your code is trying to use a table attribute (field) that does not exist.

It seems like you updated your scripts without updating the database...

New Member Joined: Jun 15, 2006 Posts: 19

I also can't submit new stories.
I set everything right click submit and nothing happens...

Sad

Posted: Tue Jul 04, 2006 3:34 am

hey hey... don't reply all at the same time. Laughing

Ok, maybe someone can point me out the flow of things when you post news.
The postStory function defined in .../modules/news/admin/index.php is not called when i click submit.

Do you know WHERE postStory is called?
So i can track down whereis it failing?

TIA

Posted: Tue Jul 04, 2006 3:32 pm

set your browser to debug code in advanced options and set to display errrors in config.php

If neither of these show any results, Id say more direct involvemement would be needed.

Posted: Tue Jul 04, 2006 3:47 pm

I set to a verbose debug ... but nothing appeared.
Then i just comented the "Header(Location...." part from index.php in ...modules/news/admin/
I "echoed" the SQL INSERT statement and there it was: Smile

Somehow the nuke_stories table wasn't updated. The "rating_ip" field was missing.
Since the INSERT statement had a value more than the table contained -> BANG!

Hope this helps someone with the same issue. Wink

@darklord
Thanks a lot. Wink

Posted: Tue Jul 04, 2006 6:57 pm

Glad that helped but I believe turning errors on in config.php may have given you the error it was running into. Glad you got it fixed.

Posted: Wed Jul 05, 2006 3:00 am

darklord wrote:

Glad that helped but I believe turning errors on in config.php may have given you the error it was running into. Glad you got it fixed.

It would. But the end of the routine the "Header(Location:..." call would simply load another page and i would never see the error. Wink

I just added some echos to see where in the code i was getting to. Wink