Jump to content
Damo

Hotfix CORE-17166

Recommended Posts

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 by xyzulu

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?  

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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. 

Share this post


Link to post
Share on other sites

Thanks for the info. Please delete the fixer script from your server now the update process is completed.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated