jonyjony Posted December 19, 2008 Share Posted December 19, 2008 Hi, I changed the manufacturer section to Artists, I made new tables in the database identical to the Manufacturer tables, and changed the datbase php files, and all php file with manufacturer code in them to artists. But anyway the warning I got is 1054 - Unknown column 'artists_id' in 'field list' select artists_id, artists_name from artists order by artists_name [TEP STOP] it doesn't seem to be reading the artist_id table well.. don't know why exactly .. Thank you in advance of any help!! best wishes J..... Link to comment Share on other sites More sharing options...
Guest Posted December 19, 2008 Share Posted December 19, 2008 The error says unknown column artists_id. You said it doesn't seem to be reading the artist_id. The error says the column is not there. Make sure of your spelling. Link to comment Share on other sites More sharing options...
jonyjony Posted December 19, 2008 Author Share Posted December 19, 2008 The error says unknown column artists_id. You said it doesn't seem to be reading the artist_id. The error says the column is not there. Make sure of your spelling. Hi Bktrain.... thank you for your help, that was just a an error here, it is artists_id with an S... I checked back and I was careful to put it as artists why would it not recognize the column I wonder? its an exact copy of the manufacturer table.. thank you... Link to comment Share on other sites More sharing options...
Guest Posted December 19, 2008 Share Posted December 19, 2008 I'm not much of a sql person but if you post your code maybe the problem can be spoted. Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted December 19, 2008 Share Posted December 19, 2008 If you do not need a manufacturer and an artist why not just change the title on the screen to "Artist" and use the manufacturer table. I doubt if there are more than half a dozen places to change. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
jonyjony Posted December 20, 2008 Author Share Posted December 20, 2008 If you do not need a manufacturer and an artist why not just change the title on the screen to "Artist" and use the manufacturer table. I doubt if there are more than half a dozen places to change. Hi Geoffreywalton, thank you very much for your reply.. !! you see that's what a sensible person would have done.. :0) I'm a little tick.. I think I just wanted to have a perfect script with it being solid rather than a patch. Well it should have worked, I really don't know why it didn't or worse how to fix it! Hi Bktrain.. I can't really post the code,.. as its not really defined by one section of code, and its more related to the database.. I checked the database file that comes with the installation folder, and its exactly as I've done, so I don't know.. but I'm really stuck :( thank you... j 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.