neptuo / is4wfw

PHP based CMS with multi domain support, virtual file system, library for team-sport fixtures and statistics, and many other features.
http://is4wfw.neptuo.com
Apache License 2.0
1 stars 0 forks source link

Fix projects without any page #506

Closed maraf closed 1 year ago

maraf commented 1 year ago

Web::loadPageData should be loaded only when project content includes <web:content />.

An exception of type 'DataAccessException' has occured. 
ErrorCode = 1064, 
ErrorMessage = 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 ') AND p.`wp` = 9' at line 1, 
Sql = SELECT p.`id`, i.`name`, i.`href`, i.`in_title`, i.`keywords`, i.`title`, i.`timestamp`, i.`cachetime`, IFNULL(c.`tag_lib_start`, cd.`tag_lib_start`) AS `tag_lib_start`, IFNULL(c.`tag_lib_end`, cd.`tag_lib_end`) AS `tag_lib_end`, IFNULL(c.`head`, cd.`head`) AS `head`, IFNULL(c.`content`, cd.`content`) AS `content` FROM `page` p LEFT JOIN `info` i ON p.`id` = i.`page_id` LEFT JOIN `content` c ON p.`id` = c.`page_id` AND c.`language_id` = 1 LEFT JOIN `content` cd ON p.`id` = cd.`page_id` AND cd.`language_id` = (SELECT `id` FROM `language` WHERE `language` = '') WHERE i.`is_visible` = 1 AND i.`language_id` = 1 AND p.`id` IN () AND p.`wp` = 9;
#0 /var/www/html/app/scripts/php/classes/dataaccess/DataAccess.class.php(240): DataAccess->tryToProcessError('SELECT p.`id`, ...')
#1 /var/www/html/app/scripts/php/libs/Database.class.php(123): DataAccess->fetchAll('SELECT p.`id`, ...', false, false, false, false)
#2 /var/www/html/app/scripts/php/libs/Web.class.php(423): Database->fetchAll('SELECT p.`id`, ...')
#3 /var/www/html/app/scripts/php/libs/Web.class.php(347): Web->loadPageData()
#4 /var/www/html/app/scripts/php/libs/Web.class.php(251): Web->processRequestExecute()
#5 /var/www/html/app/scripts/php/libs/Error.class.php(37): Web->{closure}()
#6 /var/www/html/app/scripts/php/libs/Web.class.php(250): php\libs\Error->boundary(Object(Closure), 'processRequest')
#7 /var/www/html/app/index.php(30): Web->processRequestNG()
#8 {main}