Archive for the Shopbetreiber Tipps Category

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=’user@domain.com’ where oxid=’oxdefaultadmin’;

Schritt 2

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

Anmerkung

  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=’user@domain.com’ where oxid=’oxdefaultadmin’;

Step 2

Go to the front end and reset the password pertaining to this email address (user@domain.com)  using the Reset Password function.

Notes

  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.

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:

EUR@1@,@.@€@2
CHF@1.35@,@.@CHF@2
GBP@0.87@,@.@£@2
USD@0.73@,@.@$@2

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 192.168.253.129 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 http://192.168.253.129/oxid/ (being used to put together a Debian 5.0 Lenny Virtual Machine for OXID 4.2)

Top OXID mod_rewrite, .htaccess Issues on Linux

Before you take off into the glories of e-Commerce with OXID, sometime, .htaccess and mod_rewrite configuration issues might pose small hinderences.  This is a collection of problems that you might encounter, and solutions to them.

RewriteBase in .htaccess

If you are are running a shop at a path other than the root web path (ex. http://www.domain.com/), say at http://www.domain.com/shop/, you will have to define the RewriteBase in your shop’s .htaccess file.  Add this line:

RewriteBase /path/to/dir/subdir/

Ex. if you are running the shop at http://www.mydomain.com/shop/, then the RewriteBase should be:

RewriteBase /shop/

AllowOverwrite All

In your Apache server configuration, AllowOverride should be set to All (None by default on most Apache installations).

This helps SEF URLs to work, by allowing URL manipulation in the .htaccess file of your OXID installation.