Esvon Classifieds

Unofficial Manual

Synopsis

This section shows how to complete the installation of Esvon Classifieds, should you be unable to execute install.php on your system.

Procedure

1. Application.php

Open inc/application.php in your php editor (or notepad).

Edit these lines with your database connection settings:

define(‘DB_SERVER’,'localhost’);

define(‘DB_NAME’,'database_name’);

define(‘DB_USER’,'database_username’);

define(‘DB_PW’,'database_password’);

2. MySQL

Open tables.sql in /docs in a text editor

For each line starting with ‘CREATE TABLE’ add ‘ec3′ before the table name. For example

change CREATE TABLE admin_login to CREATE TABLE ec3_admin_login

There should be around 36 tables names to update.

If your text editor allows it you can run find/replace as follows:

FIND ‘Table<space>’ – REPLACE ‘TABLE Ec3_’

Open PhpMyAdmin and navigate to your new database by selecting it in the drop-down menu on the left hand-side.

Select SQL at the top-right of the screen.

Copy the text from tables.sql and paste it into the SQL box. Click go.

The necessary tables will be created.

3. Final steps

Delete /docs and install.php from your server.

Change the permissions for /inc/application.php to 644

Log in admin and change your contact email address/site url and admin username and password.

You are now ready to proceed to the next section.

Synopsis

Assuming you have successfully uploaded the Esvon files, applied the necessary permissions and created a new MySQL database you can now proceed with the final setup process.

Installation Procedure

You now need to run install.php using your normal internet browser. Point it to the address:

www.yourdomain.com/install.php

If you see anything other than a screen similar to the following (note:links currently broken) click here for a list of possible error types and their solution.

• At this stage the only supported database type is MySql so the drop-down box has no effect.
• Enter the MySql details you set before. Note that in most cases the database host is usually ‘localhost’.
• The table prefix is best left as ‘ec3_’
• Leave the tick in create DB as otherwise the relevant tables will not be created and EC will not work.
• The errors in server software area of the screen are normal – they are warning you that application.php is unable to connect to your database – this is expected since you haven’t told ‘it’ what the correct database settings are.

Click install. The screen will reload and the following message will appear at the top.

If the installation was successful delete install.php and change the permissions for inc/application.php to 644

You can now log on to the administrator area at www.yourdomain.com/admin.The default user name and password are set to adm/adm. Don’t forget to change these defaults to something more secure.

The front end will usually be located at www.yourdomain.com or www.yourdomain.com/<esvon directory>

You are now ready to proceed to the next section.