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)

ForceHSS 12-22-2014 06:37 AM

Quote:

Originally Posted by Skaut (Post 2528327)
This does not work anymore.

If it does not work for you any more you need to say why as we cant read your mind

RichieBoy67 12-22-2014 04:44 PM

Quote:

Originally Posted by ForceHSS (Post 2528333)
If it does not work for you any more you need to say why as we cant read your mind

Speak for yourself. I can read minds. :D

Scoooter 12-23-2014 08:26 PM

Since last update I'm getting Database errors.

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO dbtech_dbseo_sitemapbuildlog
(dateline, builddetails, prevbuilddetails)
VALUES (
1419340412,
'a:13:{s:6:\"custom\";i:0;s:6:\"member\";i:143;s:6 :\"thread\";i:6647;s:5:\"forum\";i:448;s:4:\"poll\ ";i:0;s:4:\"blog\";i:2;s:7:\"blogtag\";i:1;s:5:\"a lbum\";i:0;s:5:\"group\";i:1;s:12:\"groupdiscuss\" ;i:0;s:4:\"tags\";i:1993;s:3:\"cms\";i:1;s:10:\"cm ssection\";i:6;}',
'a:13:{s:6:\"custom\";i:0;s:6:\"member\";i:141;s:6 :\"thread\";i:6555;s:5:\"forum\";i:441;s:4:\"poll\ ";i:0;s:4:\"blog\";i:2;s:7:\"blogtag\";i:1;s:5:\"a lbum\";i:0;s:5:\"group\";i:1;s:12:\"groupdiscuss\" ;i:0;s:4:\"tags\";i:1870;s:3:\"cms\";i:1;s:10:\"cm ssection\";i:6;}'
);

MySQL Error : Unknown column 'prevbuilddetails' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 23rd 2014 @ 06:13:32 AM
Error Date : Tuesday, December 23rd 2014 @ 06:13:33 AM
Script : http://www.allcyclesgroup.com/cron.php?rand=1419339820
Referrer : http://www.allcyclesgroup.com/all-ot...new-post.html?
IP Address : 220.181.108.XXX
Username : Unregistered
Classname : vB_Database
MySQL Version :

bzcomputers 12-23-2014 08:37 PM

Quote:

Originally Posted by Scoooter (Post 2528517)
Since last update I'm getting Database errors.

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO dbtech_dbseo_sitemapbuildlog
(dateline, builddetails, prevbuilddetails)
VALUES (
1419340412,
'a:13:{s:6:\"custom\";i:0;s:6:\"member\";i:143;s:6 :\"thread\";i:6647;s:5:\"forum\";i:448;s:4:\"poll\ ";i:0;s:4:\"blog\";i:2;s:7:\"blogtag\";i:1;s:5:\"a lbum\";i:0;s:5:\"group\";i:1;s:12:\"groupdiscuss\" ;i:0;s:4:\"tags\";i:1993;s:3:\"cms\";i:1;s:10:\"cm ssection\";i:6;}',
'a:13:{s:6:\"custom\";i:0;s:6:\"member\";i:141;s:6 :\"thread\";i:6555;s:5:\"forum\";i:441;s:4:\"poll\ ";i:0;s:4:\"blog\";i:2;s:7:\"blogtag\";i:1;s:5:\"a lbum\";i:0;s:5:\"group\";i:1;s:12:\"groupdiscuss\" ;i:0;s:4:\"tags\";i:1870;s:3:\"cms\";i:1;s:10:\"cm ssection\";i:6;}'
);

MySQL Error : Unknown column 'prevbuilddetails' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 23rd 2014 @ 06:13:32 AM
Error Date : Tuesday, December 23rd 2014 @ 06:13:33 AM
Script : http://www.allcyclesgroup.com/cron.php?rand=1419339820
Referrer : http://www.allcyclesgroup.com/all-ot...new-post.html?
IP Address : 220.181.108.105
Username : Unregistered
Classname : vB_Database
MySQL Version :

It appears you didn't import the .xml file from the latest update or it didn't import correctly for you. Re-import the .xml file and it should fix the issue.

Scoooter 12-23-2014 08:43 PM

Quote:

Originally Posted by bzcomputers (Post 2528521)
It appears you didn't import the .xml file from the latest update or it didn't import correctly for you. Re-import the .xml file and it should fix the issue.

I've already done this but will do it for a third time. I'll report back if I receive another error. Thanks for the help

ForceHSS 12-23-2014 09:55 PM

Quote:

Originally Posted by Scoooter (Post 2528527)
I've already done this but will do it for a third time. I'll report back if I receive another error. Thanks for the help

going by your above error you have more than the one table missing from dbtech_dbseo_sitemapbuildlog
run this query
Code:

DROP TABLE IF EXISTS `dbtech_dbseo_sitemapbuildlog`;
CREATE TABLE `dbtech_dbseo_sitemapbuildlog` (
  `sitemapbuildlogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dateline` int(10) NOT NULL DEFAULT '0',
  `builddetails` mediumblob,
  `sitemaphits` int(10) NOT NULL DEFAULT '0',
  `spiderhits` int(10) NOT NULL DEFAULT '0',
  `prevbuilddetails` mediumblob NOT NULL,
  PRIMARY KEY (`sitemapbuildlogid`)
) ENGINE=MyISAM

then rebuild the sitemap

khalled 12-26-2014 10:05 AM

Stopword List
when this option is active ,google web master give me more that 5000 error for not found page because some of threads have one of this stopword in his titles, and now after install DragonByte SEO and activate stopword the lank for the above page was changed and this page have backlink from anther website
so what advise in this ? are it is good to make stopword to No

Scoooter 12-26-2014 04:39 PM

Quote:

Originally Posted by ForceHSS (Post 2528534)
going by your above error you have more than the one table missing from dbtech_dbseo_sitemapbuildlog
run this query
Code:

DROP TABLE IF EXISTS `dbtech_dbseo_sitemapbuildlog`;
CREATE TABLE `dbtech_dbseo_sitemapbuildlog` (
  `sitemapbuildlogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dateline` int(10) NOT NULL DEFAULT '0',
  `builddetails` mediumblob,
  `sitemaphits` int(10) NOT NULL DEFAULT '0',
  `spiderhits` int(10) NOT NULL DEFAULT '0',
  `prevbuilddetails` mediumblob NOT NULL,
  PRIMARY KEY (`sitemapbuildlogid`)
) ENGINE=MyISAM

then rebuild the sitemap

Still having this same issue. I have had no issues until the last update..

ForceHSS 12-26-2014 04:45 PM

Quote:

Originally Posted by Scoooter (Post 2528893)
Still having this same issue. I have had no issues until the last update..

make sure you have uploaded the files into the correct folders and installed the xml

Scoooter 12-26-2014 05:02 PM

Quote:

Originally Posted by ForceHSS (Post 2528894)
make sure you have uploaded the files into the correct folders and installed the xml

Everything is in the correct location. I've been running and updating this since it first came out. Since this last release it's been nothing but database errors.


All times are GMT. The time now is 09:49 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.02301 seconds
  • Memory Usage 1,755KB
  • 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
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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