zomex Posted December 30, 2020 Share Posted December 30, 2020 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. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted December 30, 2020 Share Posted December 30, 2020 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. 🙄 1 Quote Link to comment Share on other sites More sharing options...
zomex Posted December 30, 2020 Author Share Posted December 30, 2020 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 😞 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted December 30, 2020 WHMCS Support Manager Share Posted December 30, 2020 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? 0 Quote Link to comment Share on other sites More sharing options...
zomex Posted December 30, 2020 Author Share Posted December 30, 2020 I can't send you the URL publically as it's password protected. Please confirm how I can contact you directly. Thanks. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted December 30, 2020 WHMCS Support Manager Share Posted December 30, 2020 Hi @zomex, You can privately submit bug reports via https://www.whmcs.com/bugs/ or contact technical support for assistance with issues specific to your installation via https://www.whmcs.com/submit-a-ticket/Â 0 Quote Link to comment Share on other sites More sharing options...
zomex Posted December 30, 2020 Author Share Posted December 30, 2020 Ok ticket sent. Thanks. 0 Quote Link to comment Share on other sites More sharing options...
zomex Posted December 31, 2020 Author Share Posted December 31, 2020 (edited) 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 December 31, 2020 by zomex 0 Quote Link to comment Share on other sites More sharing options...
WHMCS ChrisD Posted January 1, 2021 Share Posted January 1, 2021 Glad to hear this is resolved @zomex! 0 Quote Link to comment Share on other sites More sharing options...
JSobers1331 Posted January 8, 2021 Share Posted January 8, 2021 @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. 0 Quote Link to comment Share on other sites More sharing options...
zomex Posted January 8, 2021 Author Share Posted January 8, 2021 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, 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.