Unknown Column on Database Upgrade

I'm doing a partial upgrade/partial site rebuild from version 1.2.6 to 1.3.0.2 in that I will be upgrading my database but starting fresh with everything else.

I had done a little bit of customization to the new store when I decided I would like to load my current database into it. Here is the error I now receive when I try to access the new shop:

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

The way that I upgraded the database was to
-do a backup of my current database via the admin panel
-ftp that backup to my local files
-open the new shop database in phpmyadmin
-choose "import" at the top
-browse to the backup taken in step one and click go

I think I did that right.

I don't why I am getting the error. It seems like it doesn't recognize the current date, but I just don't get it :blink:

Any ideas mucho grande apprecianado (I think I may have made that last word up:P )

Thanks!
Audra

Hmm, I editted that post, but I must not have hit save.

I found the table zen_counter_history. When I pull it up there is a warning: No index defined!

Also, under "field" the only things I see are "month" and "counter"

You need to run the installer and upgrade the database it sounds like....

As Tina noted, do a database backup and then run the upgrader, you have missed some things ...

As to the indexes, there are not indexes at this time ... but as we are re-doing them, they will be included in a future release ...

Worked like a charm! thank you both :D