Dan L. Posted January 21, 2015 Share Posted January 21, 2015 I'm pretty new to whmcs. I had it configured with 2 products listed. When I had trouble with an unrelated issue I needed to reinstall my whmcs database (good thing I get backups emailed to me daily). I thought the reinstall of my db went smoothly. All my settings transferred properly, but my products have disappeared. Not only have my products disappeared, I am unable to create a new product or product group! If anyone has a clue on what the issue might be, please advise. I'd appreciate any help. Dan 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted January 22, 2015 Share Posted January 22, 2015 What's in your tblproducts table ? 0 Quote Link to comment Share on other sites More sharing options...
Dan L. Posted January 22, 2015 Author Share Posted January 22, 2015 What's in your tblproducts table ? Again, I'm pretty new to this stuff. So, I went into my Cpanel > phpMyAdmin. Then when I click on my DB it shows all the tables/files contained within. I'm afraid that I do not have a tblproducts table in the list!! Please advise on what I can do to remedy this. Thanks! 0 Quote Link to comment Share on other sites More sharing options...
Dan L. Posted January 23, 2015 Author Share Posted January 23, 2015 I came to the realization that this problem goes beyond my products list. I'm also unable to schedule to-do list items, create quotes, and not sure what else. I just tried importing my db backup from Jan. 1st, long before I had any issues. Here's the error I received: SQL query: CREATE TABLE `mod_onlinenic` ( `id` int(10) NOT NULL AUTO_INCREMENT, `domain` varchar(255) NOT NULL, `lockstatus` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `domainid` (`domain`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; MySQL said: Documentation #1050 - Table 'mod_onlinenic' already exists 0 Quote Link to comment Share on other sites More sharing options...
Dan L. Posted January 23, 2015 Author Share Posted January 23, 2015 Okay stop. I need to update this. I've learned quite a bit over the past couple of hours. I created a test database and successfully imported my whmcs backup db. This allowed me to compare against my live database, where I found that a slew of tables did not migrate. So, on my live db, I deleted all of the existing whmcs tables/files, then re-imported my backup. This time it worked! Thank you OthelloTech. Your simple reply/question about the tblproducts table was a good tip that helped nudge me down the right path. :-D 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.