Hot Property Error

[shabraken]

I started receiving this error earlier this week. I know this is an old Joomla install - could it be related to a PHP upgrade and can it be fixed?

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 8 SQL=CREATE TABLE jos_hp_temp (\n id INT(11) NOT NULL, \nname MEDIUMTEXT NOT NULL, \nPark_Name MEDIUMTEXT NOT NULL, \nadditional MEDIUMTEXT NOT NULL, \nNewhomes MEDIUMTEXT NOT NULL, \nPRIMARY KEY (id)\n) TYPE=MyISAM ;Table \'lifesty5_joom1.jos_hp_temp\' doesn\'t exist SQL=INSERT INTO jos_hp_temp (`id`, `name`) \n SELECT p.id, p.name\n FROM (jos_hp_properties AS p, jos_hp_companies AS c)\n LEFT JOIN jos_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN jos_hp_agents AS a ON p.agent = a.id\n WHERE p.published=\'1\' AND p.approved=\'1\' AND t.published=\'1\'\n AND a.company=c.id\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW())Table \'lifesty5_joom1.jos_hp_temp\' doesn\'t exist SQL=DELETE FROM jos_hp_temp WHERE Park_Name <> \'Imperial Bonita Estates\'

[imanickam]

Probably, in addition to the upgrade to PHP, MySQL also may have been upgraded. First check whether Joomla! 1.0.x supports that version of MySQL and PHP.


You may have to replace TYPE=MyISAM to ENGINE=MyISAM.

Review of the discussion http://forum.joomla.org/viewtopic.php?t=195859 would be of help.