onnig Posted January 30, 2003 Share Posted January 30, 2003 Hi, finally got everything installed properly, didn't realize that the configure.php file for admin and catalog are different, need to keep them separate. Here's the error I get when I go into the catalog: "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]" Onnig Thanks again. Onnig Link to comment Share on other sites More sharing options...
onnig Posted January 31, 2003 Author Share Posted January 31, 2003 anyone, anyone? Onnig :? Onnig Link to comment Share on other sites More sharing options...
onnig Posted February 3, 2003 Author Share Posted February 3, 2003 Can anyone help me with this one? Onnig Onnig Link to comment Share on other sites More sharing options...
VyReN Posted February 3, 2003 Share Posted February 3, 2003 Sounds like you do not have your database setup correctly. Does any part of your cart work? Link to comment Share on other sites More sharing options...
onnig Posted February 3, 2003 Author Share Posted February 3, 2003 no, none of the cart works. I had upgraded the oscommerce.sql to version 1.65 but still has the same problem. It sounds like a certain table doesn't exist. 'categories_name' does not exist in 'field list' table. There is no field list table. It exists somewhere else Onnig Onnig Link to comment Share on other sites More sharing options...
rseigel Posted February 3, 2003 Share Posted February 3, 2003 Look at the error again. It's looking for categories_name in the categories table. Link to comment Share on other sites More sharing options...
VyReN Posted February 3, 2003 Share Posted February 3, 2003 Upgrading to the latest database version is not always a good idea. Verify you have a cataegories table and categories_name is in there... Link to comment Share on other sites More sharing options...
onnig Posted February 3, 2003 Author Share Posted February 3, 2003 Aha! NO I don't I will create one and let you know. But why isn't it there? is the oscommerce.sql file incomplete? Onnig Onnig Link to comment Share on other sites More sharing options...
onnig Posted February 3, 2003 Author Share Posted February 3, 2003 Actually the categories_name is in the categories_description table, What do I do? Onnig Onnig Link to comment Share on other sites More sharing options...
rseigel Posted February 3, 2003 Share Posted February 3, 2003 Let me guess...you're trying to use the latest version of the database with 2.1? That won't work if that's what you're doing. Link to comment Share on other sites More sharing options...
VyReN Posted February 4, 2003 Share Posted February 4, 2003 Let me guess...you're trying to use the latest version of the database with 2.1? That won't work if that's what you're doing. That would explain it.... Link to comment Share on other sites More sharing options...
onnig Posted February 4, 2003 Author Share Posted February 4, 2003 I'm using 2.2 Onnig Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.