Shipping setup problem

[Ajeh]

That is the trick to the fix ...

At the moment ... not enough coffee to figure this out and I have to leave ...

But once that zone is resolved to not exclude the canadians in your International skip ... all your shipping should work correctly ...

[AngelT]

Hi Linda,

I have a problem: I upgraded from v1.2.7 to v1.3.7.

When I load the shopping page I can not see any differences except for the Ze Cart sign at the bottom of the page.

I also go the the Tools/Server Info in my Admin and the version is stil exist 1.2.7.

After the upgrade I received the confirmation page saying: Congratulations! You have successfully installed Zen Cart on your system! and all the Next steps that should be done.

Now my question is Do I need to do anything else to complete the process?

I did the following because both files were empty:
a) Copy the old configure.php file from /admin/includes/ to the /zen-new/admin/includes.
b) Copy the old configure.php file from /includes to zen-new/includes.
c) I did the upgrade over the existing database.

I just follow all the steps on the prompt after starting the process (www.mydomain.com/ze_new/zc_install/index.php).

Please help me on this matter!

Best Regards,

Radhames

[Ajeh]

Did you make a new database with a copy of the old database and change the database, username and password in the 2 configure.php files?

Or, did you upgrade the old database?

When you ran the /zc_install did it say Install or Upgrade?

If you go to the /zc_install and click on Upgrade, are any of the checkboxes checked?

Did you load all of the files from a clean Zen Cart v1.3.7 from our download at the top of your screen to your site?

Did you load those files over top your existing files or make a new directory?

If you made a new directory, did you edit the 2 configure.php files to reflect the new path to the files etc.?

[AngelT]

Did you make a new database with a copy of the old database and change the database, username and password in the 2 configure.php files? I made a copy of the database to my PC. Unzip the v1.3.7; upload all the files to a new directory. I did not change anything. All did was copy the configure.php to the new folder with v1.3.7 for both new-folder/admin/includes and new-folder/includes because both files were empty.


Or, did you upgrade the old database? I just run zc_install from the new directory over the old database.

When you ran the /zc_install did it say Install or Upgrade? It say Upgrade

If you go to the /zc_install and click on Upgrade, are any of the checkboxes checked? At the beginning all checkboxes starting from Upgrade DB from 1.2.7 to 1.3.0 were checked. After that I run the process for each check both separate until I reach the Upgrade DB from 1.3.6 to 1.3.7 check box. I thought it runs accumulative but because I did not see any differents in the shooping page that's why I run it that way, because then I thought again that the process does not run accumulative versions.

Did you load all of the files from a clean Zen Cart v1.3.7 from our download at the top of your screen to your site? Yes. I did the following: Unzip the downloaded v1.3.7 and ftp to my site to a new directory

Did you load those files over top your existing files or make a new directory? I made a new directory.

If you made a new directory, did you edit the 2 configure.php files to reflect the new path to the files etc.?

. Actually just copied them from the old version to the new one but did not do any change. Maybe this could be the problem. What do you think?

The upgrade screen showed up all the information about the old version, database, user, password and then I assumed that was all the process need to run.


Thank you very much for your help. This is the first time I do this on Zen Cart.

I'll be waiting for your reply before doing anything else.

Regards,

Radhames

[marcap]

Hi, setting up an e-commerce for a friend of mine, he sells wine.

Now I have some shipping limitations, i.e: to Australia he can not ship more then 12 bottles, how can I manage that?

Thanks.

[AngelT]

Hi, setting up an e-commerce for a friend of mine, he sells wine.

Now I have some shipping limitations, i.e: to Australia he can not ship more then 12 bottles, how can I manage that?

Thanks.

By the context of your message I can imagine you are joking! But just in case I think you must go to a authorized distributor that can help you out in that! The only thing I know about wine in just drink it! If you have some that could share with me that would be fine with me! eeeeh, ha...ha...ha...he

[marcap]

By the context of your message I can imagine you are joking! But just in case I think you must go to a authorized distributor that can help you out in that! The only thing I know about wine in just drink it! If you have some that could share with me that would be fine with me! eeeeh, ha...ha...ha...he

I am not joking I just have to respect locals laws !!!!
In Australia and New Zealand "no one" can ship more then 12 bottles of wine (or anything with alchol).
NO wine to UTAH
No more then 36 bottles to: Delaware, Vermont, Florida, Indiana, Kentucky, Maryland and Tennesse.

As u are from New York u can buy the all shop if u want.

Now if u know I can I manage that it it will very nice.

[AngelT]

. Actually just copied them from the old version to the new one but did not do any change. Maybe this could be the problem. What do you think?

The upgrade screen showed up all the information about the old version, database, user, password and then I assumed that was all the process need to run.


Thank you very much for your help. This is the first time I do this on Zen Cart.

I'll be waiting for your reply before doing anything else.

Regards,

Radhames

+++++++++++++++++++++++++++++++++++++

Hello Linda,

Did you get the above e-mail reply? Please reply me back if you are able to do so. All my answeers to your questions are in red!

Regards,

Radhames

[Ajeh]

Make sure that the configure.php files in:
/includes/configure.php
/admin/includes/configure.php

that are on the server match the NEW database and have the NEW paths to the NEW files ...

Then look in the NEW /admin and look at the Tools ... Server Info ...

Paste everything from below the menubar up to and including the large PHP VERSION XXX.XXX

[AngelT]

Make sure that the configure.php files in:
/includes/configure.php
/admin/includes/configure.php

that are on the server match the NEW database and have the NEW paths to the NEW files ...

Then look in the NEW /admin and look at the Tools ... Server Info ...

Paste everything from below the menubar up to and including the large PHP VERSION XXX.XXX

-------------------------------------------------------------------------------------------

Hi Linda,

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