Shipping setup problem

AngelT:

==================================================

I am also really sorry, because since the beginning I could not imaging such a law!. I never tried to cheat you but the law. Again please pardon me and forgive the inconvenients.

I also understood that it was a distribution problems and you want a way to configure your online storage so customer can be able to place an order and you be able to do the shipping accordingly. This is way I thought, in case the law is real, maybe a distributor could help because they now the process of that law.

I feel so bad for initiating this conflict, but please do not be mad and YOU COUNT WITH A FRIEND ON ME! EVEN THOSE WE DO NOT KNOW EACH OTHER!. I love making new friends because if you have people wherever you go then you have most of the things you need. But it is really funny, since I moved from my contry to USA it has been very difficult for me to accomplish this 100%. What I realice is that most of the people go to the bar or discoteck and over there make friendship. Then I do not like that kind of live that much, I define myself like a very peaceful person. I can visit a bar or discoteck once in a while. And other thing over here is that every body is normaly involved in he/her owns activities and do not have too much time left. So what can I do if not go with the flow!. I know this is something personal but just I told you so you can see a little of what kind of person I am.

God bless you in abundance!

Best Regards.

Radhames Lopez

Hello Radhames
Thank for what u wrote but for me it was not anymore a problem and still did not yet resolved this one, but I am doing something else more important at the moment.
If one day I will come in New York we will have a drink together (wine for u as u like it beer for me) same thing if one day u come in Paris.
Best Regards

Mario Caprilli

marcap:

Hello Radhames
Thank for what u wrote but for me it was not anymore a problem and still did not yet resolved this one, but I am doing something else more important at the moment.
If one day I will come in New York we will have a drink together (wine for u as u like it beer for me) same thing if one day u come in Paris.
Best Regards

Mario Caprilli

Hello Mario,

I hope you be able to solve your problem and maybe we can join any time!

Please, purdon my ignorance on that law!

Truly yours,

Radhames Lopez:clap:

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

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:lamo:

AngelT:

Hello Mario,

I hope you be able to solve your problem and maybe we can join any time!

Please, purdon my ignorance on that law!

Truly yours,

Radhames Lopez:clap:

Hello Radhames

In a certain way I resolved my problem !!! Taking off the state of Utah so they can not log in and buy !!! It is not a great solution but the easiest with in plus some explanation in the Terms & Conditions, Private Police, Shipping pages.

As you are from New York and my girl-friend would like to go there..who knows. I will let you know. But I don't drink wine, only beer :D

marcap:

Hello Radhames

In a certain way I resolved my problem !!! Taking off the state of Utah so they can not log in and buy !!! It is not a great solution but the easiest with in plus some explanation in the Terms & Conditions, Private Police, Shipping pages.

As you are from New York and my girl-friend would like to go there..who knows. I will let you know. But I don't drink wine, only beer :D

Congratulations! At least you find a way to keep the system working! Good luck in solving the issu in whole!

The drink would not be a problem to me. I am not a drinker, if I have some social drinks (a beer or cup of wine or a little wiski, is OK with me). But I feel very happy with any natural juice!.

Truly yours,

Radhames

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:lamo:

I have replied bac to you with the Quote Reply and also with Post Replay. Please let me know your opinions on what should I be doing to get this working.

We will contribute buying a cup of coffee to Zen Cart Team after we get this project going. I have a long time trying and there is always something on the road. Please help me to finish this project.

Radhames Lopez

I am confused ...

You say you installed v1.3.7 ... but I am seeing this:
Zen Cart 1.2.7
Database Patch Level: 1.2.7

Are your two configure.php files using the same directories and database information?

Be sure to check the files on the server:
/includes/configure.php
/admin/includes/configure.php

Hi Linda,

That's part of my problems; I am confused also! Because when I run the Upgrada process the final message over the windows siad that the upgradade was successful. But every things are still the same.

