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
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.
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?
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
M
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!
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
M
35 posts
Tue Nov 13, 18 1:39 PM CST
Email sent - thanks!
5 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 357 times
Category: Bug
 
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

 
©2003 - 2021 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window
Loading
Close