Guriddo » Topic: Valid MySQL query producing errors in Suito PHP

Valid MySQL query producing errors in Suito PHP

Guriddo
Valid MySQL query producing errors in Suito PHP

This topic has 1 reply, 2 voices, and was last updated 7 years, 7 months ago by guriddo.support.

Creator

Topic

January 23, 2017 at 2:30 pm #125776

bogdanm

Participant

I have the following SelectCommand:

$grid->SelectCommand = 'SELECT
  liquidityid,
  month,
  depreciation,
  ROUND(IFNULL((SELECT SUM(invoiceamount/IF(invoicecurrency="EUR",1,rate2eur)) FROM subscriptions WHERE expirationdate>=CURDATE())/12, 0), 0) AS subs,
  reserves
FROM liquidity';

$grid->SelectCommand = 'SELECT

liquidityid,

month,

depreciation,

ROUND(IFNULL((SELECT SUM(invoiceamount/IF(invoicecurrency="EUR",1,rate2eur)) FROM subscriptions WHERE expirationdate>=CURDATE())/12, 0), 0) AS subs,

reserves

FROM liquidity';

If I run it in Phpmyadmin, it works correctly:

But in jqGrid (PHP), it throws the following error:
jqGrid error

I have used Select commands nested in the SelectCommand statement before and it worked fine. I can’t figure out what the problem is.

Creator

Topic

Viewing 1 replies (of 1 total)

Author

Replies
January 24, 2017 at 11:07 am #125779

guriddo.support
Participant

Hello,

It is very difficult to say where the problem is.

This can be white space or maybe variable which is used into the script , but you have not publish it.

Please post you full PHP jqGrid code with includes variables and etc, so that we can see what is happen.

If it is not possible to publish it here, please send it to the support.

Kind Regards,

Will

Guriddo Support Team
Author

Replies