catalog 1054 error

**onnig** · 02-03-2003, 10:22 AM

This is what I get:

1054 - Unknown column 'categories_name' in 'field list'

select categories_id, categories_name, parent_id from categories where parent_id = '0' order by sort_order, categories_name

[TEP STOP]

The categories_name column is under another table, not in the 'field list' table, actually there is no 'field list' table. Am I reading this right?

Onnig
(this is worse than plucking out each hair on my head one by one)

**modom** · 02-03-2003, 07:54 PM

Hi,

Is this a new install or do you have mods in place.

Do you have a url to look at?

**onnig** · 02-03-2003, 09:27 PM

Hi,

Sorry, brand new install 2.2 and admin works fine. Site is http://www.tsapros.com/catalog/index.php or default.php

Thanks,

Onnig

**modom** · 02-04-2003, 06:54 AM

Hi,

You have an extra "categories_name" field in your database that is not in the new store installations.

In phpMyAdmin look at your categories table. It should have these fields and no more:
categories_id
categories_image
parent_id
sort_order
date_added
last_modified

**onnig** · 02-04-2003, 08:37 AM

Hi Melinda,

Thanks for your help. I have a categories table with these fields:

categories_id
categories_image
parent_id
sort_order
date_added
last_modified

and a categories_description table with these fields:

categories_id
language_id
categories_name

I think the code may be pointing to a wrong table name. What do you think?

Onnig

**modom** · 02-04-2003, 08:51 AM

Hi,

I guess it might be but this is usually a problem with the table listings.

I think I would drop my tables and reinstall today's snapshot.

Sometimes it's easier to do that than to try to figure it out.

**onnig** · 02-04-2003, 01:50 PM

when you say snapshot do you mean the .sql file? Is there one you can post here?

Onnig

**modom** · 02-04-2003, 02:11 PM

http://www.oscommerce.com/downloads/snapshot

Pick unix unless your host is on a windows machine.

**onnig** · 02-05-2003, 12:20 AM

ok I was using windows snapshot with a unix host. So I started from scratch, downloaded new unix snapshot, changed configure.php for both catalog and admin, re-uploaded everthing, dropped all database entries from old db, uploaded new db entries, admin works fine and again I get the same stinkin' error:

Categories
1054 - Unknown column 'categories_name' in 'field list'

select categories_id, categories_name, parent_id from categories where parent_id = '0' order by sort_order, categories_name

[TEP STOP]

at http://www.tsapros.com/catalog/default.php

Onnig

What Now? Thanks for your help.

**modom** · 02-05-2003, 06:25 AM

Did you run the install or just readd everything?

If you want I can take a look but would need your username and password.

You can privately email me at:
modom@designhosting.biz