vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
vBSEO Team: Hot or Not? Ready for Traffic Explosion? vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! vBSEO Helps Forum Earn $100/day from Google AdSense Discover the Power of "Long Tail Search" Crawlability Inc. Files for SEO Technology Patent
se sw

Database Errors

This is a discussion on Database Errors within the Off-Topic & Chit Chat forums, part of the Focus on Members category; The other day I reported that I lost an attachment. Today I got two database errors. Any ideas how to ...

Go Back   vBulletin SEO Forums > Focus on Members > Off-Topic & Chit Chat

Enhancing 80 million pages.

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1  
Old 09-20-2006, 06:40 PM
majordude's Avatar
Senior Member
 
Real Name: majordude
Join Date: Aug 2006
Posts: 182
Unhappy Database Errors

The other day I reported that I lost an attachment. Today I got two database errors.

Any ideas how to fix this?

ERROR 1

Database error in vBulletin 3.6.0:

Invalid SQL:

REPLACE INTO useractivation
VALUES
(NULL , 77, 1158737043, 80794438, 0, 2);

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Wednesday, September 20th 2006 @ 12:24:03 AM
Script : http://www... ...com/cron.php?rand=323190
Referrer : http://www... ...com/introductions/
IP Address : 124.xxx.xxx.xxx
Username : Unregistered
Classname : vb_database


ERROR 2

Database error in vBulletin 3.6.0:

Invalid SQL:

REPLACE INTO useractivation
VALUES
(NULL , 77, 1158674409, 63905929, 0, 2);

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Tuesday, September 19th 2006 @ 07:00:09 AM
Script : http://www... ...com/cron.php?rand=396600
Referrer :
IP Address : 216.xxx.xxx.xxx
Username : Unregistered
Classname : vb_database
__________________
.
Go Packers!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 09-20-2006, 07:20 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 20,259
Blog Entries: 1
Hello,

you should check which cron job (executed at 7:00) performs modification of "useractivation" db table and disable or fix it (it's not vBSEO).
__________________
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 09-20-2006, 09:05 PM
Juan Muriente's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Juan Carlos Muriente
Join Date: Jun 2005
Location: Puerto Rico
Posts: 12,515
Blog Entries: 2
**Moved to the troubleshooting forums**
__________________
Juan Muriente / 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
  #4  
Old 09-21-2006, 03:26 AM
Ace Shattock's Avatar
vBSEO Staff
vBSEO Total Customer SupportCommunity Builder
 
Real Name: Ace Shattock
Join Date: Jul 2005
Location: New Zealand
Posts: 2,784
I seem to recall this error on my own forums, when using an early release of one of the vBs.

Effectively, the user activation wasn't working because there was an error in the php file.

/upload/includes/cron/activate.php

Try uploading this again, from your latest download of 3.6.0.
__________________
Ace Shattock / 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.


My Personal Sites: New Zealand Forum | vBulletin Modifications and Styles | vBulletin Hosting
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5  
Old 09-21-2006, 09:28 PM
majordude's Avatar
Senior Member
 
Real Name: majordude
Join Date: Aug 2006
Posts: 182
Thanks. I believe that this is a reported bug in vBulletin 3.6. (There was a reply here that seems to have disappeared that said as much.)

I'm glad it isn't a database error!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

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
Forum Jump

Similar Threads

Thread Thread Starter Forum Replies Last Post
Database Errors Michael Troubleshooting 11 11-03-2005 04:39 PM
Database errors and problems with drex Bug Reporting 2 11-02-2005 08:02 PM
lotsa database errors on vbseo acers General Discussion 1 08-11-2005 10:40 PM


All times are GMT -4. The time now is 12:53 PM.


Powered by vBulletin Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc.