MySQLQuerierException

invalid query. (ERRNO 1054) Unknown column 'g.nbr_com' in 'order clause'
query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob, g.width, g.height, g.user_id, g.views, g.aprob, m.login
FROM phpboost_gallery g
LEFT JOIN phpboost_member m ON m.user_id = g.user_id
WHERE g.idcat = '2' AND g.aprob = 1
ORDER BY g.nbr_com DESC
LIMIT 16 OFFSET 0
STACKTRACE
METHODFILELINE
+MySQLQuerier->execute(string, array)/kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php48
+MySQLQuerier->select(string, array, int)/kernel/framework/io/db/DBQuerier.class.php50
+DBQuerier->select(string, array, int)/kernel/framework/db/Sql.class.php584
+Sql->select(string)/kernel/framework/db/Sql.class.php191
+Sql->query_while(string, int, string)/gallery/phpboost/GalleryHomePageExtensionPoint.class.php483
GalleryHomePageExtensionPoint->get_view()/gallery/phpboost/GalleryHomePageExtensionPoint.class.php39
GalleryHomePageExtensionPoint->get_home_page()/gallery/gallery.php264
output buffer
You see this page because your site is configured to use the DEBUG mode.
If you want to see the related user error page, you have to disable the DEBUG mode from the administration panel.
HTTP Request
GET
sortcom_desc
cat2
SERVER
REDIRECT_UNIQUE_IDWhZc7tTjQvoAABtfpx8AAAAD
REDIRECT_SCRIPT_URL/gallery/gallery.php
REDIRECT_SCRIPT_URIhttp://snookercolmar.com/gallery/gallery.php
REDIRECT_DOCUMENT_ROOT/kunden/homepages/30/d256801826/htdocs
REDIRECT_UI_SUEXEC_DEFAULT_CHROOT_ID7
REDIRECT_UI_SUEXEC_FSTATD_UNIXSOCKET/run/ui-fstatd.suexec.socket
REDIRECT_UI_SUEXEC_STATISTICS_UNIXSOCKET/homepages/sclientMF/http.sock.bin
REDIRECT_DBENTRY_HOSTsnookercolmar.com
REDIRECT_DBENTRY_VALUE/kunden/homepages/30/d256801826/htdocs:d0000#CPU 40 #MEM 81920 #CGI 786762 #NPROC 15 #TAID 50516821 #LANG 2 #STAT 1 #CHROOT 7
REDIRECT_DBENTRY_DOCROOT/kunden/homepages/30/d256801826/htdocs
REDIRECT_DBENTRY_HASHd0000
REDIRECT_DBENTRY__CPU40
REDIRECT_DBENTRY__MEM81920
REDIRECT_DBENTRY__CGI786762
REDIRECT_DBENTRY__NPROC15
REDIRECT_DBENTRY__TAID50516821
REDIRECT_DBENTRY__LANG2
REDIRECT_DBENTRY__STAT1
REDIRECT_DBENTRY__CHROOT7
REDIRECT_DBENTRY/kunden/homepages/30/d256801826/htdocs:d0000#CPU 40 #MEM 81920 #CGI 786762 #NPROC 15 #TAID 50516821 #LANG 2 #STAT 1 #CHROOT 7
REDIRECT_HANDLERx-mapp-php5.5
REDIRECT_STATUS200
UNIQUE_IDWhZc7tTjQvoAABtfpx8AAAAD
SCRIPT_URL/gallery/gallery.php
SCRIPT_URIhttp://snookercolmar.com/gallery/gallery.php
UI_SUEXEC_DEFAULT_CHROOT_ID7
DBENTRY_HOSTsnookercolmar.com
DBENTRY_VALUE/kunden/homepages/30/d256801826/htdocs:d0000#CPU 40 #MEM 81920 #CGI 786762 #NPROC 15 #TAID 50516821 #LANG 2 #STAT 1 #CHROOT 7
DBENTRY_DOCROOT/kunden/homepages/30/d256801826/htdocs
DBENTRY_HASHd0000
DBENTRY__CPU40
DBENTRY__MEM81920
DBENTRY__CGI786762
DBENTRY__NPROC15
DBENTRY__TAID50516821
DBENTRY__LANG2
DBENTRY__STAT1
DBENTRY__CHROOT7
DBENTRY/kunden/homepages/30/d256801826/htdocs:d0000#CPU 40 #MEM 81920 #CGI 786762 #NPROC 15 #TAID 50516821 #LANG 2 #STAT 1 #CHROOT 7
HTTP_HOSTsnookercolmar.com
HTTP_ACCEPT_ENCODINGx-gzip, gzip, deflate
HTTP_USER_AGENTCCBot/2.0 (http://commoncrawl.org/faq/)
HTTP_ACCEPTtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_IF_MODIFIED_SINCESat, 23 Sep 2017 07:31:02 GMT
PATH/bin:/usr/bin
SERVER_SIGNATURE
SERVER_SOFTWAREApache
SERVER_NAMEsnookercolmar.com
SERVER_ADDR212.227.66.250
SERVER_PORT80
REMOTE_ADDR54.161.108.158
DOCUMENT_ROOT/kunden/homepages/30/d256801826/htdocs
REQUEST_SCHEMEhttp
CONTEXT_PREFIX/system-bin/
CONTEXT_DOCUMENT_ROOT/kunden/usr/lib/cgi-bin/
SERVER_ADMINwebmaster@snookercolmar.com
SCRIPT_FILENAME/kunden/homepages/30/d256801826/htdocs/gallery/gallery.php
REMOTE_PORT60466
REDIRECT_QUERY_STRINGsort=com_desc&cat=2
REDIRECT_URL/gallery/gallery.php
GATEWAY_INTERFACECGI/1.1
SERVER_PROTOCOLHTTP/1.1
REQUEST_METHODGET
QUERY_STRINGsort=com_desc&cat=2
REQUEST_URI/gallery/gallery.php?sort=com_desc&cat=2
SCRIPT_NAME/gallery/gallery.php
STATUS200
ORIG_PATH_INFO/gallery/gallery.php
ORIG_PATH_TRANSLATED/kunden/homepages/30/d256801826/htdocs/gallery/gallery.php
PHP_SELF/gallery/gallery.php
REQUEST_TIME_FLOAT1511415022.7142
REQUEST_TIME1511415022
argv
  • sort=com_desc&cat=2
argc1