vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   New Posting Features - Automatic Thread Tagger (https://vborg.vbsupport.ru/showthread.php?t=185495)

ThorstenA 08-11-2008 11:33 AM

With no
  • DB Changes
  • Additional Files
I'd install this mod in a second.

Phalynx 08-11-2008 11:39 AM

With no
  • DB Changes
  • Additional Files
You would not have
  • Changing automated generated tags in case of changed parameters (-> additional field that marks a tag as automated)
  • AJAX driven input method (-> additional file)
  • Cron tagging new threads in background (-> additional file)

ThorstenA 08-11-2008 11:46 AM

isn't it possible to add ajax and cron within plugins? I installed some products and they use additional ajax features. As far as I know there are also cron plugins. But I am not sure.

fredang85 08-11-2008 12:34 PM

Invalid SQL:

SELECT tagid
FROM vBull_tag
WHERE tagtext IN ('russian', 'Вообщем', 'привет', 'всем');

MySQL Error : Illegal mix of collations for operation ' IN '
Error Number : 1271

is it because of the weird language?

ThorstenA 08-11-2008 02:38 PM

Mysql collation errors are usually when there's a difference between language types of tables. You can enter there UTF, ISO formats etc.

fredang85 08-11-2008 07:48 PM

who to i rectify that?

ThorstenA 08-12-2008 05:25 AM

I am sorry to not be able to help you further. I just told you all I know about that. Try googling for mysql cllation errors and take a look into admincp > style which collation do you use (UTF / ISO) and then compare it with collations in database via phpmyadmin > whole database collation and phpmyadmin > table vbull_tag.

fredang85 08-12-2008 07:20 AM

ok thanks alot =)

Phalynx 08-12-2008 07:21 AM

Quote:

Originally Posted by ThorstenA (Post 1596170)
isn't it possible to add ajax and cron within plugins? I installed some products and they use additional ajax features. As far as I know there are also cron plugins. But I am not sure.

For sure, I can incorporate all files as plugins, but every coder should know that this blows up the plugin system unnecessary, espacially if there is so many code that has to be loaded like with this modification. On big boards this makes a huge difference compared to files that are loaded on demand.

Also, please show me the product that is using plugin crons. As far as I know you have to specify a file to execute in that part.

Quote:

Originally Posted by fredang85 (Post 1596194)
Invalid SQL:

SELECT tagid
FROM vBull_tag
WHERE tagtext IN ('russian', 'Вообщем', 'привет', 'всем');

MySQL Error : Illegal mix of collations for operation ' IN '
Error Number : 1271

is it because of the weird language?

That is something I cannot help you with. Just don't use russian and english words... That error is causing in the vBulletin function called "insert_tags_thread" in file "functions_newpost.php". Auto Thread Tagger is also using such a file.

freecodevn 08-12-2008 08:28 AM

Power full for me this mod, that all what i want.
Thanks alot Phalynx lv


All times are GMT. The time now is 09:14 PM.

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.01422 seconds
  • Memory Usage 1,735KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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