Menu [toggle]

Home
Search
Contact us
Stats
Calendar
Users map
Friendship Network
[-] Wiki [+]
Wiki Home
Last Changes
Dump
Rankings
List pages
Orphan pages
Sandbox
Multiple Print
Structures
[-] Image Galleries [+]
Galleries
Rankings
[-] Blogs [+]
List blogs
[-] Forums [+]
List forums
Rankings
[-] File Galleries [+]
List galleries
Rankings
[-] Trackers [+]
List trackers
[-] Surveys [+]
List surveys
Stats

Search

in:

Search Wiki PageName

Exact match

Site Language: en

Kindly hosted at:

ourproject.org Logo

Copyleft

Creative Commons License
Content on this site is licensed under a Creative Commons Attribution-ShareAlike 2.5 Spain License.

Error

An error occured in a database query!

Context:
Filetiki-list_file_gallery.php
Urltiki-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


Go back

Return to home page
Powered by TikiWiki
RSS feed Wiki RSS feed Blogs RSS feed Image Galleries RSS feed File Galleries RSS feed Forums
Powered by TikiWiki CMS/Groupware v2.0 (CVS) -Arcturus-