Elxis CMS Forum

Support => Technical support => Topic started by: datahell on December 14, 2013, 21:24:29

Title: Elxis Converter
Post by: datahell on December 14, 2013, 21:24:29
Elxis Converter is a tool for transferring data from an old Elxis 2006.x, 2008.x and 2009.x installation to an Elxis 4.x one. Depending on the extensions you have installed on the old site the conversion percentage might reach 100% or lower. Old extensions not supported by Elxis 4.x will not be converted. For other extensions the converter will use a compatible new extension. For example instances of the Easy Gallery bot will be converter to instances of the plugin Gallery. When ever the converter reports you that used a plugin after the conversion is complete you must make sure these plugins exist in Elxis 4.x, and if not you must install them.

Before you begin

What is converted

Usage instructions

It is important to understand that the converter will transfer the site's data from one site to the other, it will not build your site. After the conversion is complete you will have to work on the Elxis 4.x site. Install a template, or configure a pre-installed one, configure and install modules, etc.

If you have any question you may ask below.
Title: Elxis Converter - οδηγίες στα Ελληνικά
Post by: datahell on December 15, 2013, 17:29:03
Ο Elxis Converter (μετατροπέας) είναι ένα εργαλείο για μεταφορά δεδομένων από μία παλιά εγκατάσταση Elxis 2006.x, 2008.x και 2009.x σε μία με το νέο Elxis 4.x.
Ανάλογα των επεκτάσεων που έχετε εγκαταστήσει στον παλιό ιστότοπο το ποσοστό μετατροπής μπορεί να φτάσει το 100% ή λιγότερο. Παλαιές επεκτάσεις που δεν
υποστηρίζονται στο Elxis 4.x δεν θα μετατραπούν. Σε άλλες επεκτάσεις ο μετατροπέας θα χρησιμοποιήσει συμβατές νέες επεκτάσεις. Για παράδειγμα ενσωματώσεις του bot Easy Gallery
θα μετατραπούν σε ενωματώσεις του plugin Gallery. Αν ο μετατροπέας σας αναφέρει ότι χρησιμοποίησε κάποια plugin, μετά το τέλος της μετατροπής βεβαιωθείτε πως αυτά τα plugin
υπάρχουν στο Elxis 4.x, και αν όχι, εγκαταστείστε τα.

Πρωτού ξεκινήσετε

Τι μετατρέπεται

Οδηγίες χρήσης

Είναι σημαντικό να κατανοήσετε ότι ο μετατροπέας θα μεταφέρει τα δεδομένα του ενός ιστότοπου στον άλλον, δεν θα φτιάξει το νέο σας site. Αφότου ολοκληρωθεί η μετατροπή θα πρέπει να δουλέψετε λίγο στον ιστότοπο με το Elxis 4.x. Να εγκαταστείσετε κάποιο template, ή να ρυθμίσετε ένα προεγκατεστημένο, να εγκαταστείσετε και ρυθμίσετε module, κλπ.

Αν έχετε κάποια ερώτηση μπορείτε να την υποβάλετε παρακάτω.
Title: Re: Elxis Converter
Post by: ArXoS on December 16, 2013, 00:13:32
  • On some steps you will see useful information you might have to note down. For example the new administrator password! Write somewhere this else you will not be later to login!
Ops .. Because of the many steps, i missed this .. Now i cant login as admin. If i start conversion again, the script will prompt me with a new admin pass?
Title: Re: Elxis Converter
Post by: datahell on December 16, 2013, 08:42:05
Yes, each time you run the converter everything starts from the very begin. The converter will show you the password, dont forget to note it down this time.
BTW, you can reset the password by using the "I forgot my password" feature.
Title: Re: Elxis Converter
Post by: fivar on December 17, 2013, 18:11:34
Μετέτρεψα 2 sites από 2006 και 2008 σε 4.1.
Η μετατροπή έγινε σε ικανοποιητικό βαθμό, το μόνο πρόβλημα που έχω είναι ότι μετά την μετατροπή
δεν μπορώ να εγκαταταστήσω module (components, plugins και templates δεν έχουν πρόβλημα).
(Δοκίμασα την εγκατάσταση του 4.1 σε φάκελο και σε subdomain.)

