Ship2Pay Support thread

This is the support thread for Ship 2 pay starting from Version 1.6
earlier versions are not supprted (in this thread)
The module can be found here
Version 1.6 will be submitted today.
What this module does: Limit the number of payment options depending on the chosen shipping method. For example When a customer chooses pickup at store he should be able to select cash on pickup or moneyorder and when he chooses flat rate shipping he should be able to select cash on delivery or moneyorder.

Hi,
I have 1.5.5e and if I put sql the error is below.

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 'IF NOT EXISTS TABLE ship2pay ( s2p_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , ' at line 1
in:
[CREATE IF NOT EXISTS TABLE ship2pay ( s2p_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , shipment VARCHAR( 100 ) NOT NULL , payments_allowed VARCHAR( 250 ) NOT NULL , status TINYINT NOT NULL );]

Quote:

---

Originally Posted by Lopi

Hi,
I have 1.5.5e and if I put sql the error is below.

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 'IF NOT EXISTS TABLE ship2pay ( s2p_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , ' at line 1
in:
[CREATE IF NOT EXISTS TABLE ship2pay ( s2p_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , shipment VARCHAR( 100 ) NOT NULL , payments_allowed VARCHAR( 250 ) NOT NULL , status TINYINT NOT NULL );]

---

the code should be

Code:

---

CREATE TABLE IF NOT EXISTS

---

. I'll update the plugin. Thanks for reporting

Now works thankx

Version 1.8 has been submitted, and will be available soon.

tested on: Zen Cart 1.5.5, but should work on all 1.5.x distributions.


- Fixed bug in install.sql
- Updated files to be compatible with php 7.0
- Removed Polish language files, because I am not able to provide support for them.
- Updated control panel file
- Added Zen Cart 1.5.5e overwrite file for "includes/classes/payment.php"

You can also use this github link to download the latest release

I have v1.5.5f.

When I upload this install.sql I got this error:

INSERT INTO 'admin_pages' ('page_key', 'language_key', 'main_page', 'page_params', 'menu_key', 'display_on_menu', 'sort_order') VALUES
('ship2pay', 'BOX_MODULES_SHIP2PAY', 'FILENAME_SHIP2PAY', '', 'modules', 'Y', 4)
MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''admin_pages' ('page_key', 'language_key', 'main_page', 'page_params', 'menu_key' at line 1

Edit that MySQL statement, removing the unwanted single-quotes:

Code:

---

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES
('ship2pay', 'BOX_MODULES_SHIP2PAY', 'FILENAME_SHIP2PAY', '', 'modules', 'Y', 4)

---

Thanks no problems with that now.

I added the files and did the edit for /includes/classes/payment.php

But ship2pay is not in the admin section.

I just submitted version 1.9 to the downloads section
Changes:

• Updated: "includes\classes\payment.php" to Zen Cart 1.5.6c, and added better comment
• Updated: "YOUR_ADMIN\includes\classes\ship2pay.php" to use foreach instead of while
• Updated: "YOUR_ADMIN\includes\classes\ship2pay_payment.php" minor changes
• Updated: "YOUR_ADMIN\includes\classes\ship2pay_shipping.php" minor changes
• Updated: "YOUR_ADMIN\includes\languages\dutch\ship2pay.php" Improved translation
• Updated: "YOUR_ADMIN\includes\languages\english\ship2pay.php" Improved translation
• Updated: "YOUR_ADMIN\ship2pay.php" Major overhaul. Improved styling, making use of bootstrap. Code clean-up
• Added auto-installer for database edits

If need ow, it can also be found at: https://github.com/Zen4All/Zen-Cart-Ship2Pay/releases