I changed both program to point to the new mysql5 (mysql.webhero.com):
/includes/configure.php
/admin/includes/configure.php

They are also pointing to the correct database name, which was supousely updated from v1.2.7 to v1.3.7.

But as you can see the shopping page is still pointing to V1.2.7 and I do not understand the reason why if every thing was done successfuly.

If you'd like I can resend the information explaining what I did to better clarify this issue.

Should you need more information please let me know ASAP.

Best Regards,

AngelT:

Hi Linda,

That's part of my problems; I am confused also! Because when I run the Upgrada process the final message over the windows siad that the upgradade was successful. But every things are still the same.

I changed both program to point to the new mysql5 (mysql.webhero.com):
/includes/configure.php
/admin/includes/configure.php

They are also pointing to the correct database name, which was supousely updated from v1.2.7 to v1.3.7.

But as you can see the shopping page is still pointing to V1.2.7 and I do not understand the reason why if every thing was done successfuly.

If you'd like I can resend the information explaining what I did to better clarify this issue.

Should you need more information please let me know ASAP.

Best Regards,

===================================================

Hi Linda,

I re-run the Upgrade Process updating one version at a time: It is from 1.27 to 1.30, then from 1.30 to 1.3.01; and so on until I reached the 1.3.7.

I did that in serires, that's only changing the version on the screen and hitting the Upgrade Database button. I do not know if after running one ve rsion I have to completely get out of the program by hitting the Done with Updates button and then go back to update the next version. There is a possibility that the process updates all versions at the same time but that I do not know. Coudl you pease tell me how it works?

Now the Tools/Server Info is showing the following (There are a lot more parameters but I just typed down the most important ones:

• Database Host: mysql.webhero.com (209.217.33.160)
• Database: MySQL 5.0.27-standard-log
• PHP Version: 4.4.4 (Zend: 1.3.0)
• Zen Cart 1.2.7
• Database Patch Level: 1.3.7

I think the data base was updated but no the programs.

I am continue to receive the same message (1054 Unknown column 'p.products_id' in 'on clause')

According you see the scenarious, Could you p lease tell me which the next step to take place?

Best Regards,

Eadhames Lopez:laugh:

Ajeh:

I am confused ...

You say you installed v1.3.7 ... but I am seeing this:
Zen Cart 1.2.7
Database Patch Level: 1.2.7

Are your two configure.php files using the same directories and database information?

Be sure to check the files on the server:
/includes/configure.php
/admin/includes/configure.php

===============================================

Hello Linda,

I do not know if you read the e-mai lI sent you after the above questions. But it does not matter a this time. I already restore the data base to run the update againg. Currently I am not having the error anymore because configure.php is pointing to mysql4. Then my question is the following:

Do I have to update both configure.php files before upgrading or after upgrading to the new Zen Cart? By the way! I took a look to Tools/Server Info and it still pointing to Zen Cart 1.2.7 and Database Patch Level: 1.3.7.

Please get back to me with your answer so maybe this time I can get the upgrade working fine!

Regards,

Radhames Lopez:laugh:

I would backup both the database and the site and make a new directory:
/new_shop

Load a copy of your site there and make a new database for v137 and load a copy of your Live Database in there ...

Then edit the 2 configure.php files to use the new path to:
/new_shop

And the new database
v137

or whatever the name is ...

Then practice upgrades ...

There are several posts on
/new_shop

with various levels of detail to help break this down that would be of help to read that have been posted over the last few months ...

Ajeh:

I would backup both the database and the site and make a new directory:
/new_shop

Load a copy of your site there and make a new database for v137 and load a copy of your Live Database in there ...

Then edit the 2 configure.php files to use the new path to:
/new_shop

And the new database
v137

or whatever the name is ...

Then practice upgrades ...

There are several posts on
/new_shop

with various levels of detail to help break this down that would be of help to read that have been posted over the last few months ...

===================================================

Hi Linda,

Thank you very much for all your helps...

Currently I am working on that the way you have suggested because I have tried so many different way and always get the same point: Zen Cart level 1.27 and database patch 1.3.7. So let me see what I get next following your suggestions. I am doing every thing from scratch: New database, new website, new download of the Zen Cart v1.37...

I need your help on the next matter just to make sure I am doing it right:
a) Do you think the admin/includes/configure.php should be pointing to mysql.catalog.com and the includes/configure.php to the host where the database exist? or Do you considere they should be both pointing to the hots where the database exist?

