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)

DragonByte Tech 03-12-2014 12:21 AM

DragonByte SEO v1.0.7

Bug Fixes And Issue Fixes:
  • Fixed internal thread URLs not fetching their titles as intended


Fillip

Lexserv 03-12-2014 02:27 AM

What do I put in the text field for Sitemap File Path? I see './store_sitemap', but where is this folder located? If I have to create, where exactly do I create it in? I'm asking this because I see the error message that says "You did not enter a valid value for this setting."

Thanks in advance.

bzcomputers 03-12-2014 04:09 AM

Quote:

Originally Posted by Lexserv (Post 2486597)
What do I put in the text field for Sitemap File Path? I see './store_sitemap', but where is this folder located? If I have to create, where exactly do I create it in? I'm asking this because I see the error message that says "You did not enter a valid value for this setting."

Thanks in advance.

It should be created in the directory your forum is installed in. Should also be the same directory your dbseocp and dbtech folders are in.

singapore 03-12-2014 06:36 AM

Hello,

After installing this product, all menu items are directed to the "Activity Stream".
For example when I click on Forum and the logo, all bring me to "Activity Stream".

Please advise.
Thanks

junaid 03-12-2014 10:09 PM

after upgrade I have issue generating sitemap database error

Database error in vBulletin 4.2.2:

Invalid SQL:

REPLACE INTO adminutil
(title, text)
VALUES
('sitemapsession', 'a:6:{s:5:\"types\";a:7:{i:0;s:6:\"thread\";i:1;s: 5:\"forum\";i:2;s:4:\"poll\";i:3;s:5:\"album\";i:4 ;s:5:\"group\";i:5;s:12:\"groupdiscuss\";i:6;s:4:\ "tags\";}s:15:\"current_content\";s:6:\"thread\";s :7:\"startat\";i:113131;s:5:\"state\";s:15:\"runni ng_admincp\";s:5:\"count\";a:3:{s:6:\"custom\";i:0 ;s:6:\"member\";i:4152;s:6:\"thread\";i:30000;}s:8 :\"sitemaps\";a:7:{i:0;a:2:{s:3:\"loc\";s:29:\"dbs eo_sitemap_member_0.xml.gz\";s:7:\"lastmod\";i:139 4569593;}i:1;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap _member_1.xml.gz\";s:7:\"lastmod\";i:1394569597;}i :2;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap_member_2. xml.gz\";s:7:\"lastmod\";i:1394569603;}i:3;a:2:{s: 3:\"loc\";s:29:\"dbseo_sitemap_member_3.xml.gz\";s :7:\"lastmod\";i:1394569607;}i:4;a:2:{s:3:\"loc\"; s:29:\"dbseo_sitemap_thread_4.xml.gz\";s:7:\"lastm od\";i:1394571536;}i:5;a:2:{s:3:\"loc\";s:29:\"dbs eo_sitemap_thread_5.xml.gz\";s:7:\"lastmod\";i:139 4571544;}i:6;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap _thread_6.xml.gz\";s:7:\"lastmod\";i:1394661995;}} }');

MySQL Error : Duplicate entry 'sitemapsession' for key 'PRIMARY'
Error Number : 1062
Request Date : Wednesday, March 12th 2014 @ 04:06:35 PM
Error Date : Wednesday, March 12th 2014 @ 04:06:44 PM
Script : http:///dbseocp/index.php?do=buildsitemap
Referrer : http://dbseocp/index.php?do=buildsitemap
IP Address :
Username :
Classname : vB_Da
MySQL Version : 5.5.36-cll

DragonByte Tech 03-12-2014 10:12 PM

Quote:

Originally Posted by singapore (Post 2486631)
Hello,

After installing this product, all menu items are directed to the "Activity Stream".
For example when I click on Forum and the logo, all bring me to "Activity Stream".

Please advise.
Thanks

Make sure you've set your vB friendly URLs to "Standard URLs".

Quote:

Originally Posted by junaid (Post 2486795)
after upgrade I have issue generating sitemap database error

Database error in vBulletin 4.2.2:

Invalid SQL:

REPLACE INTO adminutil
(title, text)
VALUES
('sitemapsession', 'a:6:{s:5:\"types\";a:7:{i:0;s:6:\"thread\";i:1;s: 5:\"forum\";i:2;s:4:\"poll\";i:3;s:5:\"album\";i:4 ;s:5:\"group\";i:5;s:12:\"groupdiscuss\";i:6;s:4:\ "tags\";}s:15:\"current_content\";s:6:\"thread\";s :7:\"startat\";i:113131;s:5:\"state\";s:15:\"runni ng_admincp\";s:5:\"count\";a:3:{s:6:\"custom\";i:0 ;s:6:\"member\";i:4152;s:6:\"thread\";i:30000;}s:8 :\"sitemaps\";a:7:{i:0;a:2:{s:3:\"loc\";s:29:\"dbs eo_sitemap_member_0.xml.gz\";s:7:\"lastmod\";i:139 4569593;}i:1;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap _member_1.xml.gz\";s:7:\"lastmod\";i:1394569597;}i :2;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap_member_2. xml.gz\";s:7:\"lastmod\";i:1394569603;}i:3;a:2:{s: 3:\"loc\";s:29:\"dbseo_sitemap_member_3.xml.gz\";s :7:\"lastmod\";i:1394569607;}i:4;a:2:{s:3:\"loc\"; s:29:\"dbseo_sitemap_thread_4.xml.gz\";s:7:\"lastm od\";i:1394571536;}i:5;a:2:{s:3:\"loc\";s:29:\"dbs eo_sitemap_thread_5.xml.gz\";s:7:\"lastmod\";i:139 4571544;}i:6;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap _thread_6.xml.gz\";s:7:\"lastmod\";i:1394661995;}} }');

