Clients Losing Permission to Forms

[Ben]

Hey Prig,

Don't worry about the Themes link not working: that's actually expected. Give this page a read over:
http://docs.formtools.org/upgrading/?page=2_0_3

That explains how to fix the Themes page. It was moved out of the Settings tab with version 2.0.3. Because the menus are customizable I couldn't just update everyone's system to put it in a new location - it has to be done manually (don't worry, it's very simple).

For the other error, run this SQL query through phpMyAdmin:

Code:

ALTER TABLE ***view_filters
CHANGE operator operator ENUM('equals', 'not_equals', 'like', 'not_like', 'before', 'after' )
CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'equals'

Again, *** should be your database table prefix, like before.

After executing that query, re-run the Database Integrity module to check that all tables are all fixed now.

*However* after all this (!) I'm still not convinced these problems are related to your original problem: client account permissions being dropped. If I haven't already recommended it, could you try installing the Client Audit module? That module tracks all changes made to client accounts - including permission changes. It's very possible that it may help debug why this is occurring.

Thanks!

- Ben