Jump to content

PLEASE HELP! Weird BUGS | Client list, Support list disappearing then reappearing


Recommended Posts

I am pretty new to WHMCS and I would GREATLY appreciate any help or advice.


Intermittently (very RANDOM), my client list and other lists such as support tickets, mass mail emails, will completely disappear.


See attached PNG. When attempting to view client list, it is completely BLANK. However, as the system says, "203 Records Found, Page 1 of 3".


A similar issue happens when trying to view other lists such as support tickets or invoices. The weird thing is that this only happens sometimes and is very random.


Another example is the 2nd PNG that I attached.. it is displaying Active Tickets (which is 2), however, in the side panel, the number of "All Active Tickets" is ZERO. Even when we have many active tickets, this number (along with the other 2 it is paired with) only displays ZERO.



Thanks in advance for ANY assistance!




Link to comment
Share on other sites

  • WHMCS Support Manager


If it's intermittent it sounds like a server issue, do your server error logs show any errors when this occurs?

Try temporarily enabling Setup > General Settings > Other tab > SQL Debug Mode and see if any errors are recorded in your Utilities > Logs > Activity Log when it next occurs. Then disable the option again.

Link to comment
Share on other sites

Screen Shot 2012-09-21 at 12.32.38 PM.jpgHey John,


Thanks so much for a response. I did as instructed and received the following error:


SQL Error: Unknown column 'date' in 'order clause' - Full Query: SELECT * FROM tblemailmarketer ORDER BY `date` DESC LIMIT 0,100


I have attached a PNG of the email marketer page. Any ideas on how to fix this?




Link to comment
Share on other sites

  • WHMCS Support Manager


That error message says the 'date' column is missing from the tblemailmarketer table in your database. But as far as I'm aware there isn't supposed to be such a column.


Do you have any customisations in your /modules/addons or /includes/hooks directory that could be causing this? If so please try removing them temporarily to see if it stops the errors.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated