Go Back   Mosets Community > Archives > Mosets Hot Property 1.0 > Discussions, Troubleshooting and Problems

Thread Tools Search this Thread Display Modes
Old 01-23-2013, 07:55 AM
johnlanglois johnlanglois is offline
Join Date: Sep 2011
Posts: 32
Default Generate Report Error

We have upgraded to PHP 5.3 and are now getting the following error when we generate a report:
"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 'TYPE=MyISAM' at line 5 SQL=CREATE TABLE jos_hp_temp2 ( id INT(11) NOT NULL, name MEDIUMTEXT NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM ;Table 'berrylan_berrylandco2.jos_hp_temp2' doesn't exist SQL=INSERT INTO jos_hp_temp2 (`id`, `name`) SELECT p.id, p.name FROM (jos_hp_properties AS p, jos_hp_companies AS c) LEFT JOIN jos_hp_prop_types AS t ON p.type = t.id LEFT JOIN jos_hp_agents AS a ON p.agent = a.id WHERE a.company=c.idTable 'berrylan_berrylandco2.jos_hp_temp2' doesn't exist SQL=SELECT count(*) FROM jos_hp_temp2 "
Please advise.
Thank you.
Old 04-19-2013, 01:36 AM
johnlanglois johnlanglois is offline
Join Date: Sep 2011
Posts: 32

Well, since support never bothered to reply to this, I thought I would post the solution for the next pilgrim to come this way.

Find the file named view.html.php in the folder administrator/components/com_hotproperty/views/report/view.html.php

Around line 92 you should see $sql .= "\nPRIMARY KEY (id)"
. "\n) TYPE=MyISAM ;"
Change it to read $sql .= "\nPRIMARY KEY (id)"
. "\n) ENGINE=MyISAM ;"
Save and refresh and things will work.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Generate report daisysmom Discussions, Troubleshooting and Problems 1 09-26-2012 01:20 AM
Add field to Generate Report les Hot Property 1.0 Tips and Tricks 0 07-21-2009 09:24 PM

All times are GMT +8. The time now is 11:51 PM.

Copyright © 2005-2010 Mosets Consulting

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.