Upgrade Help

**ScrapdragonDesigns** · 2 Mar 2007, 10:52 PM

Hi, I just upgraded my cart to version 1.3.7 and I've had all sorts of problems. More to do with my lack of knowledge than anything I think. I have most of the things fixed and was at the stage where I just needed to get all the pages right and update the look. But then I realised I have another problem and this has me stumped!
Whenever I click on any of the links to do we manufacturers, I get this error message:

Warning: constant() [function.constant]: Couldn't find constant in /home/scrapdr/public_html/shop/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 = 5' at line 2
in:
[select from where manufacturers_id = 5]

Is there an easy way to fix this? Or does it mean a full install again? Any help would be greatly appreciated, thanks

**Ajeh** · 3 Mar 2007, 02:10 AM

Are you sure you loaded v1.3.7?

Check the Tools ... Server Info ...

What do you see from below the menu bar, up to and including the large PHP version?

**ScrapdragonDesigns** · 3 Mar 2007, 05:11 AM

Thanks for your reply
The actual upgrade went OK, but I had an error message across the top of my store, saying it still needed upgrading. So when I tried to do it in Fantastico, it didn't like it. My hosting provider fixed that error but then I discovered this one and they said the only solution is to do a full reinstall. As this would involve reuploading everything to the store, I'm not so keen. There must be an easier way.

This is what I see,,
Server Information

Server Host: devastator.3v0.net (72.29.89.198) Database Host: localhost (127.0.0.1) Server OS: Linux 2.6.9-42.0.3.EL Database: MySQL 4.1.21-standard Server Date: 03/03/2007 04:10:55 Database Date: 03/03/2007 04:10:55 Server Up Time: 04:10:55 up 54 days, 22:52, 1 user, load average: 1.38, 1.11, 0.61
PHP Version: 4.4.3 (Zend: 1.3.0)
HTTP Server: Apache/1.3.37 (Unix) mod_jk/1.2.14 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.3 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a

Zen Cart 1.3.7
Database Patch Level: 1.3.7
v1.3.5 [2007-02-17 13:59:49] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2007-02-17 13:59:48] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2006-07-18 16:54:40] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2006-05-23 07:15:17] (Fresh Installation

**Ajeh** · 3 Mar 2007, 05:45 AM

You might want to download the Zen Cart v1.3.7 from our Download link at the top of the screen ...

Load it to the site ...

Run the /zc_install and make sure all is really upgraded ...

NOTE: Be sure to backup both your site and database ...

NOTE: Be sure to add the current patch for PayPal at:
http://www.zen-cart.com/forum/showthread.php?t=56216