Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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...

Posted

that is suggesting that a sql statement to add categories_status has not been run against the database.

Posted

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

Posted

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

Posted

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

Posted

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.

Posted

Can you provide the SQL statement you used to create the field - thanx

Posted

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!

Posted

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:

Posted

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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...