CalcBuilder Forum

Migration Issues

Usuario moon_418 2015-07-30 16:50:01

Hi,

I am migrating a site from Joomla 2.5 to 3.4 and am having some issues with my Calc Builder module.

On the old site I was running version 2.0 on the new site I am running the latest version.

Here are the links to both the old (working) module and the new broken module, the module is on the right side of the page.

Old: http://massmanngeothermal.com/index.php/services/savings-calculator
New: http://184.154.232.5/~massmann/zimmerman/index.php/services/savings-calculator

Can you please advise why the options and button aren't working.

Thanks,
--Ben

Moonsoft support 2015-07-30 19:51:02

Hi,

We can see at your new page that there are many configuration parameters not set. Please note newer version has some new parameters that must be saved for every calculator. We suggest to enter your calculator backend and save calculator and module/menu configuration in order to set default values for all the new options and try again the page.

Regards,

Usuario moon_418 2015-07-30 21:32:33

Here is what I get when I save the calculator:

Unknown column 'calculateonfly' in 'field list' SQL=UPDATE `h764t_calcbuilder_utility` SET `name`='',`code`='$Geothermal=\'\';\r\n$Electric=\'\';\r\n$gas=\'\';\r\n$oil=\'\';\r\n$propane=\'\';\r\n\r\nif ($square==\'A\'){\r\n$Geothermal=\'$568.00\';\r\n$Electric=\'$1,377.00\';\r\n$gas=\'$1,117.00\';\r\n$oil=\'$1,812.00\';\r\n$propane=\'$2,101.00\'; \r\n} elseif($square==\'B\'){\r\n$Geothermal=\'$611.00\';\r\n$Electric=\'$1,649.00\';\r\n$gas=\'$1,341.00\';\r\n$oil=\'$2,229.00\';\r\n$propane=\'$2,524.00\'; \r\n}\r\nelseif($square==\'C\'){\r\n$Geothermal=\'$682.00\';\r\n$Electric=\'$1,942.00\';\r\n$gas=\'$1,586.00\';\r\n$oil=\'$2,666.00\';\r\n$propane=\'$2,967.00\'; \r\n}\r\nelseif($square==\'D\'){\r\n$Geothermal=\'$714.00\';\r\n$Electric=\'$2,235.00\';\r\n$gas=\'$1,831.00\';\r\n$oil=\'$3,104.00\';\r\n$propane=\'$3,411.00\'; \r\n}\r\nelseif($square==\'E\'){\r\n$Geothermal=\'$1,053.00\';\r\n$Electric=\'$2,487.00\';\r\n$gas=\'$2,035.00\';\r\n$oil=\'$3,500.00\';\r\n$propane=\'$3,812.00\'; \r\n}\r\nelseif($square==\'F\'){\r\n$Geothermal=\'$1,140.00\';\r\n$Electric=\'$2,759.00\';\r\n$gas=\'$2,259.00\';\r\n$oil=\'$3,917.00\';\r\n$propane=\'$4,235.00\'; \r\n}\r\nelseif($square==\'G\'){\r\n$Geothermal=\'$1,223.00\';\r\n$Electric=\'$3,031.00\';\r\n$gas=\'$2,483.00\';\r\n$oil=\'$4,334.00\';\r\n$propane=\'$4,656.00\'; \r\n}\r\nelseif($square==\'H\'){\r\n$Geothermal=\'$1,230.00\';\r\n$Electric=\'$3,303.00\';\r\n$gas=\'$2,707.00\';\r\n$oil=\'$4,750.00\';\r\n$propane=\'$5,080.00\'; \r\n}\r\nelseif($square==\'I\'){\r\n$Geothermal=\'$1,255.00\';\r\n$Electric=\'$3,554.00\';\r\n$gas=\'$2,910.00\';\r\n$oil=\'$5,146.00\';\r\n$propane=\'$5,482.00\'; \r\n}\r\nelseif($square==\'J\'){\r\n$Geothermal=\'$1,303.00\';\r\n$Electric=\'$3,805.00\';\r\n$gas=\'$3,114.00\';\r\n$oil=\'$5,542.00\';\r\n$propane=\'$5,884.00\'; \r\n}\r\nelseif($square==\'K\'){\r\n$Geothermal=\'$1,463.00\';\r\n$Electric=\'$4,098.00\';\r\n$gas=\'$3,359.00\';\r\n$oil=\'$5,980.00\';\r\n$propane=\'$6,327.00\'; \r\n}\r\nelseif($square==\'L\'){\r\n$Geothermal=\'$1,560.00\';\r\n$Electric=\'$3,200.00\';\r\n$gas=\'$4,391.00\';\r\n$oil=\'$6,418.00\';\r\n$propane=\'$6,770.00\'; \r\n}',`info`='',`reset_button`='0',`info_img`='0',`date_frontend_format`='%d-%m-%Y',`decimal_number_format`='.',`thousand_number_format`=',',`preformhtml`='Calculate your Geothermal Savings Today!\r\nNot every house has the same heat loss per square foot. This is an example only!The costs are figured with the following utility prices:Geothermal electrical rate .06 per KWHElectric off peak rate at .06 per KWHNatural Gas at $1.00 per thermFuel oil at $3.00 per gallonPropane at $2.00 per gallon',`precalcprint`='',`poscalcprint`='',`sendemailform`='',`pdf_orientation`='0',`front_email`='0',`front_pdf`='0',`front_excel`='0',`calculateonfly`='',`resultpopup`='',`js_functions`='',`js_pre_calc_button`='',`js_reset_button`='',`js_post_calc_button`='',`js_event_code`='',`up_maxuploadfiles`='10',`up_prefix`='-1',`up_filesize`='8',`up_extensions`='',`up_mimetypes`='',`up_folder`='',`import_bootstrap`='',`datasave`='-1',`popupwidth`='250',`calculate_button_text`='Calculate',`include_input`='',`include_result`='' WHERE `id`='2'

Moonsoft support 2015-07-31 09:41:42

Hi,

This message means the database was not updated properly. You should export your calculators and uninstall component and install latest version. Than you can import your calculators.
We always suggest to make a backup before any changes on Joomla.

Regards,

Usuario moon_418 2015-08-01 02:57:16

Hi,

I have reinstalled, but don't see an export button on the Joomla 2.5, Calc Builder 2.0 version.

Can you please advise.

Thanks,
--Ben

Moonsoft support 2015-08-01 09:21:59

Hi,

Version 2.0 is pretty old but we think the export option was already there. Please double check if you see a 'save' icon next to the calculator name at the main calculator list page.

Regards,

Usuario moon_418 2015-08-01 16:21:32

Got it working! Thanks for your support!