PILMAN

Having issue with WHMCS. Customers were not billed 1st of the month like they are supposed to. Went to WHMCS admin panel and noticed that it says 0 dollars for income and I went under my admin activity logs and the following shows up 11/25/2008 03:00 Email Sent to Antonia Hartley (Credit Card Payment Failed) System 11/24/2008 14:31 Deleted Invoice (ID: 127 - User ID: 0000000046) cbern 11/24/2008 14:26 Deleted Invoice (ID: 71 - User ID: 0000000038) cbern 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 14:19 Deleted Order ID pilman 11/24/2008 03:00 Cron Job Run System 11/24/2008 03:00 Email Sent to AZSS (Upcoming Domain Renewal Notice) System 11/24/2008 03:00 Email Sent to Charles Taylor (Upcoming Domain Renewal Notice) System 11/24/2008 03:00 Credit Card Payments Processed (0 Captured, 5 Failed) System I haven't deleted anything and now under all my clients, everythings missing like what services they have, how much they paid and they are not being billed. Is there any way to fix this? Thanks.

The user was already added to the database.

Getting a different error now. Connected to MySQL Access denied for user 'data_invoice'@'localhost' to database 'data_invoice'

Yes it appears you are right, looks like when I recompiled Apache, a number of my scripts stopped working (not able to connect to MYSQL database). My PHPNUKE and Modernbill still work but some of my store scripts and Joombla no longer work...

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/data/public_html/test.php on line 2 Client does not support authentication protocol requested by server; consider upgrading MySQL client

Yes, they have full permissions. It's the same procedure I have done for other MYSQL scripts.

I am the server administrator, there is nothing wrong with the database details. Also all other scripts using my MYSQL database work fine.

I downloaded the trial version of WHMCS as I want to see how it is before I purchase it. I am getting an error for some reason about my MYSQL database. I actually recompiled my apache to install CURL before hand because I didn't have it. When I try to do the install, I get the error Could not connect to the database - check the database connection details you entered and go back and correct them if necessary my MYSQL information is correct, I triple checked. everything is CHMOD correctly as well. Any ideas?