You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I guess adding an ID with auto_increment may work. If you do so, it would be interesting to report your findings so that more people are aware of this.
We are migrating to MySQL cluster and one of the requirements is that every table has a primary key so deletes work across the cluster.
I noticed a few tables don't have primary keys:
My SQL knowledge is poor to honest, but here is my go at the issue:
linktrack_userclick
. I only found one query (https://github.com/phpList/phplist3/blob/main/public_html/lists/admin/convertstats.php#L105) and it uses select fields so it should be OK to add id field to the table and not break anything.email
field inuser_blacklist
anduser_blacklist_data
as primary key since it's only unique field and not nullIs there any chance primary keys could be added so that phplist is compatible with cluster version.
The text was updated successfully, but these errors were encountered: