stats bug ?

[ljvd]

i have made the update to 1.4.8 version from the last version.
i meet a bug with the stats operation , more than 100%



and with messages like :
Moyenne des notes : 8.6400 sur 5 (25 Votes)

[Thorsten]

Hi,

I'll have a look at this issue.

bye
Thorsten

[Thorsten]

Hi,

is it possible to get a SQL dump of the table "faqvoting"?

Thanks!

bye
Thorsten

[ljvd]

is it possible to get a SQL dump of the table "faqvoting"?

of course you could have,
sorry for this time delay.i have only forget to choice "notify me"
take your time, holidays coming soon for my familly, so i'm not in hurry.

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
-- 
-- Serveur: ######
-- Généré le : Mardi 12 Juillet 2005 à 19:17
-- Version du serveur: 4.0.24
-- Version de PHP: 4.3.11
-- 
-- Base de données: `######`
-- 

-- --------------------------------------------------------

-- 
-- Structure de la table `faq_faqvoting`
-- 

CREATE TABLE `faq_faqvoting` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `artikel` int(11) unsigned NOT NULL default '0',
  `vote` int(11) unsigned NOT NULL default '0',
  `usr` int(11) NOT NULL default '0',
  `datum` varchar(20) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=102 ;

-- 
-- Contenu de la table `faq_faqvoting`
-- 

