Archive for the e-Commerce Blog Category

Memory Error on OXID CE 4.2 for Gutschein/Coupons

While generating Gutschein-Series, this error has consistently shown.

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 45 bytes) in /home/originis/www/core/oxbase.php on line 1207

Using wget for Downloading latest OXID CE

The OXID CE Download page doesn’t offer a direct link to download the latest distribution using wget, rather just a button.

If you’d like to download the latest version of OXID CE to your CLI-run servers using wget, use

The file will be placed on your disk as index.php, which you will have to rename.

Purging the OXID CE Product Catalog

If you’d for some reason like to purge the Product and Category catalog in an OXID CE (4.2 at time of writing) database, delete entries from the below tables:

  • oxartextends
  • oxaccessoire2article
  • oxarticles
  • oxattribute
  • oxreviews
  • oxvouchers
  • oxactions2article
  • oxcategories
  • oxobject2article
  • oxprice2article
  • oxselectlist
  • oxcategory2attribute
  • oxpricealarm
  • oxuserbasketitems
  • oxmediaurls
  • oxobject2category
  • oxobject2selectlist

Wiederherstellung des OXID Admin Passwortes

Falls Sie jemals das OXID/Admin Passwort vergessen sollten, können Sie es mit Hilfe der folgenden Schritte zurücksetzen.

Schritt 1

Loggen Sie sich mit dem Client Ihrer Wahl in die MySQL-Datenbank ein (z.B. mysql, mysql5 or phpmyadmin)  und ändern Sie Email-Adresse (und Benutzernamen) im Verzeichnis oxuser.

Ab OXID CE 4.2.x können Sie auch den folgenden Befehl verwenden:

update oxuser set oxusername=’’ where oxid=’oxdefaultadmin’;

Schritt 2

Navigieren Sie zum Frontend und setzen Sie mit der Funktion Reset Password das Passwort unter Beibehaltung dieser Email-Adresse ( zurück.


  1. Mit dieser Methode kann nicht nur das Admin Passwort, sondern auch der Benutzername geändert werden. Diese Funktion benötigen Sie auch zur Anderung des voreingestellten Benutzernamens in der Debian/Lenny Virtual Machine für OXID.

Neu in 4.3

Ab OXID 4.3 ist der /admin/ Benutzername eine Email-Adresse. Damit können Sie einfach das Passwort vergessen Tool im Frontend verwenden, um das Passwort via Reset-Link per Email zurückzusetzen.

Recovering OXID Admin Password

If you have ever misplaced the OXID/Admin password, these steps will help you reset it.

Step 1

Login to your MySQL database with your favorite client (like mysql, mysql5 or phpmyadmin)  and change the email address (also username) of the admin user in the table oxuser.

Upward of OXID CE 4.2.x, you can use the following command:

update oxuser set oxusername=’’ where oxid=’oxdefaultadmin’;

Step 2

Go to the front end and reset the password pertaining to this email address (  using the Reset Password function.


  1. This method can be used not only to change the administrator password, rather also the username.  You will need this for changing the default username on the Debian/Lenny Virtual Machine for OXID.

Starting Version 4.3.x

The /n/ username starting OXID 4.3 is enforced to be an email address.  Hence for all newer versions, namely 4.4.x, 4.5.x etc.., you can skip Step-1 above, and use the Forgot Password tool from the shop front-end to have a password-reset link send by email.

Debug Information from OXID Shop

The OXID e-shop allows extensive logging and debugging information if you are attempting to troubleshoot problems, or just wanting to gain better insight into the system.  A debug level between -1 and 7 can be set in the file.

Currency Settings in OXID e-Shop

OXID Currency // Master Settings New-comers to OXID e-Shop may find the currency-settings a bit mysterious.  Even as of current version 4.2.0 it is relatively simple to setup in the /admin area.  Follow:

Master Settings > Core Settings > Settings > Other Settings

Look for a textarea with instructions which read as:

Add or remove Currencies. The format is:
[name]@[rate]@[decimal separator]@[thousand separator]@[symbol]@[decimal precision]

Setup all the currencies you desire using the format above (drop the square brackets [] and use @ as the separator).  Example:


They appear on the front end as follows.

OXID eShop Currency Settings

404 Not found oxseo.php

Short of bashing my head against the office wall upon being repeatedly confronted with a 404 Not Found error, I realized that I was using the wrong path for RewriteBase in .htaccess file.  The exact error was:

The requested URL /home/oxid/pubweb/4_2_0/oxseo.php was not found on this server.
Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny4 with Suhosin-Patch Server at Port 80

If anyone faces this on your OXID installations, this could be your fix, too.

We were using:
RewriteBase /home/oxid/pubweb/4_2_0/

Instead we should have been using:
RewriteBase /oxid/

.. where the target URL is (being used to put together a Debian 5.0 Lenny Virtual Machine for OXID 4.2)

xtc2oxid – Migrating xt:commerce Shops to OXID

Itratos from Bamberg has done a great job with coming up with a Migration-Script for shops moving from xt:commerce shop software to OXID (currently version 4.2).

Command Line (CLI) and Web-based Script

Two variants of the script are available, each for a web-browser based invocation and a command-line (CLI) invocation.  We used CLI method.

console@host:~/xtc2oxidmodule$ php xtc2oxid_commandline.php &

Skip the & at the end of the command if you wish to see the live output on the console, else the command will run in the background.  For the first time you run the script, it isn’t a bad idea to view the live output on the console.


A few initial glitches had to be overcome, primarily because the PHP CLI binary on the migration machine was of PHP4, which rendered calls to native OXID classes unsuccessful.  Replacing the php4-cli package from our Debian 5.0 Lenny machine with php5-cli fixed the problem.  Remarks in this post pertain to the CLI-method.

Variables related to the migration environment, such as paths of the existing xt:commerce shop, the target OXID shop, database settings etc. are stored in a handy _config.php, placed in the same directory as the xtc2oxid_commandline.php script.

Types of Data Migrated

  • Customer/Buyer data with all addresses
  • Products, including pictures and variants
  • Categories
  • Manufacturers
  • Orders
  • Newsletter and newsletter-subscribers

User Data

User-data (shop buyers) is migrated as well.  However it is required that users are informed of new passwords, since the database storage encryption is different in xt:commerce and OXID (uses md5).

About euroblaze’s OXID Migration Services

euroblaze provides migration-services for OXID Shops.  We migrate other shops systems (such as xt:commerce) to OXID e-Sales, or older versions of OXID (OXID-2, OXID-3, OXID Mietshop/SaaS), to  newer versions.

Save MySQL – Oracle, the fox in the henhouse?

For those us in the OXID community who are living the benefits of Commercial Open-Source software, The future of MySQL in Oracle’s ownership could come as a particularly tricky issue, since there is direct competition between MySQL and the new owner’s core product.

Under Sun’s ownership, the danger was not as acute, since autonomous-Sun was an open-source affine company, and secondly had no other parallely competing products in their portfolito.

The future of MySQL is indeed at stake.  Please take a minute to voice your opinion at and promote this question, so that it can be debated in the community as formidably as possible.