Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Login Errors ?

Quote Reply
Login Errors ?
A fatal error has occured:

GT::Session::SQL (8874): Failed to execute query: 'DELETE FROM glinks_Sessions WHERE (session_date < ? AND session_expires = ?)': Unknown column 'session_expires' in 'where clause' at /home/MYDOMAIN/cgi-bin/booths/admin/Links/Authenticate.pm line 172.


Does anyone know what the heck is going on here?


Sandra Roussel
Chonsa Group Design - Fresh Start Housing

Last edited by:

SandraR: Jul 7, 2008, 9:22 AM
Quote Reply
Re: [SandraR] Login Errors ? In reply to
Mmm.. odd

Try going to:

http://domain.com/cgi-bin/dev/admin/admin.cgi?db=Sessions&do=editor_update_def

..what does it show you for the fields there now? Should be:

Quote:
1 session_id CHAR(32) Yes TEXT
2 session_user_id CHAR(50) Yes TEXT
3 session_date INT Yes TEXT
4 session_expires TINYINT No 1 TEXT
5 session_data TEXT No TEXTAREA

..that error would indicate to me, that the "session_expires" field has been removed somehow (directly in the DB, and not in the admin area)

Give that a go - and I expect you will find its missing that field.

If so, should be as simple as re-adding it:

Field Name: session_expires
Type: TINYINT
Default : 1
Form Type: TEXT
Form size: 10

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Login Errors ? In reply to
Hey Andy,

That fixed it -- THANKS!

Now I can play with the new FF Laugh


Sandra Roussel
Chonsa Group Design - Fresh Start Housing
Quote Reply
Re: [SandraR] Login Errors ? In reply to
No worries - btw, its always good to have a backup of your database - in case of things like the above (but more serious).

You can do it easily via MySQLMan (or via my Auto_Backup plugin - which can be set to run whenever you want, via cronjob (and backup other sections of your GLinks install too =))

I believe you already own the ULTRA Package, so thats part of it Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Login Errors ? In reply to
Just landed here thanks to Google with the same error, and your fix worked for me too. Thanks.