Forum

Thread tagged as: Error

Mysql database error

Hi Caught this error in the log. This appears with the Admin user page in runway. Flagging this because i experienced a database corruption and had to reload an earlier db.

SELECT * FROM perch2_users WHERE userID='1' LIMIT 1
SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
Invalid query: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'cementa_perch.perch2_settings.userID' which is not in SELECT list; this is incompatible with DISTINCT

DIAGNOSTIC

Perch Runway: 2.8.34, PHP: 5.6.28, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $, with PDO
Server OS: Linux, fpm-fcgi
Installed apps: content (2.8.34), assets (2.8.34), categories (2.8.34), collection_1 (2.8.34), perch_blog (5.0), perch_events (1.9.3), collection_2 (2.8.34)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_blog', 'perch_events', );
PERCH_LOGINPATH: /perch
PERCH_PATH: /usr/share/nginx/html/perch
PERCH_CORE: /usr/share/nginx/html/perch/core
PERCH_RESFILEPATH: /usr/share/nginx/html/perch/resources
Image manipulation: GD Imagick
PHP limits: Max upload 2M, Max POST 2M, Memory: 128M, Total max file upload: 2M
F1: 6a33f95eca3667f9e0c39bf5ca2980fe
Resource folder writeable: Yes
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
REQUEST_URI: /perch/core/settings/diagnostics/
DOCUMENT_ROOT: /usr/share/nginx/html
HTTP_HOST: dev.cementa.com.au

THANKS IAN

ian hobbs

ian hobbs 1 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Which page exactly?

site/perch/core/account/

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok, we'll take a look. It shouldn't cause you database corruption.

Yes i imagine thats true. Just a bug report.