Backend shows:
You may add albums to your gallery once you have saved the page for the first time.
Frontend shows:
Error
The website server has not been able to respond to your request.
Error (?isDev=1) shows:
FATAL ERROR: DATABASE ERROR: Couldn't run query: SELECT `ImageGalleryAlbum`.*, `ImageGalleryAlbum`.ID, if(`ImageGalleryAlbum`.ClassName,`ImageGalleryAlbum`.ClassName,'ImageGalleryAlbum') AS RecordClassName FROM `ImageGalleryAlbum` WHERE (ImageGalleryPageID = '48') ORDER BY SortOrder ASC | Unknown column 'SortOrder' in 'order clause'
At line 431 in /home/w1436526/domains/zeeppompje.nl/public_html/sapphire/core/model/Database.php
user_error(DATABASE ERROR: Couldn't run query: SELECT `ImageGalleryAlbum`.*, `ImageGalleryAlbum`.ID, if(`ImageGalleryAlbum`.ClassName,`ImageGalleryAlbum`.ClassName,'ImageGalleryAlbum') AS RecordClassName FROM `ImageGalleryAlbum` WHERE (ImageGalleryPageID = '48') ORDER BY SortOrder ASC | Unknown column 'SortOrder' in 'order clause',256)
line 431 of Database.php
Database->databaseError(Couldn't run query: SELECT `ImageGalleryAlbum`.*, `ImageGalleryAlbum`.ID, if(`ImageGalleryAlbum`.ClassName,`ImageGalleryAlbum`.ClassName,'ImageGalleryAlbum') AS RecordClassName FROM `ImageGalleryAlbum` WHERE (ImageGalleryPageID = '48') ORDER BY SortOrder ASC | Unknown column 'SortOrder' in 'order clause',256)
line 108 of MySQLDatabase.php
MySQLDatabase->query(SELECT `ImageGalleryAlbum`.*, `ImageGalleryAlbum`.ID, if(`ImageGalleryAlbum`.ClassName,`ImageGalleryAlbum`.ClassName,'ImageGalleryAlbum') AS RecordClassName FROM `ImageGalleryAlbum` WHERE (ImageGalleryPageID = '48') ORDER BY SortOrder ASC,256)
line 81 of DB.php
DB::query(SELECT `ImageGalleryAlbum`.*, `ImageGalleryAlbum`.ID, if(`ImageGalleryAlbum`.ClassName,`ImageGalleryAlbum`.ClassName,'ImageGalleryAlbum') AS RecordClassName FROM `ImageGalleryAlbum` WHERE (ImageGalleryPageID = '48') ORDER BY SortOrder ASC)
line 157 of SQLQuery.php
SQLQuery->execute()
line 1519 of DataObject.php
DataObject->instance_get(ImageGalleryPageID = '48',,,,ComponentSet)
line 793 of DataObject.php
DataObject->getComponents(Albums)
call_user_func_array(Array,Array)
line 185 of Object.php
Object->__call(Albums,Array)
ImageGalleryPage->Albums()
call_user_func_array(Array,Array)
line 177 of Object.php
Object->__call(Albums,Array)
ImageGalleryPage_Controller->Albums()
line 374 of ImageGalleryPage.php
ImageGalleryPage_Controller->SingleAlbumView()
line 212 of ImageGalleryPage.php
ImageGalleryPage_Controller->init()
line 126 of Controller.php
Controller->run(Array)
line 22 of ModelAsController.php
ModelAsController->run(Array)
line 104 of Director.php
Director::direct(new-imagegallerypage/)
line 158 of main.php
Context
Debug (Debug::showError() in line 180 of Debug.php)
msg =
Couldn't run query: SELECT `ImageGalleryAlbum`.*, `ImageGalleryAlbum`.ID, if(`ImageGalleryAlbum`.ClassName,`ImageGalleryAlbum`.ClassName,'ImageGalleryAlbum') AS RecordClassName FROM `ImageGalleryAlbum` WHERE (ImageGalleryPageID = '48') ORDER BY SortOrder ASC | Unknown column 'SortOrder' in 'order clause'
errorLevel =
256