Das ist hier natrlich alles ein bichen ein Folgefehler ... Knackpunkt ist die fehlende vatID beim Export, die aber beim Import wiederum erwartet wird (es gibt hier in den Foren entsprechende Threads und auch einen Patch zum Download).
Die 'Duplicate keys' werden wohl auch daraus entstehen ... Eigentlich sollten vor einem Import ,wie Du ihn versucht hast, erst alle Tabellen ausgeleert werden. Das scheint bei der Tabelle iteminfo nicht funktioniert zu haben ...
Lsungsanstze:
Erstmal die vatID in die Backup-Datei bringen, dann das "DELETE FROM iteminfo" einfgen.
Gru,
Andreas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Erst einmal danke fr die schnelle Antwort.
Komm aber nicht wirklich weiter.
Hab deshalb mal ein auszug aus der .csv (ich hoffe mit der richtigen Zeile) und einen Auszug imoprtitem.inc.php kopiert.
db_query("update item set itemgrID='$data[8]', keywords='$data[13]', picname1='$data[11]', picname2='$data[12]', quantity='$data[2]', orderby='$data[9]', visible='$data[10]', packID='$npackID' where ID='$nitemID'") or db_die();
hab auch in der csv vatID schon hinzugefgt, in der importitem find ich den Datensatz fr vatID='$data[xx]' nicht.
WO steckt der Fehler ?
Die Folgefehler sehe ich als logisch an.
Danke fr die Hilfe.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Nicht ganz ... wie Du inzwischen sicher festgestellt hast, hat die Tabelle iteminfo keine Spalte vatID, sondern nur die Tabelle item (siehe mein Posting von 10:46 ;-)
Mal ganz allgemein zur Info: Alle Tabellen mit 'info' im Namen enthalten sprachabhngige Informationen, also Werte die in der einen Sprache anders sind als in einer anderen.
Gru,
Andreas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
OK, ..info hab ich verstanden.
Hier mein nchster Versuch der nicht funktioniert.
db_query("insert into item values('%','$data[0]','$data[8]','$data[13]','$data[11]','$data[12]','$data[2]','$newid','$data[9]','$data[10]','$npackID','$vatID')") or db_die();
und nochmal passend dazu die import.csv
#ID; number; itemgrID; keywords; picname1; picname2; quantity; newid; orderby; visible; packID; vatID (table item)
"1"; "bwpp"; "1"; ""; ""; ""; "1.000"; "2967371855"; "0"; "1"; "1"; "2"
aber die Fehlermeldung beim Import bleibt:
# abtinfo.................................
# currency..
# itemColumn count doesn't match value count at row 1 (naja ca.250-300mal) denke die Anzahl der Artikel; und dewegen mchte ich den ganzen Kram nicht neu eingeben.
Und nochmal Danke fr deine Untersttzung.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Mal 'ne Frage am Rande: Wieviele Spalten hat Deine Tablle item? Ich ging bisher davon aus, da vatID vorhanden ist und das Problem verursacht.
Irgendwie habe ich das Gefhl wie sprechen von verschiedenen Versionen oder Dateien ... Wenn ich mir meine admin/backupimport.* so ansehe, habe ich da einen anderen Query ... db_query("insert into item values('$data[0]',' $data[1]',' $data[2]',' $data[3]',' $data[4]', '$data[5]', '$data[6]', '$data[7]', '$data[8]', '$data[9]', '$data[10]')") or db_die();
Mag sein, da auch der nicht funktioniert ...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
OK Problem mit itemColumn count doesn't match value count at row 1 ist gelst. Aber Fragt bitte nicht wie. Ich weiss es nicht. Sagt mir das ihr sowas auch schon hattet.:).
Jetzt kommt nur noch :
# abt.................................
# abtinfo.................................
# currency..
# item...................................................................................................................................................
# itemgr
# itemgrinfo.................................................................................
# iteminfo..........................................................................................................................................Duplicate entry '525' for key 1 ......................................................................................................................................................................................................................................................Duplicate entry '527' for key 1 ..................................................................................................................Duplicate entry '534' for key 1 ............Duplicate entry '564' for key 1 ....................................................................................................................................Duplicate entry '600' for key 1 ...................................................................................................................................................................Duplicate entry '601' for key 1 .Duplicate entry '602' for key 1 ..................Duplicate entry '605' for key 1 .Duplicate entry '606' for key 1 ........Duplicate entry '542' for key 1 ...................................................................................................................................................................................................................................................................Duplicate entry '624' for key 1 .....................................................................................................................................................................................................................................................Duplicate entry '623' for key 1 ............................................................................................................................................................................................................................................................Duplicate entry '565' for key 1 ........Duplicate entry '544' for key 1 .Duplicate entry '586' for key 1 .Duplicate entry '530' for key 1 .............................................................................Duplicate entry '553' for key 1 .Duplicate entry '554' for key 1 .Duplicate entry '555' for key 1 .Duplicate entry '556' for key 1 .Duplicate entry '557' for key 1 .Duplicate entry '535' for key 1 .....................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '540' for key 1 ...........................................................................................................................................................Duplicate entry '550' for key 1 .............................................................................................................................................................................................................................Duplicate entry '562' for key 1 ..................................................................................................................................................................................................................Duplicate entry '580' for key 1 .Duplicate entry '581' for key 1 .Duplicate entry '568' for key 1 .Duplicate entry '582' for key 1 .Duplicate entry '574' for key 1 .Duplicate entry '587' for key 1 ..Duplicate entry '578' for key 1 .Duplicate entry '583' for key 1 .Duplicate entry '588' for key 1 .Duplicate entry '569' for key 1 ..Duplicate entry '526' for key 1 ...........................................................................................................................................Duplicate entry '589' for key 1 .Duplicate entry '561' for key 1 ..................................................................................................Duplicate entry '592' for key 1 .Duplicate entry '575' for key 1 .Duplicate entry '608' for key 1 .Duplicate entry '576' for key 1 .Duplicate entry '610' for key 1 .Duplicate entry '611' for key 1 .Duplicate entry '577' for key 1 .Duplicate entry '593' for key 1 .Duplicate entry '566' for key 1 .Duplicate entry '607' for key 1 ..You have an error in your SQL syntax near 'gpedit.msc') -> Computerkonfiguration-> Administrative Vorlagen-> Windows-Kompon' at line 1 ..Duplicate entry '584' for key 1 .Duplicate entry '590' for key 1 .Duplicate entry '616' for key 1 .Duplicate entry '579' for key 1 .Duplicate entry '594' for key 1 .Duplicate entry '567' for key 1 ..Duplicate entry '558' for key 1 .Duplicate entry '570' for key 1 .Duplicate entry '585' for key 1 .Duplicate entry '613' for key 1 ...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '621' for key 1 ..Duplicate entry '620' for key 1 ...Duplicate entry '617' for key 1 ........................................................................................................................................................................................Duplicate entry '619' for key 1 .....................................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '563' for key 1 ...Duplicate entry '539' for key 1 ...........................................................................................................................................................Duplicate entry '529' for key 1 .................................................................................................Duplicate entry '595' for key 1 ..............................................................................................................................................................................................................................Duplicate entry '598' for key 1 ..Duplicate entry '552' for key 1 ..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '551' for key 1 .............................................................................................................................................................................................................................................................................Duplicate entry '571' for key 1 .Duplicate entry '596' for key 1 .Duplicate entry '572' for key 1 .Duplicate entry '597' for key 1 .......................................................................................................Duplicate entry '549' for key 1 ................................................................................................................................................................................................................................................................................................Duplicate entry '545' for key 1 .........................................................................................................................Duplicate entry '546' for key 1 ............................................................................................................Duplicate entry '547' for key 1 .............................................................................................................Duplicate entry '548' for key 1 ............................................................................................................................................................................................................................................Duplicate entry '573' for key 1 ...Duplicate entry '591' for key 1 ..Duplicate entry '560' for key 1 .
# language.
# link....
# package...
# packinfo.........
# payment...
# price..................................................................................................................................................................................................................................................................................
# pricetype...
# shipment......
# size...................................................................................................................................................
# sizeinfo
# user.....
# usrgroup...
Daten aus xbackupJune252003-1021.csv importiert
Teilweise sind Datenstze nicht vorhanden, kann aber auch kein system dahinter entdecken.
Noch ne IDEE?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ich weiss zwar das es im forum schon behandelt wurde, aber ich bekomm es einfach nicht hin.
Hier die Fehlermeldungen :
# ## phPayV2 database backup Wednesday, June 25th 2003 10:21:55 (CEST)abt.................................
# abtinfo.................................
# currency..
# itemColumn count doesn't match value count at row 1 (wiederholt sich 250 mal)
# itemgr
# itemgrinfo.................................................................................
# iteminfo..........................................................................................................................................Duplicate entry '525' for key 1 ......................................................................................................................................................................................................................................................Duplicate entry '527' for key 1 ..................................................................................................................Duplicate entry '534' for key 1 ............Duplicate entry '564' for key 1 ....................................................................................................................................Duplicate entry '600' for key 1 ...................................................................................................................................................................Duplicate entry '601' for key 1 .Duplicate entry '602' for key 1 ..................Duplicate entry '605' for key 1 .Duplicate entry '606' for key 1 ........Duplicate entry '542' for key 1 ...................................................................................................................................................................................................................................................................Duplicate entry '624' for key 1 .....................................................................................................................................................................................................................................................Duplicate entry '623' for key 1 ............................................................................................................................................................................................................................................................Duplicate entry '565' for key 1 ........Duplicate entry '544' for key 1 .Duplicate entry '586' for key 1 .Duplicate entry '530' for key 1 .............................................................................Duplicate entry '553' for key 1 .Duplicate entry '554' for key 1 .Duplicate entry '555' for key 1 .Duplicate entry '556' for key 1 .Duplicate entry '557' for key 1 .Duplicate entry '535' for key 1 .....................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '540' for key 1 ...........................................................................................................................................................Duplicate entry '550' for key 1 .............................................................................................................................................................................................................................Duplicate entry '562' for key 1 ..................................................................................................................................................................................................................Duplicate entry '580' for key 1 .Duplicate entry '581' for key 1 .Duplicate entry '568' for key 1 .Duplicate entry '582' for key 1 .Duplicate entry '574' for key 1 .Duplicate entry '587' for key 1 ..Duplicate entry '578' for key 1 .Duplicate entry '583' for key 1 .Duplicate entry '588' for key 1 .Duplicate entry '569' for key 1 ..Duplicate entry '526' for key 1 ...........................................................................................................................................Duplicate entry '589' for key 1 .Duplicate entry '561' for key 1 ..................................................................................................Duplicate entry '592' for key 1 .Duplicate entry '575' for key 1 .Duplicate entry '608' for key 1 .Duplicate entry '576' for key 1 .Duplicate entry '610' for key 1 .Duplicate entry '611' for key 1 .Duplicate entry '577' for key 1 .Duplicate entry '593' for key 1 .Duplicate entry '566' for key 1 .Duplicate entry '607' for key 1 ..You have an error in your SQL syntax near 'gpedit.msc') -> Computerkonfiguration-> Administrative Vorlagen-> Windows-Kompon' at line 1 ..Duplicate entry '584' for key 1 .Duplicate entry '590' for key 1 .Duplicate entry '616' for key 1 .Duplicate entry '579' for key 1 .Duplicate entry '594' for key 1 .Duplicate entry '567' for key 1 ..Duplicate entry '558' for key 1 .Duplicate entry '570' for key 1 .Duplicate entry '585' for key 1 .Duplicate entry '613' for key 1 ...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '621' for key 1 ..Duplicate entry '620' for key 1 ...Duplicate entry '617' for key 1 ........................................................................................................................................................................................Duplicate entry '619' for key 1 .....................................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '563' for key 1 ...Duplicate entry '539' for key 1 ...........................................................................................................................................................Duplicate entry '529' for key 1 .................................................................................................Duplicate entry '595' for key 1 ..............................................................................................................................................................................................................................Duplicate entry '598' for key 1 ..Duplicate entry '552' for key 1 ..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '551' for key 1 .............................................................................................................................................................................................................................................................................Duplicate entry '571' for key 1 .Duplicate entry '596' for key 1 .Duplicate entry '572' for key 1 .Duplicate entry '597' for key 1 .......................................................................................................Duplicate entry '549' for key 1 ................................................................................................................................................................................................................................................................................................Duplicate entry '545' for key 1 .........................................................................................................................Duplicate entry '546' for key 1 ............................................................................................................Duplicate entry '547' for key 1 .............................................................................................................Duplicate entry '548' for key 1 ............................................................................................................................................................................................................................................Duplicate entry '573' for key 1 ...Duplicate entry '591' for key 1 ..Duplicate entry '560' for key 1 .
# language.
# link....
# package...
# packinfo.........
# payment...
# price..................................................................................................................................................................................................................................................................................
# pricetype...
# shipment......
# size...................................................................................................................................................
# sizeinfo
# user.....
# usrgroup...
Daten aus backupJune252003-1021.csv importiert
Hab auch schon den patch aufgespielt aber keine nderung. Wenn es weiterhilft kann ich die importitem.inc.php beim nchsten posteing mit reinpacken.
Ich sag schon einmal an jeden Danke der sich damit befasst.
Hoffe mir kann noch geholfen werden.
Das ist hier natrlich alles ein bichen ein Folgefehler ... Knackpunkt ist die fehlende vatID beim Export, die aber beim Import wiederum erwartet wird (es gibt hier in den Foren entsprechende Threads und auch einen Patch zum Download).
Die 'Duplicate keys' werden wohl auch daraus entstehen ... Eigentlich sollten vor einem Import ,wie Du ihn versucht hast, erst alle Tabellen ausgeleert werden. Das scheint bei der Tabelle iteminfo nicht funktioniert zu haben ...
Lsungsanstze:
Erstmal die vatID in die Backup-Datei bringen, dann das "DELETE FROM iteminfo" einfgen.
Gru,
Andreas.
Erst einmal danke fr die schnelle Antwort.
Komm aber nicht wirklich weiter.
Hab deshalb mal ein auszug aus der .csv (ich hoffe mit der richtigen Zeile) und einen Auszug imoprtitem.inc.php kopiert.
In *.csv steht:
#ID; number; itemgrID; keywords; picname1; picname2; quantity; newid; orderby; visible; packID; vatID (table item)
"1"; "bwpp"; "1"; ""; ""; ""; "1.000"; "2967371855"; "0"; "1"; "1"; "2"
und in der importitem:
db_query("update item set itemgrID='$data[8]', keywords='$data[13]', picname1='$data[11]', picname2='$data[12]', quantity='$data[2]', orderby='$data[9]', visible='$data[10]', packID='$npackID' where ID='$nitemID'") or db_die();
hab auch in der csv vatID schon hinzugefgt, in der importitem find ich den Datensatz fr vatID='$data[xx]' nicht.
WO steckt der Fehler ?
Die Folgefehler sehe ich als logisch an.
Danke fr die Hilfe.
CSV-Datei sieht doch schon mal gut aus ...
Der 'Column count doesnt match'-Fehler kommt aber von einem INSERT-Query, also sowas wie 'INSERT INTO item ...'
Gru,
Andreas.
hab da glaub ich was gefunden !
db_query("insert into iteminfo values ('%','$nitemID','$nlangID','$data[1]','$data[13]','$data[14]','')") or db_die();
wenn ich dich richtig versteh soll da ja als letztes '$vatID' rein, oder ??
Nicht ganz ... wie Du inzwischen sicher festgestellt hast, hat die Tabelle iteminfo keine Spalte vatID, sondern nur die Tabelle item (siehe mein Posting von 10:46 ;-)
Mal ganz allgemein zur Info: Alle Tabellen mit 'info' im Namen enthalten sprachabhngige Informationen, also Werte die in der einen Sprache anders sind als in einer anderen.
Gru,
Andreas.
OK, ..info hab ich verstanden.
Hier mein nchster Versuch der nicht funktioniert.
db_query("insert into item values('%','$data[0]','$data[8]','$data[13]','$data[11]','$data[12]','$data[2]','$newid','$data[9]','$data[10]','$npackID','$vatID')") or db_die();
und nochmal passend dazu die import.csv
#ID; number; itemgrID; keywords; picname1; picname2; quantity; newid; orderby; visible; packID; vatID (table item)
"1"; "bwpp"; "1"; ""; ""; ""; "1.000"; "2967371855"; "0"; "1"; "1"; "2"
aber die Fehlermeldung beim Import bleibt:
# abtinfo.................................
# currency..
# itemColumn count doesn't match value count at row 1 (naja ca.250-300mal) denke die Anzahl der Artikel; und dewegen mchte ich den ganzen Kram nicht neu eingeben.
Und nochmal Danke fr deine Untersttzung.
Mal 'ne Frage am Rande: Wieviele Spalten hat Deine Tablle item? Ich ging bisher davon aus, da vatID vorhanden ist und das Problem verursacht.
Irgendwie habe ich das Gefhl wie sprechen von verschiedenen Versionen oder Dateien ... Wenn ich mir meine admin/backupimport.* so ansehe, habe ich da einen anderen Query ... db_query("insert into item values('$data[0]',' $data[1]',' $data[2]',' $data[3]',' $data[4]', '$data[5]', '$data[6]', '$data[7]', '$data[8]', '$data[9]', '$data[10]')") or db_die();
Mag sein, da auch der nicht funktioniert ...
OK Problem mit itemColumn count doesn't match value count at row 1 ist gelst. Aber Fragt bitte nicht wie. Ich weiss es nicht. Sagt mir das ihr sowas auch schon hattet.:).
Jetzt kommt nur noch :
# abt.................................
# abtinfo.................................
# currency..
# item...................................................................................................................................................
# itemgr
# itemgrinfo.................................................................................
# iteminfo..........................................................................................................................................Duplicate entry '525' for key 1 ......................................................................................................................................................................................................................................................Duplicate entry '527' for key 1 ..................................................................................................................Duplicate entry '534' for key 1 ............Duplicate entry '564' for key 1 ....................................................................................................................................Duplicate entry '600' for key 1 ...................................................................................................................................................................Duplicate entry '601' for key 1 .Duplicate entry '602' for key 1 ..................Duplicate entry '605' for key 1 .Duplicate entry '606' for key 1 ........Duplicate entry '542' for key 1 ...................................................................................................................................................................................................................................................................Duplicate entry '624' for key 1 .....................................................................................................................................................................................................................................................Duplicate entry '623' for key 1 ............................................................................................................................................................................................................................................................Duplicate entry '565' for key 1 ........Duplicate entry '544' for key 1 .Duplicate entry '586' for key 1 .Duplicate entry '530' for key 1 .............................................................................Duplicate entry '553' for key 1 .Duplicate entry '554' for key 1 .Duplicate entry '555' for key 1 .Duplicate entry '556' for key 1 .Duplicate entry '557' for key 1 .Duplicate entry '535' for key 1 .....................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '540' for key 1 ...........................................................................................................................................................Duplicate entry '550' for key 1 .............................................................................................................................................................................................................................Duplicate entry '562' for key 1 ..................................................................................................................................................................................................................Duplicate entry '580' for key 1 .Duplicate entry '581' for key 1 .Duplicate entry '568' for key 1 .Duplicate entry '582' for key 1 .Duplicate entry '574' for key 1 .Duplicate entry '587' for key 1 ..Duplicate entry '578' for key 1 .Duplicate entry '583' for key 1 .Duplicate entry '588' for key 1 .Duplicate entry '569' for key 1 ..Duplicate entry '526' for key 1 ...........................................................................................................................................Duplicate entry '589' for key 1 .Duplicate entry '561' for key 1 ..................................................................................................Duplicate entry '592' for key 1 .Duplicate entry '575' for key 1 .Duplicate entry '608' for key 1 .Duplicate entry '576' for key 1 .Duplicate entry '610' for key 1 .Duplicate entry '611' for key 1 .Duplicate entry '577' for key 1 .Duplicate entry '593' for key 1 .Duplicate entry '566' for key 1 .Duplicate entry '607' for key 1 ..You have an error in your SQL syntax near 'gpedit.msc') -> Computerkonfiguration-> Administrative Vorlagen-> Windows-Kompon' at line 1 ..Duplicate entry '584' for key 1 .Duplicate entry '590' for key 1 .Duplicate entry '616' for key 1 .Duplicate entry '579' for key 1 .Duplicate entry '594' for key 1 .Duplicate entry '567' for key 1 ..Duplicate entry '558' for key 1 .Duplicate entry '570' for key 1 .Duplicate entry '585' for key 1 .Duplicate entry '613' for key 1 ...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '621' for key 1 ..Duplicate entry '620' for key 1 ...Duplicate entry '617' for key 1 ........................................................................................................................................................................................Duplicate entry '619' for key 1 .....................................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '563' for key 1 ...Duplicate entry '539' for key 1 ...........................................................................................................................................................Duplicate entry '529' for key 1 .................................................................................................Duplicate entry '595' for key 1 ..............................................................................................................................................................................................................................Duplicate entry '598' for key 1 ..Duplicate entry '552' for key 1 ..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Duplicate entry '551' for key 1 .............................................................................................................................................................................................................................................................................Duplicate entry '571' for key 1 .Duplicate entry '596' for key 1 .Duplicate entry '572' for key 1 .Duplicate entry '597' for key 1 .......................................................................................................Duplicate entry '549' for key 1 ................................................................................................................................................................................................................................................................................................Duplicate entry '545' for key 1 .........................................................................................................................Duplicate entry '546' for key 1 ............................................................................................................Duplicate entry '547' for key 1 .............................................................................................................Duplicate entry '548' for key 1 ............................................................................................................................................................................................................................................Duplicate entry '573' for key 1 ...Duplicate entry '591' for key 1 ..Duplicate entry '560' for key 1 .
# language.
# link....
# package...
# packinfo.........
# payment...
# price..................................................................................................................................................................................................................................................................................
# pricetype...
# shipment......
# size...................................................................................................................................................
# sizeinfo
# user.....
# usrgroup...
Daten aus xbackupJune252003-1021.csv importiert
Teilweise sind Datenstze nicht vorhanden, kann aber auch kein system dahinter entdecken.
Noch ne IDEE?
Jetzt fehlt zweifelsfrei nur noch ein 'DELETE FROM iteminfo' bevor die INSERT-Queries starten ...
Gru,
Andreas.