SMF 2 to Wedge importer errors

gevv

  • Posts: 91
Re: SMF 2 to Wedge importer errors
« Reply #30, on March 20th, 2014, 07:28 PM »
I'm having the same problem :)
Quote from txcas on February 27th, 2014, 12:06 AM
I just tried the latest commit and now get:
Code: [Select]
Importing settings... ✔
Importing members... Unsuccessful!
 This query:

SELECT
 id_member, member_name, date_registered, posts, id_group, lngfile, last_login,
 real_name, instant_messages, unread_messages, buddy_list, pm_ignore_list,
 pm_prefs, passwd, email_address, personal_text, gender, birthdate,
 website_url, website_title, location, hide_email, show_online,
 time_format, signature, time_offset, avatar, pm_email_notify,
 usertitle, notify_announcements, notify_regularity, notify_send_body,
 notify_types, member_ip, member_ip2, is_activated, validation_code,
 id_msg_last_visit, additional_groups, smiley_set, id_post_group,
 total_time_logged_in, password_salt, ignore_boards,
 IFNULL(warning, 0) AS warning, passwd_flood, pm_receive_from,
 message_labels, secret_question, secret_answer, mod_prefs, '' AS data
 FROM `creedmoo_wedge`.wedge_members
 LIMIT 0, 500;
Caused the error:

Unknown column 'message_labels' in 'field list'

Nao

  • Dadman with a boy
  • Posts: 15,974
Re: SMF 2 to Wedge importer errors
« Reply #32, on March 21st, 2014, 03:19 PM »
@TE, do you think it's possible to make a version that ignores any missing input fields from the database?

TE

  • Posts: 286
Re: SMF 2 to Wedge importer errors
« Reply #33, on March 24th, 2014, 01:11 PM »
Quote from Nao on March 21st, 2014, 03:19 PM
@TE, do you think it's possible to make a version that ignores any missing input fields from the database?
mhh, that's getting complicated ..

Would require a "SHOW COLUMNS FROM `table`" for each and every table + related code & error handling in order to compare the existing fields with the query.
I feel it might be "overkill" for a rare case.
Thorsten "TE" Eurich - Former SMF Developer & Converters Guru

Kian

  • Posts: 35
Re: SMF 2 to Wedge importer errors
« Reply #34, on April 16th, 2014, 06:17 PM »
I tried (twice) a new fresh install and import from my SMF 2.0.6 forum.

The import tool fails on the smileys :
Importation en cours...

(click to show/hide)
Importing settings... ✔
Importing members... ✔
Importing attachments... ✔
Importing avatars... ✔
Importing categories... ✔
Importing collapsed categories... ✔
Importing boards... ✔
Importing topics... ✔
Importing messages... ✔
Importing polls... ✔
Importing poll choices... ✔
Importing poll votes... ✔
Importing personal messages... ✔
Importing pm recipients... ✔
Importing pm rules... ✔
Importing board moderators... ✔
Importing mark read data (topics)... ✔
Importing mark read data... ✔
Importing notifications... ✔
Importing membergroups... ✔
Importing group moderators... ✔
Importing permission profiles... ✔
Importing permissions... ✔
Importing board permissions... ✔
Importing smileys... ✔
Copying smileys...

Code: [Select]
Message: mkdir(): Permission denied
Trace: mkdir(): Permission denied
Line: 1641
File: /opt/sites/beta.potesnroll.com/www/import.php

Pandos

  • Living on the edge of Wedge
  • Posts: 635
# dpkg-reconfigure brain
error: brain is not installed or configured

Kian

  • Posts: 35
Re: SMF 2 to Wedge importer errors
« Reply #36, on April 16th, 2014, 08:07 PM »
Quote from Pandos on April 16th, 2014, 07:23 PM
Wedge dir is writeable and running under the same user as your webserver?
It seems so :

