Guest Posted August 31, 2005 Share Posted August 31, 2005 Hi...Nice big problem: I've installedwishlist, uninstalled it because I got an error somewhere in products history or something an now, to maybe correct the mistake, I've installed a newer version...And at login, I get this: 1054 - Unknown column 'products_id' in 'field list' select products_id from customers_wishlist where customers_id = '2' [TEP STOP] I beg of you, help me! Thank you very very much! Link to comment Share on other sites More sharing options...
Daemonj Posted August 31, 2005 Share Posted August 31, 2005 You need to find that query and replace the products_id field with the actual name of the field in the table. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein Link to comment Share on other sites More sharing options...
Guest Posted August 31, 2005 Share Posted August 31, 2005 Well...I have absolutely no idea how to do that...I'm afraidI'm stuck if you won't help me! Link to comment Share on other sites More sharing options...
Daemonj Posted August 31, 2005 Share Posted August 31, 2005 In PHPMyAdmin, look at the structure for the customers_wishlist table and determine the actual name of the field that has products_id in it. Then look through all of the new files from your wishlist contribution for the query and replace products_id with the actual name. It sounds much worse than it actually is. ;) "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein Link to comment Share on other sites More sharing options...
Guest Posted August 31, 2005 Share Posted August 31, 2005 Hmm... before installing again wishlist I think I've removed that field...trying, ofcourse to do something else...Do u have a hammer to hit me in the head with it? If no, do u have a solution? Because I'm discovering that I'm really really stupid!!!!!!!!!!!!!!! Link to comment Share on other sites More sharing options...
Guest Posted August 31, 2005 Share Posted August 31, 2005 Brain working! If I look in the sql file that comes with the mod could I create manually the fields with the values I see there? CREATE TABLE `customers_wishlist` ( `products_id` tinytext NOT NULL, `customers_id` int(13) NOT NULL default '0' ) TYPE=MyISAM; Link to comment Share on other sites More sharing options...
Daemonj Posted August 31, 2005 Share Posted August 31, 2005 Just import that file using PHPMyAdmin and you should be set. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein Link to comment Share on other sites More sharing options...
Guest Posted August 31, 2005 Share Posted August 31, 2005 If I try to import it, it says that it already exists...So... Link to comment Share on other sites More sharing options...
Daemonj Posted August 31, 2005 Share Posted August 31, 2005 so edit that file and before the create table line add: drop table customers_wishlist; "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein Link to comment Share on other sites More sharing options...
Guest Posted August 31, 2005 Share Posted August 31, 2005 Dis that, same for customers_wishlist_attributes, because it said that exists too, but now I got this: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `customers_wishlist_attributes` ( `customers_wi Thank you a looot for being so patient! When you come to romania I'll buy u a beer or something...:) Link to comment Share on other sites More sharing options...
Daemonj Posted August 31, 2005 Share Posted August 31, 2005 Did you put a semi-colon ( ; ) at the end of the line? I have always wanted to visit Romania so I may take you up on the beer. :) "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein Link to comment Share on other sites More sharing options...
Guest Posted August 31, 2005 Share Posted August 31, 2005 Well, I've tried and the site works, no more error...No need to do more...I hope...But thank you, I appreciate your help...If u come to romania u'll see our ospitality..:) you know, it's a great country, bad ratings, but not true...And I may soon have a travel agency and help you to come here for a vacation :) really! Link to comment Share on other sites More sharing options...
Daemonj Posted August 31, 2005 Share Posted August 31, 2005 Glad to hear that the errors are gone and hopefully everything is working properly. :) A friend of mine visited a friend of his in Romania for a month and thoroughly enjoyed it. The 3 months after his return all we heard about was Romania and how he wanted to go back. PM me when you get the travel agency going. ;) "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein 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.