Hope I'm not repeating something previously asked but I couldn't find it.........when trying to select an image for a SUB-CATEGORY, there is no order to the images -- not alphabetical (like they appear when I want to select one for a product), nor in the order I loaded them. Anyway I can fix this? Thanks.
crap - now they are out of order on all my screens. I logged out several times and got back in and they are still out of order. If I still have the problem later, I will send you screen shots. I tried but sys said the attachment was too large
This is the Query in Category.
$results = $database->cache('image', "select i.image_id, i.filename, id.title from image i left join image_description id on i.image_id = id.image_id where id.language_id = '" . (int)$language->getId() . "'");
This is the Query in Product
$results = $database->cache('image', "select i.image_id, i.filename, id.title from image i left join image_description id on (i.image_id = id.image_id) where id.language_id = '" . (int)$language->getId() . "' order by id.title");
Product orders by image title. Category does not, though it should.
When you add an image to category, it seems to change the sort order in product. If you add several products, the sort order will correct.
If you close your browser, and reopen, clear browser cache, Product image sort will be fine.
In Admin/controller/category.php in about line 410 change
$results = $database->cache('image', "select i.image_id, i.filename, id.title from image i left join image_description id on i.image_id = id.image_id where id.language_id = '" . (int)$language->getId() . "'order by id.title");
This will cure your problem
$results = $database->cache('image', "select i.image_id, i.filename, id.title from image i left join image_description id on i.image_id = id.image_id where id.language_id = '" . (int)$language->getId() . "'");
This is the Query in Product
$results = $database->cache('image', "select i.image_id, i.filename, id.title from image i left join image_description id on (i.image_id = id.image_id) where id.language_id = '" . (int)$language->getId() . "' order by id.title");
Product orders by image title. Category does not, though it should.
When you add an image to category, it seems to change the sort order in product. If you add several products, the sort order will correct.
If you close your browser, and reopen, clear browser cache, Product image sort will be fine.
In Admin/controller/category.php in about line 410 change
$results = $database->cache('image', "select i.image_id, i.filename, id.title from image i left join image_description id on i.image_id = id.image_id where id.language_id = '" . (int)$language->getId() . "'order by id.title");
This will cure your problem
Last edited by Anonymous on Thu Dec 04, 2008 10:39 am, edited 1 time in total.
Brent
This is where this forum gets funny.bruce wrote:Hi Denise,dmbrownfield wrote: Bruce,
I am sending you a PM with screen shots of what I mean.
Denise
I did not receive this from you.
There is a user called "bruce"
and there is hm2k with a picture of Bruce Willis.
in this case, hm2k was asking the question, but denise saw the picture of bruce willis and the mental connection was to reference the name bruce. So really denise pm'd "bruce willis", aka hm2k, not "bruce" the user name.
1. I did get the PM, but I'd have preferred a screenshot to clearly outline the issue. I suppose I should have said.
2. I had better update my picture.
3. bthirsk has proposed a solution, can you test this to ensure solves it. Please let us know.
2. I had better update my picture.
3. bthirsk has proposed a solution, can you test this to ensure solves it. Please let us know.
http://i384.photobucket.com/albums/oo28 ... ha_sml.gif[/img]Qphoria wrote: This is where this forum gets funny.
There is a user called "bruce"
and there is hm2k with a picture of Bruce Willis.
I'm sorry, I have nothing to contribute. I just came here to laugh
Who is online
Users browsing this forum: No registered users and 3 guests
