Forums / Addon Sideboxes / Manufacturer sidebox not working

Manufacturer sidebox not working

Locked

Started by zarrelli on 17 Sep 2006, 11:28 AM · Views: 2,552

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
17 Sep 2006, 11:28 AM
#1
zarrelli avatar

zarrelli

New Zenner

Join Date:
Sep 2006
Posts:
4
Plugin Contributions:
4

Manufacturer sidebox not working

Hi,

I installed some modules, EasyPopulate, Super Orders, Ask a question, News and Articoles and some others. All seems to work, except for the manufacturers sidebox:

I see the list of manufacturers but when I click on one of them, I receive an SQL error message:

1064 Errore di sintassi nella query SQL vicino a 'from where manufacturers_id = 10' linea 2
in:
[select from where manufacturers_id = 10]

It seems it doen't put the table name in the query. You can look at the error at the following url:

http://www.wavetechnology.it/index.php?manufacturers_id=10&main_page=index

Where is the file which builds the query? What could I do?

Thanks

22 Sep 2006, 1:47 AM
#2
beez avatar

beez

Zen Follower

Join Date:
Sep 2005
Location:
Malmö, Sweden
Posts:
117
Plugin Contributions:
4

Re: Manufacturer sidebox not working

I've got the same problem after I've updated to 1.3.5 and installed some Mods... Don't know which one that broke it, but I can't even go back to my backup database... I'v tried to do replace all files, still the same...

Warning: constant() [function.constant]: Couldn't find constant in /includes/init_includes/init_add_crumbs.php on line 45
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from where manufacturers_id = 1' at line 2
in:
[select from where manufacturers_id = 1]

Focus dammit, I'm trying to focus!

SweetFabrik - True believer of Zen Cart!

http://www.last.fm/user/beez/

22 Sep 2006, 1:53 AM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Manufacturer sidebox not working

You might peek at the bugfixes for v1.3.5 and see if the one on manufacturers helps ...

http://www.zen-cart.com/forum/showthread.php?t=45377

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

22 Sep 2006, 7:44 AM
#4
zarrelli avatar

zarrelli

New Zenner

Join Date:
Sep 2006
Posts:
4
Plugin Contributions:
4

Re: Manufacturer sidebox not working

Ajeh:

You might peek at the bugfixes for v1.3.5 and see if the one on manufacturers helps ...

http://www.zen-cart.com/forum/showthread.php?t=45377

Thank you. I alrready saw that thread and following the instructions I solved the bug. Thank you anyway :-)

22 Sep 2006, 8:21 AM
#5
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Manufacturer sidebox not working

Hi zarrelli. Welcome to the Zen Cart community. As you'll find out, it's a very helpful and friendly community. Once of the things that we encourage to make it that way is that if you solve a problem (including your own) that you post the solution. This saves other people from trying to solve it for you, and helps others who, having the same problem, find your thread.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

22 Sep 2006, 8:33 AM
#6
zarrelli avatar

zarrelli

New Zenner

Join Date:
Sep 2006
Posts:
4
Plugin Contributions:
4

Re: Manufacturer sidebox not working

kuroi:

Hi zarrelli. Welcome to the Zen Cart community. As you'll find out, it's a very helpful and friendly community. Once of the things that we encourage to make it that way is that if you solve a problem (including your own) that you post the solution. This saves other people from trying to solve it for you, and helps others who, having the same problem, find your thread.

To be true, I modified some delivery module to add some "Poste Italiane" delivery options to my cart. I didn't look around a lot, so I don't know if there were any already. In this case, may I share them? How?

22 Sep 2006, 8:39 AM
#7
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Manufacturer sidebox not working

zarrelli:

I modified some delivery module to add some "Poste Italiane" delivery options to my cart ... may I share them? How?If you go to the top of this window you'll find a "downloads" button. On that page is a "submit your module" button. What you have done would go under the shipping modules category. Again welcome!

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

22 Sep 2006, 10:04 AM
#8
zarrelli avatar

zarrelli

New Zenner

Join Date:
Sep 2006
Posts:
4
Plugin Contributions:
4

Re: Manufacturer sidebox not working

kuroi:

If you go to the top of this window you'll find a "downloads" button. On that page is a "submit your module" button. What you have done would go under the shipping modules category. Again welcome!

Well, I submitted my first contribution. If it will receive an OK, I will submit other 2 contribs.