bplaced.net

[Dom]

Hi Leute,
da funpic seinen Laden zu gemacht hat, bin ich zu bplaced.net gekommen.
Ich wollte mein altes SMF-Forum 1.1.8 istallieren.
Aber leider kommt folgende Fehlermeldungen.

Deprecated: Function mysql_list_tables() is deprecated in /users/xxx/www/sr/forum/install.php on line 798

Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.

Technical information about the queries:

Line #21: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 15
Line #39: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 13
Line #62: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 18
Line #74: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Line #150: Table 'dom01.smf_board_permissions' doesn't exist
Line #179: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 23
Line #187: Table 'dom01.smf_boards' doesn't exist
Line #206: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 13
Line #218: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Line #335: Table 'dom01.smf_calendar_holidays' doesn't exist
Line #395: Table 'dom01.smf_calendar_holidays' doesn't exist
Line #408: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Line #415: Table 'dom01.smf_categories' doesn't exist
Line #426: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 5
Line #442: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 11
Line #458: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 11
Line #472: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 9
Line #483: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 6
Line #501: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 13
Line #511: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 5
Line #524: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 8
Line #535: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 6
Line #547: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Line #562: Too big precision 14 specified for 'logTime'. Maximum is 6.
Line #573: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 6
Line #583: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 5
Line #596: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 8
Line #607: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 6
Line #617: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 5
Line #629: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Line #644: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Line #659: Table 'dom01.smf_membergroups' doesn't exist
Line #728: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 63
Line #742: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 9
Line #762: Table 'dom01.smf_message_icons' doesn't exist
Line #793: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 25
Line #801: Table 'dom01.smf_messages' doesn't exist
Line #812: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 5
Line #823: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 6
Line #831: Table 'dom01.smf_package_servers' doesn't exist
Line #843: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 6
Line #889: Table 'dom01.smf_permissions' doesn't exist
Line #907: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 12
Line #922: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Line #939: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 12
Line #951: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Line #961: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 5
Line #1124: Table 'dom01.smf_settings' doesn't exist
Line #1136: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 6
Line #1151: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Line #1177: Table 'dom01.smf_smileys' doesn't exist
Line #1191: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 8
Line #1230: Table 'dom01.smf_themes' doesn't exist
Line #1255: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 19
Line #1263: Table 'dom01.smf_topics' doesn't exist
Line #0: Incorrect table name ''

In der Zeile 798 steht folgender Befehl.

define('SMF', 1);

Hat einer eine Idee, wo der Fehler liegt??
Oder kennt einer einen kostenlosen Webspace, wo SMF 1.1.8 ohne probleme läuft.

Noch ein Word zur alten Software.
Ich brauche die, da mein Backup, von meiner Homepage auf dieser Version läuft.
Will Homepage dann auf neues CMS Software rüber kopieren.
Kennt ihr ein kostenloses CMS, was für einen Blutigen Anfänger geeignet ist?
SMF 2.08 hatte ich auch schon auf den Server gehabt, da ging die installtion ohne problme, bis dass die Themes nicht zu sehen waren, warum weiß ich auch nicht.

Bin auf eure Antworten gespannt.
Danke schon einmal im vorraus.

[Tekkla]

Schau mal hier. http://dev.simplemachines.org/mantis/view.php?id=3696#c11907

Wenn ich das richtig interpretiere, dann muss die Zeile

Code Select Expand

$tables = mysql_list_tables($db_name);

mit

Code Select Expand

$tables = db_query("SHOW TABLES FROM {$db_name}", __FILE__, __LINE__);

in der install.php ersetzt werden. Laut Statusanzeige soll das aber seit 2010 gefixt sein.

[Dom]

Danke für deine schnelle Antwort.
bekomme nun folgen Antwort, vom Server.

Code Select Expand

Fatal error: Call to undefined function db_query() in /users/xxx/www/sr/forum/install.php on line 799

Den alten Satz habe ich heraus kommentiert, mit //
Deshalb ist dein Satz auf die Zeile 799 gerutscht.

Ich habe mal eine PHP-Info-Seite eingerichtet.
Vielleich findest du damit den Fehler er.
zur phpinfo.php Seite

[Tekkla]

Nein, auf anhieb kann ich dir nicht helfen. Ohne es jetzt genauer betrachtet zu haben, vermute ich einfach mal, dass die Version 1.1.8 die Funktion db_query() bei der Installation noch nicht kennt und erst mit einer späteren 1.1er Version der 'deprecated' Fehler wie oben beschrieben gefixt wurde.

Ich kann dir jetzt nur sagen wie ich es mit Umzügen handhabe:

   
• Ich mache eine Sicherung der Dateien und der DB des aktiven Forums.
• Ich aktualisiere das aktive Forum auf den letzten Versionstand (bei dir 1.1.19) und aktualisiere auch installierte Mods.
• Dann installiere ich ein blankes Forum mit gleicher Version und die genutzten Mods auf dem neuen Host.
• Zum Schluss kopiere ich die für mich notwendigen Tabellen und Dateien vom alten Host zum Neuen.

Mehr kann ich aber auch nicht sagen oder helfen.