Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Фильтрация по категориям #196

Open
rok9997 opened this issue May 19, 2021 · 0 comments
Open

Фильтрация по категориям #196

rok9997 opened this issue May 19, 2021 · 0 comments

Comments

@rok9997
Copy link

rok9997 commented May 19, 2021

Доброго времени суток.

Спасибо за модуль, но есть ошибки или я не смог настроить..

вроде вывод новостей работает, но как только включаю фильтрация по категориям , сразу получаю ошибки

Fatal error: Uncaught Exception: SafeMySQL: Illegal argument to a regular expression.. Full query: [SELECT p.id, p.autor, p.date, p.short_story, p.full_story, p.xfields, p.title, p.category, p.alt_name, p.allow_comm, p.comm_num, p.fixed, p.allow_main, p.symbol, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.related_ids, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE approve AND category regexp "[:<:][[:>:]]" AND p.date < "2021-05-19 18:17:08" ORDER BY fixed DESC, p.date DESC LIMIT 0, 10] in C:\OpenServer\domains\localhost\engine\modules\base\core\SafeMySQL.php:632 Stack trace: #0 C:\OpenServer\domains\localhost\engine\modules\base\core\SafeMySQL.php(492): SafeMySQL->error('SafeMySQL: Ille...') #1 C:\OpenServer\domains\localhost\engine\modules\base\core\SafeMySQL.php(291): SafeMySQL->rawQuery('SELECT p.id, p....') #2 C:\OpenServer\domains\localhost\engine\modules\base\blockpro.inc.php(915): SafeMySQL->getAll('SELECT ?p FROM . in C:\OpenServer\domains\localhost\engine\modules\base\core\SafeMySQL.php on line 632

  • Версия DLE: 14.2
  • Версия PHP: 7.1.33

Строка подключения с включенным параметром Фильтрация по категориям:

{include file="engine/modules/base/blockpro.php?template=blockpro/lastdate&catId=2&limit=10&sort=date"}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant