z900collector Posted October 25, 2017 Share Posted October 25, 2017 We have a licensed copy of the Client Profile Viewer Module but it appears to crash with a missing table error: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'admin_whmcs.cp_person_assigned' doesn't exist I've looked in the DB and we only have the following "cp_xxxx" tables... cp_clients_custom_statuses cp_conf_role cp_conf_widget cp_configuration cp_widget_configuration How do I get back my tables? Do I delete the existing ones and re-run the module? Sid 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Developer WHMCS Andrew Posted October 25, 2017 WHMCS Developer Share Posted October 25, 2017 You may be better contacting the developer of the module directly using their own support channels. 0 Quote Link to comment Share on other sites More sharing options...
z900collector Posted October 26, 2017 Author Share Posted October 26, 2017 14 hours ago, WHMCS Andrew said: You may be better contacting the developer of the module directly using their own support channels. I actually could not find any way to easily contact them, however I spent a few hours and have solved it by dropping the cp_* tables, running the modules and the recreating them one by one from the backup I took and manually updating the version info in the module config table. I'd say it failed between the 1.5.5 to 1.5.6 upgrade someone did recently. Sid 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.