Code: [Select]
nova:/opt/sites/beta.potesnroll.com/www# ps fauxw | grep apache | grep -v grep
root     30529  0.0  0.7  76636 15540 ?        Ss   Apr09   0:19 /usr/sbin/apache2 -k start
www-data 18138  0.9  1.0  85440 21052 ?        S    15:30   2:33  \_ /usr/sbin/apache2 -k start
www-data 18141  0.9  1.0  85524 20880 ?        S    15:30   2:38  \_ /usr/sbin/apache2 -k start
www-data 18386  0.9  1.0  85332 20884 ?        S    15:31   2:33  \_ /usr/sbin/apache2 -k start
www-data 29651  1.0  1.0  85708 20956 ?        S    16:50   1:59  \_ /usr/sbin/apache2 -k start
www-data 29658  1.2  1.0  86404 21844 ?        S    16:50   2:21  \_ /usr/sbin/apache2 -k start
www-data  7594  0.8  1.0  85404 20856 ?        S    18:00   1:06  \_ /usr/sbin/apache2 -k start
www-data  7804  0.8  0.9  85372 20188 ?        S    18:01   1:05  \_ /usr/sbin/apache2 -k start
www-data 16777  0.7  0.9  85296 19752 ?        S    18:59   0:29  \_ /usr/sbin/apache2 -k start
www-data 25015  0.7  0.9  85376 20000 ?        S    19:49   0:07  \_ /usr/sbin/apache2 -k start
www-data 26889  0.7  0.9  85416 19528 ?        S    20:01   0:02  \_ /usr/sbin/apache2 -k start
nova:/opt/sites/beta.potesnroll.com/www# ll
total 300
drwxr-xr-x 15 www-data www-data  4096 Apr 16 17:51 assets
drwxr-xr-x  2 www-data www-data 61440 Apr 16 17:55 attachments
-rw-r--r--  1 www-data www-data   560 Apr 16 17:51 changelog.txt
-rw-r--r--  1 www-data www-data  5530 Apr 16 17:51 contributors.txt
drwxr-xr-x  7 www-data www-data  4096 Apr 16 17:51 core
-rw-r--r--  1 www-data www-data  1883 Apr 16 17:51 DCO.txt
drwxr-xr-x  7 www-data www-data  4096 Apr 16 17:51 gz
-rw-r--r--  1 www-data www-data  6514 Apr 16 17:54 import_de.xml
-rw-r--r--  1 www-data www-data  6304 Apr 16 17:54 import_en.xml
-rw-r--r--  1 www-data www-data  7086 Apr 16 17:54 import_fr.xml
-rw-r--r--  1 www-data www-data  8960 Apr 16 17:51 index.php
drwxr-xr-x  2 www-data www-data  4096 Apr 16 17:51 install
-rw-r--r--  1 www-data www-data  1517 Apr 16 17:54 LICENSE
-rw-r--r--  1 www-data www-data  6658 Apr 16 17:51 license.txt
drwxr-xr-x  8 www-data www-data  4096 Apr 16 17:51 media
-rw-r--r--  1 www-data www-data 11898 Apr 16 17:54 mybb16_to_wedge.xml
-rw-r--r--  1 www-data www-data 10993 Apr 16 17:54 phpbb3_to_wedge.xml
drwxr-xr-x  2 www-data www-data  4096 Apr 16 17:51 plugins
-rw-r--r--  1 www-data www-data  1219 Apr 16 17:54 README.md
-rw-r--r--  1 www-data www-data   947 Apr 16 17:53 Settings_bak.php
-rw-r--r--  1 www-data www-data   947 Apr 16 17:53 Settings.php
-rw-r--r--  1 www-data www-data 14831 Apr 16 17:54 smf11_to_wedge.xml
-rw-r--r--  1 www-data www-data 21758 Apr 16 17:54 smf2RC_to_wedge.xml
-rw-r--r--  1 www-data www-data 21799 Apr 16 17:54 smf2_to_wedge.xml
-rw-r--r--  1 www-data www-data  8434 Apr 16 17:51 subscriptions.php
-rw-r--r--  1 www-data www-data 11265 Apr 16 17:54 vbulletin4_to_wedge.xml
-rw-r--r--  1 www-data www-data 12864 Apr 16 17:54 wbb3_to_wedge.xml
-rw-r--r--  1 www-data www-data  5863 Apr 16 17:54 wordpress3_to_wedge.xml
nova:/opt/sites/beta.potesnroll.com/www#

nova:/opt/sites/beta.potesnroll.com/www# ll ../
total 3024
drwxr-xr-x  2 root     root        4096 Apr  5 12:50 importer-master
drwxr-xr-x  2 www-data www-data    4096 Feb 28 15:46 logs
-rw-r--r--  1 root     root     3069011 Apr 16 15:21 master.zip
drwxr-xr-x  5 www-data www-data    4096 Apr 15 07:51 wedge-master
drwxr-xr-x  9 www-data www-data    4096 Apr 16 18:09 www
drwxr-xr-x 11 www-data www-data    4096 Apr 16 15:26 www.20140416
nova:/opt/sites/beta.potesnroll.com/www#


