Pantalla Sencera

.ourproject.org		 Dv 21 de Nov, 2008 21:01 CET

Error Error

Ha hagut un error en una petició de la base de dades!

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


You are not logged in. Go to Login Page


Tornar Enrera

Torna a la pàgina d'inici

Menú [intercanvia]

Inici
Categories
Toggle Wiki
Inici del Wiki
Últimes modificacions
Volcat
Llistar pàgines
Pàgines òrfenes
Multiple Print
Estructures
Toggle Galeries d'imatges
Toggle Fòrums
Llista de fòrums
Toggle Galeries d'arxius
Toggle Enquestes
Llista enquestes
Estadístiques

Idioma del Lloc:  ca [intercanvia]

Col·laboren [intercanvia]

ub.edu Logo UAB Logo
ourproject.org Logo Agaur Logo
Logo de l'ICE de la UB

Traduccions automàtiques [intercanvia]

Pàgina generada en 2.69s
per TikiWiki
Llicència de Creative Commons
Tots els materials docents recollits en aquest espai web estan sota una Llicència de Creative Commons, sempre i quan no s'indiqui el contrari. Per saber més detalls sobre la llicència de copyright, punxa amb el ratolí sobre la icona.