Brauche Hilfe

[Partygirl]

Hallöchen ich bin Anfänger was PHP Fusion betrifft das Design an sich kann ich ja schon aaaaber ich wollte umziehen auf einen anderen Server hab ein SQL Datenbank Backup gemacht nun wollte ich es exportieren und er schreibt mir diesen Fehler hier in der Datenbank selber

Kann mir da jemand helfen was ich da rauslöschen oder bearbeiten muss den mit Sql bin ich nicht versiert

LG Partygirl

ich hab das Setup mal mit angehängt

[vt1816]

Hallo und willkommen hier im Forum.

Zitat von Partygirl

[...]
und er schreibt mir diesen Fehler hier in der Datenbank selber

Sorry, aber Fielmann hat es mal wieder nicht geschafft mir meine Brille auf Deine Fehlermeldung anzupassen. Wie lautet die/Deine Fehlermeldung?

Zitat von Partygirl

[]
Kann mir da jemand helfen was ich da rauslöschen oder bearbeiten muss den mit Sql bin ich nicht versiert

LG Partygirl

ich hab das Setup mal mit angehängt

Anhänge - und dann auch noch in dieser Größe - sind PFUI. Den Anhang wird sich keiner runterladen. Bitte kopiere die ersten bzw. einige Zeilen (im Zusammenhang zur Fehlermeldung) hier ins Forum.

[Partygirl]

Sorry ähm ja dann hier die ersten paar Zeilen


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__banner`
#
DROP TABLE IF EXISTS `#__banner`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[vt1816]

Zitat von Partygirl

Sorry ähm ja dann hier die ersten paar Zeilen
...

Könnten es ein paar mehr Zeilen vom Anfang der SQL-Datei sein?

Wie willst Du die Daten importieren (Konsole, phpMyAdmin)?

[Partygirl]

Jepp ich will das Backup beim neuen Serveranbieter hochladen also importieren

#
DROP TABLE IF EXISTS `#__core_acl_aro_sections`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__core_acl_groups_aro_map`
#
DROP TABLE IF EXISTS `#__core_acl_groups_aro_map`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__core_log_items`
#
DROP TABLE IF EXISTS `#__core_log_items`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__core_log_searches`
#
DROP TABLE IF EXISTS `#__core_log_searches`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__groups`
#
DROP TABLE IF EXISTS `#__groups`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__menu`
#
DROP TABLE IF EXISTS `#__menu`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__menu_types`
#
DROP TABLE IF EXISTS `#__menu_types`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__messages`
#
DROP TABLE IF EXISTS `#__messages`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__messages_cfg`
#
DROP TABLE IF EXISTS `#__messages_cfg`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__modules`
#
DROP TABLE IF EXISTS `#__modules`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__modules_menu`
#
DROP TABLE IF EXISTS `#__modules_menu`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__newsfeeds`
#
DROP TABLE IF EXISTS `#__newsfeeds`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual
#

[vt1816]

Womit hast Du den Export gemacht? Die Fehlermeldung(en) sind bereits im Export enhalten!

[Partygirl]

Ich hab das Backup so von meiner PHP Fusion geladen als zip.gz

Prefix Kerntabellen: fusion_
Totale Tabellengrösse: 570.2Kb (153 Tabellen)
Kerntabellengrösse: 498.82Kb (118 Tabellen)
Backup Optionen:
Dateiname: *
Backup Typ:
Admin Passwort: *

[Partygirl]

Zitat von Partygirl

Ich hab das Backup so von meiner PHP Fusion geladen als zip.gz

Prefix Kerntabellen: fusion_
Totale Tabellengrösse: 570.2Kb (153 Tabellen)
Kerntabellengrösse: 498.82Kb (118 Tabellen)
Backup Optionen:
Dateiname: *
Backup Typ:
Admin Passwort: *

Also sql.gz sorry ;-)

[vt1816]

Wie hast Du das Backup erzeugt?

[Partygirl]

Also nun nochmal ich habe das PHP Fusion Neu bei dem Webhoster wo wir noch sind damals gemacht das heisst er erzeugte die Datenbank selber so nun möchte ich umziehen und diese Textdatei (Sql Datenbank) zum neuen Webhoster mitnehmen und da hochladen das geht aber eben nicht weil er mir diese Fehler anzeigt. Wie wäre es wenn ich dir das Skript per Mail schicke das du dir das mal in Ruhe anschaust das bringt mir sonst nichts weil es müsste schon schnell gehen