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 :

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.

Originally Posted by Pandemikk

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.