Darkphyre Posted October 25, 2010 Share Posted October 25, 2010 Hello, I can't seem to add new orders to my WHMCS 4.3.1 installation. In the "Add Order" page, the "Client" and "Payment gateway" drop down menus are just blank. The "Product/Service" drop down menu is just stuck at "None." It was working fine for weeks. We had over 300 orders then all of a sudden it just stopped working. In the "Manage Orders" page, no orders are being shown at all. Even the "Staff Online" section on the bottom left corner of the page is just blank. Here are some screenshots: Please advice. Thank you. 0 Quote Link to comment Share on other sites More sharing options...
Darkphyre Posted October 26, 2010 Author Share Posted October 26, 2010 I just checked my mysql server log files and its spitting something out whenever we try to view the orders via whmcs. I have attached the log file. It looks like it's failing when trying to perform the following query: SELECT id,firstname,lastname,companyname,groupid FROM tblclients WHERE status='Active' ORDER BY `firstname` ASC,`lastname` ASC But I don't understand why if we are able to browse the tblclients table without any issues via phpmyadmin. I tried updating my MySQL version from 5.0.51a to 5.1.51 (the latest stable release) to see it may have been a bug in 5.0.51a and that does not appear to have fixed it. I get the same error message in the log file. Please advise. Thank you. whmcsmysqllog.txt 0 Quote Link to comment Share on other sites More sharing options...
m00 Posted October 26, 2010 Share Posted October 26, 2010 Do you have a lot of clients? It looks like the database crashes on that query. Try to disable the full client dropdown (Setup > General Settings > Tab Other and check Disable Full Client Dropdown). 0 Quote Link to comment Share on other sites More sharing options...
Darkphyre Posted October 26, 2010 Author Share Posted October 26, 2010 Woooo! That fixed it! Thank you so much! So I guess It's just crashing because it's querying too much data? Or is there something else going on here? 0 Quote Link to comment Share on other sites More sharing options...
m00 Posted October 26, 2010 Share Posted October 26, 2010 Woooo! That fixed it! Thank you so much! So I guess It's just crashing because it's querying too much data? Or is there something else going on here? Looks like it. You can try to tweak your buffer sizing a bit if you want to enable the full client dropdown list again. 0 Quote Link to comment Share on other sites More sharing options...
Chasem Posted October 28, 2010 Share Posted October 28, 2010 I'm having the same issue, the "Disable Full Client Dropdown" did not fix the issue at all... 0 Quote Link to comment Share on other sites More sharing options...
Darkphyre Posted October 28, 2010 Author Share Posted October 28, 2010 Chasem, Can you post your MySQL server log file here just like I did on my second post? Have you tried checking if your MySQL database is corrupt? Thank you. 0 Quote Link to comment Share on other sites More sharing options...
Chasem Posted October 29, 2010 Share Posted October 29, 2010 Hey, I just found the issue... My server was completely out of hard drive space... Runaway log files 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.