Add Shipping Telephone Support Thread

[beco1979]

A quick question I hope someone might know, Will this work with version 1.38a? Hope so. If not, can anyone help or recommend?
Many thanks, Im almost ready to cut the ribbon on our store!

[JTheed]

A quick question I hope someone might know, Will this work with version 1.38a? Hope so. If not, can anyone help or recommend?
Many thanks, Im almost ready to cut the ribbon on our store!

Yes, It should work fine in 1.38a

[mdmoose]

When I try to install the SQL on 1.3.9g i receive the following error:

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 'SQL CHANGES ALTER TABLE zen_address_book ADD entry_telephone VARCHAR( 32 ) NULL ' at line 1
in:
[SQL CHANGES ALTER TABLE zen_address_book ADD entry_telephone VARCHAR( 32 ) NULL AFTER entry_lastname ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Not very savvy with any of the SQL. Anyone have any ideas?

[JTheed]

When I try to install the SQL on 1.3.9g i receive the following error:



Not very savvy with any of the SQL. Anyone have any ideas?

Try it without the zen_ at zen_address_book so it should be:

ALTER TABLE address_book ADD entry_telephone VARCHAR( 32 ) NULL AFTER entry_lastname

JT

[mdmoose]

Oddly enough in the sql I was using it was formatted as you said. But the error message still says it has zen_address_book.
SQL as follows:

SQL CHANGES

ALTER TABLE address_book ADD entry_telephone VARCHAR( 32 ) NULL AFTER `entry_lastname` ;

ALTER TABLE orders ADD delivery_telephone VARCHAR( 32 ) NULL AFTER `delivery_country` ;

UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =1 LIMIT 1 ;
UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =2 LIMIT 1 ;
UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =3 LIMIT 1 ;
UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =4 LIMIT 1 ;
UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =5 LIMIT 1 ;
UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =6 LIMIT 1 ;

[JTheed]

Oddly enough in the sql I was using it was formatted as you said. But the error message still says it has zen_address_book.
SQL as follows:

Did you use the prefix zen when you created your store? Possibly you need to add zen_ to the beginning of all of them then.


ALTER TABLE zen_address_book ADD entry_telephone VARCHAR( 32 ) NULL AFTER `entry_lastname` ;

ALTER TABLE zen_orders ADD delivery_telephone VARCHAR( 32 ) NULL AFTER `delivery_country` ;

UPDATE `zen_address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =1 LIMIT 1 ;
UPDATE `zen_address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =2 LIMIT 1 ;
UPDATE `zen_address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =3 LIMIT 1 ;
UPDATE `zen_address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =4 LIMIT 1 ;
UPDATE `zen_address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =5 LIMIT 1 ;
UPDATE `zen_address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =6 LIMIT 1 ;

[mdmoose]

Thanks for all your help. It seems I am getting even different error messages now. I though the sql installed correctly but I was not recieving phone numbers in my invoices. Now when trying the sql i get

1054 Unknown column 'address_format.address_format_id' in 'where clause'
in:
[UPDATE zen_address_format SET address_format = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE address_format.address_format_id =1 LIMIT 1 ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[miffy22]

Hi,

Just wondering if I could get some help on this module.

I am using Zen Cart 1.3.9b, and because I also had other modules previously installed, I chose to manually enter the changes to all the files. I followed very carefully with all the instructions and compared my changes with the codes from the module, just to make sure I'm adding the changes at the correct places.

However, after everything is done, I noticed another addition of phone number in the customer invoice below "SOLD TO" (before I added the module, I had only one telephone number displayed, but now I have two).

I would like to have the shipping phone number to be displayed below "SHIP TO" on customer's invoice. What should I do?

I don't have Super_Orders 2.0 installed in my zen cart, could this be the cause of the problem??

Please help me, anyone...I am so lost and desperate.....

Thank you!!

[HBELLC]

Hello,
I have 1.3.9h and the super order also installed when i went to install this mod and inserted the sql into the database i get this.

1054 Unknown column 'address_format.address_format_id' in 'where clause'
in:
[UPDATE zen_address_format SET address_format = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE address_format.address_format_id =1 LIMIT 1 ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Now i checked and rechecked all looks good as i can see but i keep getting this error.

Is something wrong or am i doing something wrong?

Thanks

[bindaaz]

I got this mode working in 1.5.0. Let me know if someone needs any assistance. I only changed the sql a bit. Otherwise I merged the changes to the 1.5.0 files and it works perfect now.