Title: DanRoller's Replies | WordPress.org --- # DanRoller [ ](https://wordpress.org/support/users/danroller/) * [Profile](https://wordpress.org/support/users/danroller/) * [Topics Started](https://wordpress.org/support/users/danroller/topics/) * [Replies Created](https://wordpress.org/support/users/danroller/replies/) * [Reviews Written](https://wordpress.org/support/users/danroller/reviews/) * [Topics Replied To](https://wordpress.org/support/users/danroller/replied-to/) * [Engagements](https://wordpress.org/support/users/danroller/engagements/) * [Favorites](https://wordpress.org/support/users/danroller/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/users/danroller/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/danroller/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Install question](https://wordpress.org/support/topic/install-question-3/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 8 months ago](https://wordpress.org/support/topic/install-question-3/#post-3991132) * With objtracker 1.0.6, I have tested on both Windows and Fedora having resolved numerous issues. * Let call this closed. Please open new install issues if you have problems with the install. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Install question](https://wordpress.org/support/topic/install-question-3/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 8 months ago](https://wordpress.org/support/topic/install-question-3/#post-3991131) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Install question](https://wordpress.org/support/topic/install-question-3/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 8 months ago](https://wordpress.org/support/topic/install-question-3/#post-3991111) * Please upgrade to objtracker 1.0.3 which has a step-by-step database setup requiring multiple clicks to continue. I hope this works because each setp uses less time than your time out or it shows me what other problems there are. * First please drop one database table using (with your userid …) mysql -h localhost- uroot -D wordpress??? then DROP TABLE IF EXISTS objtrackerT_InstallState; This will force objtracker to restart the its database setup. * Thank you * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Install question](https://wordpress.org/support/topic/install-question-3/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 8 months ago](https://wordpress.org/support/topic/install-question-3/#post-3991105) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Install question](https://wordpress.org/support/topic/install-question-3/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 8 months ago](https://wordpress.org/support/topic/install-question-3/#post-3991104) * You have provided something that gives me a clue to what is going on. * Please look into the objtrackert_department and objtrackert_organization tables. The department table should have one row with ID 1. The organization table should have 2 rows with IDs 0 and 1. The ID column is the first column of each table. * Please respond with the IDs for the rows that you find in each table. * Thank you * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Install question](https://wordpress.org/support/topic/install-question-3/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 8 months ago](https://wordpress.org/support/topic/install-question-3/#post-3991089) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Install question](https://wordpress.org/support/topic/install-question-3/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 9 months ago](https://wordpress.org/support/topic/install-question-3/#post-3991064) * Manuel. * Have your problems been addressed? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Install question](https://wordpress.org/support/topic/install-question-3/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 9 months ago](https://wordpress.org/support/topic/install-question-3/#post-3990979) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Install question](https://wordpress.org/support/topic/install-question-3/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 9 months ago](https://wordpress.org/support/topic/install-question-3/#post-3990930) * Update 1.0.1 has revised description of capabilities. * If you have tools other than the “Capability Manager Enhanced” plugin that can add WordPress user capabilites, please reply so that I can improve the installation description, * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Warning: Missing argument 2 for wpdb::prepare()](https://wordpress.org/support/topic/warning-missing-argument-2-for-wpdbprepare-17/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 9 months ago](https://wordpress.org/support/topic/warning-missing-argument-2-for-wpdbprepare-17/#post-3997905) * Resolved by update 1.0.1. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Broken links for WordPress installed in subdirectory](https://wordpress.org/support/topic/broken-links-for-wordpress-installed-in-subdirectory/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 9 months ago](https://wordpress.org/support/topic/broken-links-for-wordpress-installed-in-subdirectory/#post-3997902) * Resolved by update 1.0.1. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Objective Tracker] Install question](https://wordpress.org/support/topic/install-question-3/) * Plugin Author [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 9 months ago](https://wordpress.org/support/topic/install-question-3/#post-3990923) * 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. * Forum: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/) In reply to: [Is full control of http response possible?](https://wordpress.org/support/topic/is-full-control-of-http-response-possible/) * Thread Starter [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 9 months ago](https://wordpress.org/support/topic/is-full-control-of-http-response-possible/#post-3713110) * And the init hook works! Just check for mimetype with $_GET and do the download of tsv or document starting with http headers. * Thanks * Forum: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/) In reply to: [Is full control of http response possible?](https://wordpress.org/support/topic/is-full-control-of-http-response-possible/) * Thread Starter [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 9 months ago](https://wordpress.org/support/topic/is-full-control-of-http-response-possible/#post-3713109) * I appreciate your help and it got me though a lot of stuff. * But then I made it more complex. I had taken all of the app to depend on wp-load because I couldn’t get Tools/Available Tools and Setting to behave. I now have the primary app working (minus the tools/setting issues). * Now back to the original problem – tab separated download to excel. Removing wp-load quickly gets into __( and ABSPATH not found, probably can bypass, but I need to know who the user is is_user_logged, user name, get_current_blog_id, then DB_HOST, DB_USER, … and eventually escaping/sanitizing … * As for picking a good hook presumes that I know something about hooks, but I’ll start reading from the top. Thanks again * Forum: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/) In reply to: [Is full control of http response possible?](https://wordpress.org/support/topic/is-full-control-of-http-response-possible/) * Thread Starter [DanRoller](https://wordpress.org/support/users/danroller/) * (@danroller) * [12 years, 9 months ago](https://wordpress.org/support/topic/is-full-control-of-http-response-possible/#post-3713107) * I have changed this item back to unresolved because when I tried to submit the plugin, it was rejected because its use of wp-load.php. * I’ll see if I can get around not have wp-load.php, but I expect to be lost in the woods for awhile. Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/users/danroller/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/danroller/replies/page/2/?output_format=md)