Can't set manufacturers URL?

May be just me.. but on my 1.3.9d installation I can't seem to set the manufacturers URL via the admin. I paste in my url, hit save and then click on the manufacturer again to view it and nothing.

Running through the code now to see what I can find.. was wondering if anyone else could reproduce or if I'm alone. I haven't modified anything near there I don't think :(

It works fine for me in my fresh clean install :blush:

So I've somewhat hunted down the problem.. looks like my cart1_manufacturers_info database isn't complete. I only have info for a few manufacturers in there (16) when I have a few hundred manufacturers.

Doesn't look like anything is 'lost' so to speak.. the few lines in there are the ones that always had urls set up. I only started playing with this now.

I'm going to dig through my backups and see if anything pops up... but my idea is that maybe if you don't set a manufacturer URL on a new product then no info is set up in the database. The way the save action on manufacturers is set up it will only update the database.. so nothing is happening.

I will continue to debug and see if I can reproduce it solidly.

llynix:

... but my idea is that maybe if you don't set a manufacturer URL on a new product then no info is set up in the database.
No. The URL is not a required field, so that's not the problem.

So I've just gone through my backups.. and as far back as I've got them I've never had the manufactures_info database filled with all manufacturers.

So now I'm left with two causes.. a) perhaps they imported manufacturers when they set up this cart.. and did it incorrectly.
or b) perhaps somewhere along the upgrade path things changed. And the database patcher wasn't updated to reflect this.

Either way the solution should be simple.. to populate the manufacturers_info database with the proper ID's and it should all work after that.

Very strange.

If your webshop is not conforming to what should be standard behaviour, then the only explanation is that the code and/or the database has been physically modified or altered, by a person.

There is no way anyone on the forum can assist you, unless you provide a very knowledgeable person with access to your database and your code...

... expect a hefty invoice: trying to fathom out crude hacks from past "developers" can be time-consuming, frustrating, and complicated to repair...

schoolboy:

There is no way anyone on the forum can assist you, unless you provide a very knowledgeable person with access to your database and your code...

... expect a hefty invoice: trying to fathom out crude hacks from past "developers" can be time-consuming, frustrating, and complicated to repair...

I happen to be a fairly knowledgeable person. Initially I was just wondering if it was reproducible. After that I found the problem. Now for the solution:

INSERT INTO `cart1_manufacturers_info` (`manufacturers_id`,`languages_id`,`manufacturers_url`,`url_clicked`)
SELECT `cart1_manufacturers`.`manufacturers_id`, 1, '', 0
FROM `cart1_manufacturers`
LEFT JOIN `cart1_manufacturers_info` ON `cart1_manufacturers`.`manufacturers_id` = `cart1_manufacturers_info`.`manufacturers_id`
WHERE `cart1_manufacturers_info`.`manufacturers_id` IS NULL

You'll need to adjust if your database prefix is different or your using a different language.

My apologies if I sounded a bit uncomplimentary earlier. My post was not at all intended to be a slight on your capabilities.

I come across a large number of badly-constructed "hacks" in many sites that I take over from previous "developers", so my prejudice probably has a context.

Good news that you got it sorted, and it is extremely helpful to others to post the solution.