vb.org Archive

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)

Cla75 11-13-2014 01:48 PM

Hi support,
I have a problem ...

One of my user has registered this nickname: @lex

when you click on his nickname to enter the profile, I get an error because SEO automatically removes the "@" in ALL link, ... and only "lex"

for example:

http://www.xxxxxx.com/members/lex.html

or

http://www.xxxxx.com/area-privata-fv...-progetti-con-lex/

How can I fix this?
thanks

DreadsUK 11-13-2014 03:00 PM

i am currently using pro v1.1.5 how do i upgrade?

migratoria 11-13-2014 04:50 PM

Arrowchat or Cometchat Plugin do not work with dbseo.
The chat is not invoked

Is there a solution?

brandondrury 11-15-2014 01:58 PM

I'm not sure if this is the right place, but I'm absolutely THRILLED with dbseo! I thought I was going to be in some trouble when vbseo went downhill, but dbseo came in and saved the day. I put 'em through a bit too much support hassle and they took it like champs. Excellent product! I sprung for the paid version because I needed custom URLs for just about everthing.

Brandon

dorans 11-17-2014 10:36 AM

Quote:

Originally Posted by dorans (Post 2522093)
Topics that have the title ":, *," etc.
the real problem with the query and the collapse of the base.
Other working properly but the number of errors enormous.
Frivolous is that nobody answers after so many days.


The solution to my problem, maybe some help.

Code:

That means that you haven't added .htaccess rewrites for the old vB4 mod_rewrite friendly URLs, and DBSEO is trying to resolve this as a user account.

Try adding this above your DBSEO rewrite rules in .htaccess:

Code:

RewriteRule ^threads/.* showthread.php [QSA]
http://www.dragonbyte-tech.com/f241/...835/#post87446

DragonByte Tech 11-17-2014 03:56 PM

DragonByte SEO v1.3.1

New Features:

Thread Prefix URLs
  • Forum Prefix URLs
  • (Pro) Custom Forum Prefix URLs
  • Forum Prefix (Paged) URLs
  • (Pro) Custom Forum Prefix (Paged) URLs

Bug Fixes:
  • In some cases, Quick Edit could fail to load correctly
  • MySQLi database connection issues should now display the correct error message


Fillip

Cla75 11-17-2014 04:03 PM

Quote:

Originally Posted by Cla75 (Post 2522531)
Hi support,
I have a problem ...

One of my user has registered this nickname: @lex

when you click on his nickname to enter the profile, I get an error because SEO automatically removes the "@" in ALL link, ... and only "lex"

for example:

http://www.xxxxxx.com/members/lex.html

or

http://www.xxxxx.com/area-privata-fv...-progetti-con-lex/

How can I fix this?
thanks

sorry, you have the solution ?
thanks for support

DragonByte Tech 11-17-2014 04:26 PM

Quote:

Originally Posted by Cla75 (Post 2522531)
Hi support,
I have a problem ...

One of my user has registered this nickname: @lex

when you click on his nickname to enter the profile, I get an error because SEO automatically removes the "@" in ALL link, ... and only "lex"

for example:

http://www.xxxxxx.com/members/lex.html

or

http://www.xxxxx.com/area-privata-fv...-progetti-con-lex/

How can I fix this?
thanks

Change your URL format to include the User ID :)

Quote:

Originally Posted by DreadsUK (Post 2522547)
i am currently using pro v1.1.5 how do i upgrade?

Same way you installed the mod in the first place, but you don't have to make any .htaccess edits :)

Quote:

Originally Posted by migratoria (Post 2522562)
Arrowchat or Cometchat Plugin do not work with dbseo.
The chat is not invoked

Is there a solution?

I'm not sure if that's something I'm able to assist with, as we can't guarantee compatibility with 3rd party modifications.


Fillip

Cla75 11-17-2014 08:00 PM

Quote:

Originally Posted by DragonByte Tech (Post 2523153)
Change your URL format to include the User ID :)
Fillip

I had thought, but I was hoping you could do accept the "@" in all the links.
in other link, where in the title the "@" and is removed!
thanks