b) Do I have to practice the update separately for each level or can I select all levels from the update page to upgrade all of them at the same time? Please also let me how the upgrade process run internally if it is possible to you.

c) Do I have to run any particular process to upgrade the Zen Cart version or is it updated at the same time the database update takes place?

d) I have created a directory in the host to upload the new v1.3.7. I have been running zc_install (with upgrade option) directly from this directory. Do you think I need to do anything else, beside updadeting the two configure.php files, to have a succesful upgrade? Do I have to update also this two files in this new directory?

I will have every thing prepare to run, but before I will wait for your reply to my questions so I make sure I am doing right! I need to get this done ASAP!!!

I really appreciate your help...

Best Regards,

Radhames Lopez:clap:

AngelT:

===================================================

Hi Linda,

Thank you very much for all your helps...

Currently I am working on that the way you have suggested because I have tried so many different way and always get the same point: Zen Cart level 1.27 and database patch 1.3.7. So let me see what I get next following your suggestions. I am doing every thing from scratch: New database, new website, new download of the Zen Cart v1.37...

I need your help on the next matter just to make sure I am doing it right:
a) Do you think the admin/includes/configure.php should be pointing to mysql.catalog.com and the includes/configure.php to the host where the database exist? or Do you considere they should be both pointing to the hots where the database exist?

b) Do I have to practice the update separately for each level or can I select all levels from the update page to upgrade all of them at the same time? Please also let me how the upgrade process run internally if it is possible to you.

c) Do I have to run any particular process to upgrade the Zen Cart version or is it updated at the same time the database update takes place?

d) I have created a directory in the host to upload the new v1.3.7. I have been running zc_install (with upgrade option) directly from this directory. Do you think I need to do anything else, beside updadeting the two configure.php files, to have a succesful upgrade? Do I have to update also this two files in this new directory?

I will have every thing prepare to run, but before I will wait for your reply to my questions so I make sure I am doing right! I need to get this done ASAP!!!

I really appreciate your help...

Best Regards,

Radhames Lopez:clap:

===============================================

Linda,

This e-mail is added to the above one. Please answer both of them. I need your reply to continue the upgrade.

a) There is a Zen Cart patch wich name is "zen-cart-v1.3.7-xss-patch.zip". Do I have to run it after the upgrade or all together with v1.3.7

Again thank you very much,

Radhames Lopez:clap:

Ajeh:

I would backup both the database and the site and make a new directory:
/new_shop

Load a copy of your site there and make a new database for v137 and load a copy of your Live Database in there ...

Then edit the 2 configure.php files to use the new path to:
/new_shop

And the new database
v137

or whatever the name is ...

Then practice upgrades ...

There are several posts on
/new_shop

with various levels of detail to help break this down that would be of help to read that have been posted over the last few months ...

==================================================

Hello Linda,

I did exactly the way you describe above. Now I can see the new admin and the info on Tools/Server Info is Zen Car 1.3.7 and Database Patch 1.3.7. When I select "Online Catalog" what I receive is the page with thw wornning messages after the upgrade (Change the two configure.php files security, rename the zc_install folder ...) and the Welcome Page. It show the Categories and Products but the page surface is all blank and not boxes over it. So it is seem like when you are writing a text in world. Any way when I select a product an error message is display on other page which is "Sorry: 404 error : Page not found and it is a windows from my host. (It is supouse to open a Zen Cart windows to show the selected product information.

