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 9 SQL=CREATE TABLE jos_hp_temp (\n id INT(11) NOT NULL, \nname MEDIUMTEXT NOT NULL, \nRegion MEDIUMTEXT NOT NULL, \nDepartement MEDIUMTEXT NOT NULL, \nEnvironnement MEDIUMTEXT NOT NULL, \nAssoposss SET(\'Oui\', \'Non\') NOT NULL, \nPRIMARY KEY (id)\n) TYPE=MyISAM ;Table \'jrconseils.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 \'jrconseils.jos_hp_temp\' doesn\'t exist SQL=DELETE FROM jos_hp_temp WHERE Region <> \'Bourgogne\'