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


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
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


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
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.