Jump to content



Recommended Posts

So I have tried changing the cont. in the db to 0 (archiving_on) nothing, this error still pops up and is providing a headache. I turned on archiving and not well, it just doesn't want to query (maybe its because we use MariaDB). 


SELECT COUNT(*) FROM `forums_topics` WHERE topic_archive_status!=3 AND last_post<1445912244 AND pinned='0' AND featured='0' AND !(posts'')
IPS\Db\Exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?)' at line 1 (1064)
#0 /home/****/public_html/system/Db/Select.php(346): IPS\_Db->preparedQuery('SELECT COUNT(*)...', Array)
#1 /home/****/public_html/system/Db/Select.php(402): IPS\Db\_Select->runQuery()
#2 /home/****/public_html/system/Db/Select.php(329): IPS\Db\_Select->rewind()
#3 /home/****/public_html/applications/forums/modules/admin/forums/settings.php(74): IPS\Db\_Select->first()
#4 [internal function]: IPS\forums\modules\admin\forums\_settings->manageArchiving()
#5 /home/****/public_html/applications/forums/modules/admin/forums/settings.php(47): call_user_func(Array)
#6 /home/****/public_html/system/Dispatcher/Controller.php(94): IPS\forums\modules\admin\forums\_settings->manage()
#7 /home/****/public_html/system/Dispatcher/Dispatcher.php(129): IPS\Dispatcher\_Controller->execute()
#8 /home/****/public_html/****/index.php(13): IPS\_Dispatcher->run()
#9 {main}

Any ideas would be very helpful ^_^ 

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...