Please Help me Critical Database error

[Tango589]

my index.php opens up fine and you see all of my catergories, and all the albums contained in them.  But when you click on an album to view the photos inside of it, you get this:

Critical Error

There was an error while processing a database query.

and the debug gave me this>>>>

While executing query "SELECT category, title, aid, keyword, description, alb_password_hint FROM cpg_albums WHERE aid='36'" on 0

mySQL error: Unknown column 'alb_password_hint' in 'field list'


what do I do?? 

I had CPG 1.3x and moved it to a new host and now installed CPG 1.4x, and just used the; Albums, Catergories, Comments, Pictures, Users database tables from my other installation...

P.S. I can get into any other view..  I can view my album in catergory view, I can open any photo, and once I open it, I can filmstrip through the ones around it..  I seem to be able to do everything but open up individual albums..

[Nibbler]

Ensure your db user has the ALTER privilege and run update.php.

[Tango589]

Ensure your db user has the ALTER privilege and run update.php.

YOU SOOO ROCK!!  thanx a million for your help, it works great now..