Insert Query Problem in Zucker Report

[chetanvalueone]

Hello All,

I have installed ZuckerReport, but i am going to create a new Report and Query Parameters, and i have selected Selection field as "Date Input" then its is giving me the following error while saving:

Query Failed:INSERT into zucker_reportparameters set id='5621b4e8-e8c6-a64c-a524-497459ca9ea4', deleted='0', date_entered='2009-01-19 10:43:15', date_modified='2009-01-19 10:43:15', modified_user_id='1', created_by='1', friendly_name='newTesting', default_name='newTesting', default_value='newTesting', range='DATE', description='newTesting'::MySQL error 1064: 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 'range='DATE', description='newTesting'' at line 1

but it's working fine on my local system but not working on Live Server.

my local MySQL version is: 5.0.51b
Live Server MySQL version is: 5.1.30-log

Please help me out

Thanks,
Chetan

[genius786]

Hi,

For your answer click here

Best regards,

[chetanvalueone]

Hi SARFARAZ,

Thanks for your suggestion

it is working now

Regards,
Chetan

[genius786]

Always here for your help


Best regards,