search

thorsten / phpMyFAQ

phpMyFAQ - Open Source FAQ web application for PHP 8.1+ and MySQL, PostgreSQL and other databases
https://www.phpmyfaq.de
Mozilla Public License 2.0
585 stars 254 forks source link

4.0 Error when trying to Access the sitemap #3043

Closed c1972 closed 3 months ago

c1972 commented 3 months ago

No matter where I currently access the sitemap from, the following error message appears at the top of the screen:

sitemap-fehler

string(1013) " SELECT fd.thema AS thema, fd.id AS id, fd.lang AS lang, fcr.category_id AS category_id, fd.content AS snap FROM faqcategoryrelations fcr, faqdata fd LEFT JOIN faqdata_group AS fdg ON fd.id = fdg.record_id LEFT JOIN faqdata_user AS fdu ON fd.id = fdu.record_id WHERE fd.id = fcr.record_id AND SUBSTRING(fd.thema, 1, 1) = 'A' AND fd.lang = 'de' AND fd.active = 'yes' AND ( fdu.user_id = 1 OR fdu.user_id = -1 )" NULL

The sitemap link refers to: https://cc10.de/sitemap/A/de.html

Site: cc10.de OS: Windows 11 Pro 23H2 Browser: Chrome 126.0.6478.127 phpMyFAQ Version: 4.0 PHP-Version: 8.2 Database: MariaDB 10.11.4 Elasticsearch: No

Regards Christian

thorsten commented 3 months ago

@c1972 I cannot reproduce this error. The sitemap and the XML sitemap are different things.

c1972 commented 3 months ago

This error can be reproduced in 4.0 ! And on a fresh installed system.

siemap-error

It's just a click on the Sitemap link in the footer (https://cc10.de/sitemap/A/de.html).

(You are right: it was misleading to mention the XML-Sitemap which isn't affected in this case.)