1054 Unknown column 'counter' in 'field list'

[greelhound]

I'm not 100% sure what I have done here, in between upgrading to the latsest version and also installing a new template I am getting the following error when I go to my site

1054 Unknown column 'counter' in 'field list'
in:
[select startdate, counter, session_counter from counter_history where startdate='20100528']

Help please

[greelhound]

Oh, here is the server info




Zen Cart 1.3.9c
Database Patch Level: 1.3.0.1
v1.3.0.1 [2010-05-28 02:37:45] (Version Update 1.3.0->1.3.0.1)
v1.3.8 [2010-05-28 02:31:07] (Version Update 1.3.7->1.3.8)
v1.3.7 [2010-05-28 02:31:04] (Version Update 1.3.6->1.3.7)
v1.3.6 [2010-05-28 02:31:04] (Version Update 1.3.5->1.3.6)
v1.3.5 [2010-05-28 02:31:03] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2010-05-28 02:30:59] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2010-05-28 02:30:58] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2010-05-28 02:30:58] (Version Update 1.2.7->1.3.0)
v1.2.7 [2010-05-28 02:30:57] (Version Update 1.2.6->1.2.7)
v1.2.6 [2005-12-05 12:40:40] (Fresh Installation)
PHP Version 5.2.8

[Ajeh]

This looks like you never upgraded your database to v1.3.9c ...

[greelhound]

Okay, I just redid the upgrade and it is definitely now fully patched and up to date, but as soon as I run the SQL back up I get this error, similar to the one before, but slightly different

Help, I am tearing my hair out here

1054 Unknown column 'startdate' in 'field list'
in:
[select startdate, counter, session_counter from counter_history where startdate='20100528']

SERVER INFO NOW IS

Zen Cart 1.3.9c
Database Patch Level: 1.3.9c
v1.3.9c [2010-05-28 05:14:29] (Version Update 1.3.8->1.3.9c)
v1.3.8 [2010-05-28 05:12:07] (Version Update 1.3.7->1.3.8)
v1.3.7 [2010-05-28 05:12:04] (Version Update 1.3.6->1.3.7)
v1.3.6 [2010-05-28 05:12:03] (Version Update 1.3.5->1.3.6)
v1.3.5 [2010-05-28 05:12:03] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2010-05-28 05:12:00] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2010-05-28 05:11:59] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2010-05-28 05:11:59] (Version Update 1.2.7->1.3.0)
v1.2.7 [2010-05-28 05:11:57] (Version Update 1.2.6->1.2.7)
v1.2.6 [2005-12-05 12:40:40] (Fresh Installation)

[greelhound]

Hmmm

I just checked the server info again after I ran the back up SQL file and it has reverted to this

Zen Cart 1.3.9c
Database Patch Level: 1.2.6
v1.2.6 [2005-12-05 12:40:40] (Fresh Installation)
v1.2.6 [2005-12-05 12:40:40] (Fresh Installation)


What's going on? The oldest version I have ever installed was 1.3.8

[DrByte]

Sounds like you're *restoring* old files(overwriting your database with old data), and not making *new* backups.

I hope you have an actual backup from before you did all this.