Problems with Nuke 7.8

ccghs · 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 to the forums!

my website can be found

Only registered users can see links on this board!
Get registered or login to the forums!

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.

persona_non_grata · Joined: Posts: 0

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

ccghs · New Member Joined: May 15, 2006 Posts: 2

What is the difference?

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4687

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...

krubach · 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

krubach · New Member Joined: Jun 15, 2006 Posts: 19

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

gregexp · 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.

krubach · New Member Joined: Jun 15, 2006 Posts: 19

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

gregexp · 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.

krubach · New Member Joined: Jun 15, 2006 Posts: 19

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