An error occured in a database query!
|
View:
New views
4 Messages
—
Rating Filter:
Alert me
|
 |
An error occured in a database query!
by Russ Harvell-Fruhwirth
::
Rate this Message:
Hi there, I just upgraded from 1.9.11 to 2.0 Tikiwiki yesterday, and am very happy with the upgrade so far except for one important issue. I get the following error message when I try to Administer Categories (tiki-admin_categories.php): An error occured in a database query! Context: File tiki-admin_categories.php Url tiki-admin_categories.php?parentId=0 Query: SELECT tab.*, tfgp.`name` as `parentName` 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`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) ORDER BY `isgal` desc, tab.`name` desc Values: 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.*, tfgp.`name` as `parentName` 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`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) ORDER BY `isgal` desc, tab.`name` desc I have reported this as a bug: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1953&trackerId=5 and also posted on the forums: http://tikiwiki.org/tiki-view_forum_thread.php?comments_parentId=29568&topics_offset=3&topics_sort_mode=lastPost_desc&forumId=4 Any thoughts anyone? I am thinking that the admin_categories.php has a syntax error somewhere in it... Thanks! Russ Russell Harvell-Fruhwirth Network Engineer Nebraska Educational Telecommunications 1800 N. 33rd St. Lincoln, NE 68503 (402) 472-9333 ext. 566 CompTIA A+ Certified, Microsoft MCDST ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Tikiwiki-users mailing list Tikiwiki-users@... https://lists.sourceforge.net/lists/listinfo/tikiwiki-users |
|||||||||||
|
|
Re: An error occured in a database query!
by Russ Harvell-Fruhwirth
::
Rate this Message:
I get a similar error when attempting to administer modules as well, I just discovered: An error occured in a database query! Context: File tiki-admin_modules.php Url tiki-admin_modules.php Query: SELECT `tc`.*, tpcd.`data`, COALESCE(`tpcf`.`future`,0) AS `future`, COALESCE(`tpca`.`actual`,?) AS `actual`, COALESCE(`tpcn`.`next`,?) AS `next`, GREATEST(0, COALESCE(`tpco`.`old`,0) - 1) AS `old` FROM (`tiki_content` AS `tc` LEFT JOIN ( SELECT `contentId`, count(*) AS `future` FROM `tiki_programmed_content` WHERE `publishDate`>? GROUP BY contentId ) AS `tpcf` ON ( `tc`.`contentId` = `tpcf`.`contentId` ) LEFT JOIN ( SELECT `contentId`, max(`publishDate`) AS `actual` FROM `tiki_programmed_content` WHERE `publishDate`<=? GROUP BY contentId ) AS `tpca` ON ( `tc`.`contentId` = `tpca`.`contentId` ) LEFT JOIN ( SELECT `contentId`, min(`publishDate`) AS `next` FROM `tiki_programmed_content` WHERE `publishDate`>=? GROUP BY contentId ) AS `tpcn` ON ( `tc`.`contentId` = `tpcn`.`contentId` ) LEFT JOIN ( SELECT `contentId`, count(*) AS `old` FROM `tiki_programmed_content` WHERE `publishDate`<? GROUP BY contentId ) AS `tpco` ON ( `tc`.`contentId` = `tpco`.`contentId` ) LEFT JOIN ( SELECT `contentId`, `data`, `publishDate` FROM `tiki_programmed_content` ) AS `tpcd` ON ( `tc`.`contentId` = `tpcd`.`contentId` AND `tpcd`.`publishDate` = `tpca`.`actual` )) ORDER BY `contentId` desc Values: 0 1218729586 1 1218729586 2 1218729586 3 1218729586 4 1218729586 5 1218729586 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 `contentId`, count(*) AS `future` FROM `tiki_programmed_ Built query was probably: SELECT `tc`.*, tpcd.`data`, COALESCE(`tpcf`.`future`,0) AS `future`, COALESCE(`tpca`.`actual`,'1218729586') AS `actual`, COALESCE(`tpcn`.`next`,'1218729586') AS `next`, GREATEST(0, COALESCE(`tpco`.`old`,0) - 1) AS `old` FROM (`tiki_content` AS `tc` LEFT JOIN ( SELECT `contentId`, count(*) AS `future` FROM `tiki_programmed_content` WHERE `publishDate`>'1218729586' GROUP BY contentId ) AS `tpcf` ON ( `tc`.`contentId` = `tpcf`.`contentId` ) LEFT JOIN ( SELECT `contentId`, max(`publishDate`) AS `actual` FROM `tiki_programmed_content` WHERE `publishDate`<='1218729586' GROUP BY contentId ) AS `tpca` ON ( `tc`.`contentId` = `tpca`.`contentId` ) LEFT JOIN ( SELECT `contentId`, min(`publishDate`) AS `next` FROM `tiki_programmed_content` WHERE `publishDate`>='1218729586' GROUP BY contentId ) AS `tpcn` ON ( `tc`.`contentId` = `tpcn`.`contentId` ) LEFT JOIN ( SELECT `contentId`, count(*) AS `old` FROM `tiki_programmed_content` WHERE `publishDate`<'1218729586' GROUP BY contentId ) AS `tpco` ON ( `tc`.`contentId` = `tpco`.`contentId` ) LEFT JOIN ( SELECT `contentId`, `data`, `publishDate` FROM `tiki_programmed_content` ) AS `tpcd` ON ( `tc`.`contentId` = `tpcd`.`contentId` AND `tpcd`.`publishDate` = `tpca`.`actual` )) ORDER BY `contentId` desc Now I think that perhaps something went wrong during the SQL script database updates during the upgrade process... Anyone? Thanks! Russ Russell Harvell-Fruhwirth Network Engineer Nebraska Educational Telecommunications 1800 N. 33rd St. Lincoln, NE 68503 (402) 472-9333 ext. 566 CompTIA A+ Certified, Microsoft MCDST
Hi there, I just upgraded from 1.9.11 to 2.0 Tikiwiki yesterday, and am very happy with the upgrade so far except for one important issue. I get the following error message when I try to Administer Categories (tiki-admin_categories.php): An error occured in a database query! Context: File tiki-admin_categories.php Url tiki-admin_categories.php?parentId=0 Query: SELECT tab.*, tfgp.`name` as `parentName` 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`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) ORDER BY `isgal` desc, tab.`name` desc Values: 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.*, tfgp.`name` as `parentName` 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`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) ORDER BY `isgal` desc, tab.`name` desc I have reported this as a bug: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1953&trackerId=5 and also posted on the forums: http://tikiwiki.org/tiki-view_forum_thread.php?comments_parentId=29568&topics_offset=3&topics_sort_mode=lastPost_desc&forumId=4 Any thoughts anyone? I am thinking that the admin_categories.php has a syntax error somewhere in it... Thanks! Russ Russell Harvell-Fruhwirth Network Engineer Nebraska Educational Telecommunications 1800 N. 33rd St. Lincoln, NE 68503 (402) 472-9333 ext. 566 CompTIA A+ Certified, Microsoft MCDST------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________ Tikiwiki-users mailing list Tikiwiki-users@... https://lists.sourceforge.net/lists/listinfo/tikiwiki-users ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Tikiwiki-users mailing list Tikiwiki-users@... https://lists.sourceforge.net/lists/listinfo/tikiwiki-users |
|||||||||||
|
|
Re: An error occured in a database query!
by Xavier de Pedro Puente-2
::
Rate this Message:
I confirm a similar error on edu.tw.o using 2.0
There might be an error somewhere... Xavi En/na Russ Harvell-Fruhwirth ha escrit: > > Hi there, I just upgraded from 1.9.11 to 2.0 Tikiwiki yesterday, and > am very happy with the upgrade so far except for one important issue. > I get the following error message when I try to Administer Categories > (tiki-admin_categories.php): > > > An error occured in a database query! > > Context: > File tiki-admin_categories.php > Url tiki-admin_categories.php?parentId=0 > Query: > SELECT tab.*, tfgp.`name` as `parentName` 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`) GROUP BY tfg.`galleryId`) as tab > LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = > tfgp.`galleryId`) ORDER BY `isgal` desc, tab.`name` desc > Values: > 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.*, tfgp.`name` as `parentName` 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`) GROUP BY tfg.`galleryId`) as tab > LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = > tfgp.`galleryId`) ORDER BY `isgal` desc, tab.`name` desc > > > I have reported this as a bug: > http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1953&trackerId=5 > > > and also posted on the forums: > http://tikiwiki.org/tiki-view_forum_thread.php?comments_parentId=29568&topics_offset=3&topics_sort_mode=lastPost_desc&forumId=4 > > > Any thoughts anyone? I am thinking that the admin_categories.php has > a syntax error somewhere in it... > > Thanks! > Russ > > Russell Harvell-Fruhwirth > Network Engineer > Nebraska Educational Telecommunications > 1800 N. 33rd St. > Lincoln, NE 68503 > (402) 472-9333 ext. 566 > CompTIA A+ Certified, Microsoft MCDST > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > ------------------------------------------------------------------------ > > _______________________________________________ > Tikiwiki-users mailing list > Tikiwiki-users@... > https://lists.sourceforge.net/lists/listinfo/tikiwiki-users > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Tikiwiki-users mailing list Tikiwiki-users@... https://lists.sourceforge.net/lists/listinfo/tikiwiki-users |
|||||||||||
|
|
Re: An error occured in a database query!
by kmichel
::
Rate this Message:
Same error - hosted website
//******************************** // File tiki-admin_categories.php Url tiki-admin_categories.php Query: SELECT tab.*, tfgp.`name` as `parentName` 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`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) ORDER BY `isgal` desc, tab.`name` desc Values: 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 //******************************** // worked well with mysql 4.1.9 (EasyPHP) but does'nt see to be supported with mysql 4.0.24 which is the one available with my provider... It would have been great if tiki 2.0 was compliant with mysql 4.0.24. But as now, i can't use tiki... i will uninstall it. No choice. Karin
|
| Free Forum Powered by Nabble | Forum Help |
