To post a new support question, click the Post New Topic button below.
Current Version: 4.8.5 | Sytist Manual | Common Issues | Feature Requests
Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.
Mysql Error: Duplicate Entry
M
Michael Comer
35 posts
Mon Nov 12, 18 1:42 PM CST
I'm getting an error when I try to post a new gallery as a watch folder:
***
MYSQL ERROR: Duplicate entry '191623' for key 'PRIMARY'
Query:
***
Has anybody seen this before? I took a look through the support posts for MySQL errors but couldn't find one specifically for upload.
***
MYSQL ERROR: Duplicate entry '191623' for key 'PRIMARY'
Query:
***
Has anybody seen this before? I took a look through the support posts for MySQL errors but couldn't find one specifically for upload.
Tim - PicturesPro.com
16,148 posts
(admin)
Tue Nov 13, 18 4:15 AM CST
Basically it means it is trying to use the same value as a primary key value. But shouldn't be happening because it would be an autoincrement value.
Have you made any changes to the database at all?
Have you made any changes to the database at all?
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
My Email Address: info@picturespro.com
M
Michael Comer
35 posts
Tue Nov 13, 18 11:40 AM CST
No, haven't made changes to the db. I have been uploading and deleting large numbers (tens of thousands) of images, though, trying to get ready for our holiday sale. I switched to Sytist halfway through the year, and the first half of my year was on our old platform. In the process, I've created and abandoned several galleries and run several watch folder ingests that were also stopped for one reason or another (watermark wasn't right, etc.).
Can you take a closer look? I can send you the credentials for cPanel for my server again if needed...
Thanks for the help!
Can you take a closer look? I can send you the credentials for cPanel for my server again if needed...
Thanks for the help!
Tim - PicturesPro.com
16,148 posts
(admin)
Tue Nov 13, 18 1:30 PM CST
You can email me that info and also let me know the exact steps to duplicate the error. I do suspect something did change in the database.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
My Email Address: info@picturespro.com
M
Michael Comer
35 posts
Tue Nov 13, 18 1:39 PM CST
Email sent - thanks!
Please log in or Create an account to post or reply to topics.
Loading more pages