Error log  (perhaps not from the right period)

Code: [Select]
[Wed Apr 16 17:00:02 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:02 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:02 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:06 2014] [error] [client 217.174.199.129] File does not exist: /opt/sites/beta.potesnroll.com/www/n
[Wed Apr 16 17:00:13 2014] [error] [client 217.174.199.129] Directory index forbidden by Options directive: /opt/sites/beta.potesnroll.com/www/install/
[Wed Apr 16 17:00:32 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:32 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:32 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:41 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:41 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:41 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:41 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:41 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:41 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:41 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:41 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:41 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:42 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:43 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:43 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:43 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:43 2014] [error] [client 217.174.199.129] PHP Warning:  copy(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 182
[Wed Apr 16 17:00:43 2014] [error] [client 217.174.199.129] PHP Warning:  require_once(/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php): failed to open stream: No such file or directory in /opt/sites/beta.potesnroll.com/www/index.php on line 191
[Wed Apr 16 17:00:43 2014] [error] [client 217.174.199.129] PHP Fatal error:  require_once(): Failed opening required '/opt/sites/beta.potesnroll.com/www/gz/app/Class-System.php' (include_path='.:/usr/share/php:/usr/share/pear') in /opt/sites/beta.potesnroll.com/www/index.php on line 191
Re: SMF 2 to Wedge importer errors
« Reply #37, on April 17th, 2014, 01:40 PM »
This is the part that fails :

Code: [Select]
public static function copy_smileys($source, $dest)
        {
                if (!is_dir($source) || !($dir = opendir($source)))
                        return;

                while ($file = readdir($dir))
                {
                        if ($file == '.' || $file == '..')
                                continue;

                        // If we have a directory create it on the destination and copy contents into it!
                        if (is_dir($source . '/' . $file))
                        {
                                if (!is_dir($dest))
                                        @mkdir($dest . '/' . $file, 0777);
                                self::copy_dir($source . '/' . $file, $dest . '/' . $file);
                        }
                        else
                        {
                                if (!is_dir($dest))
                                        @mkdir($dest . '/' . $file, 0777);
                                copy($source . '/' . $file, $dest . '/' . $file);
                        }
                }
                closedir($dir);

I could perhaps manually create the folder and chmod it before running the installer :hmm:
Re: SMF 2 to Wedge importer errors
« Reply #39, on April 17th, 2014, 11:47 PM »
I tried tonight ton convert another forum, Eclipse Totale, which is a dead forum.

The process stopped with :

Code: [Select]
Importation en cours...

Message: Undefined property: Importer::$xml
Trace: Undefined property: Importer::$xml
Line: 525
File: /opt/sites/eclipse.potesnroll.com/www/import.php

I have no clue if everthing is globally OK. The forum being dead, I'll leave it with Wedge and will try to check. If it's a real problem, I'll rollback to SMF, not a problem ^^

( http://eclipse.potesnroll.com/ )
Re: SMF 2 to Wedge importer errors
« Reply #40, on April 18th, 2014, 12:08 AM »
@Nao : Tu penses qu'il manque quelque chose ?
A vu de nez, non, le nombre de messages est le bon. Je ne sais pas sur quelle étape ça a coincé.

Gaza07

  • Posts: 3
Re: SMF 2 to Wedge importer errors
« Reply #41,  »
I have just setup wedge and tried to import my database from smf 2.011 and got this error after it imported the members
Quote
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 12288 bytes) in /home/multirot/public_html/wedge-master/importer-master/import.php(2061) : runtime-created function on line 5
any ideas how to get past this :unsure:

Pandos

  • Living on the edge of Wedge
  • Posts: 635

Gaza07

  • Posts: 3
Re: SMF 2 to Wedge importer errors
« Reply #43,  »
I dont have access to the file on my server, it already used a large amount of memory :wow: not sure if my provider will allow more, my database is 152mb

CerealGuy

  • Posts: 330
Re: SMF 2 to Wedge importer errors
« Reply #44,  »
Try to convert it on you computer and just import the converted database on your webspace.