Search nonfunctional

News for this website will be posted here. Mostly Technical.
Forum rules
This forum is for technical discussion regarding the portal and vore itself.

Generally speaking, if you have something that needs moderator attention, you should simply Private message Eka. That includes any bug report, error report, violation report, outage report, suggestion, feature request. Etc.

Most topics will be locked as soon as they are acknowledged. Due to the nature that not many people can do anything regarding a technical issue. In that case, if you need something unlocked for any reason. Feel free to message Eka directly.

Search nonfunctional

Postby MysteryFuto » Tue Dec 10, 2019 6:26 pm

For the past three or four days, literally every time I've tried to use gallery search, without exception, I've gotten this:
Uncaught Exception

exception 'SqlException' in /home/aryion/public_html/g4/lib/sql.php:33
Stack trace:
#0 /home/aryion/public_html/g4/lib/sql.php(41): sql_query('SET STATEMENT m...')
#1 /home/aryion/public_html/g4/lib/libsql.php(188): sql_fetch('SET STATEMENT m...', 2)
#2 /home/aryion/public_html/g4/lib/libpagination.php(72): sql_fetch_value('SET STATEMENT m...')
#3 /home/aryion/public_html/g4/lib/libpagination.php(55): ItemPagination->_calculateTotalItemCount('item JOIN guser...', 'item.type = 'It...', NULL, NULL)
#4 /home/aryion/public_html/g4/search.php(139): ItemPagination->fetchPaginatedItems('item.item_id, i...', 'item JOIN guser...', 'item.type = 'It...', 'ctime DESC', 'ctime', 'DESC')
#5 {main}
Query execution was interrupted (max_statement_time exceeded) :: (SET STATEMENT max_statement_time=3 FOR SELECT COUNT(*) FROM item JOIN gusers ON (item.user_id = gusers.user_id) WHERE item.type = 'Item' AND (item.view_perm IN ('ALL','USER') OR (item.view_perm = 'SELF' AND item.user_id = 67801)) AND (description LIKE '%touhou%' OR title LIKE '%touhou%')


Refreshing and trying again later both don't work at all.
User avatar
MysteryFuto
Been posting for a bit
 
Posts: 24
Joined: Sat Sep 26, 2015 11:57 pm

Re: Search nonfunctional

Postby sovet » Tue Dec 10, 2019 7:15 pm

Same exact error as you, except on line 4 it says (121)
User avatar
sovet
Somewhat familiar
 
Posts: 74
Joined: Mon May 30, 2011 10:32 pm

Re: Search nonfunctional

Postby EnderDracolich » Tue Dec 10, 2019 7:21 pm

Same here. Never had this error before, either. Seems to be a new problem.
User avatar
EnderDracolich
Advanced Vorarephile
 
Posts: 665
Joined: Sun Aug 20, 2017 8:58 pm
Location: Nagaloka

Re: Search nonfunctional

Postby Eka » Tue Dec 10, 2019 8:09 pm

Just try again later when the site is less busy.
User avatar
Eka
Administrator
 
Posts: 4492
Joined: Fri May 13, 2005 10:59 pm
Location: Canada


Return to Technical stuff

Who is online

Users browsing this forum: No registered users