1054 - Unknown column 'o.date_purchased' in 'field list'

[Lee Cottrell]

Hi All,

 

Yesterday when i tried to access my site on the web i got an 404 error. I contacted my service provider and they informed me that my public_html folder had been removed. I explained that i had not done this, and they said that it was also nothing to do with them.

 

Anyway they did a backup restore for me and at least my site was back on the web. However in my admin section i can no longer see any of my customers orders. The following error is there instead.

 

1054 - Unknown column 'o.date_purchased' in 'field list'

 

select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from orders o, orders_total ot, orders_status s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by date_last_modified desc limit 6

 

[TEP STOP]

 

 

 

This is also preventing any new orders being placed, as when a customer confirms their order a similar error occurs.

 

My hosting provider says that the problem looks to be inside the scripts configuration, somewhere you are looking for a column in a table that is ill defined or does not exist.

 

Can any please help, this is very very urgent.

 

Thank you very much

 

Lee

[FIMBLE]

Hello,

You could create it in php my admin.

I do not suppose there is a data base back up in your backups folder? might have to reset the permission for the folder.

[Lee Cottrell]

Hello,

You could create it in php my admin.

I do not suppose there is a data base back up in your backups folder? might have to reset the permission for the folder.

 

Hi,

 

Thank you for your reply Fimble, you will have to forgive my knowledge of databases is very low.

 

Firstly i dont think there is a database back up, and when you say change the permissions which folder do you mean?

 

Thanks for your help.

 

Lee

[FIMBLE]

OK ,

If you look at your site thorugh an FTP program or Web site control panel file manager you see a folder called ADMIN, open this, and there should be one called backups (if you use 2.2ms then you will have needed to create it) if you use the latest then its there as defualt, in this folder may well be a back up of your database.

Though you have to do this manually and if you are not sure what i am on about then you probably have not done it!

 

Can you remember which contributions you ghave installed?

[Lee Cottrell]

OK ,

If you look at your site thorugh an FTP program or Web site control panel file manager you see a folder called ADMIN, open this, and there should be one called backups (if you use 2.2ms then you will have needed to create it) if you use the latest then its there as defualt, in this folder may well be a back up of your database.

Though you have to do this manually and if you are not sure what i am on about then you probably have not done it!

 

Can you remember which contributions you ghave installed?

 

Hi,

 

Once again thanks for the reply. The only backup file in this folder is one called backup.php?

 

In regards to contributions installed, i have quite a few but these have been installed for a while apart from the SEO-G contribution which was installed some time last week? Could this be the problem you think?

 

Thanks

 

Lee

[Lee Cottrell]

Hi,

 

Once again thanks for the reply. The only backup file in this folder is one called backup.php?

 

In regards to contributions installed, i have quite a few but these have been installed for a while apart from the SEO-G contribution which was installed some time last week? Could this be the problem you think?

 

Thanks

 

Lee

 

 

Any other help at all guys?

 

Thanks

 

Lee