2. PHPRunner General questions
  3. [SOLVED]  Phpr6.2 Enterprise - Bug Report Chart - Sql Query Problems
This topic is locked
[SOLVED]

 Phpr6.2 Enterprise - Bug Report Chart - Sql Query Problems

 		4/16/2013 8:16:55 AM
PHPRunner General questions
ffrinai author

Hi,

with Phprunner enterprise 6.2 build 15275

when i create a new chart with Web Reports after table select, the query have a sintax error.

with the table po this is the query created:
SELECT

po.idpo AS ,

po.iduo AS ,

po.podesc AS

FROM po
and the error in view results is
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 ' po.iduo AS , po.podesc AS FROM po LIMIT 50' at line 2
after the AS clause no name is specified !!
is the same with every other table.

is there a solution ?

thanks
Sergey Kornilov admin 4/16/2013

My guess is that you need to remove those AS keywords:

SELECT

`idpo`,

`iduo`,

`podesc`

FROM `po`
ffrinai author 4/17/2013



My guess is that you need to remove those AS keywords:

SELECT

`idpo`,

`iduo`,

`podesc`

FROM `po`



ok, but how ? this query is automatic created by wizard and i can't modify it
Sergey Kornilov admin 4/17/2013

You can edit SQL Query on 'SQL Query' screen in PHPRunner.
ffrinai author 4/18/2013



You can edit SQL Query on 'SQL Query' screen in PHPRunner.


I'm working with web reports and I can't modifiy the Query SQL but only see it
Sergey Kornilov admin 4/18/2013

I would ask you to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. We would also need instructions on reproducing the issue.
ffrinai author 4/19/2013



I would ask you to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. We would also need instructions on reproducing the issue.


I upload the project in Demo account and the ticket number is 288674

thanks
Sergey Kornilov admin 4/19/2013

Thanks, we have asked for some additional info.