Votings von alter Version in neue Version importieren

brakai295 · Post by **brakai295** » Thu Aug 18, 2005 2:49 pm

Hallo,

ich habe eben die Datenbank meiner alten Version in die meiner neuen Version von phpMyFAQ (1.5.0 RC6) importiert. Dabei ist mir ein kleiner Fehler aufgefallen.

Und zwar gibt es da anscheinend ein Problem bei der Verwertung der Voting-Daten. Unter meinen Artikeln ist nun sowas wie

Code: Select all

Durchschnittliche Bewertung: 12 von 5 (1 Bewertungen)

zu lesen.

Irgendeine Idee woher das kommt?

Liebe Gruesse

Kai

Post by **Thorsten** » Thu Aug 18, 2005 2:53 pm

Hi,

kannst du mir deine faqvoting-Tabelle zusenden?

bye
Thorsten

brakai295 · Post by **brakai295** » Thu Aug 18, 2005 3:12 pm

here we go:

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 19, 2005 at 12:03 AM
-- Server version: 4.1.8
-- PHP Version: 5.0.3
-- 
-- Database: `faq`
-- 

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

-- 
-- Table structure for table `faq2faqvoting`
-- 

CREATE TABLE `faq2faqvoting` (
  `id` int(11) unsigned NOT NULL default '0',
  `artikel` int(11) unsigned NOT NULL default '0',
  `vote` int(11) unsigned NOT NULL default '0',
  `usr` int(11) unsigned NOT NULL default '0',
  `datum` varchar(20) collate latin1_general_ci NOT NULL default '',
  `ip` varchar(15) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- 
-- Dumping data for table `faq2faqvoting`
-- 

INSERT INTO `faq2faqvoting` VALUES (1, 1, 18, 6, '1113753862', '217.249.86.146');
INSERT INTO `faq2faqvoting` VALUES (2, 2, 25, 6, '1114898029', '217.93.211.253');
INSERT INTO `faq2faqvoting` VALUES (3, 6, 17, 4, '1115186460', '217.85.191.229');
INSERT INTO `faq2faqvoting` VALUES (4, 14, 67, 14, '1120216955', '84.58.150.53');
INSERT INTO `faq2faqvoting` VALUES (5, 15, 23, 5, '1106053258', '220.235.83.112');
INSERT INTO `faq2faqvoting` VALUES (6, 12, 25, 5, '1113754720', '217.249.86.146');
INSERT INTO `faq2faqvoting` VALUES (7, 3, 29, 6, '1115376815', '84.191.216.136');
INSERT INTO `faq2faqvoting` VALUES (8, 13, 9, 2, '1092734663', '212.59.63.12');
INSERT INTO `faq2faqvoting` VALUES (9, 19, 42, 9, '1115380813', '212.144.18.118');
INSERT INTO `faq2faqvoting` VALUES (10, 4, 22, 5, '1118176848', '217.250.19.102');
INSERT INTO `faq2faqvoting` VALUES (11, 7, 3, 1, '1092734216', '212.59.63.12');
INSERT INTO `faq2faqvoting` VALUES (12, 25, 3, 1, '1092734531', '212.59.63.12');
INSERT INTO `faq2faqvoting` VALUES (13, 18, 29, 6, '1119488494', '59.167.69.66');
INSERT INTO `faq2faqvoting` VALUES (14, 11, 24, 5, '1117538568', '84.155.24.18');
INSERT INTO `faq2faqvoting` VALUES (15, 16, 17, 4, '1110298609', '217.246.188.64');
INSERT INTO `faq2faqvoting` VALUES (16, 9, 9, 3, '1114134175', '59.167.70.183');
INSERT INTO `faq2faqvoting` VALUES (17, 34, 6, 2, '1099318596', '217.231.83.69');
INSERT INTO `faq2faqvoting` VALUES (18, 22, 20, 4, '1122889903', '85.73.188.193');
INSERT INTO `faq2faqvoting` VALUES (19, 33, 12, 4, '1114791337', '134.2.3.102');
INSERT INTO `faq2faqvoting` VALUES (20, 38, 29, 6, '1111858171', '84.56.232.173');
INSERT INTO `faq2faqvoting` VALUES (21, 37, 33, 7, '1113025770', '59.167.70.200');
INSERT INTO `faq2faqvoting` VALUES (22, 24, 4, 1, '1106093038', '220.235.82.1');
INSERT INTO `faq2faqvoting` VALUES (23, 20, 7, 2, '1117358572', '84.141.95.192');
INSERT INTO `faq2faqvoting` VALUES (24, 10, 5, 1, '1108049452', '80.228.161.54');
INSERT INTO `faq2faqvoting` VALUES (25, 39, 11, 4, '1120956026', '84.161.77.247');
INSERT INTO `faq2faqvoting` VALUES (26, 45, 5, 1, '1113755021', '217.249.86.146');
INSERT INTO `faq2faqvoting` VALUES (27, 26, 5, 1, '1114134122', '59.167.70.183');
INSERT INTO `faq2faqvoting` VALUES (28, 44, 4, 2, '1117665124', '84.188.238.43');
INSERT INTO `faq2faqvoting` VALUES (29, 21, 4, 1, '1114438343', '59.167.70.183');
INSERT INTO `faq2faqvoting` VALUES (30, 48, 55, 12, '1122477082', '84.180.103.111');
INSERT INTO `faq2faqvoting` VALUES (31, 23, 5, 1, '1114709702', '80.137.208.116');
INSERT INTO `faq2faqvoting` VALUES (32, 47, 5, 1, '1115214351', '217.184.133.198');
INSERT INTO `faq2faqvoting` VALUES (33, 50, 13, 3, '1118291799', '62.180.53.220');
INSERT INTO `faq2faqvoting` VALUES (34, 53, 12, 3, '1120383322', '59.167.74.137');
INSERT INTO `faq2faqvoting` VALUES (35, 8, 5, 1, '1124081459', '127');

Post by **Thorsten** » Thu Aug 18, 2005 6:06 pm

Hi,

danke, ist in 1.5.0 und 1.6.0-dev gefixt.

bye
Thorsten

brakai295 · Post by **brakai295** » Fri Aug 19, 2005 4:04 am

hi,

kannst du mir sagen, wie ich das in meinem laufenden system fixen kann?

die seite ist uebrigens online: www.ausmag.de/australien_faq

dort kannst du auch sehen, was mit den votings nicht stimmt :-/

vielen dank

gruesse
kai

Post by **Thorsten** » Fri Aug 19, 2005 6:27 am

Hi,

suche mal in der Datei inc/functions.php ab der Zeile 700 nach der Funktion generateVoting(). Tausche sie gegen diese hier aus:

Code: Select all

function generateVoting($id)
{
	global $db, $PMF_LANG;
 	$result = $db->query(sprintf('SELECT (vote/usr) as voting, usr FROM %sfaqvoting WHERE artikel = %d', SQLPREFIX, $id));
	if ($db->num_rows($result) > 0) {
        list($vote, $user) = $db->fetch_row($result);
        return " ".round($vote, 2)." ".$PMF_LANG["msgVoteFrom"]." 5 (".$user." ".$PMF_LANG["msgVotings"].")";
	} else {
		return " 0 ".$PMF_LANG["msgVoteFrom"]." 5 (0 ".$PMF_LANG["msgVotings"].")";
	}
}

Deine FAQ sieht wirklich geil aus!!

bye
Thorsten

brakai295 · Post by **brakai295** » Sat Aug 20, 2005 1:11 am

vielen vielen dank! hat einwandfrei geklappt!

danke auch fuer dein kompliment. du kannst meine seite gerne in deine referenzen aufnehmen, wenn du moechtest

lg

kai

Denise_van_Hoorn · Post by **Denise_van_Hoorn** » Mon Jan 02, 2006 11:20 am

Moin,

wenn ich meine Bewertungsstatistik aufrufe (Version 1.5.3) dann werden einige Artikel durchaus doppelt (mit jeweils eigener Wertung) und manche sogar dreimal aufgelistet (ebenfalls mit jeweils eigener Wertung). Ich habe von der Version 1.4.? upgedatet.

Aufgefallen ist mir auch daÃŸ die Session-Logs nicht in chronolischer Reihenfolge aufgelistet waren, wenn ich nicht irre, habe ich Thorsten aber den korrigierten Code zugesandt. Nur um das Problem zu beheben, reicht mein PHP nicht...

Liebe GrÃ¼ÃŸe

Denise

Post by **Thorsten** » Mon Jan 02, 2006 11:22 am

Hi,

das habe ich IMHO in der Version 1.5.4 oder 1.5.5 korrigiert und sollte nun passen.

bye
Thorsten

Denise_van_Hoorn · Post by **Denise_van_Hoorn** » Mon Jan 09, 2006 5:41 pm

Leider nein. Das Problem besteht immer noch. Bin ich zu blÃ¶d, habbich was falschgemacht?

Hier mal die Tabelle:

# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Erstellungszeit: 09. Januar 2006 um 17:39
# Server Version: 4.0.18
# PHP-Version: 4.3.4
#
# Datenbank: `phpMyFAQ`
#

# --------------------------------------------------------

#
# Tabellenstruktur fÃ¼r Tabelle `faqvoting`
#

CREATE TABLE `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) unsigned NOT NULL default '0',
`datum` varchar(20) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=282 ;

#
# Daten fÃ¼r Tabelle `faqvoting`
#

INSERT INTO `faqvoting` VALUES (1, 12, 23, 5, '1134986039', '164.128.54.35');
INSERT INTO `faqvoting` VALUES (2, 6, 48, 12, '1102393852', '204.95.48.174');
INSERT INTO `faqvoting` VALUES (3, 14, 56, 14, '1134983134', '195.93.60.12');
INSERT INTO `faqvoting` VALUES (4, 27, 44, 13, '1132262072', '213.6.80.84');
INSERT INTO `faqvoting` VALUES (5, 29, 101, 43, '1134916123', '195.14.216.94');
INSERT INTO `faqvoting` VALUES (6, 8, 26, 8, '1131407199', '85.75.51.83');
INSERT INTO `faqvoting` VALUES (7, 17, 16, 4, '1087224051', '217.255.253.59');
INSERT INTO `faqvoting` VALUES (8, 10, 29, 9, '1134581311', '87.78.7.182');
INSERT INTO `faqvoting` VALUES (9, 36, 7, 3, '1096839753', '80.108.120.74');
INSERT INTO `faqvoting` VALUES (10, 13, 17, 5, '1096881959', '81.164.224.38');
INSERT INTO `faqvoting` VALUES (11, 41, 27, 7, '1132187727', '84.145.97.198');
INSERT INTO `faqvoting` VALUES (12, 42, 13, 3, '1092630362', '217.208.46.189');
INSERT INTO `faqvoting` VALUES (13, 43, 20, 6, '1102785556', '217.88.68.39');
INSERT INTO `faqvoting` VALUES (14, 22, 108, 30, '1131366641', '85.72.149.86');
INSERT INTO `faqvoting` VALUES (15, 40, 22, 6, '1100270735', '80.219.145.87');
INSERT INTO `faqvoting` VALUES (16, 64, 6, 2, '20030613102240', '');
INSERT INTO `faqvoting` VALUES (18, 62, 36, 8, '1107184521', '217.224.198.2');
INSERT INTO `faqvoting` VALUES (19, 68, 31, 7, '1087482113', '217.234.227.193');
INSERT INTO `faqvoting` VALUES (20, 75, 58, 18, '1131282165', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (21, 70, 10, 2, '1100870908', '217.227.108.224');
INSERT INTO `faqvoting` VALUES (27, 15, 39, 10, '1136155255', '62.59.108.5');
INSERT INTO `faqvoting` VALUES (23, 9, 52, 17, '1107123611', '81.182.10.143');
INSERT INTO `faqvoting` VALUES (26, 76, 2, 1, '20030930012750', '');
INSERT INTO `faqvoting` VALUES (28, 24, 105, 30, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (29, 58, 27, 7, '1096750318', '217.231.50.59');
INSERT INTO `faqvoting` VALUES (30, 84, 15, 3, '1072216893', '80.219.91.34');
INSERT INTO `faqvoting` VALUES (31, 28, 17, 5, '1136207136', '212.152.9.36');
INSERT INTO `faqvoting` VALUES (32, 71, 9, 3, '1102752400', '212.41.73.177');
INSERT INTO `faqvoting` VALUES (33, 82, 70, 17, '1136215405', '84.183.115.89');
INSERT INTO `faqvoting` VALUES (34, 81, 16, 4, '1087420952', '80.142.168.75');
INSERT INTO `faqvoting` VALUES (35, 2, 13, 6, '1101599832', '220.7.160.37');
INSERT INTO `faqvoting` VALUES (36, 86, 59, 16, '1096050864', '62.180.98.84');
INSERT INTO `faqvoting` VALUES (37, 73, 21, 7, '1078687848', '217.187.57.40');
INSERT INTO `faqvoting` VALUES (38, 5, 5, 1, '1072550413', '194.152.106.10');
INSERT INTO `faqvoting` VALUES (39, 25, 21, 6, '1079038227', '217.85.122.171');
INSERT INTO `faqvoting` VALUES (40, 67, 23, 5, '1084269392', '195.158.152.115');
INSERT INTO `faqvoting` VALUES (41, 85, 6, 2, '1073667881', '217.230.209.178');
INSERT INTO `faqvoting` VALUES (42, 87, 19, 5, '1108114271', '62.159.197.66');
INSERT INTO `faqvoting` VALUES (43, 88, 15, 4, '1096750049', '217.231.50.59');
INSERT INTO `faqvoting` VALUES (44, 72, 24, 6, '1108406378', '217.246.18.40');
INSERT INTO `faqvoting` VALUES (45, 23, 7, 3, '1104747590', '81.156.179.215');
INSERT INTO `faqvoting` VALUES (64, 99, 7, 2, '1108811124', '217.93.177.163');
INSERT INTO `faqvoting` VALUES (46, 91, 28, 9, '1132935495', '80.171.59.2');
INSERT INTO `faqvoting` VALUES (47, 20, 1, 1, '1074893207', '145.254.113.35');
INSERT INTO `faqvoting` VALUES (48, 66, 6, 3, '1084741781', '81.182.10.178');
INSERT INTO `faqvoting` VALUES (49, 30, 63, 23, '1108917479', '217.232.197.36');
INSERT INTO `faqvoting` VALUES (50, 89, 11, 3, '1089710926', '217.49.84.137');
INSERT INTO `faqvoting` VALUES (51, 18, 7, 2, '1088990589', '217.231.85.3');
INSERT INTO `faqvoting` VALUES (52, 53, 7, 3, '1097086927', '82.83.112.187');
INSERT INTO `faqvoting` VALUES (53, 50, 5, 1, '1075494466', '195.93.66.9');
INSERT INTO `faqvoting` VALUES (54, 7, 16, 4, '1133732595', '84.226.63.140');
INSERT INTO `faqvoting` VALUES (55, 32, 4, 1, '1077012374', '195.93.66.16');
INSERT INTO `faqvoting` VALUES (56, 16, 16, 5, '1105279634', '80.170.29.45');
INSERT INTO `faqvoting` VALUES (57, 54, 27, 10, '1108849206', '217.84.42.113');
INSERT INTO `faqvoting` VALUES (58, 59, 6, 2, '1096750357', '217.231.50.59');
INSERT INTO `faqvoting` VALUES (59, 74, 4, 4, '1131282102', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (60, 100, 7, 3, '1108956503', '80.142.46.119');
INSERT INTO `faqvoting` VALUES (61, 44, 9, 2, '1082053964', '217.184.104.160');
INSERT INTO `faqvoting` VALUES (62, 94, 10, 2, '1101430331', '80.128.18.17');
INSERT INTO `faqvoting` VALUES (63, 47, 11, 3, '1108732926', '84.58.19.241');
INSERT INTO `faqvoting` VALUES (65, 37, 6, 2, '1102212460', '213.23.155.184');
INSERT INTO `faqvoting` VALUES (66, 104, 3, 1, '1080068630', '195.93.65.5');
INSERT INTO `faqvoting` VALUES (67, 106, 18, 4, '1130171141', '84.182.194.135');
INSERT INTO `faqvoting` VALUES (68, 55, 5, 1, '1081422803', '195.93.66.15');
INSERT INTO `faqvoting` VALUES (69, 102, 14, 4, '1103836935', '84.72.166.128');
INSERT INTO `faqvoting` VALUES (70, 110, 12, 5, '1089924034', '217.235.17.35');
INSERT INTO `faqvoting` VALUES (71, 109, 13, 6, '1108917260', '217.232.197.36');
INSERT INTO `faqvoting` VALUES (72, 107, 16, 5, '1132032360', '195.93.60.11');
INSERT INTO `faqvoting` VALUES (73, 112, 2, 2, '1090163894', '217.245.171.116');
INSERT INTO `faqvoting` VALUES (74, 113, 14, 7, '1090954102', '195.93.72.10');
INSERT INTO `faqvoting` VALUES (75, 26, 10, 2, '1096749936', '217.231.50.59');
INSERT INTO `faqvoting` VALUES (76, 93, 2, 2, '1089795642', '195.93.74.22');
INSERT INTO `faqvoting` VALUES (77, 78, 5, 1, '1087224176', '217.255.253.59');
INSERT INTO `faqvoting` VALUES (78, 69, 5, 1, '1088991298', '217.231.85.3');
INSERT INTO `faqvoting` VALUES (79, 4, 2, 2, '1101214869', '222.158.48.138');
INSERT INTO `faqvoting` VALUES (80, 120, 28, 8, '1133028334', '84.131.13.65');
INSERT INTO `faqvoting` VALUES (81, 98, 5, 1, '1092991226', '195.93.60.44');
INSERT INTO `faqvoting` VALUES (82, 56, 5, 1, '1096750203', '217.231.50.59');
INSERT INTO `faqvoting` VALUES (83, 57, 5, 1, '1096750255', '217.231.50.59');
INSERT INTO `faqvoting` VALUES (84, 123, 5, 2, '1103462573', '217.229.138.179');
INSERT INTO `faqvoting` VALUES (85, 124, 3, 1, '1100369492', '217.252.73.147');
INSERT INTO `faqvoting` VALUES (86, 38, 5, 1, '1102212441', '213.23.155.184');
INSERT INTO `faqvoting` VALUES (87, 33, 5, 1, '1102212594', '213.23.155.184');
INSERT INTO `faqvoting` VALUES (88, 134, 18, 4, '1108848605', '217.84.42.113');
INSERT INTO `faqvoting` VALUES (89, 11, 3, 1, '1105110237', '84.128.109.198');
INSERT INTO `faqvoting` VALUES (90, 135, 6, 2, '1108288653', '85.74.153.170');
INSERT INTO `faqvoting` VALUES (91, 128, 3, 1, '1107562780', '217.227.104.43');
INSERT INTO `faqvoting` VALUES (92, 138, 8, 2, '1108497200', '217.230.143.20');
INSERT INTO `faqvoting` VALUES (93, 148, 5, 1, '1109254253', '213.191.94.100');
INSERT INTO `faqvoting` VALUES (94, 40, 1, 1, '1109351848', '80.219.189.107');
INSERT INTO `faqvoting` VALUES (95, 15, 6, 2, '1136155255', '62.59.108.5');
INSERT INTO `faqvoting` VALUES (96, 2, 4, 1, '1109370718', '149.225.0.172');
INSERT INTO `faqvoting` VALUES (97, 72, 4, 1, '1109427544', '195.93.60.7');
INSERT INTO `faqvoting` VALUES (98, 121, 4, 1, '1109428134', '195.93.60.8');
INSERT INTO `faqvoting` VALUES (99, 14, 11, 3, '1134983134', '195.93.60.12');
INSERT INTO `faqvoting` VALUES (100, 100, 5, 1, '1110108629', '217.81.50.63');
INSERT INTO `faqvoting` VALUES (101, 24, 12, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (102, 9, 5, 1, '1110393429', '217.184.16.165');
INSERT INTO `faqvoting` VALUES (103, 29, 14, 5, '1134916123', '195.14.216.94');
INSERT INTO `faqvoting` VALUES (104, 29, 11, 5, '1134916123', '195.14.216.94');
INSERT INTO `faqvoting` VALUES (105, 138, 1, 1, '1110706965', '217.84.44.206');
INSERT INTO `faqvoting` VALUES (106, 152, 20, 4, '1136813318', '84.56.107.73');
INSERT INTO `faqvoting` VALUES (107, 29, 14, 5, '1134916123', '195.14.216.94');
INSERT INTO `faqvoting` VALUES (108, 93, 1, 1, '1110808175', '84.60.10.241');
INSERT INTO `faqvoting` VALUES (109, 152, 16, 4, '1136813318', '84.56.107.73');
INSERT INTO `faqvoting` VALUES (110, 73, 2, 1, '1110963157', '213.7.42.2');
INSERT INTO `faqvoting` VALUES (111, 30, 5, 1, '1110986285', '213.58.134.141');
INSERT INTO `faqvoting` VALUES (112, 75, 9, 2, '1131282165', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (113, 9, 3, 1, '1111097716', '68.117.67.175');
INSERT INTO `faqvoting` VALUES (114, 128, 5, 1, '1111183127', '83.77.82.9');
INSERT INTO `faqvoting` VALUES (115, 157, 4, 2, '1135198705', '84.137.249.53');
INSERT INTO `faqvoting` VALUES (116, 42, 5, 1, '1111677982', '149.225.216.174');
INSERT INTO `faqvoting` VALUES (117, 22, 14, 3, '1131366641', '85.72.149.86');
INSERT INTO `faqvoting` VALUES (118, 29, 10, 5, '1134916123', '195.14.216.94');
INSERT INTO `faqvoting` VALUES (119, 106, 10, 2, '1130171141', '84.182.194.135');
INSERT INTO `faqvoting` VALUES (120, 120, 6, 2, '1133028334', '84.131.13.65');
INSERT INTO `faqvoting` VALUES (121, 157, 5, 2, '1135198705', '84.137.249.53');
INSERT INTO `faqvoting` VALUES (122, 105, 5, 1, '1112441065', '84.153.88.193');
INSERT INTO `faqvoting` VALUES (123, 99, 1, 1, '1112464838', '84.57.0.230');
INSERT INTO `faqvoting` VALUES (124, 24, 13, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (125, 75, 5, 2, '1131282165', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (126, 14, 11, 3, '1134983134', '195.93.60.12');
INSERT INTO `faqvoting` VALUES (127, 15, 7, 2, '1136155255', '62.59.108.5');
INSERT INTO `faqvoting` VALUES (128, 9, 5, 1, '1113066910', '213.202.35.102');
INSERT INTO `faqvoting` VALUES (129, 29, 11, 5, '1134916123', '195.14.216.94');
INSERT INTO `faqvoting` VALUES (130, 71, 1, 1, '1113237440', '80.109.56.30');
INSERT INTO `faqvoting` VALUES (131, 24, 11, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (132, 75, 8, 2, '1131282165', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (133, 24, 10, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (134, 106, 7, 2, '1130171141', '84.182.194.135');
INSERT INTO `faqvoting` VALUES (135, 155, 9, 3, '1133467146', '84.182.89.156');
INSERT INTO `faqvoting` VALUES (136, 30, 3, 1, '1113511479', '80.186.119.58');
INSERT INTO `faqvoting` VALUES (137, 24, 11, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (138, 24, 13, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (139, 128, 5, 1, '1115211343', '132.199.3.226');
INSERT INTO `faqvoting` VALUES (140, 24, 10, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (141, 44, 4, 1, '1115282191', '84.178.55.217');
INSERT INTO `faqvoting` VALUES (142, 17, 5, 1, '1115305316', '80.171.11.85');
INSERT INTO `faqvoting` VALUES (143, 58, 5, 1, '1115306071', '80.171.11.85');
INSERT INTO `faqvoting` VALUES (144, 120, 6, 2, '1133028334', '84.131.13.65');
INSERT INTO `faqvoting` VALUES (145, 22, 14, 3, '1131366641', '85.72.149.86');
INSERT INTO `faqvoting` VALUES (146, 93, 4, 1, '1115678388', '84.150.180.110');
INSERT INTO `faqvoting` VALUES (147, 30, 5, 1, '1115678730', '84.150.180.110');
INSERT INTO `faqvoting` VALUES (148, 106, 7, 2, '1130171141', '84.182.194.135');
INSERT INTO `faqvoting` VALUES (149, 67, 1, 1, '1116787123', '62.134.24.1');
INSERT INTO `faqvoting` VALUES (150, 134, 4, 1, '1116841743', '62.214.29.95');
INSERT INTO `faqvoting` VALUES (151, 12, 10, 2, '1134986039', '164.128.54.35');
INSERT INTO `faqvoting` VALUES (152, 128, 5, 1, '1116842528', '62.214.29.95');
INSERT INTO `faqvoting` VALUES (153, 133, 1, 1, '1116861995', '84.167.145.237');
INSERT INTO `faqvoting` VALUES (154, 106, 8, 2, '1130171141', '84.182.194.135');
INSERT INTO `faqvoting` VALUES (155, 82, 32, 7, '1136215405', '84.183.115.89');
INSERT INTO `faqvoting` VALUES (156, 15, 3, 2, '1136155255', '62.59.108.5');
INSERT INTO `faqvoting` VALUES (157, 104, 1, 1, '1117376341', '80.144.118.154');
INSERT INTO `faqvoting` VALUES (158, 86, 5, 1, '1117451321', '84.72.24.139');
INSERT INTO `faqvoting` VALUES (159, 82, 33, 7, '1136215405', '84.183.115.89');
INSERT INTO `faqvoting` VALUES (160, 100, 1, 1, '1117470753', '62.143.38.51');
INSERT INTO `faqvoting` VALUES (161, 128, 5, 1, '1117803674', '134.102.204.187');
INSERT INTO `faqvoting` VALUES (162, 41, 10, 2, '1132187727', '84.145.97.198');
INSERT INTO `faqvoting` VALUES (163, 30, 2, 1, '1117965119', '195.93.60.16');
INSERT INTO `faqvoting` VALUES (164, 9, 3, 1, '1117973996', '82.140.26.29');
INSERT INTO `faqvoting` VALUES (165, 29, 13, 5, '1134916123', '195.14.216.94');
INSERT INTO `faqvoting` VALUES (166, 29, 13, 5, '1134916123', '195.14.216.94');
INSERT INTO `faqvoting` VALUES (167, 159, 5, 1, '1118242469', '84.158.33.196');
INSERT INTO `faqvoting` VALUES (168, 70, 4, 1, '1118242662', '84.158.33.196');
INSERT INTO `faqvoting` VALUES (169, 11, 5, 1, '1118242787', '84.158.33.196');
INSERT INTO `faqvoting` VALUES (170, 102, 1, 1, '1118243022', '84.158.33.196');
INSERT INTO `faqvoting` VALUES (171, 159, 5, 1, '1118576253', '193.249.174.253');
INSERT INTO `faqvoting` VALUES (172, 13, 4, 1, '1118586186', '86.56.0.6');
INSERT INTO `faqvoting` VALUES (173, 24, 13, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (174, 22, 14, 3, '1131366641', '85.72.149.86');
INSERT INTO `faqvoting` VALUES (175, 82, 33, 7, '1136215405', '84.183.115.89');
INSERT INTO `faqvoting` VALUES (176, 62, 5, 1, '1118962567', '62.47.13.33');
INSERT INTO `faqvoting` VALUES (177, 71, 5, 1, '1118963293', '62.47.13.33');
INSERT INTO `faqvoting` VALUES (178, 86, 5, 1, '1118964667', '62.47.13.33');
INSERT INTO `faqvoting` VALUES (179, 66, 5, 1, '1118973414', '84.163.169.176');
INSERT INTO `faqvoting` VALUES (180, 157, 4, 2, '1135198705', '84.137.249.53');
INSERT INTO `faqvoting` VALUES (181, 7, 10, 2, '1133732595', '84.226.63.140');
INSERT INTO `faqvoting` VALUES (182, 81, 2, 1, '1119186605', '84.158.21.36');
INSERT INTO `faqvoting` VALUES (183, 120, 6, 2, '1133028334', '84.131.13.65');
INSERT INTO `faqvoting` VALUES (184, 102, 1, 1, '1119207344', '80.129.187.150');
INSERT INTO `faqvoting` VALUES (185, 9, 5, 1, '1119381464', '213.39.182.211');
INSERT INTO `faqvoting` VALUES (186, 15, 4, 2, '1136155255', '62.59.108.5');
INSERT INTO `faqvoting` VALUES (187, 44, 5, 1, '1119473713', '62.47.12.83');
INSERT INTO `faqvoting` VALUES (188, 86, 5, 1, '1119474062', '62.47.12.83');
INSERT INTO `faqvoting` VALUES (189, 75, 7, 2, '1131282165', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (190, 15, 7, 2, '1136155255', '62.59.108.5');
INSERT INTO `faqvoting` VALUES (191, 22, 14, 3, '1131366641', '85.72.149.86');
INSERT INTO `faqvoting` VALUES (192, 99, 3, 1, '1119832757', '84.172.136.17');
INSERT INTO `faqvoting` VALUES (193, 91, 11, 4, '1132935495', '80.171.59.2');
INSERT INTO `faqvoting` VALUES (194, 25, 1, 1, '1120244077', '80.139.70.210');
INSERT INTO `faqvoting` VALUES (195, 27, 7, 3, '1132262072', '213.6.80.84');
INSERT INTO `faqvoting` VALUES (196, 11, 3, 1, '1120412605', '62.119.214.108');
INSERT INTO `faqvoting` VALUES (197, 159, 5, 1, '1120547051', '84.164.124.164');
INSERT INTO `faqvoting` VALUES (198, 42, 2, 1, '1120574735', '84.180.52.11');
INSERT INTO `faqvoting` VALUES (199, 120, 6, 2, '1133028334', '84.131.13.65');
INSERT INTO `faqvoting` VALUES (200, 157, 4, 2, '1135198705', '84.137.249.53');
INSERT INTO `faqvoting` VALUES (201, 147, 2, 1, '1121075232', '84.172.190.18');
INSERT INTO `faqvoting` VALUES (202, 11, 1, 1, '1121378175', '193.218.98.19');
INSERT INTO `faqvoting` VALUES (203, 82, 33, 7, '1136215405', '84.183.115.89');
INSERT INTO `faqvoting` VALUES (204, 6, 5, 1, '1123130617', '194.166.197.113');
INSERT INTO `faqvoting` VALUES (205, 6, 5, 1, '1123385341', '195.93.60.76');
INSERT INTO `faqvoting` VALUES (206, 22, 13, 3, '1131366641', '85.72.149.86');
INSERT INTO `faqvoting` VALUES (207, 22, 12, 3, '1131366641', '85.72.149.86');
INSERT INTO `faqvoting` VALUES (208, 82, 32, 7, '1136215405', '84.183.115.89');
INSERT INTO `faqvoting` VALUES (209, 2, 5, 1, '1123831814', '84.144.39.39');
INSERT INTO `faqvoting` VALUES (210, 9, 3, 1, '1124110208', '84.157.93.88');
INSERT INTO `faqvoting` VALUES (211, 102, 1, 1, '1124110321', '84.157.93.88');
INSERT INTO `faqvoting` VALUES (212, 10, 7, 2, '1134581311', '87.78.7.182');
INSERT INTO `faqvoting` VALUES (213, 28, 9, 2, '1136207136', '212.152.9.36');
INSERT INTO `faqvoting` VALUES (214, 13, 4, 1, '1124202866', '80.228.2.62');
INSERT INTO `faqvoting` VALUES (215, 9, 1, 1, '1124438658', '84.159.213.36');
INSERT INTO `faqvoting` VALUES (216, 17, 5, 1, '1124463225', '84.183.246.31');
INSERT INTO `faqvoting` VALUES (217, 62, 5, 1, '1125004793', '80.184.138.253');
INSERT INTO `faqvoting` VALUES (218, 9, 5, 1, '1125173296', '84.185.180.154');
INSERT INTO `faqvoting` VALUES (219, 82, 33, 7, '1136215405', '84.183.115.89');
INSERT INTO `faqvoting` VALUES (220, 13, 2, 1, '1125223072', '172.182.136.156');
INSERT INTO `faqvoting` VALUES (221, 135, 4, 1, '1125571823', '195.93.60.72');
INSERT INTO `faqvoting` VALUES (222, 147, 5, 1, '1125571898', '195.93.60.72');
INSERT INTO `faqvoting` VALUES (223, 75, 9, 2, '1131282165', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (224, 152, 16, 4, '1136813318', '84.56.107.73');
INSERT INTO `faqvoting` VALUES (225, 12, 10, 2, '1134986039', '164.128.54.35');
INSERT INTO `faqvoting` VALUES (226, 161, 4, 1, '1126179147', '80.185.17.217');
INSERT INTO `faqvoting` VALUES (227, 87, 4, 1, '1126179283', '80.185.17.217');
INSERT INTO `faqvoting` VALUES (228, 22, 13, 3, '1131366641', '85.72.149.86');
INSERT INTO `faqvoting` VALUES (229, 72, 1, 1, '1126179424', '80.185.0.238');
INSERT INTO `faqvoting` VALUES (230, 82, 33, 7, '1136215405', '84.183.115.89');
INSERT INTO `faqvoting` VALUES (231, 86, 5, 1, '1126180256', '80.185.19.73');
INSERT INTO `faqvoting` VALUES (232, 86, 5, 1, '1126180292', '80.185.13.139');
INSERT INTO `faqvoting` VALUES (233, 41, 6, 2, '1132187727', '84.145.97.198');
INSERT INTO `faqvoting` VALUES (234, 161, 5, 1, '1126588376', '84.59.6.186');
INSERT INTO `faqvoting` VALUES (235, 38, 1, 1, '1126629864', '82.3.32.72');
INSERT INTO `faqvoting` VALUES (236, 41, 10, 2, '1132187727', '84.145.97.198');
INSERT INTO `faqvoting` VALUES (237, 91, 15, 4, '1132935495', '80.171.59.2');
INSERT INTO `faqvoting` VALUES (238, 82, 30, 7, '1136215405', '84.183.115.89');
INSERT INTO `faqvoting` VALUES (239, 109, 5, 1, '1126957651', '217.248.180.199');
INSERT INTO `faqvoting` VALUES (240, 10, 10, 2, '1134581311', '87.78.7.182');
INSERT INTO `faqvoting` VALUES (241, 14, 15, 3, '1134983134', '195.93.60.12');
INSERT INTO `faqvoting` VALUES (242, 151, 4, 1, '1127477695', '84.182.73.156');
INSERT INTO `faqvoting` VALUES (243, 4, 1, 1, '1127605760', '201.154.88.145');
INSERT INTO `faqvoting` VALUES (244, 40, 4, 1, '1127633379', '84.177.144.227');
INSERT INTO `faqvoting` VALUES (245, 120, 6, 2, '1133028334', '84.131.13.65');
INSERT INTO `faqvoting` VALUES (246, 9, 1, 1, '1127920212', '84.191.223.50');
INSERT INTO `faqvoting` VALUES (247, 75, 9, 2, '1131282165', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (248, 40, 2, 1, '1127920570', '84.191.223.50');
INSERT INTO `faqvoting` VALUES (249, 40, 2, 1, '1127976865', '172.181.177.27');
INSERT INTO `faqvoting` VALUES (250, 22, 13, 3, '1131366641', '85.72.149.86');
INSERT INTO `faqvoting` VALUES (251, 50, 5, 1, '1128021554', '195.93.60.12');
INSERT INTO `faqvoting` VALUES (252, 10, 8, 2, '1134581311', '87.78.7.182');
INSERT INTO `faqvoting` VALUES (253, 120, 6, 2, '1133028334', '84.131.13.65');
INSERT INTO `faqvoting` VALUES (254, 5, 5, 1, '1128169228', '85.124.19.240');
INSERT INTO `faqvoting` VALUES (255, 14, 11, 3, '1134983134', '195.93.60.12');
INSERT INTO `faqvoting` VALUES (256, 75, 9, 2, '1131282165', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (257, 59, 4, 1, '1128210747', '84.182.208.150');
INSERT INTO `faqvoting` VALUES (258, 162, 5, 1, '1128619355', '84.142.191.109');
INSERT INTO `faqvoting` VALUES (259, 22, 14, 3, '1131366641', '85.72.149.86');
INSERT INTO `faqvoting` VALUES (260, 106, 10, 2, '1130171141', '84.182.194.135');
INSERT INTO `faqvoting` VALUES (261, 105, 5, 1, '1128876305', '84.191.225.34');
INSERT INTO `faqvoting` VALUES (262, 24, 13, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (263, 163, 17, 4, '1131815593', '195.202.170.170');
INSERT INTO `faqvoting` VALUES (264, 162, 5, 1, '1129039274', '85.176.74.52');
INSERT INTO `faqvoting` VALUES (265, 24, 13, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (266, 26, 3, 1, '1129126404', '62.20.19.143');
INSERT INTO `faqvoting` VALUES (267, 163, 17, 4, '1131815593', '195.202.170.170');
INSERT INTO `faqvoting` VALUES (268, 27, 10, 3, '1132262072', '213.6.80.84');
INSERT INTO `faqvoting` VALUES (269, 12, 10, 2, '1134986039', '164.128.54.35');
INSERT INTO `faqvoting` VALUES (270, 24, 12, 3, '1131280855', '213.6.12.110');
INSERT INTO `faqvoting` VALUES (271, 61, 5, 1, '1129399660', '195.162.172.151');
INSERT INTO `faqvoting` VALUES (272, 28, 8, 2, '1136207136', '212.152.9.36');
INSERT INTO `faqvoting` VALUES (273, 170, 6, 2, '1136206537', '212.152.9.36');
INSERT INTO `faqvoting` VALUES (275, 171, 9, 3, '1134769800', '82.83.75.90');
INSERT INTO `faqvoting` VALUES (274, 49, 1, 1, '1130403694', '80.139.222.189');
INSERT INTO `faqvoting` VALUES (276, 173, 5, 2, '1132155946', '62.117.30.216');
INSERT INTO `faqvoting` VALUES (277, 176, 5, 1, '1132187636', '84.145.97.198');
INSERT INTO `faqvoting` VALUES (278, 177, 5, 1, '1132187649', '84.145.97.198');
INSERT INTO `faqvoting` VALUES (279, 178, 5, 1, '1133732557', '84.226.63.140');
INSERT INTO `faqvoting` VALUES (280, 183, 6, 2, '1136237274', '80.171.162.211');
INSERT INTO `faqvoting` VALUES (281, 52, 1, 1, '1136155122', '62.59.108.5');

Post by **Thorsten** » Mon Jan 09, 2006 8:09 pm

Hallo Denise,

hast du die update.php durchlaufen lassen? Deine Tabelle ist nicht aktuell.

bye
Thorsten

Denise_van_Hoorn · Post by **Denise_van_Hoorn** » Tue Jan 10, 2006 7:18 am

Ja, auf jeden Fall. Schon deshalb, weil ich ja nicht wissen kann, ob neue Felder eingefÃ¼gt werden mÃ¼ssen. Ich programmiere selbst Datenbanken (MSAccess) und greife daher immer auf die Update-Funktionen eines Programms zurÃ¼ck, wenn eine vorhanden ist. AuÃŸerdem stand es doch in der documentation.eng.html ...

Und die install.php hat selbststÃ¤ndig festgestellt, daÃŸ nur ein Update gemacht werden muÃŸ.

Wie kann ich die Tabelle selbst aktualisieren? Was fehlt bzw. mÃ¼ÃŸte geÃ¤ndert werden?

Liebe GrÃ¼ÃŸe

Denise

Post by **Thorsten** » Tue Jan 10, 2006 7:27 am

Hi,

das AUTO_INCREMENT muss entfernt werden. Das geht auch leicht mit phpMyAdmin.

bye
Thorsten

Denise_van_Hoorn · Post by **Denise_van_Hoorn** » Wed Jan 11, 2006 7:01 am

Hallo,

habbich gemacht, hat allein auch nichts genutzt. Jetzt ist wohl etwas Handarbeit angesagt. Ich habe die Tabelle geleert, eine Bewertung abgegeben, die IP-Adresse in der Tabelle geÃ¤ndert (um nochmal voten zu kÃ¶nnen), und mir dann die Tabelle erneut angeschaut. Nach wie vor ein Datensatz, mit 2 Votings und einem Votingwert von 10 (10:2=5). Nun heiÃŸt es also alle doppelten DatensÃ¤tze herausfinden, Werte zusammenrechnen, Votings zusammenrechnen, Ã¼berflÃ¼ssige DatensÃ¤tze lÃ¶schen und dann die Tabelle wieder einstellen.
Da ich zwar MS-SQL spreche, nicht aber MySQL wird's ein wenig aufwendig. Bei 277 DatensÃ¤tzen aber wohl noch zu verkraften.

GruÃŸ Denise

Post by **Thorsten** » Wed Jan 11, 2006 7:21 am

Hi,

mir fÃ¤llt leider auch keine Funktion in MySQL ein, damit das klappen kÃ¶nnte. Aber ansonsten kann MySQL sicherlich einen GroÃŸteil SQL-Befehle, die auch MS SQL kann.

bye
Thorsten

Votings von alter Version in neue Version importieren

Votings von alter Version in neue Version importieren

Bewertungsstatistiken zeigt Dopplungen