Hi Linda,

(This is the same message i sent you in a quote replay)

I am back to the office today, so that's why I have not replied back to y ou.

I change both files includes/configure.php and admin/includes/configure.php to point to mysql.webhero.com (mysql5 version). Let explain you the following:

The error message I was having before installing the new Zen Cart is the following when traying to open a product: 1054 Unknown column 'p.products_id' in 'on clause'. I created two new products to figure out what the problem is. The product were created successfully but did not show up on the shopping cart, not even on the total of products show next to the category). This is why I tried installing the new Zen Cart version 1.3.7.

Now, after the update to both configure.php files, the correct quantity of products is show in parenthesis next to the category. But when selecting the category no products are displayed for the selecte one and received the same message (1054 Unknown column 'p.products_id' in 'on clause') underneath to the category description.

I also looked over the Tool/Server Info and the information on it is the following:

Server Information

Server Host: neptune (192.168.1.21)
Database Host: mysql.webhero.com (209.217.33.160)
Server OS: SunOS 5.9
Database: MySQL 5.0.27-standard-log
Server Date: 05/02/2007 15:54:44
Database Date: 05/02/2007 15:54:56
Server Up Time: 3:54pm up 61 day(s), 10:37, 2 users, load average: 92.07, 56.70, 58.18
PHP Version: 4.4.4 (Zend: 1.3.0)
HTTP Server: Apache


The Zen Cart Logo and then the following:

Zen Cart 1.2.7
Database Patch Level: 1.2.7


PHP Version 4.4.4

System SunOS neptune 5.9 Generic_117171-17 sun4u
Build Date Jan 31 2007 14:45:36
Configure Command './configure' '--prefix=/usr/local/php4cgi' '--enable-discard-path' '--with-config-file-path=/usr/local/php4cgi/lib' '--disable-debug' '--enable-libgcc' '--with-openssl=/usr/local/ssl' '--with-zlib' '--with-xml' '--with-dom' '--enable-domxml' '--with-zlib-dir=/usr/local' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr/local' '--with-xpm-dir=/usr/local' '--with-curl' '--enable-ftp' '--enable-dba' '--with-cdb' '--with-gd' '--with-freetype-dir=/usr/local' '--with-ttf' '--enable-mcal' '--with-mhash' '--with-mysql=/usr/local/mysql' '--with-pcre-regex' '--with-mm' '--enable-shared' '--enable-sockets=shared' '--with-regex=php' '--enable-sysvmsg' '--enable-sysvsem' '--enable-sysvshm' '--enable-xml' '--with-pear' '--enable-inline-optimization' '--enable-static' '--enable-calendar' '--with-gettext' '--with-ncurses' '--with-iconv' '--with-mcrypt' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-soap' '--with-soap' '--enable-memory-limit'
Server API CGI
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/php4cgi/Zend/etc/php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20050606
Debug Build no
Zend Memory Manager enabled
Thread Safety disabled
Registered PHP Streams php, http, ftp, https, ftps, compress.zlib

The following information point to the Zen Cart logo showing the sign "Powered by ZenCart":
This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies with eAccelerator v0.9.5, Copyright (c) 2004-2006 eAccelerator, by eAccelerator with Zend Extension Manager v1.0.9, Copyright (c) 2003-2005, by Zend Technologies with Zend Optimizer v2.6.0, Copyright (c) 1998-2005, by Zend Technologies

In addition to this is all the Configuration information, which I did not include because is a lot.


My questions:
1) Is there any way that I can see the differences between the Zen Cart versino 1.2.7 and the Zen Cart version 1.3.7.?
2) Why do you think I am getting the same message but now after selecting the category and no getting any product displayed for that category? How could I solve this problem?
3) Is it suppouse to show the new Zen Cart version on Tool/Server Info?
4) The Web Hero people say that the installation was successful, same thing I got on the upgrade screen message but currently I see all the files with the "Last Update date" been the same as before the upgrade and not changes at all are show over any program (files) in any directory. What can I do to verify that my installation was upgraded properly?

Please help me on this matter, Linda! I need to keep going on this project!

Thank you very much for all your help.

Radhames Lopez