Jump to content

mySQL Error - 1062 Duplicate entry


Guest DacorDave

Recommended Posts

Guest DacorDave

I was attaching an image to an item in stock when I got this error:

"MySQL Error Occured

1062: Duplicate entry '0.00--0.00--0.00--0.00' for key 2"

Can someone explain what that means; I havent got a picture on there, so how can that be duplicate, I'm bewildered what it can be!

Tah!

DacorDave

Link to comment
Share on other sites

Guest DacorDave

Did you transfer this store's database from somewhere else by creating a SQL script and then running that script to populate the new database?

Hi bsmither

No, it was a brand new database.

Link to comment
Share on other sites

Are you naming your image files in a distinctive way?

That error means that a record in that table (probably CubeCart_img_idx) already has a entry with that value. The key is on the field "id" and it's (supposedly) auto-incrementing. "Key 2" is that the match happened with the second record.

Can you view the data in that table?

Link to comment
Share on other sites

  • 8 months later...
Guest salaam bollywood

hi i have upgraded my site to cube cart 4.2.3

when i tried acess my web site this erroer occurs

1.1 2003/06/25 17:17:52 jeremy // Initial Import // // Revision 1.4 2001/08/17 18:25:45 jeremy // Sorted greedy matching regular expression in parse function preg_match_all line 166: added ? after .* when looking for comments // */ /* Old log stuff Revision 1.2 2001/09/19 14:11:25 cranx fixed a bug in the whitespace-stripping block variable interpolating regexp. Revision 1.1 2001/07/11 10:42:39 cranx added: - filename substitution, no nested arrays for the moment, sorry (including happens when assigning, so assign filevar in the outside blocks first!) Revision 1.5 2001/07/11 10:39:08 cranx added: - we can now specify base dir - array_loop() - trigger_error in _set_error modified: - newline bugs fixed (for XML) - in out(): content-length header added - whiles changed to foreach - from now on, the class is php4 only :unsure: */ /* Old stuff from original releases xtemplate class 0.3pre !!! {FILE {VAR}} file variable interpolation may still be buggy !!! */ ?>

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/salaambo/public_html/store1/classes/xtpl/xtpl.php:1030) in /home/salaambo/public_html/store1/classes/session/cc_session.php on line 184

Warning: session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent in /home/salaambo/public_html/store1/classes/session/cc_session.php on line 185

Warning: Cannot modify header information - headers already sent by (output started at /home/salaambo/public_html/store1/classes/xtpl/xtpl.php:1030) in /home/salaambo/public_html/store1/classes/session/cc_session.php on line 200

MySQL Error Occurred

Error Message:

1062: Duplicate entry 'a673b7b2ba3c6ae45e9d16a9b3ecdb0e' for key 1

SQL:

INSERT INTO CubeCart_sessions (`sessId`,`timeStart`,`timeLast`,`customer_id`,`ip`,`browser`) VALUES ('a673b7b2ba3c6ae45e9d16a9b3ecdb0e','1227438668','1227438668',0,'121.44.108.30','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)');

my we site is www.salaambollywood.com.au

pls let me know what to do

reagrds

ravi

[email protected]

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...