Brandon Sheley 11-17-2014 08:07 PM

Quote:

Originally Posted by Cla75 (Post 2523177)
I do not understand, how can I do?
thanks

db admin > Member Profile URL > members/[user_id].html

Cla75 11-17-2014 08:13 PM

sorry I corrected my question / request ...

I had thought, but I was hoping you could do accept the "@" in all the links.
in other link, where in the title the "@" and is removed!
thanks

Teascu Dorin 11-21-2014 02:26 PM

After upgrade to v1.3.2 from dbtech site, I get an error on posting new thread:

Fatal error: require(): Failed opening required '/home/........../html/forum/dbtech/dbseo_pro/hooks/forumdata_start.php' (include_path='.:/usr/local/php5_4/lib/php') in /home........./html/forum/includes/class_dm_forum.php(123) : eval()'d code on line 7

The error appears also on thread or post edit saving, even in ACP thread/post approval window!

P.S. I use the lite version.

dorans 11-21-2014 06:48 PM

Me too :(

Gadget_Guy 11-22-2014 01:47 PM

I just installed the product yesterday.

Woke up to these errors in my e-mail notifications:


Database error in DragonByte SEO 1.3.1:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*144884(&[\#\da-z]*;|[^a-z\d])*f\*\*\*\*(&[\#\da-z]*;|[^a-z\d])*[iМНОПмноп][cЗc][eИЙКЛийкл](&[\#\da-z]*;|[^a-z\d])*[cЗc]h([uЩЪЫЬщъыь?]|u|Ж|ж)[nСс]k[sЉљ].html(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Saturday, November 22nd 2014 @ 02:27:15 PM
Error Date : Saturday, November 22nd 2014 @ 02:27:15 PM
Script : http://www.toronto-subaru-club.com/f...ce-chunks.html
Referrer :
IP Address : 66.249.79.88
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :


Database error in DragonByte SEO 1.3.1:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*135247(&[\#\da-z]*;|[^a-z\d])*h[eИЙКЛийкл][aАБВГДЕабвгде]d[sЉљ](&[\#\da-z]*;|[^a-z\d])*([uЩЪЫЬщъыь?]|u|Ж|ж)p(&[\#\da-z]*;|[^a-z\d])*\*(&[\#\da-z]*;|[^a-z\d])*[iМНОПмноп][nСс][sЉљ]([uЩЪЫЬщъыь?]|u|Ж|ж)r[aАБВГДЕабвгде][nСс][cЗc][eИЙКЛийкл](&[\#\da-z]*;|[^a-z\d])*[sЉљ][cЗc][aАБВГДЕабвгде]m.html(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Saturday, November 22nd 2014 @ 02:42:03 PM
Error Date : Saturday, November 22nd 2014 @ 02:42:03 PM
Script : http://www.toronto-subaru-club.com/f...ance-scam.html
Referrer :
IP Address : 66.249.79.88
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :




Any ideas?

D.

dorans 11-22-2014 02:43 PM

<a href="https://vborg.vbsupport.ru/showpost.php?p=2523100&postcount=525" target="_blank">https://vborg.vbsupport.ru/showp...&postcount=525</a>

Gadget_Guy 11-22-2014 03:05 PM

Thanks!

I will try it.

D.

cdoyle 11-22-2014 05:55 PM

So I have had this installed for awhile, but there are now so many different options.
Is there a recommended way to have all the options set up in regards to SEO?

Gadget_Guy 11-22-2014 07:34 PM

Quote:

Originally Posted by Teascu Dorin (Post 2523628)
After upgrade to v1.3.2 from dbtech site, I get an error on posting new thread:

Fatal error: require(): Failed opening required '/home/........../html/forum/dbtech/dbseo_pro/hooks/forumdata_start.php' (include_path='.:/usr/local/php5_4/lib/php') in /home........./html/forum/includes/class_dm_forum.php(123) : eval()'d code on line 7

The error appears also on thread or post edit saving, even in ACP thread/post approval window!

P.S. I use the lite version.


The issue is that (in my opinion) the lite version that was made available has the code for the pro version.

There is no "dbseo_pro" directory in the lite version....

forumdata_start does not exist in the lite version.

Hopefully they will re-upload the proper lite version to get this working again.

D.

Gadget_Guy 11-22-2014 07:57 PM

If it helps anyone,

I took the XML file with the 1.3.2 version and stripped out the lines that refer to dbseo_pro functions and re-uploaded to my site.

Seems to have got things working for the time being.

(I hope)

D.

DragonByte Tech 11-23-2014 02:58 PM

DragonByte SEO v1.3.2

New Features:

SiteLinks
  • The homepage URL as defined in your vBulletin Options is now used in the Search SiteLinks
  • A new option has been added to customise the search target URL
  • Allows admins to use Google Custom Search for their site

Bug Fixes:
  • "All Blogs" Page 2 onwards would not work as intended in certain scenarios


Fillip

katie hunter 11-23-2014 03:14 PM

Thanks Fillip (: I am not sure how we can use this feature ? From my understanding a custom Google search is simply a generated code you generate from google webmaster. Right ?

What do we need to do to try this feature ?

Custom SiteLinks URL
If you are using a custom URL for your search engine (such as Google Custom Search), you can alter this variable to match your search form.

Available replacement variables:
{bburl} (your forum URL)
{homeurl} (your home page URL)
{search_term_string} (Required).

DragonByte Tech 11-23-2014 03:21 PM

Follow the instructions on this site: https://www.google.co.uk/cse/


Fillip

Gadget_Guy 11-23-2014 04:25 PM

Since installing this mod... links to my "home" which are linked like this:

https://www.mysite.com/forums

Go to:

https://www.mysite.com/forums/blogs/all/


What do I have to correct to make it go to /forms and not the blogs?


This is what my .htaccess file looks like:

Quote:


<IfModule mod_rewrite.c>

RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://www.toronto-subaru-club.com/\forums\/$1 [R=301,L]

RewriteEngine on

# Set to vbulletin directory
RewriteBase /forums/

# Retrieve gamedata requests and send to new dbtech locations
RewriteRule ^arcade/gamedata/(.*) dbtech/vbarcade/media/$1 [L]

# Retrieve crossdomain requests and send to new dbtech location
RewriteRule ^crossdomain\.xml dbtech/vbarcade/crossdomain.xml [L]

# Send hardcoded legacy scores to arcade instead
RewriteCond %{REQUEST_URI} newscore\.php [OR]
RewriteCond %{REQUEST_URI} viewgame\.php
RewriteRule .* arcade.php?sendscore=legacy [L,QSA]

# Send hardcoded legacy scores to arcade instead
RewriteCond %{QUERY_STRING} func=storeScore [OR]
RewriteCond %{QUERY_STRING} autocom=arcade [OR]
RewriteCond %{QUERY_STRING} act=arcadelib [OR]
RewriteCond %{QUERY_STRING} act=Arcade
RewriteRule .* arcade.php [L,QSA]

# Reroute v3arcade liveinstaller
RewriteCond %{QUERY_STRING} do=liveinstall
RewriteCond %{REQUEST_URI} v3arcade_admin\.php

# If you renamed your admincp directory, change it here
RewriteRule .* %{DOCUMENT_ROOT}/admincp/arcade_admin.php?%{QUERY_STRING}&do=review&import= browse&system=v3a [L,R=301]
</IfModule>
RewriteEngine Off

RewriteEngine On

RewriteRule ^classifieds/([^/]*)/ ./ozzmodz_classifieds.php?do=main&catid=$1 [L,NC]
RewriteRule ^sale/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^wanted/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^trade/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^offer/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^seller/([^/]*)/ ./ozzmodz_classifieds.php?do=seller&sellerid=$1 [L,NC]


RewriteEngine On

# If you are having problem with "None Could Be Negotiated" errors in Apache, uncomment this to turn off MultiViews
# Options -MultiViews

RewriteRule ^threads/.* showthread.php [QSA]
RewriteRule ^forums/.* forumdisplay.php [QSA]
RewriteRule ^members/.* member.php [QSA]
RewriteRule ^blogs/.* blog.php [QSA]
RewriteRule ^entries/.* entry.php [QSA]

RewriteCond %{REQUEST_URI} !(admincp/|dbseocp/|modcp/|cron|arrowchat/|cometchat/|mobiquo|forumrunner|api\.php|reviewpost/|classifieds/|photopost/)
RewriteRule ^((archive/)?(.*\.php(/.*)?))$ dbseo.php [L,QSA]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !/(admincp|dbseocp|modcp|clientscript|cpstyles|image s|reviewpost|classifieds|photopost)/
RewriteRule ^(.+)$ dbseo.php [L,QSA]


D.

cdoyle 11-26-2014 08:47 PM

Quote:

Originally Posted by cdoyle (Post 2523755)
So I have had this installed for awhile, but there are now so many different options.
Is there a recommended way to have all the options set up in regards to SEO?

To others who are using this, are there any settings that you recommend being enabled or disabled?

ForceHSS 11-26-2014 09:23 PM

Quote:

Originally Posted by cdoyle (Post 2524318)
To others who are using this, are there any settings that you recommend being enabled or disabled?

Leave most at default, you will need to change a few things when first installed to make your site to work right but apart from that leave the rest default

Cla75 11-27-2014 12:46 AM

My continue error...

Database error in DragonByte SEO 1.3.2:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*\*p[aАБВГДЕабвгде][oТУФХЦШтуфхцш]l[aАБВГДЕабвгде]\*.htm(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Thursday, November 27th 2014 @ 01:21:48 AM
Error Date : Thursday, November 27th 2014 @ 01:21:48 AM
Script : http://www.XXX.com/members/*paola*.htm
Referrer :
IP Address : 202.46.56.124
Username : N/A
Classname : DBSEO_Database
MySQL Version :
------------------------


I was hoping you could do accept the "@" or "*" or "&" or other, in all the links (especially if your nickname contains special characters).
in other link, where in the title the "@" and is removed!
thanks

ForceHSS 11-27-2014 12:54 AM

Quote:

Originally Posted by Cla75 (Post 2524363)
My continue error...

Database error in DragonByte SEO 1.3.2:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*\*p[aАБВГДЕабвгде][oТУФХЦШтуфхцш]l[aАБВГДЕабвгде]\*.htm(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Thursday, November 27th 2014 @ 01:21:48 AM
Error Date : Thursday, November 27th 2014 @ 01:21:48 AM
Script : http://www.XXX.com/members/*paola*.htm
Referrer :
IP Address : 202.46.56.124
Username : N/A
Classname : DBSEO_Database
MySQL Version :
------------------------

I was hoping you could do accept the "@" in all the links (soprattutto se il nickname contiene caratteri speciali).
in other link, where in the title the "@" and is removed!
thanks

http://stackoverflow.com/questions/2...egexp-in-mysql

Gadget_Guy 11-27-2014 02:30 AM

Quote:

Originally Posted by ForceHSS (Post 2524364)

How does this help people like myself who are having this issue?

Or was this directed at the developer to help correct this in their code?

D.

ForceHSS 11-27-2014 03:29 AM

I linked you that to tell you to remove the special characters from members usernames and it will fix the problem and in admincp/settings/options/User Registration Options/Username Regular Expression put ^[a-zA-Z0-9\s.\-_']+$
Or something like this to stop members registering with things like this if you already have this filled, maybe what you have in there is wrong

On another note, maybe the dev has a way around to allow them if it has anything to do with this mod, but I think it is more mysql does not allow them
regexp is short for Regular expression

Gadget_Guy 11-27-2014 03:39 AM

How can I do a search / replace of existing usernames that have special characters in them now?

D.

Gadget_Guy 11-27-2014 03:42 AM

Whoops... my apologies....

I see now that the person posted that they were getting an error with usernames.


The errors I am seeing are in thread names.

I think it was from when I switched from VB friendly names or something like that... not too sure.



Database error in DragonByte SEO 1.3.3:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*auto(&[\#\da-z]*;|[^a-z\d])*insurance(&[\#\da-z]*;|[^a-z\d])*\*slight(&[\#\da-z]*;|[^a-z\d])*ww(&[\#\da-z]*;|[^a-z\d])*language(&[\#\da-z]*;|[^a-z\d])*\*(&[\#\da-z]*;|[^a-z\d])*2.html(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Wednesday, November 26th 2014 @ 04:15:50 PM
Error Date : Wednesday, November 26th 2014 @ 04:15:50 PM
Script : http://www.toronto-subaru-club.com/f...guage-*-2.html
Referrer :
IP Address : 199.167.148.2
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :

Cla75 11-27-2014 03:34 PM

now this error

Database error in DragonByte SEO 1.3.2:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

MySQL Error :
Error Number :
Request Date : Thursday, November 27th 2014 @ 06:31:07 PM
Error Date : Thursday, November 27th 2014 @ 06:31:07 PM
Script : http://www.forumviaggiatori.com/members/marco76.html
Referrer :
IP Address : 37.140.141.14
Username : N/A
Classname : DBSEO_Database
MySQL Version :

thanks for your support

ozzy47 11-27-2014 03:39 PM

Quote:

Originally Posted by Cla75 (Post 2524465)
now this error

Database error in DragonByte SEO 1.3.2:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

MySQL Error :
Error Number :
Request Date : Thursday, November 27th 2014 @ 06:31:07 PM
Error Date : Thursday, November 27th 2014 @ 06:31:07 PM
Script : http://www.forumviaggiatori.com/members/marco76.html
Referrer :
IP Address : 37.140.141.14
Username : N/A
Classname : DBSEO_Database
MySQL Version :

thanks for your support

That is most likely a server issue, read here, http://www.vbulletin.com/docs/html/cantconnect

Cla75 11-27-2014 03:46 PM

these errors receive them "random" about 1 or 2 per day always related to members
no other database error on the site
possible ?

ozzy47 11-27-2014 03:49 PM

Well if it random, then I guess you would have to wait till the developer answers.

But to be honest, it would be better off for you to ask on their site, since you seem to have many issues, http://www.dragonbyte-tech.com/f241/

You should get much better response time there.

DragonByte Tech 12-01-2014 07:09 PM

DragonByte SEO v1.3.3

New Features:

(Pro) Custom Forum Domain
  • Ability to change the domain for the Forum, Forum Prefix, Thread, Poll and Print Thread URLs (similar to Blog and CMS URLs)
  • Controllable via vBulletin Options

Bug Fixes:
  • Choosing both "After Every Post" and "After First Post" in the Social Sharing settings would double the sharing buttons
  • Certain system configurations would receive a "repetition operand invalid" error from MySQL


Fillip

xony 12-01-2014 07:59 PM

With all the respect in the world, are doing a great job of code but you stay short in explanation of that is everything and as used, for example the issue of keywords, is quite puzzling.

I repeat, are doing a great job, I congratulate you, my criticism is to improve.

DragonByte Tech 12-03-2014 09:18 PM

DragonByte SEO v1.3.4

New Features:

Meta Description: Tag Cloud
  • Ability to control the Meta Description for the Tag Cloud page
  • Controllable via DragonByte SEO CP
  • Replacement variables available

Meta Description: Tag
  • Ability to control the Meta Description for the Tag page
  • Controllable via DragonByte SEO CP
  • Replacement variables available


Fillip

dknelson 12-05-2014 12:42 AM

Does the lite version of this work for a site where the forums are in a folder? mystic/forum/

DragonByte Tech 12-07-2014 07:05 PM

Quote:

Originally Posted by dknelson (Post 2525737)
Does the lite version of this work for a site where the forums are in a folder? mystic/forum/

Yeah :)


Fillip


All times are GMT. The time now is 04:57 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.02297 seconds
  • Memory Usage 1,870KB
  • 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_code_printable
  • (15)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
  • (40)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