PHPBB error...

Regular Joined: Jul 14, 2005 Posts: 64

Hey i have done a new installation of phpnuke 7.6 patched 3.0 (i think)
but i have installed it so it is getting accessed through the IP .. like this
http://70.85.30.206/~clanaif/ .. anyway i have installed it fine but when i try to use the forum module i get this error:

Quote:

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 ('a92e93d5e645c7176ca9446bc82a2df9', '1', '1132551710', '1132551710', 'ca07a6a5', '0', '0', '0')

Line : 203
File : sessions.php

would it be because of it being accessed through IP?
i have installed it about 3 times so i dunno whats causing it...
thanks in advance!

Posted: Mon Nov 21, 2005 12:32 am

hmm thats wierd.. i did a new installation if PHP-Nuke platinum and the images dont show :S .. have a look
http://70.85.30.206/~clanaif/
anyone know what would be causing this?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

lazarus111 wrote:

Hey i have done a new installation of phpnuke 7.6 patched 3.0 (i think)
but i have installed it so it is getting accessed through the IP .. like this
http://70.85.30.206/~clanaif/ .. anyway i have installed it fine but when i try to use the forum module i get this error:

Quote:

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 ('a92e93d5e645c7176ca9446bc82a2df9', '1', '1132551710', '1132551710', 'ca07a6a5', '0', '0', '0')

Line : 203
File : sessions.php

would it be because of it being accessed through IP?
i have installed it about 3 times so i dunno whats causing it...
thanks in advance!

Please search the forums for 1054 Unknown column

Posted: Mon Nov 21, 2005 6:59 am

The first issue is because your Forum files and your database tables do not jive with each other. The 7.6 patched 3.* that you installed should have had an "update.php" in the root that you will need to run to add the admin session column that is giving you your error.

As for the missing images, it is quite possible that the theme folder is corrupt and will need to be reuploaded. As for your question about whether it is happening because you are calling up your site via IP, yes I think that is a possibility as well. You can determine if that is the cause by setting the IP in your Nuke Preferences and Forum ACP General settings.

Hope this helps

Posted: Thu Nov 24, 2005 12:30 am

Okay i have set the IP in the prefrences but still no go.. and its not the theme because i have tried several ... i cant figure out what is causeing this...
if you directly link to one of the image files it wont show but if u upload your own image it does show :S .. i dunno whats going on someone please HELP!

Posted: Thu Nov 24, 2005 6:59 am

Using your FTP client, verify that the theme files all have a file size, and are not showing zero for filesize.

Posted: Thu Nov 24, 2005 5:15 pm

Yep they all have there own filesize.. but still they dont show Sad

Posted: Fri Nov 25, 2005 9:45 am

Any ideas?

Posted: Fri Nov 25, 2005 10:25 am

I presume you have checked the permissions on the theme folder and in particular the images directory and images themselves to ensure they are world readable?

Posted: Sat Nov 26, 2005 7:05 am

yeah i have done that... even when i upload ANY image it does it ... :S

Posted: Sat Nov 26, 2005 7:23 am

Hmm how wierd.. if i use fantastico to install crappy 7.7 the image show fine.. :S help needed !!

Posted: Sat Nov 26, 2005 7:27 am

Would it have anything to do with me using the Cpanel filemanager to extrat all the files from the "html" directory instead of uploading them one by one?"???

Posted: Sat Nov 26, 2005 7:58 am

It is quite possible. It would be worth checking.

Posted: Sat Nov 26, 2005 9:18 am

That could be well worth investigating as CurtisH mentioned.
I have never used it myself but another question pops up with regard to the file manager - I wonder if it is uploading the files in the correct mode i.e ascii /binary

Posted: Sat Nov 26, 2005 10:59 am

I see, well it takes a s**tload of time to upload all the files on 256k UP.. so ill do it tonight and get back to you guys .. Smile

EDITED by moderator to remove profanity. Please refrain from using profane language

Posted: Sat Nov 26, 2005 9:33 pm

sorry about that, Yep i uploaded them one by one .. took like 6 hours but its working fine..
Ive told Cpanel.net about the issue and they said it will be fixed in the next release or something..

Posted: Sat Nov 26, 2005 10:08 pm

Ok i havent done much to the site but now im having another small problem...
go to http://70.85.30.206/~clanaif/index.php and have a look at it.. can someone please tell me why none of the "right" blocks will show up!!
ive used this skin on a different site with the same phpnuke installtion version and they do show...

Posted: Sat Nov 26, 2005 10:37 pm

Nevermind about that last post, i found out with a little searching that its sometthing to do with a new security feature in 3.1 patch.. i just had to change something in the theme.php and its working fine now.. Smile