• alanf
  • New member
  • Offline
  • Registered: 13-09-2006
  • Posts: 2

Topic: Getting SQL error with the manufactures side box

Hello,  Have installed the beta 1.3.5 UK Template and all appears to work great except the manufactures side box.   When I click on one of the manufacturers I get the following error.

-----------------------
Warning: constant(): Couldn't find constant in /home/data2inf/public_html/uk/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 = 2' at line 2
in:
[select from where manufacturers_id = 2
-----------------------

The SQL statement appears to be missing the "what to select" and which table it should be in.   

Any ideas on what I have managed to get wrong smile

Thanks

  • From: Suffolk/Essex
  • Registered: 01-03-2006
  • Posts: 165

Re: Getting SQL error with the manufactures side box

Hi Alan,

Two things jump to mind:

1.  Is this a brand new 1.3.5 install of Zen Cart? - This beta is not designed for upgrades.
2. The UK template (as far as I know smile ) does not change anything to do with manufacturers.  Hvae you checked your paths or changed the template folder?
By deafault the UK template default template is 'your_template' - you may not have changed the names of all the folders.

HTH

Kev

kevinpolley's Website