ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down.
Read our Farewell Blog Post for more details.
Databse error
-
-
- darinb
- Hero Rocketeer
- Posts: 301
- Thanks: 0
-
I've been having troubel with my site--very slow at times--and occasionally I get a database error. This time I didn't forget to write it down. I thought maybe I;d post it here first (before the Joomal site) since people here are *way* smarter
This is what I get:
jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry 'ff7d79d9c9d9e031e7092df42335836f' for key 1 SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'ff7d79d9c9d9e031e7092df42335836f','1225823390','','0','1','0' )
Something I can fix? I know my way around Joomla a bit but database stuff is very iffy for me--though I know how to access it via myPhpAdmin...
Thanks,
--Darin
-
-
-
- prim
- Preeminent Rocketeer
- Posts: 17290
- Thanks: 217
- It's probably a permissions issue with duplicate entries in the db. Have you tried repairing the session table?
- Please reply with a direct link to the issue & create a new thread for each new issue.
A template is only as good as the content that goes into it
- DanG
-
-
-
- Josepha Thompson
- Sr. Rocketeer
- Posts: 160
- Thanks: 0
-
I am getting a similar situation with this error message:
jtablesession::Store Failed
DB function failed with error number 145
Table './eilmccco_cmsicdc/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'ca7331cb8a008d79e24df425257229ea','1227636484','','0','1','0' )
It is happening on multiple templates and is also happening again after I repair the table.
In my case, I am building/updating the site content, i.e., setting up menu structure, creating and pointing to articles, etc.
I have done much research on other forums and have not seen a response yet as to what could cause it and how to prevent it. It is rather scary that the sites could go down at anytime.
Thanks much for any assistance.
Josepha - “You were born to win, but to be a winner, you must plan to win, prepare to win, and expect to win.” - Zig Ziglar
-
-
-
- Andy Miller
- Preeminent Rocketeer
- Posts: 9919
- Thanks: 96
- Web Kahuna
- Just as a test, in the joomla Global configuration, change the session storage from Database to File. You shouldn't get any errors then.
-
-
-
- Josepha Thompson
- Sr. Rocketeer
- Posts: 160
- Thanks: 0
-
Hi.
I see the options below in my Global Config (Joomal 1.5.7). Are you referring to one of these? I am not seeing "Session Storage" specifically. Also, from another forum, someone said that the problem could be caused by "dirty rebooting of the server". I am not familiar with that terminology. Do you have information on what that is and how it could be caused?
Cache Settings:
>> Cache (set to No)
>> Cache Time: (set to 15 minutes)
>> Cache Handler: (set to "File" which is the only option)
Session Settings:
>> Session Lifetime (set to 25 minutes)
>> Session Handler (set to "Database"; only other option is "None")
Thanks for your help.
Josepha - “You were born to win, but to be a winner, you must plan to win, prepare to win, and expect to win.” - Zig Ziglar
-
-
-
- Andy Miller
- Preeminent Rocketeer
- Posts: 9919
- Thanks: 96
- Web Kahuna
- Doh! I thought there was a file setting in the Session Settings. If you have a php cache plugin like Xcache or APC, they show up in that Session drop down just like Cache Settings. I personally use Xcache for both cache and sessions settings. These are effectively stored to the filesystem, so that might be something you want to try. Takes a bit of knowhow to install these php cache systems though and if your hosting somewhere they may not support them at all.
-
Time to create page: 0.075 seconds