Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Repair and Optimize Database throws warnings clustered index #14

Open
BenMak opened this issue Nov 4, 2020 · 0 comments
Open

Repair and Optimize Database throws warnings clustered index #14

BenMak opened this issue Nov 4, 2020 · 0 comments

Comments

@BenMak
Copy link

BenMak commented Nov 4, 2020

When running Repair and Optimize Database I got following Message:
Warning: [mysql error 1105] ORDER BY ignored as there is a user-defined clustered index in the table 'pi_stuffs'
ALTER TABLE pi_stuffs ORDER BY id; in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php on line 856

This is a table created by the PWG Stuffs plugin.
The Database Optimisation attempts to sort the table pi_amm_blocks by id. This is rejected by MySql as this table is already sorted by the (clustered) index.
Either the plugin needs to be modified so no clustered indexes are created in tables or Piwigo has to change the Repair and Optimize Database module such that tables with clustered indexes are skipped from re-sorting.
Any suggestions?

See also https://piwigo.org/forum/viewtopic.php?id=30714

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant