Manufacturer's page not coming up in admin

**spminis** · 20 May 2023, 10:02 AM

Since upgrading to zc 1.58 when I click on the manufacturer's page in admin, it goes to the admin home page. I need to add/remove manufacturers and i'm unable to do so.
Thanks
Carol
www.spminiatures.com

**swguy** · 20 May 2023, 12:24 PM

Download 1.5.8a and update admin/manufacturers.php from the latest release - I think this will solve your problem.

**spminis** · 20 May 2023, 01:21 PM

Originally Posted by swguy

Download 1.5.8a and update admin/manufacturers.php from the latest release - I think this will solve your problem.

Hi,
Thank you for your quick response. I tried that and it still doesn't work.
If I put the search term https://www.spminiatures.com/store/a...=manufacturers - it will bring up the correct page. But if I click on any of the manufacturers it brings me back to the home page.

Carol

**swguy** · 20 May 2023, 02:47 PM

This is fixed in 1.5.8a but it's hard for me to say which file fixes it - try this:

https://github.com/zencart/zencart/pull/5360/files

You might just want to upgrade to 1.5.8a.

**spminis** · 20 May 2023, 07:09 PM

Thanks but that didn't work. I just recently spent the time upgrading to 1.5.8 and don't have the time now to do another upgrade.
I guess I'll just have to make the changes directly in the sql file.
Carol

**lat9** · 20 May 2023, 07:35 PM

Edit /includes/functions/functions_products.php. Line 620 will read

Code:

                    INNER JOIN " . TABLE_MANUFACTURERS . " m ON manufacturers_id

change that to

Code:

                    INNER JOIN " . TABLE_MANUFACTURERS . " m USING (manufacturers_id)

**spminis** · 20 May 2023, 07:57 PM

Originally Posted by lat9

Edit /includes/functions/functions_products.php. Line 620 will read

Code:

                    INNER JOIN " . TABLE_MANUFACTURERS . " m ON manufacturers_id

change that to

Code:

                    INNER JOIN " . TABLE_MANUFACTURERS . " m USING (manufacturers_id)

I tried that thanks. Still not working.
I started to do the 1.8a upgrade. When I upload this file admin/includes/init_includes init_category_path.php the admin page goes blank. When I replace it with the old page, it's fine. When I uploaded the rest of the files in that directory, there was no problem