Context:
File	tiki-list_file_gallery.php
Url	tiki-list_file_gallery.php
Query:
SELECT tab.* FROM (SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`, tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as `creator`, '' as `author`, tfg.`hits`, tfg.`votes`, tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`, '' as `hash`, tfg.`name` as `search_data`, tfg.`lastmodif` as `lastmodif`, '' as `last_user`, '' as `lockedby`, '' as `comment`, 0 as `archiveId`, tfg.`visible`, tfg.`public`, tfg.`galleryId` as `fileId`, tfg.`parentId` as `galleryId`, 0 as `filesize`, tfg.`type` as `filetype`, tfg.`user`, '' as `lastModifUser`, count(distinct tfc.`fileId`) as `files` FROM `tiki_file_galleries` as tfg LEFT JOIN `tiki_files` tfc ON (tfg.`galleryId` = tfc.`galleryId`) WHERE (tfg.`user`='' OR tfg.`public`='y') AND tfg.`parentId`=? GROUP BY tfg.`galleryId`) as tab ORDER BY `isgal` desc, tab.`filename` asc
Values:
0	-1
Message:
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 'SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, t
Built query was probably:
SELECT tab.* FROM (SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`, tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as `creator`, '' as `author`, tfg.`hits`, tfg.`votes`, tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`, '' as `hash`, tfg.`name` as `search_data`, tfg.`lastmodif` as `lastmodif`, '' as `last_user`, '' as `lockedby`, '' as `comment`, 0 as `archiveId`, tfg.`visible`, tfg.`public`, tfg.`galleryId` as `fileId`, tfg.`parentId` as `galleryId`, 0 as `filesize`, tfg.`type` as `filetype`, tfg.`user`, '' as `lastModifUser`, count(distinct tfc.`fileId`) as `files` FROM `tiki_file_galleries` as tfg LEFT JOIN `tiki_files` tfc ON (tfg.`galleryId` = tfc.`galleryId`) WHERE (tfg.`user`='' OR tfg.`public`='y') AND tfg.`parentId`='-1' GROUP BY tfg.`galleryId`) as tab ORDER BY `isgal` desc, tab.`filename` asc

Tornar Enrera

Torna a la pàgina d'inici