DanRoller

On the suggestion of my local WordPress Meetup, I installed Virtual Box and a Linux image on my Windows machine.

The installation on Linux sites has a problem and there are several other problems all having to do with inconsistent case in stored procedures. This seems to work okay in Windows but not in Unix based systems.

I expect to have 1.0.5 out by Sept 17th 2013.

I’m starting down a path of breaking that initial db setup into smaller pieces so that the administrator is prompted through installing each set of db components, for example: tables, functions, stored procedures, and triggers and that the code try to validate each.

I suspect that either there is another bug or timeouts are breaking the process. In either case, the step by step install should either solve the problem or isolate it. This will take me a day or two.

I can get a white page with only the wordpress headers by setting set_time_limit(33); in the wp-config.php.

1. Concerning the Capability Manager:

Once you have installed the Capability Manager you shouldn’t disable or uninstall it Just use it to the capabilities set for your users.

2. I am puzzled why you would see to two types of error messages, especially the “has not been defined”.

So the following will include first a description of the expected error responses that you have seen and corresponding information from the Capability Manager.
Following that, there is a description of resetting the objtracker* components.

Description
———-
Error 1 – You do not have sufficient permissions to access this page

By design, I get this message for my “Sub Scriber” user with Role of “Subscriber”.

This user has no objtracker in WordPress Tool menu (actually no Tool at all) and if I go to Capability Manager( with my admin user ) and click the Load button for “Subscriber” in the “Select Role to View / Edit” part of the pane – both “objtracker” and “objtrackeradmin” appear in the Additional Capabilities list, but their check boxes are not checked.

Objtracker is looking for capabilities “objtracker” and “objtrackeradmin”, and if neither is set – it is desired that WordPress reject the user with that message.

Error 2 – User … has not been defined to the Balanced Scorecard

By design, I get this message for my “Con Tributor” user with Role “Contributor”. This user does have an objtracker in WordPress Tool menu and if I go to Capability Manager and click the Load button for ” Contributor ” in the “Select Role to View / Edit” part of the pane – both “objtracker” and “objtrackeradmin” appear in the Additional Capabilities list, and only “objtracker” is checked.

The idea is that this non-admin user ought to be able to use the Balanced Scorecard but an administrator (a user with “objtrackeradmin” capability) has not yet placed that person’s ID into the Balanced Scorecard person table with assigned a department.

If an “objtrackeradmin” user hasn’t been entered successfully, the response is “Error Balanced Scorecard is not yet fully installed.” – that the database components have not be initialized by the first admin’s usage.

On the other hand, if a user has ‘objtrackeradmin” capability set, their user ID would have been placed into the person table automatically.

What to do
———-
So, I suspect that (a) there may be a little confusion over the capabilities and surely (b) the prior errors that you found have partially setup the database.

You don’t need to re-install the software unless I have updated the source, but your objtracker* components in your WordPress database can and should be reinitialized by the following.

wtd 1. Delete the objtracker database tables from MySQL using MySQL Workbench or the command line.
Paste the following into MySQL Workbench or a file to use with MySQL’s command line.

DROP TABLE IF EXISTS objtrackerT_Documentation ,
objtrackerT_InstallState ,
objtrackerT_Measurement ,
objtrackerT_Target ,
objtrackerT_Objective ,
objtrackerT_Person ,
objtrackerT_Department,
objtrackerT_ObjectiveType ,
objtrackerT_Frequency ,
objtrackerT_MetricType ,
objtrackerT_FiscalYear,
objtrackerT_FyCalendar,
objtrackerT_AuditIndex,
objtrackerT_Audit,
objtrackerT_AuditColumn,
objtrackerT_AuditTable,
objtrackerT_Organization ;

I’ll presume that you can manage that so that this response occures today. If you need an explanation on using MySQL Workbench or command line, … respond with which and I’ll try to come up with a short description.

wtd 2 Enter objtracker with a user that has “objtrackeradmin” capability. This ought to take half a minute or more to complete successfully. At this point the database components are fully setup and this user will have been automatically added to the objtrackerT_Person table.

If this does not complete successfully without errors – nothing much will work.

wtd 3. This or any other “objtrackeradmin” user then can then add other users that have “objtracker” capabilities.

If you don’t see errors with step 2 but continue to have the same type of errors, then we would need to dig into the objtracker* components of your WordPress database. Lets hope that we won’t have to go there but I will give some thought to what I would want in terms of diagnostic information.

Looking forward to hearing from you.

Thanks for the corrections to the Capability Manager plugin usage.

The “Warning: file_get_contents” warning is fatal and has now been fixed by update 1.0.2.

Thanks for your patience.

Sorry to see that I managed to drop a sentence from the install instructions that meant to clarify that point.

These capabilities are attributes of WordPress users. The missing text referred to having tool such as the plugin “Capability Manager Enhanced” installed. These are named capabilities are meant to be somewhat independent of WordPress admin, author, contributor, etc.

Reminder, the “objtrackeradmin” capability allows users to:
1. See objtracker in Tools menu.
2. Enter objtracker as an objtracker admin – automatically adding user id to objtracker users.
3. Add other users to the objtracer users list.
4. Manage reference tables and objectives.

Reminder, the “objtracker” capability allows users to:
1. See objtracker in Tools menu.
2. Enter objtracker as a user if an objtrackeradmin has added user id to objtracker users.
3. Add or update objective measurements assigned to that user.

Here is a longer description of adding a WordPress user capability based on the “Capability Manager Enhanced” plugin.

If you install “Capability Manager Enhanced” plugin. Use the following steps:
1. Enable plugin – this adds a “Capability Manager” menu item to the Users menu.
2. Click “Capability Manager” from Users menu.
3. In “Select Role to View / Edit” box in upper right of page, select role “Administrator” and click “Load”.
4. In “Add Capability” box, last on right side, type “objtrackeradmin” and click “Add to role”.
5. Scroll to the bottom of the page, notice “objtrackeradmin” in “Additional Capabilities” list.
6. Click “Save Changes” – these user should now see “objtracker” in the Tools menu.

If the Tools menu is hidden from a user, then objtracker can be accessed by websitename/wp-admin/tools.php?page=objtracker/objtracker.php.