cmshosting Posted July 10, 2020 Share Posted July 10, 2020 On every single client of mine via /clientsdomains.php?userid=XXX I get Client ID Not Found. Yet they own a domain they bought from me or transferred to me anyone got any idea what could be causing this? Same area on all tabs, the client user list pops up on every new page load which is quite annoying too... 0 Quote Link to comment Share on other sites More sharing options...
yggdrasil Posted July 11, 2020 Share Posted July 11, 2020 (edited) If your database empty? It seems to me that you have either missing tables, data or a corrupted database. Step one. Check your MariaDB/MySQL database, are the customers and domains there? Edited July 11, 2020 by yggdrasil 0 Quote Link to comment Share on other sites More sharing options...
cmshosting Posted July 11, 2020 Author Share Posted July 11, 2020 48 minutes ago, yggdrasil said: If your database empty? It seems to me that you have either missing tables, data or a corrupted database. Step one. Check your MariaDB/MySQL database, are the customers and domains there? Yes, the pop up list tells me I have customers as well as the 120 customers in the list with verified emails, domain names, addresses and phone numbers and payment history? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted July 11, 2020 Share Posted July 11, 2020 have you changed anything recently, e.g upgraded WHMCS, installed an addon ?? 1 Quote Link to comment Share on other sites More sharing options...
yggdrasil Posted July 11, 2020 Share Posted July 11, 2020 8 hours ago, cmshosting said: Yes, the pop up list tells me I have customers as well as the 120 customers in the list with verified emails, domain names, addresses and phone numbers and payment history? That was not my question. The popup is not your database. You need to check if data exists in your database, not WHMCS. WHMCS will not be able to pull anything if the tables in the database are empty or don't exists. 1 Quote Link to comment Share on other sites More sharing options...
cmshosting Posted July 11, 2020 Author Share Posted July 11, 2020 10 hours ago, brian! said: have you changed anything recently, e.g upgraded WHMCS, installed an addon ?? Recently not that Im aware of but its been an issue for while now... 0 Quote Link to comment Share on other sites More sharing options...
cmshosting Posted July 11, 2020 Author Share Posted July 11, 2020 6 hours ago, yggdrasil said: That was not my question. The popup is not your database. You need to check if data exists in your database, not WHMCS. WHMCS will not be able to pull anything if the tables in the database are empty or don't exists. So where does the data come from if I see it within whmcs itself? What table am I looking for? tblclients? Ive got 110 records if so. Which are all within WHMCS and tbldomains has 101 records but client 88 is the one I originally showed and she's got the record in both tables. I have customers who pay for web hosting and don't even use the account is why 9 records are missing. 0 Quote Link to comment Share on other sites More sharing options...
yggdrasil Posted July 11, 2020 Share Posted July 11, 2020 1 minute ago, cmshosting said: So where does the data come from if I see it within whmcs itself? What table am I looking for? tblclients? Ive got 110 records if so. Which are all within WHMCS and tbldomains has 101 records but client 88 is the one I originally showed and she's got the record in both tables. I have customers who pay for web hosting and don't even use the account is why 9 records are missing. All the data comes from the WHMCS database except some minor exception that are flat configuration files. Check the domain tables. The screenshot you attached, shows that you get Client ID not Found when you clicked under Domains. That does not mean WHMCS cannot find the customer which clearly exists. It means it cannot find any domains for that customer ID. You need to verify the domains table and see if there are domains that match the ID for that customer. Maybe you or some other admin deleted the domains from WHMCS? 1 Quote Link to comment Share on other sites More sharing options...
cmshosting Posted July 11, 2020 Author Share Posted July 11, 2020 Heres more example showing everything I think. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted July 12, 2020 Share Posted July 12, 2020 12 hours ago, cmshosting said: Recently not that Im aware of but its been an issue for while now... that's not good - that means you will have forgotten what might have caused this originally. what version of WHMCS are you using? I can't check directly as your site is timing out. 0 Quote Link to comment Share on other sites More sharing options...
cmshosting Posted July 14, 2020 Author Share Posted July 14, 2020 It should be the latest whmcs. I also fixed the issue with the time out tblactivity had 1.55M records 320mb that brought the site to its knees when cron ran. It was from debug mode on a few weeks ago. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted July 14, 2020 Share Posted July 14, 2020 12 hours ago, cmshosting said: I also fixed the issue with the time out tblactivity had 1.55M records 320mb that brought the site to its knees when cron ran. It was from debug mode on a few weeks ago. the main site still times out when I try to view it from the UK (any UK IP) - but if I view it via an American IP, it loads fine... so possibly IP restrictions occurring too ? it might be worth opening a ticket with support because there are a lot of unknowns in this situation and multiple possible causes that will need to be eliminated. 0 Quote Link to comment Share on other sites More sharing options...
andrezzz Posted March 4, 2021 Share Posted March 4, 2021 Hello! I'm having the same issue after ugrade from WHMCS v7.6 to v7.10 any ideas? 0 Quote Link to comment Share on other sites More sharing options...
Codes091 Posted October 25, 2021 Share Posted October 25, 2021 I'm seeing the same issue on a Development server. It's been working for months and suddenly this morning I'm unable to view any client records. For me it started after I created a new Customer. As with the above cases, all the client records in the database remain intact. Just WHMCS code that seems unable to show the customer details after pulling the full list onto the screen. I'll be restoring from a backup but consider this highly irregular. 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.