SQL error since 7.3.4

Hi, since the update to 7.3.4 I get at times (maybe 2-3 emails per week) this error

Query:

                INSERT INTO `sys_acl_actions_track` (IDAction, IDMember, ActionsLeft, ValidSince)
                VALUES (43, 9491, 10, FROM_UNIXTIME(1510140506))

Mysql error: Duplicate entry '43-9491' for key 'PRIMARY'

Any idea?

Send a message to AlexT pointing out this forum post so he can take a look.  It appears that it combined the data for IDAction with the data for IDMember and inserted that into the primary key for the table.

The code that is trying to do that appears to be located in.

\Dolphin-v.7.3.4\inc\membership_levels.inc.php on Lines 443 and 444

According to the code, this situation should never happen. It maybe you have some custom modification which cause this. 

To better investigate this, there is call stack below this error which points out where exactly the error happens, it will help to identify the problematic place.

Hello @AlexT

as I am still bugged with these database errors and update to 7.3.5 didn't help, I will post the most recent traceback if it helps any?

I am pretty lost, for me it looks like someone will try to open a photo and gets blocked or something?

https://pastebin.com/94yynQm8

It is the same condition that was first reported.  It is suppose to be inserting two different values into two different fields.  It is possible that you installed some third party module that cause this.  Here is what I suggest, clone your site, files and database, to another site; perhaps a subdomain of a live site.  You can also do this on a local LAMP stack using AMPPS or similar.

Then you can play with removing things without it damaging your live site.

I am familiar with that, not a problem. But I can't figure when it happens. It doesn't help if I have a test system and it never happens. It doesn't seem to happen with the admin account, so I suspect it has something to do with the limits.

Then you test with non admin accounts.  The thing is, it is not doing this on the default Dolphin installation so it is only about your setup.  Since we don't have access to your setup, we can't really help.  Custom code changes, third party modules, etc has to be the cause.

Let me add this, when you did the upgrade it was also important to test or upgrade any third party module as well.