MySQL Error : Duplicate entry 'sitemapsession' for key 'PRIMARY'
Error Number : 1062
Request Date : Wednesday, March 12th 2014 @ 04:06:35 PM
Error Date : Wednesday, March 12th 2014 @ 04:06:44 PM
Script : http:///dbseocp/index.php?do=buildsitemap
Referrer : http://dbseocp/index.php?do=buildsitemap
IP Address :
Username :
Classname : vB_Da
MySQL Version : 5.5.36-cll

You will want to contact your host and ask why "REPLACE INTO" produces "duplicate entry" errors. It sounds like they have modified MySQL in some way.


Fillip

junaid 03-12-2014 10:20 PM

This is dedicated server what changes I have to do? to MYSQL server

junaid 03-12-2014 10:24 PM

after clearing cache work fine build site map
is there any way I can set flush cache by auto cron jobs

Regards

ForceHSS 03-12-2014 10:26 PM

Quote:

Originally Posted by junaid (Post 2486795)
after upgrade I have issue generating sitemap database error

Database error in vBulletin 4.2.2:

Invalid SQL:

REPLACE INTO adminutil
(title, text)
VALUES
('sitemapsession', 'a:6:{s:5:\"types\";a:7:{i:0;s:6:\"thread\";i:1;s: 5:\"forum\";i:2;s:4:\"poll\";i:3;s:5:\"album\";i:4 ;s:5:\"group\";i:5;s:12:\"groupdiscuss\";i:6;s:4:\ "tags\";}s:15:\"current_content\";s:6:\"thread\";s :7:\"startat\";i:113131;s:5:\"state\";s:15:\"runni ng_admincp\";s:5:\"count\";a:3:{s:6:\"custom\";i:0 ;s:6:\"member\";i:4152;s:6:\"thread\";i:30000;}s:8 :\"sitemaps\";a:7:{i:0;a:2:{s:3:\"loc\";s:29:\"dbs eo_sitemap_member_0.xml.gz\";s:7:\"lastmod\";i:139 4569593;}i:1;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap _member_1.xml.gz\";s:7:\"lastmod\";i:1394569597;}i :2;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap_member_2. xml.gz\";s:7:\"lastmod\";i:1394569603;}i:3;a:2:{s: 3:\"loc\";s:29:\"dbseo_sitemap_member_3.xml.gz\";s :7:\"lastmod\";i:1394569607;}i:4;a:2:{s:3:\"loc\"; s:29:\"dbseo_sitemap_thread_4.xml.gz\";s:7:\"lastm od\";i:1394571536;}i:5;a:2:{s:3:\"loc\";s:29:\"dbs eo_sitemap_thread_5.xml.gz\";s:7:\"lastmod\";i:139 4571544;}i:6;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap _thread_6.xml.gz\";s:7:\"lastmod\";i:1394661995;}} }');

MySQL Error : Duplicate entry 'sitemapsession' for key 'PRIMARY'
Error Number : 1062
Request Date : Wednesday, March 12th 2014 @ 04:06:35 PM
Error Date : Wednesday, March 12th 2014 @ 04:06:44 PM
Script : http:///dbseocp/index.php?do=buildsitemap
Referrer : http://dbseocp/index.php?do=buildsitemap
IP Address :
Username :
Classname : vB_Da
MySQL Version : 5.5.36-cll

Run this query from admincp
Code:

DELETE FROM `adminutil` WHERE (`title`='sitemapsession')
then this
Code:

REPLACE INTO adminutil
                (title, text)
            VALUES
                ('sitemapsession',  'a:6:{s:5:\"types\";a:7:{i:0;s:6:\"thread\";i:1;s:5:\"forum\";i:2;s:4:\"poll\";i:3;s:5:\"album\";i:4;s:5:\"group\";i:5;s:12:\"groupdiscuss\";i:6;s:4:\"tags\";}s:15:\"current_content\";s:6:\"thread\";s:7:\"startat\";i:113131;s:5:\"state\";s:15:\"running_admincp\";s:5:\"count\";a:3:{s:6:\"custom\";i:0;s:6:\"member\";i:4152;s:6:\"thread\";i:30000;}s:8:\"sitemaps\";a:7:{i:0;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap_member_0.xml.gz\";s:7:\"lastmod\";i:1394569593;}i:1;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap_member_1.xml.gz\";s:7:\"lastmod\";i:1394569597;}i:2;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap_member_2.xml.gz\";s:7:\"lastmod\";i:1394569603;}i:3;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap_member_3.xml.gz\";s:7:\"lastmod\";i:1394569607;}i:4;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap_thread_4.xml.gz\";s:7:\"lastmod\";i:1394571536;}i:5;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap_thread_5.xml.gz\";s:7:\"lastmod\";i:1394571544;}i:6;a:2:{s:3:\"loc\";s:29:\"dbseo_sitemap_thread_6.xml.gz\";s:7:\"lastmod\";i:1394661995;}}}');

If you are still having problems talk to your host

singapore 03-12-2014 11:05 PM

Quote:

Originally Posted by DragonByte Tech (Post 2486796)
Make sure you've set your vB friendly URLs to "Standard URLs".

Fillip

Solved by setting "Force Forum Directory Index" to "NO"
Thanks


All times are GMT. The time now is 11:12 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.01923 seconds
  • Memory Usage 1,762KB
  • 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
  • (5)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