Table doesn't exist & Prefix problem

[etsscore]

I am installing osCommerce 2.2 Milestone 2 (12th July 2003) on my shared hosting (1and1.com). When I installed it last time, a few months ago, it went through without any error. But this time, after I submitted valid database login information, I always get this error:

 

A test connection made to the database was NOT successful.

 

The error message returned is:

 

Table 'mydatabase.configuration' doesn't exist

 

Please click on the Back button below to review your database server settings.

 

If you require help with your database server settings, please consult your hosting company.

 

Then I manually created a table (configuration) through phymyadmin and re-submit the install page. It did go through as successful infomation as below:

 

The configuration was successful!

 

But when I go to catalog and admin pages, I both get this error:

 

1054 - Unknown column 'configuration_key' in 'field list'

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

I have no idea what shall I do. Does that require I create all columns manually?

 

Any help? :(

 

In the same time, in many areas of the downloaded osc php files, I find "$prefix". Does that mean OSC now offer the option to create a database table prefix? But I cannot find this information during installation.

 

Please help :(

[etsscore]

This is a follow up to my previous post.

 

The installation errors I just mentioned can be solved by ticketing "Import Catalog Database" during setup.

 

It's somehow weird. Maybe the sample spl file contains required scripts.