another "DB Error: Duplicate entry 'xxx' for key 1"

[rsenise]

Hi!

I'm having a problem with sessions. When I try to visit the site I get the message "DB Error: Duplicate entry 'xxx' for key 1".

Someone had some trouble like mine, but I believe it's worst now: I can only see the homepage once, if I click anywhere I get the Duplicate entry error. If I try to login, it happens the same.

Yes, I did clean up my database, and the error comes again. And yes, my "session.auto_start" is set to off, and OJS's "force_login_ssl" is off, too.

What could I do?

[jmacgreg]

Hi rsenise,

Can you follow Alec's advice on finding more errors in the following link and get back to us with what you find:

viewtopic.php?f=8&t=2885&p=10244#p10244

Thanks,
James

[rsenise]

Hi!
I put "ini_set('display_errors', E_ALL);" in index.php, but it didn't work.

Then I turned On the show_stacktrace option in config.inc.php, and it shows these errors:

Stack Trace:
File: /home/anptur1/public_html/rbtur/classes/session/SessionDAO.inc.php line 79
Function: DAO->update("INSERT INTO sessions (session_id, ip_address, user_agent, cr...", Array(7))

File: /home/anptur1/public_html/rbtur/classes/session/SessionManager.inc.php line 78
Function: SessionDAO->insertSession(Object(Session))

File: /home/anptur1/public_html/rbtur/classes/session/SessionManager.inc.php line 105
Function: SessionManager->SessionManager(Object(SessionDAO))

File: /home/anptur1/public_html/rbtur/index.php line 38
Function: SessionManager::getManager()

File: /home/anptur1/public_html/rbtur/index.php line 57
Function: handleRequest()

My site URI is http://anptur1.tempsite.ws/rbtur/index.php, if it happens....

Thanks, Ricardo Senise.

[smiri]

Hi Ricardo,

have you checked your server error_logs yet?

Also what happens if you delete your sessions from your database

Code: Select all

DELETE FROM sessions;

can you access the site then?