Loading...
 
Skip to main content

Features / Usability


Approval and staging issue

Hi there,

I'm having an issue when attempting to get approval up and running. Whenever a new page is created (for the time being, by an admin), it prompts me to approve the changes. When I click 'approve', I get the following error:

"Either staging or approved page cannot be found"

The page is still created in the staging category, with the prefix, but I cannot seem to get it to create an approved copy.

Does anyone have any ideas please? I am relatively new to Tiki and only really have a beginner's knowledge. Any help would be greatly appreciated.

Thanks!

I'm having the same issue, tearing my hair out to figure out why this isn't working. Added every permission I could think of. Had it running fine on Tikiwiki 3.0 but the upgrade to 5 made it break.

Any particular permissions or settings we should look out for.


To add to the above as well. On existing pages, it brings me to an error page:

''System error.

An error occured while performing the request.''

on tiki-approve_staging_page.php

Is there an error log somewhere that would state what the problem would be?

EDIT: I've tried it on TW 4.2 and it works. Also tried on a fresh install of 5.0 (nothing imported) and it breaks in the same way.


OK, so went back to the drawing board and started again. Seems that the issue may be with IIS/Win Server 03 as I installed WAMP(Apache and PHP 5.3.1) and it seems to work fine. What could it possibly be?

For the record tried on 2 servers running Win Server 03, My SQL 5.1.47, PHP 5.2.12. Going to try upgrading the PHP and see how we go.



OK, finally figured it out...just in case anyone is listening.

Wasn't IIS, PHP, Apache or any of the above although IIS is still shockingly bad at serving PHP but anyway...

The problem was an option in MySQL called MySQL mode. In My.ini:

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

commented that out, and all works. The error has something to do with how MySQL treats NULL data, http://bugs.mysql.com/bug.php?id=18551Question