shivahost Posted November 28, 2015 Share Posted November 28, 2015 Dear friends In whmcs 6.1 we cannot add product addons. It shows sucess message but nothing saved. Database tbladdons is empty. Updated from 4.4.3. All other sections are fine. 0 Quote Link to comment Share on other sites More sharing options...
shivahost Posted November 28, 2015 Author Share Posted November 28, 2015 any solution? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted November 29, 2015 Share Posted November 29, 2015 it might be prudent to open a ticket with support as it sounds as though the upgrade wasn't entirely successful, and they would be able to take a closer look at your installation. failing that, you could try installing the latest version again and see if that fixes it. 0 Quote Link to comment Share on other sites More sharing options...
shivahost Posted November 29, 2015 Author Share Posted November 29, 2015 may its better for me to stay for 6.2 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted November 29, 2015 Share Posted November 29, 2015 it's an option, but if something hasn't updated when going from v4 -> v6.1, there's no guarantee it would be fixed by v6.2 0 Quote Link to comment Share on other sites More sharing options...
shivahost Posted November 29, 2015 Author Share Posted November 29, 2015 I updated whmcs from 4 -> 6 then I installed a new whmcs 6 and all my custom modules like a new web site/ after all I imported clients, services, tickets , domains and etc. tables from old updated DB to into new installed DB. it is about mount ago! every thing works fine but "products addons" have this problem! 0 Quote Link to comment Share on other sites More sharing options...
shivahost Posted November 30, 2015 Author Share Posted November 30, 2015 how I can check and rebuild all DB tables structure without loosing any date? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted December 2, 2015 WHMCS Support Manager Share Posted December 2, 2015 Hi, Please enable the Setup > General Settings > Other tab > MySQL Debug mode, reproduce the error, switch of MySQL Debug. Then navigate to Utilities > Logs > Activity Log, and let me know whether you see any MySQL Errors recorded. 0 Quote Link to comment Share on other sites More sharing options...
shivahost Posted December 2, 2015 Author Share Posted December 2, 2015 Hi,Please enable the Setup > General Settings > Other tab > MySQL Debug mode, reproduce the error, switch of MySQL Debug. Then navigate to Utilities > Logs > Activity Log, and let me know whether you see any MySQL Errors recorded. thanks for your help: - - - Updated - - - two first errors are from going to "configaddons.php" other errors are from saving aadon! - - - Updated - - - and this is my DB structure not complete table! - - - Updated - - - So I need a query to build complete table! which is not in whmcs/install/sql/install.sql 0 Quote Link to comment Share on other sites More sharing options...
shivahost Posted December 4, 2015 Author Share Posted December 4, 2015 is anybody there!? 0 Quote Link to comment Share on other sites More sharing options...
shivahost Posted December 7, 2015 Author Share Posted December 7, 2015 no help yet! 0 Quote Link to comment Share on other sites More sharing options...
shivahost Posted December 8, 2015 Author Share Posted December 8, 2015 I have created missing columns and problem solved! But please some one send me a picture from tbladdons table structure in phpmyadmin, so I can check if I done right! 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted December 9, 2015 WHMCS Support Manager Share Posted December 9, 2015 Hi, Below is the structure of the tbladdons table as of v6.2: CREATE TABLE IF NOT EXISTS `tbladdons` ( `id` int(10) NOT NULL AUTO_INCREMENT, `packages` text NOT NULL, `name` text NOT NULL, `description` text NOT NULL, `billingcycle` text NOT NULL, `tax` text NOT NULL, `showorder` text NOT NULL, `downloads` text NOT NULL, `autoactivate` text NOT NULL, `suspendproduct` text NOT NULL, `welcomeemail` int(10) NOT NULL, `weight` int(2) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `name` (`name`(32)) 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.