Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme

User Box

Anonymous

38.107.179.220

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ? This s...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriously...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Sql error : 1054 unknown column 'session_admin' in 'field li

Sql error : 1054 unknown column 'session_admin' in 'field li

7 Replies / 2408 Views


www.clanthemes.com Forum Index » PHPBB	View previous topic :: View next topic

Bluud
Reputation: 21.6
Local time: 6:06 AM
Location: Oklahoma

Spawn Killer

0.02 posts per day
Medals: 0

Joined: Aug 04, 2008
Last Visit: 31 Jan 2010
Posts: 33
Points: 554

Sql error : 1054 unknown column 'session_admin' in 'field li Posted: Mon Aug 04, 2008 9:16 pm

The url for my website is http://bluud.byethost3.com and I am using rwsRavenNuke76_v2.02.02. When I open the forum I am getting the error SQL Error : 1054 Unknown column 'session_admin' in 'field list'. I have fixed this before in the past, but I can remember what I did to fix it. Anyone know a quick fix for this? I remember doing something about adding some tables in the db, but I cant remember what they were. Please, any help is appreciated.

kileak
Reputation: 0.1
Local time: 7:06 AM

Noob

0.00 posts per day
Medals: 0

Joined: May 24, 2008
Last Visit: 04 Aug 2008
Posts: 1
Points: 110

Sql error : 1054 unknown column 'session_admin' in 'field li Posted: Mon Aug 04, 2008 10:38 pm

this may help you.

http://www.karakas-online.de/forum/viewtopic.php?t=2916

Bluud
Reputation: 21.6
Local time: 6:06 AM
Location: Oklahoma

Spawn Killer

0.02 posts per day
Medals: 0

Joined: Aug 04, 2008
Last Visit: 31 Jan 2010
Posts: 33
Points: 554

Sql error : 1054 unknown column 'session_admin' in 'field li Posted: Mon Aug 04, 2008 11:56 pm

Well, the only answer they had there was to run an upgrade patch for something I am not using. Other than that there was no help there. What I could really use is the table that needs to be added to phpMyAdmin. The thread is not still there from where I used to be a member of this site a long time ago. If I am not mistaken it was either Floppy or Ped that was able to help me in the past.

Bluud
Reputation: 21.6
Local time: 6:06 AM
Location: Oklahoma

Spawn Killer

0.02 posts per day
Medals: 0

Joined: Aug 04, 2008
Last Visit: 31 Jan 2010
Posts: 33
Points: 554

Sql error : 1054 unknown column 'session_admin' in 'field li Posted: Tue Aug 05, 2008 12:23 am

Actually, I fixed it myself, and here is what I did:

I inserted: session_admin char(32) NOT NULL default '',

at the beginning of CREATE TABLE nuke_bbsessions (

so that it looks like this:

CREATE TABLE nuke_bbsessions (
session_admin char(32) NOT NULL default '',
session_id char(32) NOT NULL default '',
session_user_id mediumint(8) NOT NULL default '0',
session_start int(11) NOT NULL default '0',
session_time int(11) NOT NULL default '0',
session_ip char(8) NOT NULL default '0',
session_page int(11) NOT NULL default '0',
session_logged_in tinyint(1) NOT NULL default '0',
PRIMARY KEY (session_id),
KEY session_user_id (session_user_id),
KEY session_id_ip_user_id (session_id,session_ip,session_user_id)
) TYPE=MyISAM;

This actually is something that needs to be corrected in the sql table in the Ravennuke version mentioned. Other than this I dont see any other bugs except 1:

On the beginning page, the welcome text from when you first set things up cannot be removed or edited for some reason. Anyone know how to overcome that one?

floppy
Reputation: 2088.8
votes: 22
Local time: 7:06 AM
Location: Jackson Mississippi

Site Admin

1.16 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 03 May 2012
Posts: 2353
Points: 132516

Re: Sql error : 1054 unknown column 'session_admin' in 'fiel Posted: Tue Aug 05, 2008 3:16 am
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

Wow, really great to see users fixing things on their own and posting the fixes. Great Job.

Keep us updated with any possible problems or errors.

Phpnuke Downloads | VMaxxRx Male Enhancement

Bluud
Reputation: 21.6
Local time: 6:06 AM
Location: Oklahoma

Spawn Killer

0.02 posts per day
Medals: 0

Joined: Aug 04, 2008
Last Visit: 31 Jan 2010
Posts: 33
Points: 554

Sql error : 1054 unknown column 'session_admin' in 'field li Posted: Wed Aug 06, 2008 1:12 am

The name I used to go by here was Shixter. I been outta the loop for awhile. Just now starting to dip back into PHP so a little slow atm remembering how to fix things, lol.

Ped
Reputation: 93.7
votes: 37
Local time: 1:06 PM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 25 May 2012
Posts: 3672
Points: 191886

Re: Sql error : 1054 unknown column 'session_admin' in 'fiel Posted: Wed Aug 06, 2008 7:33 am
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

I remember you Shixter, good 6-8 month ago if not longer... Have you posted this over at Ravens site ?

Bluud
Reputation: 21.6
Local time: 6:06 AM
Location: Oklahoma

Spawn Killer

0.02 posts per day
Medals: 0

Joined: Aug 04, 2008
Last Visit: 31 Jan 2010
Posts: 33
Points: 554

Sql error : 1054 unknown column 'session_admin' in 'field li Posted: Thu Aug 07, 2008 2:16 pm

No, I havent. I remember some time before i disappeared for a bit, that his site wasnt running or my ISP wasnt letting get through to his domain or some other such. I will go post it over there though. I remember having this very same issue way back on a new install for another site. It looks as though the version I downloaded this time around is the very same I used over a year ago. So I will make sure to post over there and here any bugs I find and figure out how to overcome.

www.clanthemes.com Forum Index » PHPBB

7 Replies / 2408 Views
Page 1 of 1
All times are GMT

Display posts from previous:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work