Query Error

nate
@nate
11 years ago
917 posts
When I try to create a song ina custom song module (made by Steve basically jrAudio with a few extra params) I get the following error.

Quote: Query Error: Duplicate entry '26' for key 'log_log_id'

Can someone suggest what to check?
updated by @nate: 02/10/14 12:03:36AM
michael
@michael
11 years ago
7,800 posts
do you have xdebug enabled on the server where you see that? not sure that is the exact reason, but on my development server I get that occasionally.

I think it comes from a single item trying to be entered twice into the database.

The usual result is the data gets to the database correctly and I ignore that error. Never seen it on a production server.
brian
@brian
11 years ago
10,149 posts
This is coming from a jrCore_logger() call where you've set the 3rd "debug" param to a debug log entry - you really should never get this as the value for log_log_id is the autoincrement value from the logs table, so it will always be unique - double check that the module is not trying to insert into that table directly.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
SteveX
SteveX
@ultrajam
11 years ago
2,584 posts
There are no third parameter jrCore_logger calls in any of the modules, and nothing custom done to logging at all.

You said in your email that this was preventing you from creating xtSong items on the demo. If that is the case, I would look at any changes made to the modules since my last commit, as they were all working well at that point.

Is it this same error which prevents you from being able to create media on your localhost dev setup?


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

Tags