Jump to content
zomex

Marketconnect store links do not work

Recommended Posts

Hello,

Just installed the latest release for testing.

The marketconnect links within the cart are invalid. The only one that works is Professional Email.

See attached.

Screenshot 2020-12-30 at 12.17.45.png

Screenshot 2020-12-30 at 12.17.50.png

Screenshot 2020-12-30 at 12.17.58.png

Share this post


Link to post
Share on other sites
35 minutes ago, zomex said:

The marketconnect links within the cart are invalid. The only one that works is Professional Email.

it looks as though the relevant slugs for those other MC groups haven't been defined in the tblproductgroups table. 🙄

Share this post


Link to post
Share on other sites
48 minutes ago, brian! said:

it looks as though the relevant slugs for those other MC groups haven't been defined in the tblproductgroups table. 🙄

Quite a bug for a stable release 😞

Share this post


Link to post
Share on other sites

Hi @zomex,

I've not been able to reproduce this on my fresh stock v8.1 installation; all the MarketConnect services are accessible from the Sidebar and Primary Navigation bar on cart.php.

I also tried with a child theme in-case that was somehow related, but the links remained valid.

What is the href you see for these links on your installation please?

Screenshot 2020-12-30 at 16.51.57.png

Share this post


Link to post
Share on other sites

I can't send you the URL publically as it's password protected.

Please confirm how I can contact you directly.

Thanks.

Share this post


Link to post
Share on other sites

This turned out to be an issue on my dev install. Must have been caused by a previous error or glitch during a past update.

Fixed using WHMCS's provided SQL statement.

Edited by zomex

Share this post


Link to post
Share on other sites
4 hours ago, JSobers1331 said:

@zomex I'm having the same issue, would it possible if you can point me in the direction of this SQL fix?

Thanks in advance.

This was their reply. Before running the command submit a ticket to WHMCS with reference to #NVK-604326 to ensure it's the same solution:

Thank you for contacting WHMCS support. I am sorry to hear that the MarketConnect client area links are not working. Based on the details provided, I suspect that this is due to missing values for the slug column in the tblproductgroups database table. This should be populated automatically, but if the table has been edited or an error occurred previously that wasn't rectified, it could result in this. The good news is that potential cause has a fairly simple solution: the slug value defaults to the product group name, converted to lowercase and spaces replaced with hyphens, so the following SQL query could be run to populate the records with missing values for it as needed:

UPDATE tblproductgroups SET slug = LOWER(REPLACE(name, " ", "-")) WHERE slug = '';

Before running the above, I would recommend taking a backup of your database as a precaution.

If that doesn't help, could you please provide temporary working WHMCS admin and cPanel/FTP login details so we can look into this for you?

To securely provide these details, please click the "View Ticket Online" button at the bottom of this email, then click the "Submit/Update Login Credentials" button. Finally, click the "Save/Update" button at the bottom of the page, and then reply here so we may continue our investigations.

If you have a firewall or htaccess blocks in place, please grant access to the following IP to allow our staff access:

  • 208.74.120.226

For information on the level of access I'll need to your server, please refer to https://www.whmcs.com/members/index.php/knowledgebase/301/FTP-UsernameorControl-Panel-Username-value-is-not-valid.html

Best regards,

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