Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
bpendleton Posted April 27, 2016 Posted April 27, 2016 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.