No valid database connection CREATE VIEW command denied to user 'elia_joomla'@'localhost' for table 'jos_booking_template_value_view' SQL=CREATE VIEW `jos_booking_template_value_view` AS
SELECT `value`.`id` AS `id`,`translation`.`language_id` AS `language`,`translation`.`value` AS `value`
FROM (
`jos_booking_template_value` `value`
LEFT JOIN `jos_jf_content` `translation` ON ((`translation`.`reference_id` = `value`.`id`))
)
WHERE
(
(`translation`.`reference_table` = 'booking_template_value')
AND
(`translation`.`reference_field` = 'value')
); No valid database connection 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 ') ORDER BY `sbj`.`publish_up` DESC' at line 1 SQL=SELECT `sbj`.`id`, COALESCE(`jfTitle`.`value`, `sbj`.`title`) AS `title`, `sbj`.`alias`, `sbj`.`template`, CONCAT(COALESCE(`jfIntrotext`.`value`, `sbj`.`introtext`)," ", COALESCE(`jfFulltext`.`value`, `sbj`.`fulltext`)) AS `text` FROM `jos_booking_subject` AS `sbj` LEFT JOIN `jos_booking_template_2` AS `tmpl1` ON `tmpl1`.`id` = `sbj`.`id` LEFT JOIN `jos_booking_template_3` AS `tmpl2` ON `tmpl2`.`id` = `sbj`.`id` LEFT JOIN `jos_jf_content` AS `jfTitle` ON `jfTitle`.`language_id` = 1 AND `jfTitle`.`reference_table` = "booking_subject" AND `jfTitle`.`reference_field` = "title" AND `jfTitle`.`reference_id` = `sbj`.`id` AND `jfTitle`.`published` = 1 LEFT JOIN `jos_jf_content` AS `jfIntrotext` ON `jfIntrotext`.`language_id` = 1 AND `jfIntrotext`.`reference_table` = "booking_subject" AND `jfIntrotext`.`reference_field` = "introtext" AND `jfIntrotext`.`reference_id` = `sbj`.`id` AND `jfIntrotext`.`published` = 1 LEFT JOIN `jos_jf_content` AS `jfFulltext` ON `jfFulltext`.`language_id` = 1 AND `jfFulltext`.`reference_table` = "booking_subject" AND `jfFulltext`.`reference_field` = "fulltext" AND `jfFulltext`.`reference_id` = `sbj`.`id` AND `jfFulltext`.`published` = 1 WHERE `sbj`.`state` = 1 AND `sbj`.`access` IN (0) AND (`sbj`.`publish_up` <= '2019-04-01 03:32:02' OR `sbj`.`publish_up` = '0000-00-00 00:00:00') AND (`sbj`.`publish_down` >= '2019-04-01 03:32:02' OR `sbj`.`publish_down` = '0000-00-00 00:00:00') AND () ORDER BY `sbj`.`publish_up` DESC
Warning: Invalid argument supplied for foreach() in /home/elia/public_html/hotel/crete/plugins/search/booking.php on line 227