Bonjour,
Je vous contacte car j'ai un souci de conversion de mon forum. J'étais sous la version PhpBB 3.0.5 et j'ai voulu transférer les données de la base (chez Free) sur le nouveau forum SMF 1.0.11.
Lorsque je souhaite faire la conversion avec les deux fichiers téléchargés sur ce site, aucun changement n'y est effectué, le nouveau forum SMF ne reçoit pas les données du forum phpbb3.
En espérant que l'on pourra m'aider ;)
Merci
Bonsoir,
Tu veux faire la conversion sur un espace free ? Je te le conseille pas fais cela en local :)
Oui, sur free.
J'ignore comment faire la conversion en local... :-\
Pourtant, j'utilise bien le bon fichier de conversion...
Bonsoir,
Oui mais free est tellement restrictif que je doute que tu arrives à un résultat satisfaisant. Tu installe un serveur local tel que wampserver.com et cela sera nettement plus facile. Pour sauvegarder ta bdd utilise mysqldumper il y a plein de docs sur ce forum :)
Je ne parviens pas à faire la conversion, j'ai le message suivant :
QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB3. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: Access denied for user 'SYSTEM'@'localhost' (using password: NO)
Et j'ai pourtant utilisé wampserver et mysqldumper...
Bonjour,
Tu dois mettre dans le fichier settings de Smf la nouvelle configuration utilisée avec l'installation de wampserver :)
D'accord mais je la trouve où cette configuration ? J'avoue être un peu perdu... :-\
Bonjour,
Tu édites le fichier settings.php qui se trouve à la racine de ton site.
$db_server = 'localhost';
$db_name = 'le nom de ta base de données';
$db_user = 'root';
$db_passwd = '';
Si tu as fais l'install par défaut tu dois avoir ceci :) Juste mettre le nom de la base de données que tu auras créé pour remettre tes données :)
Voici le message obtenu :
QuoteThe database password you entered was incorrect. Please make sure you are using the right password (for the SMF user!) and try it again. If in doubt, use the password from Settings.php in the SMF installation.
Et lorsque je ne rentre pas le mot de passe dans le champ de convert.php il m'affiche ceci :
QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB3. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: Table 'tanexpress.phpbb3_users' doesn't exist
1.0.11???
Oui, 1.0.11
Pourquoi j'ai écrit une bêtise ?!
Bonjour,
Oui effectivement la version qui doit être en cible est la version 1.1.11 :)
Ah en effet, au temps pour moi alors ;)
Mais ça ne change hélas rien au problème...
Bonjour,
Apparemment tu n'as pas mis les paramètres dans le fichier config.php de phpbb car il n'a pas accès à la bdd :)
Attention pour que ca marche les deux doivent être sur la même base....(à faire)
Les deux forums sont bien sur la même base de données. L'un avec les tables commençant par "phpbb3_" et l'autre par "smf_".
Voici mon fichier config.php du forum phpbb3 :
<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'tanexpress';
$dbuser = 'tanexpress';
$dbpasswd = 'XXXXXX';
$table_prefix = 'phpbb3_';
$acm_type = 'file';
$load_extensions = '';
@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>
donc pour smf tu as la même chose? (sauf le préfixe of course)
Oui. Et quand je rééssaye la conversion en ligne, ça donne ça :
QuoteConverting...
Notice: Undefined index: convert_script in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 822
Warning: Invalid argument supplied for foreach() in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 825
Notice: Undefined index: convert_script in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 837
Notice: Undefined index: convert_script in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 733
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1223
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1233
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1241
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1251
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1264
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1277
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1323
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1325
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1331
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1337
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1348
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1349
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1357
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1359
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1365
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1366
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1372
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1373
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1397
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1399
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1405
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1417
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1442
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1444
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1488
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1503
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1532
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1534
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1547
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1569
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1574
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1635
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1637
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1673
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1692
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1715
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1716
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2429
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2429
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Successful.
Notice: Undefined index: convert_script in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1823
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2257
Notice: Undefined variable: result in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 2258
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the
Notice: Undefined index: name in /mnt/116/sdb/1/7/tanexpress/discussionsSMF/convert.php on line 1857
installation.
We hope you had a smooth transition!
Donc aucune solution ?
Bonjour,
Essaye en local logiquement cela devrait aller :)
Dans wampserver, lorsque je vais dans localhost,
Si je clique sur le projet du forum actuel j'ai ce message :
QuoteGeneral Error
SQL ERROR [ mysql4 ]
Access denied for user 'tanexpress'@'localhost' (using password: YES) [1045]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Lorque je clique sur celui du forum SMF, j'ai ceci :
QuoteConnection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
soit tes données de connexion sont incorrectes, soit les deux ne sont pas sur la même base (mais à priori si)
tu es sûr de ton dbhost?
si besoin envoi moi des identifiants de connexion ftp et sql par mp pour voir le souci.....
Quote from: GravuTrad on August 03, 2010, 12:07:46 PMtu es sûr de ton dbhost?
Le serveur est localhost. C'est bon ?
c'est un serveur dédié ou mutualisé?
Tu me poses une colle ! Je ne sais pas du tout, on fait comment pour savoir s'il te plaît ?
Ton hébergement tu l'as pris où?
Chez Free.
Alors c'est sql.free.fr et pas localhost:
http://www.free.fr/assistance/929-acces-libre-base-de-donnees-utiliser-une-base-de-donnees.html
Bonjour,
Il a installé wampserveur pour faire sa conversion en local mais il a du rater une étape de l'installation concernant ses identiticateurs :)
Normalement, sans passer par le local, directement sur site ça doit marcher....maintenant aussi c'est free....beaucoup de limitations dans les scripts...
Mais là pour moi c'était son host sql qui était pas bon...
J'ai beau réintaller sur le serveur directement, que la conversion ne marche pas. Alors, est ce bien ceci pour le fichier Setting.php :
########## Database Info ##########
$db_server = 'sql.free.fr';
$db_name = 'tanexpress';
$db_user = 'tanexpress';
$db_passwd = 'XXXXXX';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;
ca correspond dans phpbb3? (les données de connexion base uniquement bien sûr)
<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'sql.free.fr';
$dbport = '';
$dbname = 'tanexpress';
$dbuser = 'tanexpress';
$dbpasswd = 'XXXXXX';
$table_prefix = 'phpbb3_';
$acm_type = 'file';
$load_extensions = '';
@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>
essaie en changeant le nom de user (étant le même peut être que le script aime pas)
Je ne peux le changer, il me sert d'identifiant pour me connecter au serveur, et ce sont ces paramètres qui sont enregistrés !
Finalement je vais tenter d'installer la version 2.0.RC3.
Mais déja quand je suis sur la première page d'installation, en dessous du cadre en bas j'ai ceci :
QuoteWarning: Unknown: open(/mnt/116/sdb/1/7/tanexpress/sessions/sess_bf85a3c21beb8352e4ec8591da7d87b2, O_RDWR) failed: No such file or directory (2) in Unknown on line 0
Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/mnt/116/sdb/1/7/tanexpress/sessions) in Unknown on line 0
Comment ça, tu peux pas changer ça dans ton interface base de données free?
Non.
Je viens d'installer la version 2.0.RC3, et de procéder à la conversion. Tout marche bien.
Cependant, lorsque je me déconnecte (le forum est en mode maintenance), il m'affiche la page ou je peux m'identifier, puis 2 secondes après il charge une page qui plante avec "DNS error".