Title: Re: Elxis Converter
Post by: datahell on December 17, 2013, 18:32:26
Τέλειωσες δηλαδή την μετατροπή, συνδέεσε στο Elxis 4.1 και εκεί μπορείς να εγκαταστήσεις plugin αλλά όχι module; Τι μήνυμα ακριβώς σου βγάζει;

Δες τα εξής:
1. Ο φάκελος "modules" να είναι εγγράψιμος.
2. Από το μενού επέλεξε Επεκτάσεις > Components. Κάνε κλικ στο component "Extensions manager". Δες στην καρτέλα "Accesss" (πρόσβαση) αν υπάρχει αυτή η γραμμή:
Modules - Install - Administrator
Title: Re: Elxis Converter
Post by: bledi on December 17, 2013, 19:20:19
Hello!
I started the converter, and everything goes ok, till STEP 15:
HTTP 500 Internal Server Error (in explorer) or in Mozilla, Chrome the screen Freezes.
Has someone faced this problem?
Title: Re: Elxis Converter
Post by: datahell on December 17, 2013, 19:30:28
Step 14: Conversion of IOSR payment modules
Step 15: Conversion of IOSR reservations
Step 16: Conversion of IOSR reserved items

Please specify the exact area  in which the problem appears:
1. On Step 14 when you click to go to Step 15
2. On Step 15 where you click to go to Step 16
3. On Step 15 when you click to go to the next turn within step 15.

Note: In order to convert IOSR you must have IOSR of version 3.5 or 3.6. Older versions are not supported.

Also provide more information about the problem. Do you see any error message? Can you check your server's error.log and if any error is noted there? After how much time (in seconds) after you click the button the error appears?
Title: Re: Elxis Converter
Post by: fivar on December 17, 2013, 19:33:47

2. Από το μενού επέλεξε Επεκτάσεις > Components. Κάνε κλικ στο component "Extensions manager". Δες στην καρτέλα "Accesss" (πρόσβαση) αν υπάρχει αυτή η γραμμή:
Modules - Install - Administrator

Η γραμμή υπήρχε αλλά δεν είχε δικαιώματα διαχειριστή. Το άλλαξα και το πρόβλημα λύθηκε!!

Ευχαριστώ
Title: Re: Elxis Converter
Post by: bledi on December 17, 2013, 20:00:56
hello

The error shoes:
1. On Step 14 when you click to go to Step 15.
the error is shown very quick, 2 seconds, i tried many times, in mozilla and chrome the screen freezes, in explorer: HTTP 500 Internal Server Error.
 
I am using Iosr 3.6
The Server error Log is empty.
Title: Re: Elxis Converter
Post by: datahell on December 17, 2013, 20:40:22
If you see an error in your screen there will be a detailed message in error.log. Except if logging is disabled in your server which is something very rare.
Title: Re: Elxis Converter
Post by: rentasite on December 19, 2013, 00:43:18

John, can you plz tell us more about the "Covert all content" option? saw the screenshot on EDC, and can't understand why the result will be bad if this is set to YES.

