Page 1 of 2 1 2 LastLast
Results 1 to 15 of 17

getting database errors

This is a discussion on getting database errors within the Troubleshooting forums, part of the vBSEO SEO Plugin category; I know longer have blogs, how do I disable this? MySQL Error : Unknown column 'phrasegroup_vbblogglobal' in 'field list' Error ...

  1. #1
    gc1
    gc1 is offline
    Senior Member
    Real Name
    Jeff
    Join Date
    Sep 2006
    Posts
    105
    Liked
    7 times

    getting database errors

    I know longer have blogs, how do I disable this?


    MySQL Error : Unknown column 'phrasegroup_vbblogglobal' in 'field list'
    Error Number : 1054
    Request Date : Friday, January 8th 2010 @ 01:59:05 PM
    Error Date : Friday, January 8th 2010 @ 01:59:05 PM
    Script : http://www.xxxxxxxxxx.com/xxxxxxxxxx/upload/blogs/necie67/2009/12/

  2. #2
    vBSEO Staff Brian Cummiskey's Avatar
    Real Name
    Brian Cummiskey
    Join Date
    Jul 2009
    Location
    btwn NYC and Boston
    Posts
    12,782
    Liked
    648 times
    Blog Entries
    2
    Hello,

    It looks like the script is looking for a field in your database table that doesn't exist.

    If you temporarily disable vbseo, does it work? I do not believe this to be related to vbseo.
    Brian Cummiskey / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  3. #3
    gc1
    gc1 is offline
    Senior Member
    Real Name
    Jeff
    Join Date
    Sep 2006
    Posts
    105
    Liked
    7 times
    I uninstalled the blogs in my forums, didn't want them anymore and just bought the new 4.0 forums... any idea how to stop these database errors?

  4. #4
    vBSEO Staff Brian Cummiskey's Avatar
    Real Name
    Brian Cummiskey
    Join Date
    Jul 2009
    Location
    btwn NYC and Boston
    Posts
    12,782
    Liked
    648 times
    Blog Entries
    2
    If you un-installed the blogs, /blogs/ and anything after it is basically a dead URL and shouldn't even exist.

    Make sure in vbseocp that you have set "Rewrite Blog URLs" to No.
    Brian Cummiskey / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  5. #5
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    You also need to make sure you removed vBulletin Blog files from your server , so blog urls will return 404.
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  6. #6
    gc1
    gc1 is offline
    Senior Member
    Real Name
    Jeff
    Join Date
    Sep 2006
    Posts
    105
    Liked
    7 times
    Nothing against you guys... you are all great but I think VB4 totally sucks, nothing seems to work right, that stupid style variable editor does not even make changes to a style when I edit it...Vbulletin.com support sucks... I am sick of the whole mess and may just blow the whole system up and buy software that acually works. I have been a customer of theirs since 2002 and I am just sick of what they have done to Vbulletin.

    The company that owns Vbulletin inquired about buying my site.... Not a chance, especially if they are going to turn it into that junk

    As I said VBSEO has been wonderful and I have made alot of money running your software, but it's no longer worth it..
    Why don't you guys create your own forum software?

  7. #7
    vBSEO Staff Brian Cummiskey's Avatar
    Real Name
    Brian Cummiskey
    Join Date
    Jul 2009
    Location
    btwn NYC and Boston
    Posts
    12,782
    Liked
    648 times
    Blog Entries
    2
    You're certainly not alone in your opinions here. Many have jumped ship and more likely will.
    IMO, they released Gold way too soon. It still has 1000 confirmed bugs according to project tools. 4.0.1 should be better, rectifying many of these.

    If you're interested in selling, there's many other options besides IB. Flippa.com is a good start for listing if that's what you are thinking.

    We've tossed around the idea of creating IPB SEO, but it looks like IPB 3.1 will include many features and make development efforts not profitable.
    We've also tossed around the idea of making our own forum software too, but it is a LOT of work in an already flooded market. Perhaps we will consider revisiting the idea later down the road.
    Brian Cummiskey / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  8. #8
    gc1
    gc1 is offline
    Senior Member
    Real Name
    Jeff
    Join Date
    Sep 2006
    Posts
    105
    Liked
    7 times
    I wish you guys would revisit that idea, your product is excellent, and if a problem comes up there is always someone here that can tell you how to fix it.As far as selling, I am not interested in that, got a good real job, house paid for,100% debt free no credit cards/car payments etc. it's not about the money, these websites become our baby and a big part of our life, it just frosts my butt to see them release that junk and charge the price they do for it...Then you have to put it in front of your 25 thousand member website and look like a tool. I will sit here and wait for an update in a few days and see if that fixes my problem... if not, it may be time to search for a more stable user friendly alternative.

    Thanks

  9. #9
    Member
    Real Name
    Bram
    Join Date
    Apr 2008
    Posts
    73
    Liked
    2 times
    Sorry for bumping this old thread but i am experiencing the same as the OP starter, and kind find a way to solve it.

    Did you guys initially solved this issue? getting sick of the vbulletin database error emails 40 times a day

  10. #10
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    Hello Bram ,

    Does it work when vBSEO is disabled ?
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  11. #11
    vBSEO Staff Brian Cummiskey's Avatar
    Real Name
    Brian Cummiskey
    Join Date
    Jul 2009
    Location
    btwn NYC and Boston
    Posts
    12,782
    Liked
    648 times
    Blog Entries
    2
    Did you remove the blog from your services?
    Brian Cummiskey / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  12. #12
    Member
    Real Name
    Bram
    Join Date
    Apr 2008
    Posts
    73
    Liked
    2 times
    Quote Originally Posted by Brian Cummiskey View Post
    Did you remove the blog from your services?
    yes i did.

    The vb license we used on 3.8 with no extra package. A few months before vb4 came out i migrated vb blogs from my other forum to this one. I uninstalled the blogs and the errors started. More or less like the poster above.

  13. #13
    vBSEO Staff Brian Cummiskey's Avatar
    Real Name
    Brian Cummiskey
    Join Date
    Jul 2009
    Location
    btwn NYC and Boston
    Posts
    12,782
    Liked
    648 times
    Blog Entries
    2
    You should set up a redirect for those pages, as you are still getting search/etc hits to them.

    make a Custom REdirect for

    '^blogs/$' => '/'

    for example
    Brian Cummiskey / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  14. #14
    Member
    Real Name
    Bram
    Join Date
    Apr 2008
    Posts
    73
    Liked
    2 times
    Hi Brian thanks.

    Where do i put that custom redirect?

    But isnt this something i should address to vb.com. I mean i have paid for my blog license last year and now all of sudden with vb4 (no suite on this site) its not longer valid

  15. #15
    vBSEO Staff Brian Cummiskey's Avatar
    Real Name
    Brian Cummiskey
    Join Date
    Jul 2009
    Location
    btwn NYC and Boston
    Posts
    12,782
    Liked
    648 times
    Blog Entries
    2
    That was always the plan... blogs are part of the suite, not the bare bones forum package.

    You would put that code in the Custom Redirects area in VBSEO CP
    Brian Cummiskey / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


Page 1 of 2 1 2 LastLast

Similar Threads

  1. just got vbseo and now database errors..
    By Likenota in forum Troubleshooting
    Replies: 4
    Last Post: 03-02-2008, 07:40 PM
  2. Database Errors
    By majordude in forum Off-Topic & Chit Chat
    Replies: 4
    Last Post: 09-21-2006, 10:28 PM
  3. Database Errors
    By Michael in forum Troubleshooting
    Replies: 11
    Last Post: 11-03-2005, 05:39 PM
  4. Database errors and problems with
    By drex in forum Bug Reporting
    Replies: 2
    Last Post: 11-02-2005, 09:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •