Jump to content

Sql error


virgo83x

Recommended Posts

Hi, I have two problems with the latest configuration of WHMCS, the first problem is: SQL Error: Unknown column 'important' in 'where clause' - Full Query: SELECT tblnotes. *, (SELECT CONCAT (firstname, '', lastname) tbladmins FROM WHERE = tbladmins.id tblnotes.adminid) AS adminuser tblnotes FROM WHERE userid = '15 'AND important = '1' ORDER BY `modified` DESC.

The second is:

SQL Error: You have an error in your SQL syntax; check the manual That corresponds to your MySQL server version for the right syntax to use near 'SELECT (SELECT COUNT (*) FROM WHERE userid = tblhosting tblclients.id domainsta AND' at line 1 - Full Query: SELECT * FROM SELECT (SELECT COUNT (*) FROM WHERE userid = tblhosting tblclients.id domainstatus AND IN ('Active', 'Suspended')) + (SELECT COUNT (*) FROM tblhostingaddons hostingid WHERE IN (SELECT tblhosting id FROM WHERE userid = tblclients.id) AND status IN ('Active', 'Suspended')) + (SELECT COUNT (*) FROM WHERE userid = tbldomains tblclients.id AND status IN ('Active')) AS FROM activeservices tblclients WHERE tblclients.id = 14 LIMIT 1

In particular, these errors do not send the email with a summary of the data acquired, while the other occurs email notification will be sent.

This problem occurs only with the pay packages, the free packages are ok.

how can I fix this?

Link to comment
Share on other sites

Hello, thanks for the reply, I found a post that says that for the first error, you need to download a patch that provides me with WHMCS for the second aggirnamento that there should be a system that solves the problem.

 

Here is the post: http://forum.whmcs.com/showthread.php?64991-Multiple-MYSQL-errors-in-log&highlight=sql+error

 

I also requested support through a ticket but still have not been answered

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.

Guest
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