So also to update this a bit I went into PHPMYADMIN and found that at some point something in the gl_sessions Table was changed and it states there seems to be a couple of problems:
This is what I see in the gl_sessions table maybe someone can decipher the error I know I can't although if I know what to change I'm not afraid to edit I can do that part
darn I cant get the table values to flow right in the post so I used "---" to seperate the columns sorry :doh: wish I new a better way to paste this info to read better...
gl_sessions
Field ---------------Type--------------Null-------Default
sess_id -----------int(10)------------No--------0
start_time --------int(10)------------No--------0
remote_ip -------varchar(15) -----No
uid -----------------mediumint( 8 ) ----No--------1
md5_sess_id----varchar( 128 ) ----Yes----NULL
Indexes:
Keyname------------Type---------Cardinality------------Field
PRIMARY----------PRIMARY---------0------------------sess_id
remote_ip_2------UNIQUE-----------0-----------------remote_ip
uid-------------------UNIQUE-----------0--------------------uid
start_time_2-----UNIQUE------------0---------------start_time
sess_id_3---------UNIQUE-----------0----------------sess_id
md5_sess_id_2--UNIQUE--------None-------------md5_sess_id
sess_id------------INDEX-----------None---------------sess_id
start_time---------INDEX-----------None--------------start_time
remote_ip---------INDEX-----------None--------------remote_ip
sess_id_2---------INDEX----------None---------------sess_id
md5_sess_id-----INDEX---------None--------------md5_sess_id
remote_ip_4-------INDEX---------None--------------remote_ip
remote_ip_5------INDEX----------None---------------remote_ip
start_time_3-------INDEX----------None--------------start_time
uid_2----------------INDEX-----------None----------------uid
remote_ip_3----FULLTEXT-------None-------------remote_ip
md5_sess_id_3-FULLTEXT------None----------md5_sess_id
Space usage:
Type-------Usage
Data-------32 Bytes
Index------17,408 Bytes
Overhead--32 Bytes
Effective---17,408 Bytes
Total--------17,440 Bytes
Row Statistics:
Statements---------Value
Format--------------dynamic
Rows-------------------0
Creation--------------Mar 07, 2008 at 03:39 AM
Last update----------Mar 07, 2008 at 04:24 AM
And under all the of these Table values I get these statements which look like errors:
Warning PRIMARY and INDEX keys should not both be set for column `sess_id`
Warning More than one INDEX key was created for column `sess_id`
Warning UNIQUE and INDEX keys should not both be set for column `remote_ip`
Warning More than one INDEX key was created for column `remote_ip`
Warning UNIQUE and INDEX keys should not both be set for column `uid`
Warning UNIQUE and INDEX keys should not both be set for column `start_time`
Warning More than one INDEX key was created for column `start_time`
Warning UNIQUE and INDEX keys should not both be set for column `md5_sess_id`
So this is what I see in the gl_sessions Table which I think is where my problem lies with the Error:
1062: Duplicate entry '1' for key 3. SQL in question: INSERT INTO gl_sessions (sess_id, start_time, remote_ip, uid)
VALUES (1600516717,1204871718,'67.170.200.37',1)
Any and all help will be appreciated tremendously!
Thanks,
Dennis Espindola
http://www.selfautotech.com