Hi Jens-Christopher,
thank you for your valuable feedback and your solution! You can also
improve the developer documentation directly via pull request:
https://docs.oxid-esales.com/developer/en/6.0/#help-improving-this-documentation
> Maybe there is a newer/more compatible source for migrations which I
have missed?!
No, this is the official documentation. This is a major update which
means there can be manual steps necessary, depending on your system and
configuration.
> To solve this you have to remove OXNAME = 'OXID eShop 6' on line 10
We fixed this in the scripts.
> You can solve this by adding SET @@session.sql_mode = ''; to the
beginning of the script
We also added this to the scripts.
Cheers,
Gregor Hyneck, core developer
On 10.04.2018 13:22, Jens Trant wrote:
Hi guys,
I spent yesterday only a few hours for a test migration from EE 5.3.7
to 6.0.2, which seems to be actually buggy.
Maybe there is a newer/more compatible source for migrations which I
have missed?!
My source was the official documentation:
https://docs.oxid-esales.com/developer/en/6.0/update/eshop_from_53_to_6/database.html
Below you can see the results of the short test migration and possible
solutions for common errors in the migration process.
The migration SQL script seems to have some bugs
(migrate_ee_5_3_to_6_0.sql):
- All shop names will be replaced, the update command for CE & PE is
not modified for EE users in the EE script
-> To solve this you have to remove OXNAME = 'OXID eShop 6' on line 10
- If you use MySQL >= 5.7 strict mode is by default active and
NO_ZERO_DATE and NO_ZERO_IN_DATE is set in the sql_mode option by
default, the migrate script will produce fatal errors by many statements.
-> You can solve this by adding SET @@session.sql_mode = ''; to the
beginning of the script
Further if you used the Fatchip PayOne module in the CE, PE or EE
before, you are not able to activate this module after migration in
the backend (Error: Module could not be loaded).
- This is caused by the new module path (fc/fcpayone) and the old
encoded oxconfig values in the database where the path is still the
old one (fcPayOne). I tried two options for trying to fix this, but
both will result in loosing data (all fatchip transaction tables are
empty after activation)!
-> Option A: Set a symlink in the modules directory for fcPayOne ->
fc/fcpayone
-> Option B: Update the 'aModulesPaths' in oxconfig via SQL
-> SQL:
UPDATE `oxconfig`
SET `OXVARVALUE` = ENCODE(
REPLACE (
DECODE
(
OXVARVALUE
,'YOUR_ENCODING_KEY'
)
,";s:8:\"fcpayone\";s:8:\"fcPayOne\";"
,";s:8:\"fcpayone\";s:11:\"fc/fcpayone\";"
)
,'YOUR_ENCODING_KEY'
)
WHERE OXVARNAME = 'aModulePaths';
I also noticed that the GitHub page of the PayOne module (which is
already bundled with Oxid v6) says: 'Please note, that this extension
is not yet released in production.'
(https://github.com/PAYONE-GmbH/oxid-6), obviously the description is
outdated.
I Hope the information will help some of you, feel free to share this
in forums/social media/mails/or anything else you prefer ;)
Thanks,
Jens-Christopher Trant
Closed <http://www.closed.com/>
Closed GmbH| Straßenbahnring 6 | 20251Hamburg | Germany
T +49 40 441840 865 | M +49 151 28439981 | E jens.tr...@closed.com
<mailto:jens.tr...@closed.com>
closed.com <http://closed.com> | facebook.com/closed
<https://www.facebook.com/closed>_<http://www.facebook.com/closed>_ |
instagram.com/closedofficial <https://www.instagram.com/closedofficial/>
Amtsgericht Hamburg HRB 53868 | Umsatzsteuer-Ident.-Nr.: DE 164980577
GF: Gordon Giers, Til Nadler, Hans Redlefsen
--
Gregor Hyneck HTML-E-Mail-Signatur
*Gregor Hyneck*
Software Developer
*gregor.hyn...@oxid-esales.com <mailto:gregor.hyn...@oxid-esales.com>*
Fon +49 761 36889-231
Fax +49 761 36889-29
*www.oxid-esales.com
<http://www.oxid-esales.com?campaign=emailsignatur/oxid-esales-com&adword=OXSIG_Startseite>*
Logo E-Commerce Berlin <https://ecommerceberlin.com/?de>
*E-Commerce Berlin, 15.02.2018, STATION Berlin, Stand B026*
Logo Internet World <https://www.internetworld-expo.de/>
*Internet World EXPO, 06.-07.03.2018, Messe München, Stand C072*
Logo Commons <https://commons.oxid-esales.com/>
*OXID Commons 2018, 14.06.2018, Messe Freiburg*
*OXID eSales AG*
Bertoldstraße 48
79098 Freiburg
Deutschland
Vorstand: Roland Fesenmayr (Vorsitzender), Dr. Oliver Ciupke
Vorsitzender des Aufsichtsrats: Michael Schlenk, Sitz: Freiburg
Amtsgericht Freiburg i. Br., HRB 701648, USt-IdNr.: DE231450866