vb.org Archive - Major Additions - [DBTech] DragonByte SEO v2 (vB4)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Major Additions - [DBTech] DragonByte SEO v2 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=308615)

Greetings Support,

Does DBSeo Pro automatically create 301 redirects for threads/posts when forums/sub forums are merged/moved? I'm looking to combine some low traffic/low activity sub forums back up into the parent forum, and need to take into account the old URLs.

Thanks!

This is something that vB does automatically.

If you link thread, it doesn't matter in what forum it is. vB will link it where it is (if it is still available). That goes to posts also, if you link post #, it doesn't matter in what thread (and forum) it is, vB will link to that post.

Is the dragonbyte-tech website down? I have not been able to access it for 2 days. I had a bug to report, but when I tried to submit, the site went down, and has not been back up since. The bug is as follows:

---
When the config dbtech_dbseo_filter_nonlatin_chars is not 1, conversions of character groups such as eu or ss can lead to database errors if a slash is placed before the group. It may also be able to craft a request that will trigger a similar error if the setting is 1, but I think it is harder.

Here is an example database error I received in my email:

Code:

Invalid SQL:

SELECT tagtext AS id FROM forum_tag WHERE tagtext REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*[(&[\#\da-z]*;|[^a-z\d])*[i?ŒÍ?ŽÏì?+îï]m/[e?ˆ?‰?Š?‹èéêë]([u?™?š?›?œùúûüµ]|u|?†|æ)rg](&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$" ORDER BY LENGTH(tagtext) LIMIT 1;



MySQL Error   : Got error 'unmatched parentheses at offset 63' from regexp

Error Number  : 1139

Request Date  : Tuesday, April 4th 2017 @ 02:32:37 PM

Error Date    : Tuesday, April 4th 2017 @ 02:32:37 PM

Script        : http://www.vaultwiki.org/tags/[-im/eurg]/

Referrer      : 

IP Address    : [redacted]

Username      : N/A

Classname     : vBulletinDatabase_MySQLi

MySQL Version : 

Server        : ::ffff:199.167.148.228

User Agent    : 





Stack Trace:



#0 DBSEO_Database->halt() called in [path]/dbtech/dbseo/includes/class_db.php on line 910

#1 DBSEO_Database_MySQLi->execute_query() called in [path]/dbtech/dbseo/includes/class_db.php on line 304

#2 DBSEO_Database->query_read_slave() called in [path]/dbtech/dbseo/includes/class_db.php on line 779

#3 DBSEO_Database->generalQuery() called in [path]/dbtech/dbseo/includes/filter.php on line 958

#4 DBSEO_Filter::reverseObject() called in [path]/dbtech/dbseo/includes/rewrite/tag/single.php on line 27

#5 DBSEO_Rewrite_Tag_Single::resolveUrl() called in [path]/dbtech/dbseo/includes/url.php on line 967

#6 DBSEO_Url::resolve() called in [path]/dbtech/dbseo/includes/url.php on line 579

#7 DBSEO_Url::lookup() called in [path]/dbseo.php on line 159

The URL doesn't point to a valid tag, but the expected behavior here is no database error. I was able to resolve these errors on my site by making sure the regular expression is tested before it goes through MySQL. In dbtech/dbseo/includes/filter.php find:

Code:

                        $title3 = self::unFilterText(htmlspecialchars(self::$config['dbtech_dbseo_rewrite_separator'] . str_replace(' ', self::$config['dbtech_dbseo_rewrite_separator'], $title) . self::$config['dbtech_dbseo_rewrite_separator']), true);

After it, add:

Code:

                        if (!@preg_match('/' . $title2 . '/', $title, $m) OR !@preg_match('/' . $title3 . '/', $title, $m))

                        {

                                return false;

                        }

Basically this code change means that if we were not able to generate a valid regex or the regex does not actually match what it was intended to match, the reverse lookup should fail.

Quote:

Originally Posted by thincom2000 (Post 2584867)

Is the dragonbyte-tech website down? I have not been able to access it for 2 days. I had a bug to report, but when I tried to submit, the site went down, and has not been back up since.

That might be an overzealous mod_security rule, can you please provide me with your IP address so I can investigate?

Fillip

Quote:

Originally Posted by thincom2000 (Post 2584867)

When the config dbtech_dbseo_filter_nonlatin_chars is not 1, conversions of character groups such as eu or ss can lead to database errors if a slash is placed before the group. It may also be able to craft a request that will trigger a similar error if the setting is 1, but I think it is harder.

[...]

I've implemented your fix in my local dev version and put it up @ DBTech for some dogfood testing for a bit until I release an update, thank you :)

Fillip

help please

in url: "dise?o" > /forum/dise-o-de-interfaces/

solution for ??

PHP Code:


		
			
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />

Code:

ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Quote:

Originally Posted by RaYdeN.ADM (Post 2586570)

help please

in url: "dise?o" > /forum/dise-o-de-interfaces/

solution for ??

PHP Code:


		
			
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />

Code:

ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Anyone who can help me solve my problem with the url that they carry ?, ?, ?, ?, ? and ??.

please! :(

You can always report issue on DBTech's site. They respond there sooner.

Quote:

Originally Posted by RaYdeN.ADM (Post 2586773)

Anyone who can help me solve my problem with the url that they carry ?, ?, ?, ?, ? and ??.

please! :(

Have you tried turning UTF-8 on in the settings?

Fillip

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02316 seconds Memory Usage 1,756KB 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 (5)bbcode_code_printable (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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
Messages: