installation error after database details

Had to re-register as forgot my password and couldn't remember what email address i'd used to get a reminder ....

I've uploaded v1.2.8

After i enter my database details, i get the error "Unknown column 'image' in 'field list'" ....

Anyone help?

I've installed v1.1.8 previously and that worked fine ....

the db has chnaged alot since v1.1.8 version.

Daniel wrote:the db has chnaged alot since v1.1.8 version.

Hi Daniel,

What i said was that i cannot install v1.2.8 ...

After i enter my CORRECT details for the database i am using, i get that error message. Nothing else.

It's a new install, not an upgrade from v1.1.8

If i can't get this installed i'll need to try and install previous versions until one works (go back up to v.1.18).

Can anyone recommend a previous stable version?

Version 1.2.8 is stable.

Are the databases being completely removed?

Exactly what issues are you having.

Phil.

v1.1.8 already installed on a folder within my domain.

i've uploaded v1.2.8 to another separate folder and get that error after i enter database details.

i'm using the same database, normally with any cms i install i change the prefix, i.e. open1_ or open2_ etc.

am i right in assuming i can't have 2 instances of opencart on the same database because i can't change the prefix for the table name?

Yes you are right in assuming that.

You need to have separate databases for your carts. OpenCart installs and populates the tables during installation. If you already have content or the structure of the pre-existing tables are different this will cause the error you describe.

Create a new database and try again.

Create a new database and try again.

Unfortunately i don't have another database to use.

I have only 2 databases on my hosting which i use for multiple CMS's and simply use a different prefix in the table name, which Opencart does not allow i think.

What other solution is available to me?

Do you have admin access to the box?

Why cant you have more than 2 databases? Memory or hosting restrictions?

My apologies. If you use a different prefix surely this should work?

Can anyone comment on this?


So what you are saying is:

You install version x or opencart with prefix abc_opencart and now you want to use a second installation in the same database but use efg_opencart ?

My host only gives me 2 databases which is not normally a problem.

I would like to install opencart with a different prefixed table if possible, however, if it does not give me the option upon install (as some CMS's do) then how do i do this?

The other install of opencart was the first install on the database so it chose whatever table name it likes.

I've been going through the installation script and I cant find a way of doing this without re-writing all the files which runs the queries. Seems be support for database prefix but no table prefix.

I even hacked the install script to include a table prefix but this doesnt work as the scripts querying the database points on the predefined names.

If someone else knows better please right my wrongs.

Do you have a log of data in the current shop? Perhaps there is another way you can do this? The old .csv export / import perhaps?

If you choose this way I would trial this on your desktop if possible first. I.e. export some data, install 1.2.8 on your desktop and work at importing this.

thanks for the reply.

i'm not looking to import/export the first install, i'm looking to install a new copy of opencart in a different folder.

for example, when i am installing Joomla and Virtuemart as its ecommerce solution, i can choose the table prefix and have sites called jos_site1, jos_site2 etc and this works fine, the same with many other CMS's.

i'm looking to move to Opencart but i need to install a copy in each named folder and they all use the same database but with a different table prefix, as in the example above.

maybe this is a shortcoming of the system that it doesn't allow you to name the database table?

I had a look at this but I can't see how this could be possible with recent 1.x versions of opencart. The installation process does not seem to consider the table names created by the sql script but are predefined in all .php files which communicates with the database.

So far I can only see the possibility of getting this working if the opencart.sql script is hacked to use table prefix but unfortunately this is the easy part.

Then all files which references the database needs to be changed to include the table prefix and this is the hard part. The issue is probably not the installation as with some time and dedication this could probably been made to work. Plese right me people if I am wrong here.

I see the issue with such a hack to maintain and upgrade such a system being a night mare.

Is it possible for you to use the various products that can handle table prefix in one database and use opencart in the other?

I know this is not a solution to your issue but on this occasion I can not see a quick solution for this.

Maybe some dev guys can tell us if this is planned for a future release or if there is an easier way than the one I touched on above?

thanks for the reply.

so 1 database for each Opencart installation.

I think this raises a future feature that should be included. After all, many people only have a limited number of databases and NEED to share a database among many installations of any CMS.

In this case for example, i cannot now use Opencart.