So do you think it may be a setting problems in Zen Cart? Do I need to change any other program(s) beside the two configure.php?

Thank you and Best Regards,

Radhames Lopez:laugh:

Sounds like you do not have a good upload of your files ...

You might try reloading the files via FTP again ...

Ajeh:

Sounds like you do not have a good upload of your files ...

You might try reloading the files via FTP again ...

===================================================

I am checking on that! All database tables look fine.

What I can see is that in the program which manage the catalog's main page the linking are wrong. Every thing is failling execept the Home button. Even the Zen Cart logo is not showing up. I figured this out right clicking on one of the button or picture and then selecting property.

I am trying to figure out using the all vesion but I have two problems:
a) The structure of the program is totally differet from 1.2.7 to 1.3.7
b) I do not know the location of the program managing all the items (buttons) on the main page. The page link show on the page is http://www.mydomain.com/shop_137/index.php?main_page=; so where are the set of programs that this index.php is controlling to manage all the main page functions?

Could you please help me on this issue?

Best Regards,

Radhames

According my latters investigations I think that maybe the program is not getting the pointing to the new directory shop_137. Here an example: https://www.mydomain.com/includes/languages/english/images/aflag.gif when it is supouse to be https://www.mydomain.com/shop_137/includes/languages/english/images/aflag.gif (This display the current currency's flag) - The flag is not being displayed.

What do you think? If this is the case how can I fix that?

Thank you,

Radhames

AngelT:

According my latters investigations I think that maybe the program is not getting the pointing to the new directory shop_137. Here an example: https://www.mydomain.com/includes/languages/english/images/aflag.gif when it is supouse to be https://www.mydomain.com/shop_137/includes/languages/english/images/aflag.gif (This display the current currency's flag) - The flag is not being displayed.

What do you think? If this is the case how can I fix that?

Thank you,

Radhames

===================================================
Hi Linda,

Please read the last two e-mail on top of this one so you can see what I have been working on...

I did your recomendation: Drop all the database tables, realoaded a fresh copy from the backup, re-run the upgrade process and the problem continue the same. This is the information that can be read on Tools/Server Info:

Zen Cart 1.3.7
Database Patch Level: 1.3.7
v1.3.6 [2007-06-08 17:38:48] (Version Update 1.3.5->1.3.6)
v1.3.5 [2007-06-08 17:38:48] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2007-06-08 17:38:45] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2007-06-08 17:38:45] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2007-06-08 17:38:45] (Version Update 1.2.7->1.3.0)
v1.2.7 [2006-02-16 21:31:37] (Fresh Installation)

Even when I hit the Zen Cart logo is geting the same error.....

What do you think I could do to get this working?

Thank you,

Radhames

AngelT:

===================================================
Hi Linda,

Please read the last two e-mail on top of this one so you can see what I have been working on...

I did your recomendation: Drop all the database tables, realoaded a fresh copy from the backup, re-run the upgrade process and the problem continue the same. This is the information that can be read on Tools/Server Info:

Zen Cart 1.3.7
Database Patch Level: 1.3.7
v1.3.6 [2007-06-08 17:38:48] (Version Update 1.3.5->1.3.6)
v1.3.5 [2007-06-08 17:38:48] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2007-06-08 17:38:45] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2007-06-08 17:38:45] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2007-06-08 17:38:45] (Version Update 1.2.7->1.3.0)
v1.2.7 [2006-02-16 21:31:37] (Fresh Installation)

Even when I hit the Zen Cart logo is geting the same error.....

What do you think I could do to get this working?

Thank you,

Radhames

==================================================

Hi Linda,

Thank you very much for all you help. I found the problem. As I thought It was a configuration problem.

Now the problem is that the products image is not showing up for any product. I have been looking around but not success until now. Do you have an idea why it could happen? I have products with not image which are Ok (they are set to NONE), but most of the products have images.

Please give me an idea about it.

Best Regards,

Radhames