DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin





DragonByte Tech Proudly Hosted By Hivelocity.net
Custom Fitted Forum Hosting from Hivelocity

User Tag List

Results 1 to 3 of 3

Thread: database error


Forum: vBAnalytics Lite Support

Questions & Answers for vBAnalytics.
Click here to buy!

  1. #1
    Senior Member
    Level 6 (3,858 Loyalty Points)
    IcEWoLF's Avatar
    Total Downloaded
    0
    Gil
    2,634 (0 Banked)
    Total Downloaded
    0
    User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
    Join Date
    Jul 2011
    Posts
    586
    Points
    2,634
    Credits
    260
    Rep Power
    4

    Default database error

    I am getting this error on a daily basis and not sure how to fix this.

    Code:
    Database error in vBulletin 4.1.12:
    
    Invalid SQL:
    
    		INSERT INTO dbtech_vbanalytics_tracking_forums
    			(forumid, posts, threads, visits, bounces, pageviews, landings, referrals, conversions, dateline)
    		VALUES
    			(0, 39698, 4254, 1527, 592, 3836, 1072, 11, 0, 1335412799),(79, 35, 9, 5, 0, 17, 0, 0, 0, 1335412799),(78, 0, 0, 5, 0, 5, 0, 0, 0, 1335412799),(75, 225, 31, 25, 9, 61, 10, 0, 0, 1335412799),(74, 189, 21, 19, 3, 37, 8, 0, 0, 1335412799),(73, 1010, 152, 26, 9, 42, 15, 0, 0, 1335412799),(72, 425, 62, 44, 36, 110, 57, 0, 0, 1335412799),(63, 336, 89, 48, 38, 100, 42, 0, 0, 1335412799),(62, 744, 73, 14, 3, 51, 30, 0, 0, 1335412799),(56, 430, 57, 23, 36, 64, 38, 2, 0, 1335412799),(55, 312, 48, 33, 23, 77, 63, 1, 0, 1335412799),(54, 1422, 153, 51, 1, 99, 6, 0, 0, 1335412799),(53, 0, 0, 16, 4, 21, 5, 0, 0, 1335412799),(52, 691, 70, 39, 18, 102, 23, 0, 0, 1335412799),(51, 1039, 115, 47, 7, 103, 10, 0, 0, 1335412799),(50, 552, 54, 22, 6, 56, 42, 0, 0, 1335412799),(49, 182, 18, 19, 7, 50, 11, 0, 0, 1335412799),(48, 2027, 193, 64, 39, 151, 43, 0, 0, 1335412799),(42, 368, 44, 38, 21, 83, 26, 0, 0, 1335412799),(41, 186, 8, 0, 0, 0, 0, 0, 0, 1335412799),(38, 690, 70, 29, 18, 64, 23, 0, 0, 1335412799),(33, 0, 0, 15, 6, 18, 8, 0, 0, 1335412799),(32, 771, 60, 32, 14, 76, 20, 0, 0, 1335412799),(31, 89, 7, 14, 13, 37, 25, 0, 0, 1335412799),(35, 0, 0, 13, 14, 24, 26, 0, 0, 1335412799),(29, 650, 80, 5, 0, 8, 0, 0, 0, 1335412799),(28, 478, 32, 22, 17, 35, 22, 0, 0, 1335412799),(34, 219, 31, 29, 11, 75, 12, 0, 0, 1335412799),(27, 990, 32, 20, 4, 29, 10, 0, 0, 1335412799),(39, 43, 6, 17, 2, 37, 23, 0, 0, 1335412799),(36, 1981, 300, 43, 15, 104, 22, 0, 0, 1335412799),(24, 870, 105, 11, 0, 12, 0, 0, 0, 1335412799),(23, 687, 107, 10, 0, 17, 0, 0, 0, 1335412799),(22, 646, 66, 47, 17, 115, 29, 0, 0, 1335412799),(21, 0, 0, 5, 0, 10, 0, 0, 0, 1335412799),(20, 4886, 294, 47, 0, 187, 4, 0, 0, 1335412799),(17, 0, 0, 7, 0, 10, 0, 0, 0, 1335412799),(14, 99, 16, 63, 21, 134, 57, 2, 0, 1335412799),(13, 145, 44, 21, 10, 57, 18, 0, 0, 1335412799),(9, 0, 0, 15, 3, 27, 11, 0, 0, 1335412799),(8, 1925, 352, 56, 22, 172, 29, 0, 0, 1335412799),(7, 81, 12, 32, 12, 70, 22, 3, 0, 1335412799),(6, 1994, 265, 67, 28, 192, 39, 0, 0, 1335412799),(5, 2738, 379, 71, 20, 242, 29, 0, 0, 1335412799),(4, 145, 7, 51, 4, 111, 9, 0, 0, 1335412799),(3, 1434, 121, 50, 6, 129, 15, 0, 0, 1335412799),(2, 7964, 671, 179, 40, 573, 146, 0, 0, 1335412799),(1, 0, 0, 18, 35, 42, 44, 3, 0, 1335412799);
    
    MySQL Error   : Unknown column 'posts' in 'field list'
    Error Number  : 1054
    Request Date  : Thursday, April 26th 2012 @ 12:03:18 AM
    Error Date    : Thursday, April 26th 2012 @ 12:03:18 AM
    Script        : http://www.47r-squad.com/cron.php?rand=1335412997
    Referrer      : http://www.47r-squad.com/general-discussion/5621-battletag-id-exchange-diablo-iii.html
    IP Address    : 72.207.21.150
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    Code:
    Database error in vBulletin 4.1.12:
    
    Invalid SQL:
    
    		INSERT INTO dbtech_vbanalytics_tracking_forums
    			(forumid, posts, threads, visits, bounces, pageviews, landings, referrals, conversions, dateline)
    		VALUES
    			(0, 40067, 4290, 1704, 730, 4651, 1314, 13, 0, 1335671999),(79, 48, 12, 7, 0, 28, 0, 0, 0, 1335671999),(78, 0, 0, 5, 0, 5, 0, 0, 0, 1335671999),(75, 225, 31, 26, 19, 75, 20, 0, 0, 1335671999),(74, 203, 22, 23, 3, 52, 9, 0, 0, 1335671999),(73, 1010, 152, 31, 13, 56, 20, 0, 0, 1335671999),(72, 438, 63, 49, 38, 133, 67, 0, 0, 1335671999),(63, 336, 89, 50, 45, 114, 49, 0, 0, 1335671999),(62, 744, 73, 16, 3, 63, 35, 0, 0, 1335671999),(56, 430, 57, 23, 42, 76, 48, 2, 0, 1335671999),(55, 328, 50, 44, 33, 102, 73, 1, 0, 1335671999),(54, 1426, 153, 53, 5, 110, 10, 0, 0, 1335671999),(53, 0, 0, 17, 7, 25, 8, 0, 0, 1335671999),(52, 693, 70, 44, 19, 123, 28, 0, 0, 1335671999),(51, 1044, 116, 54, 11, 123, 14, 0, 0, 1335671999),(50, 552, 54, 23, 7, 64, 43, 0, 0, 1335671999),(49, 182, 18, 19, 7, 59, 15, 0, 0, 1335671999),(48, 2050, 193, 70, 46, 176, 53, 0, 0, 1335671999),(42, 374, 44, 39, 21, 96, 26, 0, 0, 1335671999),(41, 186, 8, 0, 0, 0, 0, 0, 0, 1335671999),(38, 690, 70, 32, 24, 78, 29, 0, 0, 1335671999),(33, 0, 0, 17, 8, 23, 10, 0, 0, 1335671999),(32, 779, 60, 37, 21, 90, 28, 0, 0, 1335671999),(31, 97, 8, 18, 14, 50, 26, 0, 0, 1335671999),(35, 0, 0, 13, 16, 27, 28, 0, 0, 1335671999),(29, 650, 80, 5, 0, 8, 0, 0, 0, 1335671999),(28, 478, 32, 22, 19, 40, 24, 0, 0, 1335671999),(34, 219, 31, 32, 12, 86, 21, 0, 0, 1335671999),(27, 990, 32, 22, 4, 35, 10, 0, 0, 1335671999),(39, 43, 6, 19, 2, 45, 26, 0, 0, 1335671999),(36, 1981, 300, 46, 19, 128, 28, 0, 0, 1335671999),(24, 871, 105, 11, 0, 12, 0, 0, 0, 1335671999),(23, 687, 107, 10, 0, 17, 0, 0, 0, 1335671999),(22, 667, 67, 51, 20, 140, 34, 0, 0, 1335671999),(21, 0, 0, 7, 1, 14, 1, 0, 0, 1335671999),(20, 4973, 301, 54, 0, 265, 8, 0, 0, 1335671999),(17, 0, 0, 7, 0, 10, 0, 0, 0, 1335671999),(14, 113, 19, 73, 27, 170, 75, 2, 0, 1335671999),(13, 146, 45, 23, 12, 69, 26, 0, 0, 1335671999),(9, 0, 0, 17, 5, 33, 13, 0, 0, 1335671999),(8, 1947, 354, 63, 29, 206, 38, 0, 0, 1335671999),(7, 81, 12, 35, 12, 79, 22, 3, 0, 1335671999),(6, 2010, 266, 70, 35, 226, 49, 0, 0, 1335671999),(5, 2773, 386, 82, 32, 311, 50, 2, 0, 1335671999),(4, 145, 7, 59, 8, 134, 17, 0, 0, 1335671999),(3, 1434, 121, 53, 9, 146, 18, 0, 0, 1335671999),(2, 8024, 676, 214, 41, 677, 163, 0, 0, 1335671999),(1, 0, 0, 19, 41, 52, 52, 3, 0, 1335671999);
    
    MySQL Error   : Unknown column 'posts' in 'field list'
    Error Number  : 1054
    Request Date  : Sunday, April 29th 2012 @ 12:03:06 AM
    Error Date    : Sunday, April 29th 2012 @ 12:03:06 AM
    Script        : http://www.47r-squad.com/cron.php?rand=1335672185
    Referrer      : http://www.47r-squad.com/ban-appeal-report-players/
    IP Address    : 99.172.36.183
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    Code:
    Database error in vBulletin 4.1.12:
    
    Invalid SQL:
    
    		INSERT INTO dbtech_vbanalytics_tracking_forums
    			(forumid, posts, threads, visits, bounces, pageviews, landings, referrals, conversions, dateline)
    		VALUES
    			(0, 39622, 4244, 1475, 558, 3626, 996, 11, 0, 1335326399),(79, 34, 8, 5, 0, 16, 0, 0, 0, 1335326399),(78, 0, 0, 5, 0, 5, 0, 0, 0, 1335326399),(75, 225, 31, 25, 9, 60, 10, 0, 0, 1335326399),(74, 189, 21, 19, 3, 37, 8, 0, 0, 1335326399),(73, 1010, 152, 25, 9, 41, 14, 0, 0, 1335326399),(72, 425, 62, 44, 33, 107, 54, 0, 0, 1335326399),(63, 336, 89, 47, 37, 96, 41, 0, 0, 1335326399),(62, 744, 73, 14, 3, 49, 26, 0, 0, 1335326399),(56, 430, 57, 22, 34, 60, 36, 2, 0, 1335326399),(55, 312, 48, 31, 21, 72, 57, 1, 0, 1335326399),(54, 1422, 153, 50, 1, 96, 6, 0, 0, 1335326399),(53, 0, 0, 16, 4, 20, 5, 0, 0, 1335326399),(52, 691, 70, 37, 16, 94, 19, 0, 0, 1335326399),(51, 1031, 113, 46, 7, 97, 10, 0, 0, 1335326399),(50, 551, 54, 22, 5, 53, 41, 0, 0, 1335326399),(49, 182, 18, 18, 5, 45, 9, 0, 0, 1335326399),(48, 2027, 193, 62, 37, 145, 41, 0, 0, 1335326399),(42, 368, 44, 35, 19, 75, 24, 0, 0, 1335326399),(41, 186, 8, 0, 0, 0, 0, 0, 0, 1335326399),(38, 690, 70, 29, 18, 62, 23, 0, 0, 1335326399),(33, 0, 0, 14, 6, 17, 8, 0, 0, 1335326399),(32, 770, 60, 31, 12, 71, 18, 0, 0, 1335326399),(31, 89, 7, 14, 13, 36, 23, 0, 0, 1335326399),(35, 0, 0, 13, 12, 20, 22, 0, 0, 1335326399),(29, 650, 80, 4, 0, 6, 0, 0, 0, 1335326399),(28, 478, 32, 21, 17, 34, 22, 0, 0, 1335326399),(34, 219, 31, 28, 11, 71, 12, 0, 0, 1335326399),(27, 990, 32, 19, 4, 28, 7, 0, 0, 1335326399),(39, 43, 6, 17, 2, 36, 21, 0, 0, 1335326399),(36, 1981, 300, 42, 15, 96, 22, 0, 0, 1335326399),(24, 870, 105, 11, 0, 12, 0, 0, 0, 1335326399),(23, 687, 107, 10, 0, 17, 0, 0, 0, 1335326399),(22, 645, 66, 46, 17, 111, 27, 0, 0, 1335326399),(21, 0, 0, 4, 0, 8, 0, 0, 0, 1335326399),(20, 4878, 294, 47, 0, 178, 4, 0, 0, 1335326399),(17, 0, 0, 6, 0, 9, 0, 0, 0, 1335326399),(14, 99, 16, 62, 21, 128, 50, 2, 0, 1335326399),(13, 145, 44, 21, 9, 55, 17, 0, 0, 1335326399),(9, 0, 0, 15, 2, 25, 10, 0, 0, 1335326399),(8, 1898, 348, 52, 22, 160, 27, 0, 0, 1335326399),(7, 81, 12, 31, 10, 64, 18, 3, 0, 1335326399),(6, 1984, 265, 64, 27, 183, 35, 0, 0, 1335326399),(5, 2730, 377, 66, 18, 222, 27, 0, 0, 1335326399),(4, 145, 7, 49, 4, 106, 9, 0, 0, 1335326399),(3, 1432, 121, 47, 6, 120, 15, 0, 0, 1335326399),(2, 7955, 670, 171, 37, 544, 137, 0, 0, 1335326399),(1, 0, 0, 18, 32, 39, 41, 3, 0, 1335326399);
    
    MySQL Error   : Unknown column 'posts' in 'field list'
    Error Number  : 1054
    Request Date  : Wednesday, April 25th 2012 @ 12:02:51 AM
    Error Date    : Wednesday, April 25th 2012 @ 12:02:51 AM
    Script        : http://www.47r-squad.com/cron.php?rand=287852
    Referrer      : http://www.47r-squad.com/index.php
    IP Address    : 208.107.37.70
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :

  2. #2
    Former Developer
    Level 0 (0 Loyalty Points)

    Total Downloaded
    0
    Gil
    1,682 (0 Banked)
    Total Downloaded
    0
    User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
    Join Date
    Jul 2010
    Posts
    474
    Points
    1,682
    Credits
    555
    Rep Power
    6

    Default

    The install file did not do what it's suppose to do. I don't know why vB always seems to have this problem.

    This change was made in v1.1.3.

    Please run the following query in phpmyadmin:

    Code:
    	ALTER TABLE `dbtech_vbanalytics_tracking_forums` 
    		CHANGE `replycount` `posts` INT( 10 ) UNSIGNED NOT NULL ,
    		CHANGE `threadcount` `threads` INT( 10 ) UNSIGNED NOT NULL ,
    		CHANGE `visits` `visits` INT( 10 ) UNSIGNED NOT NULL
    If you have a table prefix you will need to edit it in.

  3. #3
    Senior Member
    Level 6 (3,858 Loyalty Points)
    IcEWoLF's Avatar
    Total Downloaded
    0
    Gil
    2,634 (0 Banked)
    Total Downloaded
    0
    User Info Thanks / Tagging Info Gifts / Achievements / Awards Activity Stats
    Join Date
    Jul 2011
    Posts
    586
    Points
    2,634
    Credits
    260
    Rep Power
    4

    Default

    Quote Originally Posted by Pandemikk View Post
    The install file did not do what it's suppose to do. I don't know why vB always seems to have this problem.

    This change was made in v1.1.3.

    Please run the following query in phpmyadmin:

    Code:
    	ALTER TABLE `dbtech_vbanalytics_tracking_forums` 
    		CHANGE `replycount` `posts` INT( 10 ) UNSIGNED NOT NULL ,
    		CHANGE `threadcount` `threads` INT( 10 ) UNSIGNED NOT NULL ,
    		CHANGE `visits` `visits` INT( 10 ) UNSIGNED NOT NULL
    If you have a table prefix you will need to edit it in.
    Sweet, thank you!
    Hopefully no more issues.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. vBulletin Database Errors?
    By Boko577 in forum vBActivity & Awards Lite Support
    Replies: 2
    Last Post: 28th February 2010, 22:03

Tags for this Thread

Bookmarks

Posting Permissions

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