INSERT INTO `faq_faqvoting` VALUES (1, 1, 36, 9, '1083739496', '82.225.155.167');
INSERT INTO `faq_faqvoting` VALUES (2, 2, 82, 23, '1093278374', '83.115.164.197');
INSERT INTO `faq_faqvoting` VALUES (3, 7, 36, 8, '1083771725', '81.50.189.184');
INSERT INTO `faq_faqvoting` VALUES (4, 3, 4, 1, '1065716691', '217.109.166.224');
INSERT INTO `faq_faqvoting` VALUES (10, 8, 31, 8, '1094673695', '213.46.163.231');
INSERT INTO `faq_faqvoting` VALUES (5, 17, 10, 2, '1065894051', '217.109.166.224');
INSERT INTO `faq_faqvoting` VALUES (6, 4, 14, 5, '1074156019', '80.13.97.231');
INSERT INTO `faq_faqvoting` VALUES (7, 13, 17, 4, '1085150162', '80.14.87.101');
INSERT INTO `faq_faqvoting` VALUES (8, 26, 10, 2, '1087300600', '195.124.18.133');
INSERT INTO `faq_faqvoting` VALUES (9, 18, 30, 7, '1086985207', '84.97.168.169');
INSERT INTO `faq_faqvoting` VALUES (11, 21, 38, 9, '1093948096', '84.97.3.200');
INSERT INTO `faq_faqvoting` VALUES (12, 27, 13, 3, '1074880845', '217.109.166.224');
INSERT INTO `faq_faqvoting` VALUES (13, 32, 5, 1, '1068058479', '217.109.166.224');
INSERT INTO `faq_faqvoting` VALUES (14, 42, 12, 3, '1090574175', '82.225.155.167');
INSERT INTO `faq_faqvoting` VALUES (15, 16, 115, 29, '1096470885', '81.242.224.110');
INSERT INTO `faq_faqvoting` VALUES (16, 33, 56, 12, '1097232711', '213.154.84.252');
INSERT INTO `faq_faqvoting` VALUES (18, 28, 2, 1, '1073724813', '80.12.31.172');
INSERT INTO `faq_faqvoting` VALUES (17, 29, 11, 3, '1083850714', '82.226.214.172');
INSERT INTO `faq_faqvoting` VALUES (19, 48, 12, 3, '1084012923', '62.251.162.2');
INSERT INTO `faq_faqvoting` VALUES (20, 41, 10, 3, '1092841625', '216.213.95.146');
INSERT INTO `faq_faqvoting` VALUES (21, 31, 10, 2, '1084267289', '195.93.97.177');
INSERT INTO `faq_faqvoting` VALUES (22, 23, 6, 2, '1086859002', '212.24.218.254');
INSERT INTO `faq_faqvoting` VALUES (23, 5, 4, 1, '1082985106', '82.225.155.167');
INSERT INTO `faq_faqvoting` VALUES (24, 10, 5, 1, '1083739590', '82.225.155.167');
INSERT INTO `faq_faqvoting` VALUES (25, 11, 6, 2, '1094744467', '80.11.80.15');
INSERT INTO `faq_faqvoting` VALUES (26, 20, 5, 1, '1083739647', '82.225.155.167');
INSERT INTO `faq_faqvoting` VALUES (27, 6, 5, 1, '1083739849', '82.225.155.167');
INSERT INTO `faq_faqvoting` VALUES (28, 43, 5, 1, '1084269444', '195.93.102.8');
INSERT INTO `faq_faqvoting` VALUES (29, 44, 5, 1, '1084272263', '195.93.102.36');
INSERT INTO `faq_faqvoting` VALUES (30, 37, 1, 1, '1084883096', '81.240.223.102');
INSERT INTO `faq_faqvoting` VALUES (31, 49, 5, 3, '1091177568', '195.132.229.195');
INSERT INTO `faq_faqvoting` VALUES (34, 51, 10, 2, '1090350807', '83.155.27.191');
INSERT INTO `faq_faqvoting` VALUES (32, 34, 19, 4, '1097178904', '81.51.29.194');
INSERT INTO `faq_faqvoting` VALUES (33, 38, 5, 1, '1087551096', '82.225.155.167');
INSERT INTO `faq_faqvoting` VALUES (35, 52, 17, 4, '1095491800', '82.225.155.167');
INSERT INTO `faq_faqvoting` VALUES (36, 48, 5, 1, '1097503245', '193.55.130.208');
INSERT INTO `faq_faqvoting` VALUES (37, 2, 4, 1, '1097671471', '83.77.218.156');
INSERT INTO `faq_faqvoting` VALUES (38, 42, 3, 1, '1097707517', '66.131.235.7');
INSERT INTO `faq_faqvoting` VALUES (39, 16, 4, 1, '1098432292', '213.228.0.12');
INSERT INTO `faq_faqvoting` VALUES (40, 9, 4, 1, '1098568008', '82.123.60.112');
INSERT INTO `faq_faqvoting` VALUES (41, 16, 4, 1, '1098700297', '82.226.77.83');
INSERT INTO `faq_faqvoting` VALUES (42, 16, 4, 1, '1098700745', '82.226.77.83');
INSERT INTO `faq_faqvoting` VALUES (43, 42, 4, 1, '1098785077', '194.3.30.248');
INSERT INTO `faq_faqvoting` VALUES (44, 44, 4, 1, '1098954476', '81.250.149.241');
INSERT INTO `faq_faqvoting` VALUES (45, 7, 4, 1, '1098963303', '80.15.205.204');
INSERT INTO `faq_faqvoting` VALUES (46, 17, 4, 1, '1098963335', '80.15.205.204');
INSERT INTO `faq_faqvoting` VALUES (47, 16, 4, 1, '1098963443', '80.15.205.204');
INSERT INTO `faq_faqvoting` VALUES (48, 42, 4, 1, '1098963573', '80.15.205.204');
INSERT INTO `faq_faqvoting` VALUES (49, 8, 4, 1, '1098963632', '80.15.205.204');
INSERT INTO `faq_faqvoting` VALUES (50, 16, 4, 1, '1099401300', '82.122.51.37');
INSERT INTO `faq_faqvoting` VALUES (51, 2, 4, 1, '1099645344', '62.39.41.78');
INSERT INTO `faq_faqvoting` VALUES (52, 4, 2, 1, '1100438649', '80.9.218.197');
INSERT INTO `faq_faqvoting` VALUES (53, 52, 4, 1, '1100861364', '82.66.7.9');
INSERT INTO `faq_faqvoting` VALUES (54, 2, 4, 1, '1101052959', '81.192.247.247');
INSERT INTO `faq_faqvoting` VALUES (55, 16, 4, 1, '1101302958', '80.12.157.90');
INSERT INTO `faq_faqvoting` VALUES (56, 16, 4, 1, '1101403403', '194.78.182.51');
INSERT INTO `faq_faqvoting` VALUES (57, 33, 4, 1, '1101403510', '194.78.182.51');
INSERT INTO `faq_faqvoting` VALUES (58, 48, 5, 1, '1101406819', '81.192.165.237');
INSERT INTO `faq_faqvoting` VALUES (59, 16, 5, 1, '1102083561', '82.226.106.95');
INSERT INTO `faq_faqvoting` VALUES (60, 16, 5, 1, '1102341063', '81.251.3.148');
INSERT INTO `faq_faqvoting` VALUES (61, 34, 3, 1, '1102414139', '83.113.172.203');
INSERT INTO `faq_faqvoting` VALUES (62, 34, 4, 1, '1102602086', '193.57.141.147');
INSERT INTO `faq_faqvoting` VALUES (63, 16, 3, 1, '1103467123', '195.93.102.35');
INSERT INTO `faq_faqvoting` VALUES (64, 7, 5, 1, '1103468418', '195.93.102.34');
INSERT INTO `faq_faqvoting` VALUES (65, 16, 5, 1, '1103701275', '82.120.31.226');
INSERT INTO `faq_faqvoting` VALUES (66, 38, 1, 1, '1103868127', '81.51.198.147');
INSERT INTO `faq_faqvoting` VALUES (67, 8, 2, 1, '1104105520', '195.93.102.7');
INSERT INTO `faq_faqvoting` VALUES (68, 16, 5, 1, '1104314126', '193.253.60.90');
INSERT INTO `faq_faqvoting` VALUES (69, 16, 5, 1, '1104314452', '193.253.60.90');
INSERT INTO `faq_faqvoting` VALUES (70, 52, 1, 1, '1104761931', '213.41.174.23');
INSERT INTO `faq_faqvoting` VALUES (71, 52, 4, 1, '1104998862', '194.254.27.13');
INSERT INTO `faq_faqvoting` VALUES (72, 52, 4, 1, '1105000500', '194.254.27.13');
INSERT INTO `faq_faqvoting` VALUES (73, 41, 1, 1, '1105023790', '195.101.134.148');
INSERT INTO `faq_faqvoting` VALUES (74, 38, 3, 1, '1105135414', '82.123.6.4');
INSERT INTO `faq_faqvoting` VALUES (75, 34, 2, 1, '1105369688', '212.198.215.10');
INSERT INTO `faq_faqvoting` VALUES (76, 8, 4, 1, '1105372131', '193.41.238.173');
INSERT INTO `faq_faqvoting` VALUES (77, 2, 4, 1, '1105372506', '193.41.238.173');
INSERT INTO `faq_faqvoting` VALUES (78, 1, 1, 1, '1105372569', '193.41.238.173');
INSERT INTO `faq_faqvoting` VALUES (79, 16, 4, 1, '1105626003', '82.127.205.78');
INSERT INTO `faq_faqvoting` VALUES (80, 16, 5, 1, '1105820772', '212.194.8.34');
INSERT INTO `faq_faqvoting` VALUES (81, 2, 2, 1, '1106294955', '195.132.26.27');
INSERT INTO `faq_faqvoting` VALUES (82, 16, 4, 1, '1106901293', '83.197.107.247');
INSERT INTO `faq_faqvoting` VALUES (83, 29, 4, 1, '1106902018', '83.197.107.247');
INSERT INTO `faq_faqvoting` VALUES (84, 16, 3, 1, '1106945614', '84.100.111.228');
INSERT INTO `faq_faqvoting` VALUES (85, 16, 3, 1, '1107333570', '82.122.46.64');
INSERT INTO `faq_faqvoting` VALUES (86, 16, 4, 1, '1108560895', '82.127.27.83');
INSERT INTO `faq_faqvoting` VALUES (87, 16, 4, 1, '1108683057', '80.15.18.231');
INSERT INTO `faq_faqvoting` VALUES (88, 16, 4, 1, '1108992275', '195.154.167.66');
INSERT INTO `faq_faqvoting` VALUES (89, 2, 3, 1, '1110278018', '194.3.169.213');
INSERT INTO `faq_faqvoting` VALUES (90, 8, 4, 1, '1110278116', '194.3.169.213');
INSERT INTO `faq_faqvoting` VALUES (91, 16, 5, 1, '1112603732', '212.195.147.60');
INSERT INTO `faq_faqvoting` VALUES (92, 17, 3, 1, '1113142867', '83.115.43.86');
INSERT INTO `faq_faqvoting` VALUES (93, 2, 3, 1, '1113827575', '82.127.3.245');
INSERT INTO `faq_faqvoting` VALUES (94, 33, 4, 1, '1113827756', '82.127.3.245');
INSERT INTO `faq_faqvoting` VALUES (95, 32, 1, 1, '1113989234', '212.42.77.14');
INSERT INTO `faq_faqvoting` VALUES (96, 16, 5, 1, '1116114278', '81.57.225.42');
INSERT INTO `faq_faqvoting` VALUES (97, 33, 3, 1, '1117569322', '84.99.109.254');
INSERT INTO `faq_faqvoting` VALUES (98, 16, 4, 1, '1119005048', '82.67.127.100');
INSERT INTO `faq_faqvoting` VALUES (99, 45, 4, 1, '1119397028', '82.225.155.167');
INSERT INTO `faq_faqvoting` VALUES (100, 34, 3, 1, '1121029157', '83.192.28.131');
INSERT INTO `faq_faqvoting` VALUES (101, 16, 3, 1, '1121076432', '82.123.16.141');

[Thorsten]

Hi,

thanks a lot, I'll check this as soon as possible!

bye
Thorsten