Hello Oliver.

Can you check your “users” table using phpmyadmin to see if the is_creator field is available? If not,

1. Try and run the update once and check if the field is getting added
2. OR  you can try and run the following SQL and it should resolve the issue. 

ALTER TABLE `qc_documents` ADD `data_update_type` INT(1) NULL DEFAULT '0' AFTER `schedule_id`;
ALTER TABLE `users` ADD `is_creator` TINYINT(1) NULL DEFAULT '1' AFTER `is_approver`, ADD `is_publisher` TINYINT(1) NULL DEFAULT '1' AFTER `is_creator`;

-FlinkISO Help Team

Hello,

thanks for your reply, the mentioned field is_creator is not existing in users table. I tried to update the system from the web page but got access denied error without further details. Is there an option to run the update also from console?

If that would not work I will try to use the sql commands.

Thanks and greetings!!

Hi,

Can you try running the following commands from phpmyadmin? 

ALTER TABLE `qc_documents` ADD `data_update_type` INT(1) NULL DEFAULT '0' AFTER `schedule_id`;
ALTER TABLE `users` ADD `is_creator` TINYINT(1) NULL DEFAULT '1' AFTER `is_approver`, ADD `is_publisher` TINYINT(1) NULL DEFAULT '1' AFTER `is_creator`;

-FlinkISO Help Team

Hello,

seems that worked now with the alter table command but now the next problem popped up: I created a new document category but can't publish that because system says I'm have no approval rights. Based on user definition I have.

Is there an issue when working with user having admin rights?

Can you please check question above regarding update from command line? Web client didn't work.

Thanks !!

Hello, 

Mark yourself as Approver, then logout and login. That should resolve the issue. With new changes, a person can be Admin, but not necessarily Approver. 

-FlinkISO Help Team