Re: [Tiki-devel] Fwd: SQL Query Error

I get the error when I log in as administrator.

I think it is on every page. It is usually in a panel on the right hand 
side, headed "System error.". The Admin menu does not appear.

The error does not occur for a non-admin user, or if I am not logged in.

Happy new year
Phil

On 31-Dec-22 11:59, Ricardo Melo wrote:
> What is the page you are trying to access?
>
> On Fri, 30 Dec 2022, 09:33 Phil Jollans, <[email protected]> wrote:
>
>     More about the same error.
>
>     I have got past this problem by commenting out line 2735 in
>     filegallib.php
>
>     $limit .= ', ' . ($maxRecords == -1 ? PHP_INT_MAX : $maxRecords);
>
>     Phil
>
>
>
>     -------- Forwarded Message --------
>     Subject: 	SQL Query Error
>     Date: 	Fri, 30 Dec 2022 09:48:43 +0100
>     From: 	Phil Jollans <[email protected]> <mailto:[email protected]>
>     To: 	Tikiwiki developers <[email protected]>
>     <mailto:[email protected]>
>
>
>
>     I am testing tiki 25.0 on a XAMPP before installing it on my server.
>
>     I am getting the error
>
>
>       System error.
>
>     The following error message was returned:
>
>     *
>
>     You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
>
>     *
>
>     *The query was:*
>
>     *SELECT 0 as `isgal`, tf.`fileId` as `id`, tf.`galleryId` as
>     `parentId`, tf.`name`, tf.`description`, tf.`filesize` as `size`,
>     tf.`created`, tf.`filename`, tf.`filetype` as `type`, tf.`user` as
>     `creator`, tf.`author`, tf.`hits`, tf.`lastDownload`, tf.`votes`,
>     tf.`points`, tf.`path`, tf.`reference_url`, tf.`is_reference`,
>     tf.`hash`, tf.`search_data`, tf.`metadata`, tf.`lastModif` as
>     `lastModif`, tf.`lastModifUser` as `last_user`, tf.`lockedby`,
>     tf.`comment`, tf.`deleteAfter`, tf.`maxhits`, tf.`archiveId`,
>     tf.`ocr_state`, '' as `visible`, '' as `public`, tf.`fileId`,
>     tf.`galleryId`, tf.`filesize`, tf.`filetype`, tf.`user`,
>     tf.`lastModifUser`, 0 as `icon_fileId`, '' as `files` FROM
>     `tiki_files` as tf WHERE tf.`archiveId`=0 AND tf.`created` > ?
>     ORDER BY `isgal` desc, `created` desc LIMIT 0, *
>
>     *Values:*
>
>      1. 1670774331
>
>     *The built query was likely:*
>
>     *SELECT 0 as `isgal`, tf.`fileId` as `id`, tf.`galleryId` as
>     `parentId`, tf.`name`, tf.`description`, tf.`filesize` as `size`,
>     tf.`created`, tf.`filename`, tf.`filetype` as `type`, tf.`user` as
>     `creator`, tf.`author`, tf.`hits`, tf.`lastDownload`, tf.`votes`,
>     tf.`points`, tf.`path`, tf.`reference_url`, tf.`is_reference`,
>     tf.`hash`, tf.`search_data`, tf.`metadata`, tf.`lastModif` as
>     `lastModif`, tf.`lastModifUser` as `last_user`, tf.`lockedby`,
>     tf.`comment`, tf.`deleteAfter`, tf.`maxhits`, tf.`archiveId`,
>     tf.`ocr_state`, '' as `visible`, '' as `public`, tf.`fileId`,
>     tf.`galleryId`, tf.`filesize`, tf.`filetype`, tf.`user`,
>     tf.`lastModifUser`, 0 as `icon_fileId`, '' as `files` FROM
>     `tiki_files` as tf WHERE tf.`archiveId`=0 AND tf.`created` >
>     '1670774331' ORDER BY `isgal` desc, `created` desc LIMIT 0, *
>
>     Can anyone help me with this.
>
>     It looks to me like the error is the trailing comma.
>
>     If I remove the comma, I can execute the query in PhpMyAdmin.
>     With the comma, I get the exact same error.
>
>     Phil
>
>
>
>     _______________________________________________
>     TikiWiki-devel mailing list
>     [email protected]
>     https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>
>
>
> _______________________________________________
> TikiWiki-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

_______________________________________________
TikiWiki-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel