Damo Posted October 19, 2021 Share Posted October 19, 2021 Hello, The instructions here https://help.whmcs.com/m/v83/l/1473951-troubleshooting-a-column-group_id-cannot-be-null-error say to go to /install/install.php after running the script and deleting it after the output shows the re-assignment, however, there is no /install/ directory on functioning site. Please provide clarification on Step 7. 0 Quote Link to comment Share on other sites More sharing options...
xyzulu Posted October 19, 2021 Share Posted October 19, 2021 (edited) As I understand you would stop at step 6 if you were performing this fix after installation/upgrade (I would not be installing this myself post upgrade/installation) and not at the same time. Have you run the first mysql query to determine if you actually need to fix anything or not yet? ie SELECT * FROM tblproducts WHERE `gid` NOT IN (SELECT id FROM tblproductgroups); If this gives you no results.. you won't need to use/install this hotfix. Edited October 19, 2021 by xyzulu 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted October 20, 2021 WHMCS Support Manager Share Posted October 20, 2021 Hi @Damo The orhpaned product fixer script is only required if you encounter the group_id error whilst applying the 8.3.0 update. It differs from a hotfix, in that it should be run once and then deleted, after its corrected data in the database. Hotfixes are typically patches for the WHMCS software code which should be left in place. The orphaned product fixer shouldn't cause any problems if used in different circumstances though. 0 Quote Link to comment Share on other sites More sharing options...
Damo Posted October 21, 2021 Author Share Posted October 21, 2021 Ok well I ran it and deleted it as it was labelled a hotfix. Will I now need to do something to undo this or complete the action? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted October 21, 2021 WHMCS Support Manager Share Posted October 21, 2021 Hi @Damo, 1. What version of WHMCS are you currently running? 2. Did you encounter the Column 'group_id' cannot be null error whilst applying the 8.3.0 update? 3. What output did you see on-screen when running the fixer script? 0 Quote Link to comment Share on other sites More sharing options...
Damo Posted October 21, 2021 Author Share Posted October 21, 2021 I'm running 8.3.0 The auto updated didn't complete so had to go to the installer to finish. Didn't see the error on screen. A single line was displayed something about product and a single being moved. I can't. recall exactly. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted October 21, 2021 WHMCS Support Manager Share Posted October 21, 2021 Thanks for the info. Please delete the fixer script from your server now the update process is completed. 0 Quote Link to comment Share on other sites More sharing options...
Damo Posted October 22, 2021 Author Share Posted October 22, 2021 Did that already. Thanks 🙂 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.