Forum

[tichy]

Hi, ich musste für meine Seite nen neuen Prefix einstellen weil das Webpaket nur eine Datenbank enthält auf der schon ein Redaxo installiert ist.

Mein Problem:
Die Version mit der ich den Datenbank export erstellt habe hatte den üblichen
REX_ prefix. Jetzt Zickt Redaxo rum wenn ich die REX_ SQL Datei in das neue System eisnpielen will.

Ich habe versucht einfach alle REX_ einträge per Hand zu ersetzten, das hat es aber nicht gebracht. ;(
Problem ist Gelöst!!!! siehe ganz unten

[tichy]

Jo, ich habe das Problem gelöst. <---- War ein irrtum!!!!!!

Code: Alles auswählen

ALTER TABLE tabelle RENAME AS neuer name

das geht, vieleicht schreibe ich ein kleines script welches das in redaxo erledigt. Zurzeit muss ich es noch in der Datenbank selber machen.

[tichy]

Toll, jetzt konnte ich die Tabellen Umbennen, Fehler gibt es Trotzdem.
Also, ich kann das ganze einfach nicht Importieren.
Er Sagt mir immer das eine Tabelle fehlt, wenn ich sie per hand erstelle wird sie einfach wieder Gelöscht. Hilfe, Hilfe, habe leider keinen Plan von Myqsl.

Danke im Vorraus

[tichy]

Hier mal die Fehlermeldung:

Code: Alles auswählen

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 'ToolTip fehlt , `cat_image` varchar(255) NULL ,
PRIMARY KEY (`pid`)) TYPE=MyIS' at line 1

Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' doesn't exist Table 'beispielseite.rex_article' ........

Das wiederholt sich noch eine ganze weile!
Wahrscheinlich für jeden Artikel der Existiert


[tichy]

So dank Koala gibt es einen Plan.

[tichy]

So, es gibt immer noch einen Fehler beim einspielen des Lokalen Exports auf das Redaxo auf dem Server

Code: Alles auswählen

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 '0` , `attributes` text NULL , `type` int(10) unsigned NULL , Table 'db215192855.julius_beispiel1_62_params' doesn't exist Table 'db215192855.julius_beispiel1_62_params' doesn't exist Table 'db215192855.julius_beispiel1_62_params' doesn't exist Table 'db215192855.julius_beispiel1_62_params' doesn't exist Table 'db215192855.julius_beispiel1_62_params' doesn't exist Table 'db215192855.julius_beispiel1_62_params' doesn't exist Table 'db215192855.julius_beispiel1_62_params' doesn't exist Table 'db215192855.julius_beispiel1_62_params' doesn't exist Table 'db215192855.julius_beispiel1_62_params' doesn't exist Table 'db215192855.julius_beispiel1_62_params' doesn't exist Table 'db215192855.julius_beispiel1_62_params' doesn't exist 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 '0` , PRIMARY KEY (`id`)) TYPE=MyISAM' at line 1 Table 'db215192855.julius_beispiel1_62_type' doesn't exist Table 'db215192855.julius_beispiel1_62_type' doesn't exist Table 'db215192855.julius_beispiel1_62_type' doesn't exist Table 'db215192855.julius_beispiel1_62_type' doesn't exist Table 'db215192855.julius_beispiel1_62_type' doesn't exist Table 'db215192855.julius_beispiel1_62_type' doesn't exist Table 'db215192855.julius_beispiel1_62_type' doesn't exist Table 'db215192855.julius_beispiel1_62_type' doesn't exist Table 'db215192855.julius_beispiel1_62_type' doesn't exist Table 'db215192855.julius_beispiel1_62_type' doesn't exist 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 '0` , `updateuser` varchar(255) NOT NULL , `updatedate` int(11 Table 'db215192855.julius_beispiel1_action' doesn't exist 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 '0` , `re_id` int(11) NOT NULL DEFAULT `0` , `name` varchar(25 Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist Table 'db215192855.julius_beispiel1_article' doesn't exist 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 '0` , `ctype` int(11) NOT NULL DEFAULT `0` , `re_article_slice Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist Table 'db215192855.julius_beispiel1_article_slice' doesn't exist 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 '0` , `name` varchar(255) NOT NULL , `revision` int(11) NULL Table 'db215192855.julius_beispiel1_clang' doesn't exist Table 'db215192855.julius_beispiel1_clang' doesn't exist 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 '0` , `category_id` int(11) NOT NULL DEFAULT `0` , `attributes Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist Table 'db215192855.julius_beispiel1_file' doesn't exist 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 '0` , `path` varchar(255) NOT NULL , `createdate` int(11) NOT Table 'db215192855.julius_beispiel1_file_category' doesn't exist Table 'db215192855.julius_beispiel1_file_category' doesn't exist Table 'db215192855.julius_beispiel1_file_category' doesn't exist 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 '0` , `ausgabe` text NOT NULL , `eingabe` text NOT NULL , `cr Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist Table 'db215192855.julius_beispiel1_module' doesn't exist 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 '0` , `action_id` int(11) NOT NULL DEFAULT `0` , `revision` in 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 '0` , `updatedate` int(11) NOT NULL DEFAULT `0` , `attributes` Table 'db215192855.julius_beispiel1_template' doesn't exist Table 'db215192855.julius_beispiel1_template' doesn't exist Table 'db215192855.julius_beispiel1_template' doesn't exist

Die Ausgangs Situation ist die.

Lokales Redaxo läuft mit Prefix
julius_beispiel1_
MySQL-Client-Version: 5.0.51

Server auch läuft mit Prefix
julius_beispiel1_
MySQL4.0

Könnte es vieleicht daran liegen das lokal Mysql 5
und Online Mysql 4 verwendet wird?

Kann ich das Korrigieren?

gruß Tichy

[tichy]

Soooo, ich habe die Datenank Lokal im über PHPMYADMIN im MYSQL4 Kompatibilitäts Modus exportiert.

Redaxo hat das erstmal nicht genommen,
Aber ich habe es einfach auf meinem Webserver über den SQL Button eingespielt (Da bei meinem Webserver die Import funtion fehlt) und siehe da, Jaaa es hat geklappt.

Ich denke das Das Import/Export Addon sowas wie einen Kompatibilitäts Modus braucht!



Freude