ZuckerReports 1.10 install on SugarCRM 5.1.0

[assos40]

everytime installation stops at 84% and i get the following error

Installing Images
Installing menus
Rebuilding Menus...
Removing Sugar Dashlets cache and scanning known directories for Sugar Dashlet files.



Sugar Dashlets cache file rebuilt.Installing Relationships
Rebuilding Vardefs...
Rebuilding Layoutdefs...
Rebuilding administration Section...
Installing Language Packs
Rebuilding Language...en_us
Rebuilding Language...ge_ge
Rebuilding Language...es_es
Rebuilding Language...fr_FR
Installing Bean : ZuckerReports
Table already exists : zucker_report
Installing Bean : ZuckerReportContainer
Table already exists : zucker_reportcontainer
Installing Bean : ZuckerReportModuleLink
Table already exists : zucker_reportmodulelink
Installing Bean : ZuckerReportParameter
Error creating table: zucker_reportparameters: Query Failed:CREATE TABLE zucker_reportparameters (id char(36) NOT NULL ,deleted bool DEFAULT '0' NOT NULL ,date_entered datetime NOT NULL ,date_modified datetime NOT NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,friendly_name varchar(255) NOT NULL ,default_name varchar(255) NOT NULL ,default_value varchar(255) NULL ,range varchar(255) NOT NULL ,range_options text NULL ,description text NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci::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 varchar(255) NOT NULL ,range_options text NULL ,description text NULL ' at line 1

Any ideas please

[assos40]

any help please
Thanks

[jdolling]

any help please
Thanks

I've got the same problem. Can anyone help us? Please.

Greets
Jan

[eggsurplus]

The column "range" is a reserved word in MySQL. I'd contact the developer about this.

[genius786]

Hi,

According to me, Before trying to install ZuckerReports you could perform repair from admin tools. I think it can may be help you out



Best Regards,

[azurtec]

Hi, i experienced the same problem.

First i installed this version of zucker on a sugar 5.2 running with easyphp 2.0b without any problem (except the 5.2 manifest.php modification to make).

This time, i make the same installation, but on an easyphp3.0 platform, a,d now i get the error.

According to eggsurplus advice, what i did is unzipping the package, change every occurence of "range" by "range2" (only the needed ones, like in vardefs, etc...) and finally it works well.

[afinke]

According to eggsurplus advice, what i did is unzipping the package, change every occurence of "range" by "range2" (only the needed ones, like in vardefs, etc...) and finally it works well.

Would you happen to have a list of the files in which you changed "range" to "range2"? I tried to do the same thing, but I'm still getting the error, so I must have missed something. Thanks.

[jdolling]

Would you happen to have a list of the files in which you changed "range" to "range2"? I tried to do the same thing, but I'm still getting the error, so I must have missed something. Thanks.

Files which I have changed:

manifest.php (Version to 5.2.*)
scripts/post_install (-> all the range values)
modules/ZuckerReportParameter/vardefs.php

Installation should be completed then.

[afinke]

Thank you, that's very helpful.