alostslipper Posted February 20, 2004 Posted February 20, 2004 I just tried installing Header Tags Controller v2.0 and I get the following when I go to the Product/Description section of Catalog in Admin: 1054 - Unknown column 'c.categories_status' in 'field list' select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name [TEP STOP] Can anyone tell me what i need to do? I installed it because i want to install Image Catalog v1.33 Thanks... Quote
Guest Posted February 20, 2004 Posted February 20, 2004 that is suggesting that a sql statement to add categories_status has not been run against the database. Quote
alostslipper Posted February 20, 2004 Author Posted February 20, 2004 Can you please elaborate. What do I need to do to run a sql statement against the database. Quote
Guest Posted February 21, 2004 Posted February 21, 2004 Hey Skipper, I can't help ya with the SQL issue - I have the same issue and need to know what to do as well - :blink: But I can tell ya that you can leave all the coding in place and just drop your old categories.php file back into the admin folder so you can get back to work in other areas (like adding products) Whewww! :rolleyes: So until someone can step up to point us both in the right direction as far as resolving the problem at least all that coding isn't going to the dogs and will politely sit there and wait for us. :D Quote
Guest Posted February 21, 2004 Posted February 21, 2004 the installation instructions of header tags probably has a file with an extension of '.sql' or in the instalation instructions is a line asking you to run a sql command via phpmyadmin, mysql connector or the mysql root prompt Quote
Guest Posted February 21, 2004 Posted February 21, 2004 Yes it does haver an SQL file and no it mentions nothing about categories_status <_< Apparently this is a real PAIN in the butt install to get working :blink: I have been at it for going on 12 hours and keep getting the same result :angry: HOWEVER it does work as I have seen it working and have also seen the "success" stories, but few are willing to share the knowledge it would seem :blink: Keep plugging away at it I guess Quote
alostslipper Posted February 21, 2004 Author Posted February 21, 2004 We found the file requesting the categories_status field in the database so we added that field to the database in the categories section. That now works but in the process we reverted to the pre contibution files. If our server gets over its problem of staying on line for no more than 5 minutes, we will try to make the change again to the header tags. I'll let you know if it works and how we did it. Quote
alostslipper Posted February 21, 2004 Author Posted February 21, 2004 It Works! just add a categories_status field to categories in the MySQL Database! :D Quote
Guest Posted February 21, 2004 Posted February 21, 2004 Can you provide the SQL statement you used to create the field - thanx Quote
alostslipper Posted February 21, 2004 Author Posted February 21, 2004 Just open the header sql file that came with the contribution, delete everthing and paste the following line in. ALTER TABLE categories ADD categories_status LONGTEXT NULL; Save as 'change sql'. Then do the sql thing (my son does that so I'm not sure how to describe it if you need that info let me know.) I'm not sure if longtext is right, but the thing seems to work now. We also went to add in some changes to allow us to load a small and a large image so when you go to "click on to enlarge' you actually get a larger picture. If you want that info I can post it here. It was on another thread of the forum. Hope it works! Quote
Guest Posted February 22, 2004 Posted February 22, 2004 Cool, it worked for me as well - whew was beginning to lose my mind over it :wacko: Finally B)- now I just gotta fart around in the header_tags.php and get the stuff to display.< < That part was a mute factor if I couldn't get the admin working right - but I do have the pages with the replacement title text and the missing ";" in place. So I think I am in good shape there - as far as the images, yeah, put it up. ;) Thanx! I too am still learning the SQL thing, but I am learning that it can be VERY powerful if implimented properly.:ph34r: Quote
alostslipper Posted February 22, 2004 Author Posted February 22, 2004 This is what I found about images. I think there is another contribution you can add to the header deal that lets you upload 3 image sizes. We may do that if I feel brave. I also found this which allows you 2 images, one thumbnail and one large which then is accessed when you click to enlarge. We have made the changes for the latter but have yet to check it out. Thanks to Mibble for pointing us in the right direction Thanks to the following contributor for the image info: murt Posted: Feb 18 2004, 04:03 PM adolfhitler Group: Community Member Posts: 2 Joined: 5-December 03 hi, basically my cheat to this is to do the following : first i seperate images in 2 folders i.e. Large images and Small thumbnails but the main thing to be kept in mind is that names of both large and small images should be exacly same , now that you have seperated the images as large and small upload the images in catalog/images/small and catalog/images/large respectively , next open up catalog/includes/configure.php find: define('DIR_WS_IMAGES', 'images/'); and change it to : define('DIR_WS_IMAGES', 'images/small'); next add the folowing line under it: define('DIR_WS_IMAGES_ZOOM', 'images/large'); now you have defined the 2 new paths for small and large images next open catalog/popup_image.php find: <?php echo tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name']); ?> and replace it with: <?php echo tep_image(DIR_WS_IMAGES_ZOOM . $products['products_image'], $products['products_name']); ?> this should work out fine...now you have seperate thumbnail images and the popup shows the large images.... hope this works out for you...it did for me ...bye Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.