Status
Not open for further replies.

IcEWoLF

Customer
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.
 
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. :)
 
Status
Not open for further replies.

Legacy vBAnalytics

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
401
Customer rating
0.00 star(s) 0 ratings
Back
Top