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

What system specs is the new server versus old?

Versions of apache, php. mydql and Zen Cart

Webserver = Apache/2.2.4 (Fedora)

HTTP Host = https://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 =

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?