(https://www.elxis.net/components/com_edc/images/ext_57_image2.png)
Title: Re: Elxis Converter
Post by: datahell on December 19, 2013, 09:05:20
This option has effect only on sites with content in multiple languages.

If you select Yes, content for all languages will be mixed to the final output. For instance if you have in mainmenu a menu item named "Home" in English and an other menu item named "Αρχική" in Greek in the final result both "Home" and "Αρχική" will be shown for English and for Greek! The same will happen for categories, articles, etc. If you have content in more than 2 languages the mess will become even bigger. Cose this option only if you absolutely understand what it means and you want to do something custom.

Instead of selecting Yes, if you select No, then only content for the main, or all, language will be converted and at a later step you will be able to convert the rest content as translations of the content in the default language.

I cant analyze it more, it is a long discussion that derives from the different multilinguism philosophy of Elxis 200x.x and Elxis 4.x, but I think you got the idea.
Title: Re: Elxis Converter
Post by: rentasite on December 19, 2013, 20:07:49
I cant analyze it more, it is a long discussion that derives from the different multilinguism philosophy of Elxis 200x.x and Elxis 4.x, but I think you got the idea.

Yes John, i did. Thanks!  :)
Title: Re: Elxis Converter
Post by: intefix on January 14, 2014, 18:21:34
Για σας και καλή χρονιά..
Περίμενα τον μετατροπέα και είπα να αρχίσω να μετετρέπω τα παλιά μου sites.
Άρχισα από το πρώτο (http://lets.net.gr/elx41/) που βρήκα μπροστά μου.
Άφησα την ίδια βάση αλλάζοντας prefix στους πίνακες σε elx41 και όλα τα άλλα
default. Η εγκατάσταση έγινε κανονικά ως βλέπετε.
-----Έκανα 2 φακέλους ένας elx41 για το site και ένας new για τον converter.-------είναι κάτι λάθος;
Πάω στη διαχείριση (http://lets.net.gr/elx41/estia/)...τζίφος με γυρνάει στο παλιό site.
Βάζω καρφωτά το index.php (http://lets.net.gr/elx41/estia/index.php) με πάει στη σελίδα login
Βάζω τα δέοντα αλλά πάλι στο παλιό site...
Τι κάνω;
Title: Re: Elxis Converter
Post by: datahell on January 14, 2014, 21:14:30
Εφόσον έχεις το site μέσα σε φάκελο πρέπει να αλλάξεις στο αρχείο .htaccess το rewrite base σε:

RewriteBase /elx41/
Title: Re: Elxis Converter
Post by: intefix on January 15, 2014, 06:54:23
"Εγκαταστείστε το Elxis 4.x στον ίδιο ιστότοπο με το παλιό Elxis 200x.x (σε ένα sub-domain ή φάκελο). Αυτό απαιτείται προκειμένου ο μετατροπέας να μπορέσει να μεταφέρει αρχεία εικόνων από τον έναν ιστότοπο στον άλλον."
Μπορούσα και να μην το κάνω; Πως θα γίνει η δουλειά αλλοιώς; Μετά θα το βγάλω από τον φάκελο;
Συγγνώμη αν λέω καμμια κοτσάνα...
Title: Re: Elxis Converter
Post by: datahell on January 15, 2014, 09:23:29
Καλά το έκανες, απλά το htaccess άλλαξε ή απενεργοποίησε τις sef urls (configuration.php : PRIVATE $SEF = 0; )
Μετά μπορείς να το βγάλεις από το φάκελο και να το πας όπου θες.
Title: Re: Elxis Converter - οδηγίες στα Ελληνικά
Post by: intefix on January 28, 2014, 18:50:14
Ο Elxis Converter (μετατροπέας) είναι ένα εργαλείο για μεταφορά δεδομένων .... Αφότου ολοκληρωθεί η μετατροπή θα πρέπει να δουλέψετε λίγο στον ιστότοπο με το Elxis 4.x. Να εγκαταστείσετε κάποιο template, ή να ρυθμίσετε ένα προεγκατεστημένο, να εγκαταστείσετε και ρυθμίσετε module, κλπ...
Να υποθέσω ότι πρέπει να είναι συμβατά με Elxis 4x ε;
Τα κατάφερα να μετατρέψω το πρώτο μου site (http://www.lets.net.gr/elx41/). Και εδώ το παλιό (http://www.lets.net.gr) Ενώ δεν έβγαλε κάποιο πρόβλημα κατά τη μετατροπή μου φαίνεται ότι κάτι δεν πάει καλά...πχ με τις φωτο.
Στο παλιό πρέπει να βγάζει σφάλματα και μη δυνατότητα login (http://lets.net.gr/administrator/) η είναι άσχετο;
Άντε και τα τέλειωσα διαγράφω το παλιό και πως μεταφέρω (αλλάζω φακέλους ) στο καινούριο;
Title: Re: Elxis Converter
Post by: datahell on January 28, 2014, 19:59:25
Το σφάλμα στο παλιό δεν έχει σχέση με την μετατροπή, είναι επειδή έχουν κόψει την συνάρτηση php_uname στην php σου. Ο converter σου μεταφέρει τα δεδομένα, δεν σου φτιάχνει το site. Αφού ολοκλήρωσες την μετατροπή ασχολήσου με το νέο, φτιάξε την εμφάνιση, βάλε module, κλπ, και όταν είσαι έτοιμος διαγράφεις το παλιό και μεταφέρεις τα περιεχόμενα του φακέλου elx41 στον πηγαίο κατάλογο. Θέλει λίγη δουλίτσα για να σουλουπώσεις το νέο.

Για να λύσεις το πρόβλημα στο παλιό site άνοιξε το αρχείο includes/Core/locale.php πήγαινε στη γραμμή 200 και άλλαξε αυτό:
$os = strtoupper(substr(php_uname(), 0, 3));
με αυτό:
$os = 'LIN';

Εφόσον ο server σου είναι linux/unix
Αν είναι windows κάντο $os = 'WIN';
Title: Re: Elxis Converter
Post by: wbread on February 17, 2014, 11:50:45
disappointed  :-\

worse result my expectations, the site will still have to rewrite
Title: Re: Elxis Converter
Post by: datahell on February 17, 2014, 13:25:39
The Converter imports data, which can be imported, from the old site to the new one. It will not make you a site ready to be turned online to public. Depending on the original site the convertion rate may vary from 100% to any percentage below that. You may try to re-write the articles and the categories from the very beginning to see the difference and estimate the help the Converter offers you.
Title: Re: Elxis Converter
Post by: wbread on February 17, 2014, 14:19:39
I understand it, and did it. but the result - it is easier to do it again.
besides, the template does not allow to place the blocks as I need
http://gyazo.com/c0e12851e20c81c7bd360d778a4ea081
Title: Re: Elxis Converter
Post by: datahell on February 17, 2014, 18:42:08
This is the Elxis' frontpage generator grid, not the template. Your template surely has even more template positions and certainly left and/or right columns. You can put unlimited module positions on each frontpage grid cell and each module position can have assigned unlimited modules.  Are you sure you can't have the layout you want? Can you draw me which layout you want?
Title: Re: Elxis Converter
Post by: wbread on February 17, 2014, 20:38:30
it would be more understandable if the template was a note like this
(https://www.elxis.net/components/com_edc/images/ext_24_image3.png)
Title: Re: Elxis Converter
Post by: datahell on February 19, 2014, 13:50:42
Elxis frontpage grid is not a template. It lets you generate a grid layout. Inside each grid cell you place module positions to generate a template style layout. Have you read the documentation (https://www.elxis.net/docs/using-elxis/administration/site-frontpage.html)?
Title: Re: Elxis Converter
Post by: wbread on February 19, 2014, 14:03:48
read it) thanks
Title: Re: Elxis Converter
Post by: mscrivo on September 19, 2014, 03:56:24
I'm having a problem with this converter.  I've got a site that is using Elxis 2009 with IOSR 3.6, and everything checks out fine on Step 1.  Here are the details:

Detected conversion source:
Name
Elxis 2009.3 Stable rev2681 [ Aphrodite ] 24-April-2011 21:08 GMT+2

Detected conversion target:
Name
. rev [ ]


It detects IOSR and doesn't give me any warnings other than it not being able to convert Hotels and Room facilities, so I click next and Step 2 doesn't give me any failures, but once I click next to Step 3, I get this:


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in /rootPath/includes/libraries/elxis/database/statement.class.php:41 Stack trace: #0 /rootPath/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL) #1 /rootPath/converter/inc/conv.class.php(886): elxisPDOStatement->execute() #2 /rootPath/converter/inc/conv.class.php(109): elxisConverter->step3() #3 /rootPath/converter/index.php(32): elxisConverter->processStep() #4 {main} thrown in /rootPath/includes/libraries/elxis/database/statement.class.php on line 41

Any ideas?
Title: Re: Elxis Converter
Post by: datahell on September 19, 2014, 19:30:24
The Converter needed an update for Elxis 4.2, sorry for the trouble.

Download again the Converter (https://www.elxis.net/edc/miscellaneous/57.html).
The only file I updated is this:
converter/inc/conv.class.php

You can replace just that or the whole converter.

If you still have problems please reply below.
Title: Re: Elxis Converter
Post by: mscrivo on September 19, 2014, 21:03:12
Got the new converter, ensured that the file you mentioned is newer than what I had, but still the same error persists.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in /rootPath/includes/libraries/elxis/database/statement.class.php:41 Stack trace: #0 /rootPath/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL) #1 /rootPath/converter/inc/conv.class.php(886): elxisPDOStatement->execute() #2 /rootPath/converter/inc/conv.class.php(109): elxisConverter->step3() #3 /rootPath/converter/index.php(32): elxisConverter->processStep() #4 {main} thrown in /rootPath/includes/libraries/elxis/database/statement.class.php on line 41
Title: Re: Elxis Converter
Post by: datahell on September 20, 2014, 18:27:37
No, you are not using the new version. In the new version the code that triggers the error has been moved from line 886 to line 908. If you get exactly the same error it means you still use the old version. Please re-download Elxis Converter and do as I wrote in my previous post.

 /rootPath/converter/inc/conv.class.php(886)
Title: Re: Elxis Converter
Post by: mscrivo on September 21, 2014, 17:45:06
I actually did ensure I had the new version (verified by date and file size), and it still does error out.  I just happened to copy and paste the old error from the wrong tab.  Here's the new error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in /rootPath/includes/libraries/elxis/database/statement.class.php:41 Stack trace: #0 /rootPath/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL) #1 /rootPath/converter/inc/conv.class.php(908): elxisPDOStatement->execute() #2 /rootPath/converter/inc/conv.class.php(110): elxisConverter->step3() #3 /rootPath/converter/index.php(32): elxisConverter->processStep() #4 {main} thrown in /rootPath/includes/libraries/elxis/database/statement.class.php on line 41
Title: Re: Elxis Converter
Post by: datahell on September 21, 2014, 19:58:31
It is very strange, it should work...
If you like send me with a private message access details to your site's FTP or to a file manager in your hosting control panel to debug the converter. I need to debug it to see why this error occurs.
Title: Re: Elxis Converter
Post by: sawaedy on January 04, 2015, 21:46:36
i upload the converter but what i install? 
Title: Re: Elxis Converter
Post by: sawaedy on January 05, 2015, 00:00:28
i convert but website not loaded and shows the eror:  Directory browsing is not allowed!
Title: Re: Elxis Converter
Post by: sawaedy on January 05, 2015, 13:18:25
I want help to resolve problem
Title: Re: Elxis Converter
Post by: datahell on January 05, 2015, 20:10:42
The first post of this topic describes in details how to use the converter. If you follow the instructions you wont have any problem.

The general idea is this:
I have a web site example.com powered by Elxis 200x.x
I install Elxis 4.x on a folder of that site, eg example.com/elxis4/
I upload the converter in a folder of the Elxis 4.x site example.com/elxis4/converter/
I run the converter. The converter will transfer all the data from the Elxis 200x.x site to the Elxis 4.x one.
I delete the converter folder.
I work on the Elxis 4.x site and when ready I delete the old 200x.x site and move the Elxis 4.x site to its place. At the end I will have an Elxis 4.x site with the contents of the old 200x.x site running on example.com
Title: Re: Elxis Converter
Post by: sawaedy on January 06, 2015, 01:55:12
i do but frontpage not load and shows the :
Directory browsing is not allowed!
sawaedy.com
Title: Re: Elxis Converter
Post by: sawaedy on January 06, 2015, 03:00:57
the home page is not loaded but other pages website loaded normally  where is the problem? thank from help
Title: Re: Elxis Converter
Post by: webgift on January 06, 2015, 12:11:14
Remove index.html file from the root folder and try again!
Title: Re: Elxis Converter
Post by: datahell on January 06, 2015, 12:24:51
I believe you have problem with the htaccess file. When the site is inside a folder and there is a parent folder with an other site, and most probably an other htacces file, you must edit the htaccess file to set the proper value for RewriteBase for the site inside the folder. Open the default .htaccess file and you will see a comment for that that will help you fix the problem. If you can't fix the problem send me a PM with access to your ftp to do it for you.
Title: Re: Elxis Converter
Post by: sawaedy on January 06, 2015, 16:48:49
MR Datahell i send pm for you with id and password fo resolve the problem. very  thank.
Title: Re: Elxis Converter
Post by: sawaedy on January 06, 2015, 18:12:43
thank from all. i removed the index.html  and website work correctly .
Title: Elxis Converter 1.3 for Elxis 4.3+
Post by: datahell on December 18, 2015, 20:57:50
I release an updated version of Elxis Converter compatible to Elxis 4.3+
Current version of Elxis converter is now 1.3
Download Converter from EDC (https://www.elxis.net/edc/miscellaneous/57.html)
Title: Re: Elxis Converter
Post by: jimmyz on November 01, 2016, 09:57:05
Hello dear friends,
I've been trying to convert a 2009.3 to 4.3



Got stuck on step 4:

Code: [Select]
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in /home/jim/public_html/new4/includes/libraries/elxis/database/statement.class.php:41 Stack trace: #0 /home/jim/public_html/new4/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL) #1 /home/jim/public_html/new4/converter/inc/conv.class.php(1119): elxisPDOStatement->execute() #2 /home/jim/public_html/new4/converter/inc/conv.class.php(111): elxisConverter->step4() #3 /home/jim/public_html/new4/converter/index.php(32): elxisConverter->processStep() #4 {main} thrown in /home/jim/public_html/new4/includes/libraries/elxis/database/statement.class.php on line 41
I don't understand what column is mising from the db. My 4.3 db has 21 tables:
elx_acl
elx_authentication
elx_categories
elx_comments
elx_components
elx_content
elx_downloads
elx_engines
elx_frontpage
elx_groups
elx_menu
elx_modules
elx_modules_menu
elx_plugins
elx_session
elx_statistics
elx_statistics_temp
elx_templates
elx_template_positions
elx_translations
elx_users

Any clues?
Title: Re: Elxis Converter
Post by: datahell on November 01, 2016, 21:46:40
The error is been generated during conversion of Elxis 2009.x eBlog items into Elxis 4.x articles. Are you sure you have Elxis 4.3?
Can you please tell me which columns (id, catid, title, ...) the database table "elx_content" has in your Elxis 4.x installation?
Title: Re: Elxis Converter
Post by: jimmyz on November 02, 2016, 00:13:33
Hi Yannis,
thank you for replying.

I guess these are the columns of elx_content
Code: [Select]
`elx_content` (`id`, `catid`, `title`, `seotitle`, `subtitle`, `introtext`, `maintext`, `image`, `caption`, `published`, `metakeys`, `created`, `created_by`, `created_by_name`, `modified`, `modified_by`, `modified_by_name`, `ordering`, `hits`, `alevel`, `params`, `pubdate`, `unpubdate`, `important`, `relkey`)
Title: Re: Elxis Converter
Post by: jimmyz on November 02, 2016, 00:28:40
Bypassing the eblog conversion, took me to the next step.

Almost finished now, thank you!

Lots of hard work must follow now.
Title: Re: Elxis Converter
Post by: webgift on November 02, 2016, 09:28:35
In any way it is important to fix this issue for eBlog items into 4.x.
Title: Re: Elxis Converter
Post by: giormet on February 04, 2017, 19:28:05
Bypassing the eblog conversion, took me to the next step.
Hi, because i have the same problem how you bypass eblog conversion?
Thanks
Title: Re: Elxis Converter
Post by: giormet on February 04, 2017, 19:41:59
Ok, i find it...
Title: Re: Elxis Converter
Post by: webgift on June 08, 2017, 10:33:46
Issue converting eBlog posts to Elxis 4.2+ is now fixed.
https://www.elxis.net/edc/miscellaneous/57.html
Title: Re: Elxis Converter
Post by: nikos on January 28, 2019, 22:26:02
I converted an Elxis 2008.0 Rev 1891 old site with over 600 articles, 40 categories, 9 sections and many images, to a new Elxis 4.6 Phaethon rev1958, within 4 minutes, without any problem.

Congratulations @datahell for this super tool!