Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

SQL Query OK, but get empty output.
(1 viewing) (1) Guest
Flash chart component for Joomla CMS.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: SQL Query OK, but get empty output.

SQL Query OK, but get empty output. 11 years, 1 month ago #40918

Hi,
My configuration
Joomla 2.5.14
Fusion Chart 1.1.9
I have a query :
SELECT
'- 25 ans',
left(cb_sexe,1),count(left(cb_sexe,1))
FROM jos_comprofiler jcm
where left(cb_sexe,1)<>""
and (YEAR(CURRENT_DATE)-YEAR(cb_datedenaissance)) - (RIGHT(CURRENT_DATE,5)<RIGHT(cb_datedenaissance,5))<=25
group by left(cb_sexe,1)
When I launch in Fusionchart, I have this message : "SQL Query OK, but get empty output."
If i launch since phpmyadmin, the results are correct
If you need an account on my server, it's possible.
Thanks for your help.
Franck
The topic has been locked.

Re: SQL Query OK, but get empty output. 11 years ago #40929

  • jitr
  • OFFLINE
  • ARTIO Support
  • Posts: 1432
Hello, could you get us dump of this table? We will test it.
ARTIO Support Team
The topic has been locked.

Re: SQL Query OK, but get empty output. 11 years ago #40930

I send you the dump of this table.
Thanks,
Franck

File Attachment:

File Name: dump_artio.zip
File Size: 2 KB
Last Edit: 11 years ago by fsebbah. Reason: It's not possible to add sql file.
The topic has been locked.

Re: SQL Query OK, but get empty output. 10 years, 11 months ago #41353

Hi,
I never received a response ? Have you more information for me ?
The topic has been locked.

Re: SQL Query OK, but get empty output. 10 years, 8 months ago #42758

  • jitr
  • OFFLINE
  • ARTIO Support
  • Posts: 1432
Hello

We need dump of jos_comprofiler table to try it. You got us jos_artiofusioncharts only. Joomla database connector is different from PHPMyAdmin. I think that it is not problem of Fusioncharts but Joomla database connector.
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
User Login Empty