Loading...
 
Skip to main content

Features / Usability


Page staging approval error

So close to having page staging working I can TASTE it.
Clicking the approve changes link while viewing a staged page produces the following database query error message...

Column 'wiki_authors_style' cannot be null

The pink error page suggests the query contained...
...wysiwyg`=, `wiki_authors_style`=NULL , `flag`=,...

I can't find where this is happening in tiki-approve_staging_page.php
Any ideas on what might fix this? what's the wiki_authors_style column for anyway?

I want this feature SO bad!

I think wiki_authors_styles refers to the "List authors:" dropdown list on the admin wiki page. I don't know what setting it should have, though.

-- Gary

Hmm. Changing the setting doesn't seem to affect the error. It's almost like $tikilib->update_page() is choking when getting called in tiki-approve_staging_page.php.
Though, I can't see how... of course, that's not saying much.

lucas


Still can't find the problem. Would reinstalling help? I've been operating under the impression that just reinstalling would be a bit of a waste.

Tried this...
Installed TW 2.0 with no issues.
Logged in as administrator.
Created two categories 'approved' & 'staged'
Enabled page staging in wiki admin, selected these categories in the wiki admin for page staging, set 'If not in group, redirect' to 'registered'.
Created a wiki page 'stage test'.
Saved a normal edit of 'stage test'.
Added page 'stage test' to the category 'approved'.
Tried to edit 'stage test' and was brought to a staging page edit (yay).
Saved edit to staging page.
Clicked 'approve changes' link...
...ERROR IN DATABASE QUERY! j0U 4R3 PWNED!!

I'm beginning to think this is not a problem I can fix.
Anybody else able to verify this behavior in 2.0?


I just tried a fresh install of 2.0 RC2 and get the same error. Is there another version of PHP I should maybe be using? Right now I'm using PHP 5.2.5 on Apache 2.0.61, and MySQL 5.0.45.

Ugh, still not getting anywhere with this feature. Fantastic idea though... Will drop it in the bugs bucket. Will maybe work in next release? Would be so great for my application.

Cheers,

lucas


Could anyone verify that the page staging feature works in ANY version of TikiWiki?

It's working at support.mozilla.com, which is where the feature got folded back from. But I'm not sure about success/failure in the 2.0 release.

-- Gary


This issue can be fixed by changing the field in the database to where nulls are allowed. I used phpmyadmin to change it for approvals in mine and it resolved the issue. The field doesn't appear to be used at this point for anything anyway so I am not sure whether this was a design mistake or not but resetting the field to allow Nulls will fix it.

Regards,

wilsonmi

I'm running 2.0 on Linux and getting same error using the staging configuration. I got in through phpmyadmin and rooted around looking for where nulls are allowed, but could not find it. wilsonmi, can you give me a little guidance?
Thanks!
mdsmith

So I found the issue in the database per wilsonmi's suggestion and it's working now.

Enter database via PHPmyadmin.
Navigate to wiki-pages
At the bottom of the list is wiki_authors_style and just edit it to allow NULL.
Working!!!

P.S. I'm no expert. It doesn't seem to have broken anything. I'll post later if I find this isn't working out.

Mark