adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-11-03 23:42:27 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

"rank" still causes error with Mysql 8 #926

New Issue
Closed
opened 2026-10-05 00:24:00 +02:00 by adam · 1 comment
adam commented 2026-10-05 00:24:00 +02:00
Owner
Copy link
Copy source

Reported on Piwigo forum by mickey49 https://piwigo.org/forum/viewtopic.php?pid=173980#p173980

I'm getting the error below; this is on a Beta2 install running on MySQL 8.

Piwigo encountered an irrecoverable error
[mysql error 1064] You have an error in your
SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax
to use near 'rank,global_rank,commentable,visible,status)
  VALUES('asdf','0','0','true','tru' at line 2

INSERT INTO piwigo_categories
  (name,rank,global_rank,commentable,visible,status)
  VALUES('asdf','0','0','true','true','public')

#1    my_error include/dblayer/functions_mysqli.inc.php(132)
#2    pwg_query include/dblayer/functions_mysqli.inc.php(617)
#3    single_insert admin/include/functions.php(1539)
#4    create_virtual_category admin/cat_list.php(163)
#5    include admin.php(310)
Reported on Piwigo forum by mickey49 https://piwigo.org/forum/viewtopic.php?pid=173980#p173980 I'm getting the error below; this is on a Beta2 install running on MySQL 8. ``` Piwigo encountered an irrecoverable error [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank,global_rank,commentable,visible,status) VALUES('asdf','0','0','true','tru' at line 2 INSERT INTO piwigo_categories (name,rank,global_rank,commentable,visible,status) VALUES('asdf','0','0','true','true','public') #1 my_error include/dblayer/functions_mysqli.inc.php(132) #2 pwg_query include/dblayer/functions_mysqli.inc.php(617) #3 single_insert admin/include/functions.php(1539) #4 create_virtual_category admin/cat_list.php(163) #5 include admin.php(310) ``` <!-- github-sync-id:480198274 -->
adam closed this issue 2026-10-05 00:24:00 +02:00
adam commented 2026-10-05 00:24:01 +02:00
Author
Owner
Copy link
Copy source

This issue is related to #919 of course.

This issue is related to #919 of course. <!-- github-comment-id:520867029 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#926