adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

upgraded to Latest got [mysql error 1054] Unknown column 'rank' in 'order clause' #842

New Issue
Closed
opened 2026-10-05 00:20:10 +02:00 by adam · 7 comments
adam commented 2026-10-05 00:20:10 +02:00
Owner
Copy link
Copy source

Just upgraded to latest version of Piwigo and get this error. can no longer access admin or even see images on site.

Just upgraded to latest version of Piwigo and get this error. can no longer access admin or even see images on site. <!-- github-sync-id:386571413 -->
adam closed this issue 2026-10-05 00:20:10 +02:00
adam commented 2026-10-05 00:20:11 +02:00
Author
Owner
Copy link
Copy source

Wait, you updated piwigo to the latest and got this error now? Or did you update your database, like to mysql8? I have seen the issue of not encapsulated keywords like rank, section, date, time and a few more, and there are other issues open about this, including a few pull requests to solve parts of the misery.

Wait, you updated piwigo to the latest and got this error now? Or did you update your database, like to mysql8? I have seen the issue of not encapsulated keywords like rank, section, date, time and a few more, and there are other issues open about this, including a few pull requests to solve parts of the misery. <!-- github-comment-id:443552691 -->
adam commented 2026-10-05 00:20:12 +02:00
Author
Owner
Copy link
Copy source

Hello pstimpel. Yes I updated software for Piwigo yesterday 02/012/2018 . I didn't dump the database though. Should I have done that? That seemed drastic to me but perhaps that was my error. In the end as I couldn't have a site with no photos I had to install a fresh version of Piwigo in a different folder and upload photos again. Changing the code on the webpages. As I could not access the broken version of Piwigo I could not see which photos I had before to make sure it was the same. Incase others get this problem thought I should bring it to someones attention.

Hello pstimpel. Yes I updated software for Piwigo yesterday 02/012/2018 . I didn't dump the database though. Should I have done that? That seemed drastic to me but perhaps that was my error. In the end as I couldn't have a site with no photos I had to install a fresh version of Piwigo in a different folder and upload photos again. Changing the code on the webpages. As I could not access the broken version of Piwigo I could not see which photos I had before to make sure it was the same. Incase others get this problem thought I should bring it to someones attention. <!-- github-comment-id:443642540 -->
adam commented 2026-10-05 00:20:13 +02:00
Author
Owner
Copy link
Copy source

Wow, that sounds harsh. Hopefully the core devs will fix this soon - even it is a monster job.

Wow, that sounds harsh. Hopefully the core devs will fix this soon - even it is a monster job. <!-- github-comment-id:443646614 -->
adam commented 2026-10-05 00:20:13 +02:00
Author
Owner
Copy link
Copy source

Thank you for your response to this. If you know about the "Dump database " option when updating the software that would be great. Then I will know for future. Thank you again.

Thank you for your response to this. If you know about the "Dump database " option when updating the software that would be great. Then I will know for future. Thank you again. <!-- github-comment-id:443651741 -->
adam commented 2026-10-05 00:20:14 +02:00
Author
Owner
Copy link
Copy source

I am just an user, as you are. However, I would dump my database before every update. I know, I am paranoid somehow

I am just an user, as you are. However, I would dump my database before every update. I know, I am paranoid somehow <!-- github-comment-id:443677244 -->
adam commented 2026-10-05 00:20:15 +02:00
Author
Owner
Copy link
Copy source

Think you are right though and again thank you. In future I will dump the database.

Think you are right though and again thank you. In future I will dump the database. <!-- github-comment-id:443788848 -->
adam commented 2026-10-05 00:20:16 +02:00
Author
Owner
Copy link
Copy source

fixed in #919 (even if we still find some problems, see #1060)

fixed in #919 (even if we still find some problems, see #1060) <!-- github-comment-id:526541498 -->
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#842