Thread: Show Thread Enhancements - Yilmaz - Similar Threads vB5
View Single Post
  #18  
Old 02-28-2021, 06:08 PM
milforum milforum is offline
 
Join Date: Nov 2019
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It works fine for me, but I now and then get database errors. One example below:

Database error in vBulletin 5.6.4:

Invalid SQL:
SELECT tagnode.nodeid as tagnodeid, node.iconid, node.prefixid, node.nodeid as nodeidsi, node.title as konubasligi, node.lastcontentid, node.parentid, node.textcount, node.totalcount, icon.iconpath, icon.title as icontitle, closure.parent as forumidesi, closure.depth, forum.title as forumtitle, node.authorname
FROM tag AS tag
LEFT JOIN tagnode AS tagnode ON (tagnode.tagid = tag.tagid)
LEFT JOIN node AS node ON (node.nodeid = tagnode.nodeid)
LEFT JOIN closure AS closure ON (closure.child = node.nodeid)
LEFT JOIN node AS forum ON (forum.nodeid = closure.parent)
LEFT JOIN user AS user ON (user.userid = node.lastauthorid)
LEFT JOIN icon AS icon ON (icon.iconid = node.iconid)
WHERE ()
AND closure.depth = 1
AND node.title !=''
AND node.inlist = 1
AND tagnode.nodeid != '15615'
AND tagnode.nodeid = node.starter
GROUP BY tagnode.nodeid
ORDER BY tagnode.nodeid DESC
LIMIT 10;

MySQL Error : 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 ')
AND closure.depth = 1
AND node.title !=''
AND node.inlist = 1
AND tagnod...' at line 9
Error Number : 1064
Request Date : Sunday, February 28th 2021 @ 08:22:04 PM
Error Date : Sunday, February 28th 2021 @ 08:22:04 PM
Script : https://xxx.yyy/node/15615
Referrer :
IP Address : 99999999999
Username : <i>Gjest</i>
Classname : vB_Database_MySQLi
MySQL Version :


Stack Trace:
#0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1214
#1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249
#2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 583
#3 vB_Database->query_read() called in [path]/packages/yilmazsimilarthreads/api/template.php on line 69
#4 YilmazSimilarThreads_Api_Template::fetchBulk() called in phar://[path]/vb/vb.phar/api/wrapper.php on line 223
#5 vB_Api_Wrapper->__call() called in /home/xxxxx/public_html/includes/api/interface/collapsed.php on line 105
#6 Api_Interface_Collapsed->callApi() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 224
#7 vB5_Template_Cache->fetchTemplate() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 110
#8 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#9 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 134
#10 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#11 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 134
#12 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#13 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 134
#14 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#15 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 134
#16 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#17 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 134
#18 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#19 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/frontend/controller/page.php on line 275
#20 vB5_Frontend_Controller_Page->index() called in /home/xxxxx/public_html/index.php on line 75
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01274 seconds
  • Memory Usage 1,786KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete