Moved Server-Installed new Store-NO GO

[phillpal]

Hi there, I crashed my last server due to high bandwidth. Got a new server now and gonna install the store from scratch. Did as I normally would and got this:


1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM categories c, categories_description cd LEFT JOIN categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='1' WHERE c.categories_id=cd.categories_id AND cd.language_id='1']


I am stressing out big time now. Not sure what the hell is happening. Please can anyone help me

[kobra]

What system specs is the new server versus old?

Versions of apache, php. mydql and Zen Cart

[phillpal]

# Webserver = Apache/2.2.4 (Fedora)
# HTTP Host = www.perlui.co.uk
# Path_Translated = /var/www/vhosts/perlui.co.uk/httpdocs/zc_install/index.php(SCRIPT_FILENAME)
# Real Path = /var/www/vhosts/perlui.co.uk/httpdocs
# Server Free Disk Space = 64.1 GB
# PHP O/S = Linux
# PHP API Mode = apache2handler
# PHP Max Execution Time per page = 30
# Register Globals = OFF
# MySQL Support = ON
# MySQL Version = 5.0.27 Click here for more info
# PHP Version = 5.1.6
# PHP Safe Mode = OFF
# PHP Sessions Support = ON
# PHP Session.AutoStart = OFF
# PHP session.use_trans_sid = OFF
# Current SQL Cache Folder = /var/www/vhosts/perlui.co.uk/httpdocs/cache -->Writeable
# Suggested SQL Cache Folder = /var/www/vhosts/perlui.co.uk/httpdocs/cache
# PHP magic_quotes_runtime setting = OFF
# PHP magic_quotes_sybase setting = OFF
# PHP GD Support = ON
# GD Version = GD bundled (2.0.28 compatible)
# PHP ZLIB Compression Support = ON
# PHP OpenSSL Support = ON
# PHP cURL Support = ON
# CURL NON-SSL Capability = Okay
# CURL SSL Capability = Okay
# PHP Upload Support = ON upload_max_filesize=8M; post_max_size=8M
# PHP Upload TMP dir =

[kobra]

Went to the url you provided and see a blank shop but no error???

Is this where you ar seeing the error and if so - when doing what?