Loading...
 
Skip to main content

Features / Usability


tiki-admin_modules.php not loading

I just installed tikiwiki 2.0.
Installation went pretty smoothly and I started turning on some features.
However, when I went to click "Administer Modules", the page (and page source) is empty.

I checked the permissions on the file and executable is set for all.

Is there something else I should be checking?

Thx,

pwg

To wrap up this thread, increasing the memory_limit parameter solved the blank page issue.
It would have been nice to see errors in the error logs for this, however.

Thx,

pwg


I also get this same error on a new installation with php 4.4.2, mysql 4.0.20

It doesn't happen on another installation on a different server with php 5.2.2, mysql 5.0.37

Does this help anyone work out what is causing it? Is it a mysql installation issue?

Any help appreciated.


I get an error when trying to load up admin_modules (as well as admin_categories, as noted in another post), and it is a SQL syntax error:

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 `tpcn` ON ( `tc`.`contentId` = `tpcn`.`contentId` ) LEFT JOIN ( SELECT `contentId`, count(*) AS `old` FROM `tiki_programmed_content` WHERE `publishDate`

it does work for me (admin modules), using tiki 2.0
Try attempting to reproduce your bug using the TikiLiveCD : if you can, the fill in a bug report at http://dev.tikiwiki.orgQuestion
if not, ask your sys admin about it (you might have some problems in your mysql server )
HTH

I see that too. Have you found out what to do about it?

/Clausen

I tried pasting the reported query in to MySql, it returned the following:

#1064 - 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_programm


Unfortunately I can not figure out what the problem is with the SQL or where it is generated.

I am using MySql 4.0. Should I try migrating to a newer version?

/Christian

I moved my database to MySql 4.1, that solved the problem.

/Christian