DB Error: Duplicate entry 'kmtn98ef8p478fdt16homi7mb1' for key 1
What seemed to precipitate this error this am was my LOGGING OFF and attempting to LOG BACK ON. [EDIT] Note that AT TIMES it is impossible to get into the site at all, while at other times one can get in but not log on -- does this suggest a cache or cookie issue?
Alec's first suggestion to this problem is to flush the session with this SQL command: DELETE * FROM sessions;
Now, I hate to be the noob or the newbie, but I am very new to DB work so I am having trouble divining where to enter the command in MyPHPAdmin. I tried using the SQL tab, which leads to "RUN SQL query on databse ojs:" panel, and entered exactly: DELETE * FROM sessions
This delivers the error message:
DELETE * FROM sessions
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM sessions' at line 1
So my syntax is wrong or I am in the wrong panel/function area of myphpadmin. I am in need of more guidance as to how or where to enter the DELETE * FROM sessions; command via myphpadmin.
I do my best to solve these issues before coming to this forum, but here I am stumped. I know Alec et al must be fairly overwhelmed with all the support issues that arise and am grateful for whatever help may be forthcoming.
- NOTE: I was able to set up certain features and enter text and a notice into iipj.org/ojs BEFORE this DB Error: Duplicate entry problem.
NOTE: There is no line or word pertaining to session.auto_start option in my config.inc.php file -- A PROBLEM HERE? SHOULD THERE BE?
NOTE: I am using the services of a web site hosting company (blacksun.ca) so I am not certain that I have access to the ability to "restart your IIS/Apache after changing the php.ini file" -- ALSO NOTE: I cannot locate a php.ini in /web/ojs/
I may be in over my head here, but I think I may also be quite close to having a working OJS system.
Thank you for your time and attention,
University of Ottawa