SQL patch error

[bishop999]

When isntalling a sql patch (from DPS payment plugin) I get this error report


Failed: 2
ERROR: Cannot create table dps_pxpay because it already exists
ERROR: Cannot CHANGE column because it does not exist.
Note: 2 statements ignored. See "upgrade_exceptions" table for additional details.

does anyone know what this means and will it effect the plugin?

Also I dont know what this next step means??


3.3 Due to the extremly long redirect URLs generated by DPS, the size of the
column 'last_page_url' in the zen-cart table 'whos_online' needs to be extended
from 255 to at least 2048.

Thanks in advance

[bishop999]

FYI issue resolved, martin from mixedmatter.co.nz the coder of the plugin resolved the issue by getting me to use phpMyAdmin and installing the script from there

[0be1]

Thanks for posting the solution so others can learn from this.

Also did you try using the install sql patches under tools AND open the sql file in question and copy and paste the contents into the sql patch tool instead of trying to browse to a file and upload. Browsing to the file does not always work, and the copy of the file contents and pasing in the box and submitting has worked every time for me. Just an FYI for next time, and if you do a lot of modding your zc sites, trust me, there will be many more times.

Sincerely,

0be1

[bishop999]

Thanks for posting the solution so others can learn from this.

Also did you try using the install sql patches under tools AND open the sql file in question and copy and paste the contents into the sql patch tool instead of trying to browse to a file and upload. Browsing to the file does not always work, and the copy of the file contents and pasing in the box and submitting has worked every time for me. Just an FYI for next time, and if you do a lot of modding your zc sites, trust me, there will be many more times.

Sincerely,

0be1

thank for the help, to be specific this line (below)

ALTER TABLE whos_online MODIFY last_page_url varchar(2048) NOT NULL default '';

didnt work using the tools, SQL patches either by pasting or uploading the file, all of the other commands worked, that line had to be copied and pasted in the phpMyAdmin script installer, Martin mentioned why but it went over my head :) he said he will fix the plugin for others with that issue.

[DrByte]

Also I dont know what this next step means??


3.3 Due to the extremly long redirect URLs generated by DPS, the size of the
column 'last_page_url' in the zen-cart table 'whos_online' needs to be extended
from 255 to at least 2048.

FYI ...
As of Zen Cart v1.3.8, only the first 254 characters are saved to the database. Everything after that is chopped off (truncated) before insertion. Thus extending it to a longer value is no longer useful or required.