vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 5.x Products & Extensions (https://vborg.vbsupport.ru/forumdisplay.php?f=258)
-   -   Major Additions - Yilmaz - Automatic Topic Tagger vB5 (https://vborg.vbsupport.ru/showthread.php?t=328256)

milforum 02-21-2021 06:39 PM

Quote:

Originally Posted by yilmaz (Post 2606389)
I updated the version again.
No issues left in version 1.1.4

Thanks, but actually I think you have the wrong zip-file here; it's the one for hiding text from guests.

yilmaz 02-21-2021 06:47 PM

Quote:

Originally Posted by milforum (Post 2606393)
Thanks, but actually I think you have the wrong zip-file here; it's the one for hiding text from guests.

Sorry, now I've uploaded the correct one. :p

milforum 02-21-2021 07:47 PM

Thanks a lot. It seems to work now. I'll check in tomorrow.

milforum 02-22-2021 04:05 PM

Some more information: It worked to a certain point, but then there were many threads that it didn't manage to tag. When I changed in AdminCP -> Tagging Options and set it to run as Super Moderator it worked, since many of the threads in question were in hidden sub-forums. From some point earlier today all that is logged is "Tags are not added", which is good.

However, some new public threads have been created today, and these have not been tagged, even though it's been a few hours and the autotagger still runs. Is there a setting somewhere that stops it from tagging new threads?

yilmaz 02-22-2021 04:28 PM

Quote:

Originally Posted by milforum (Post 2606417)
Some more information: It worked to a certain point, but then there were many threads that it didn't manage to tag. When I changed in AdminCP -> Tagging Options and set it to run as Super Moderator it worked, since many of the threads in question were in hidden sub-forums. From some point earlier today all that is logged is "Tags are not added", which is good.

However, some new public threads have been created today, and these have not been tagged, even though it's been a few hours and the autotagger still runs. Is there a setting somewhere that stops it from tagging new threads?

That the problem was fixed with a small change.

Upload files back to FTP, nothing else is needed.

milforum 02-23-2021 07:29 AM

Maybe I did something wrong, because I uploaded the files and also did the add/import XML again. Now it tries to tag a lot of old threads over and over again, but without success. I have set tagging to be done using Super Moderator privileges, but to no avail.

milforum 02-23-2021 11:34 AM

I just found that I get a lot of database errors, one every few minutes. One example below (slightly redacted with xxx):

Invalid SQL:
SELECT * FROM node WHERE nodeid = ORDER BY created DESC LIMIT 0,1;

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 'ORDER BY created DESC LIMIT 0,1' at line 1
Error Number : 1064
Request Date : Tuesday, February 23rd 2021 @ 09:23:44 AM
Error Date : Tuesday, February 23rd 2021 @ 09:23:44 AM
Script : https://xxx/create-content/loadnewposts
Referrer : https://xxx/node/18353/page2
IP Address : xxx
Username : xxx
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 627
#3 vB_Database->query_first() called in [path]/packages/yilmazsimilarthreads/api/template.php on line 33
#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/xxx/public_html/includes/api/interface/collapsed.php on line 105
#6 Api_Interface_Collapsed->callApi() called in /home/xxx/public_html/includes/vb5/template/cache.php on line 224
#7 vB5_Template_Cache->fetchTemplate() called in /home/xxx/public_html/includes/vb5/template/cache.php on line 110
#8 vB5_Template_Cache->replacePlaceholders() called in /home/xxx/public_html/includes/vb5/template.php on line 421
#9 vB5_Template->render() called in /home/xxx/public_html/includes/vb5/frontend/controller/createcontent.php on line 2442
#10 vB5_Frontend_Controller_CreateContent->renderSinglePostTemplate() called in /home/xxx/public_html/includes/vb5/frontend/controller/createcontent.php on line 2246
#11 vB5_Frontend_Controller_CreateContent->actionLoadNewPosts() called in /home/xxx/public_html/index.php on line 75

yilmaz 02-23-2021 12:18 PM

Quote:

Originally Posted by milforum (Post 2606432)
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 'ORDER BY created DESC LIMIT 0,1' at line 1

Judging by the mysql error, the files belong to the old version.

https://vborg.vbsupport.ru/showthread.php?t=328436

webnsn 05-02-2021 03:47 PM

Will it work for 3.8 version?

And what happens to already old tags ?

dorans 05-27-2023 07:45 PM

Too bad, it works on 5.7.4 and PHP 8.26 but I turned it off.
It automatically created tags from all moderator topics, for example with message reports, so that in similar topics there is "xxx reported a message" ...
Can this be resolved?


All times are GMT. The time now is 02:35 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01113 seconds
  • Memory Usage 1,741KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete