vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
New vBSEO Discount Level for Network Builders Meet vBSEO Team in New York (Nov. 3rd & 4th) vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! Crawlability Inc. Files for SEO Technology Patent
se sw

Crons Don't Install With Mysql_Slave Datatype

This is a discussion on Crons Don't Install With Mysql_Slave Datatype within the Bug Reporting forums, part of the vBSEO Google/Yahoo Sitemap category; When you import the product with mysql_slave as the datatype the product produces an sql error. Code: Database error in ...

Go Back   vBulletin SEO Forums > vBSEO Google/Yahoo Sitemap > Bug Reporting

Crons Don't Install With Mysql_Slave Datatype Crons Don't Install With Mysql_Slave Datatype

Enhancing 80 million pages.

 Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1  
Old 08-22-2007, 04:39 AM
BamaStangGuy's Avatar
Senior Member
vBSEO Pre-Release TeamBig Board Administrator
  
Real Name: Brent Wilson
Join Date: Aug 2005
Location: Huntsville, Alabama
Posts: 2,347
Send a message via AIM to BamaStangGuy Send a message via MSN to BamaStangGuy
Crons Don't Install With Mysql_Slave Datatype
When you import the product with mysql_slave as the datatype the product produces an sql error.

Code:
Database error in vBulletin 3.6.8:

Invalid SQL:

		UPDATE forums_cron
		SET nextrun = 1187492340
		WHERE cronid = 31 AND nextrun =;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Error Number : 1064
Username     : Tech Admin
Classname    : vB_Database_Slave
Works fine with mysql as the datatype.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 08-22-2007, 06:21 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,449
Blog Entries: 1
Try to manually remove <cron> section from vbseo_sitemap.xml product file, install it and create a scheduled task manually.
__________________
Oleg Ignatiuk / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 08-22-2007, 02:11 PM
BamaStangGuy's Avatar
Senior Member
vBSEO Pre-Release TeamBig Board Administrator
  
Real Name: Brent Wilson
Join Date: Aug 2005
Location: Huntsville, Alabama
Posts: 2,347
Send a message via AIM to BamaStangGuy Send a message via MSN to BamaStangGuy
It's just easier to change the data_type to mysql and then back That way the crons install with the plugin. I just wanted to report it because I didn't know if it was a vbulletin bug or vbseo bug.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 05-07-2008, 04:13 PM
Member
  
Real Name: eric
Join Date: Apr 2006
Posts: 56
hey, i am having this same problem installing 3.2 rc5 , but i don't see a <cron> section, only cron entries. lil help?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5  
Old 05-07-2008, 04:21 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,449
Blog Entries: 1
There is a section:
HTML Code:
<cron varname="vbseo_serviceupdate"...
</cron>
__________________
Oleg Ignatiuk / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6  
Old 05-07-2008, 04:28 PM
Member
  
Real Name: eric
Join Date: Apr 2006
Posts: 56
worked, thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7  
Old 10-15-2008, 11:19 PM
Member
  
Real Name: eric
Join Date: Apr 2006
Posts: 56
just as an update, i had to do this same thing for the sitemap ver 2.2
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Vbseo error css in Internet Explorer | Security issue with filevbseo_getsitemap.php »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
how to install zend optimizer? Hawork Troubleshooting 1 04-07-2007 06:55 PM
Install VBseo on 3.5 or wait and install on 3.6? cgchris99 Pre-Sales Questions 3 08-01-2006 11:30 AM
You Install? We Install? Where's Install Info? WiseOne Pre-Sales Questions 24 06-11-2006 06:35 PM
adding my vbadvanced pages.... BamaStangGuy General Discussion 8 12-12-2005 11:18 AM


All times are GMT -4. The time now is 09:07 AM.

Contact Us - vBSEO Home - Site Map - Top

Powered by vBulletin Version 3.8.0 Beta 3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.