Trouble with Export Shipping Information Module

[kinget]

Hi,

I'm using 1.3.7 currently, and have attempted to install the export shipping information module, but I continuously get an error, when I follow the instructions to add a line into the "Install SQL Patches"

when I add the line as instructed:
ALTER TABLE orders ADD downloaded_ship ENUM( 'yes', 'no' ) NOT NULL DEFAULT 'no';

I get the following error:

1142 ALTER command denied to user: '' for table 'zen_orders'
in:
[ALTER TABLE zen_orders ADD downloaded_ship ENUM( 'yes', 'no' ) NOT NULL DEFAULT 'no';]
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.

Can someone tell me what I'm doing wrong? I also tried doing it as a file, and still received the same error. Perhaps the line is incorrect in the instructions?

[pixeldiva]

I just installed that same mod and it works fine. Based on the error you're getting it seems that you don't have rights to make changes to the database. Some hosts, when setting up the database, assign one user with full rights (meaning you can write to the DB) and another user with read only permission. So you can see all the data but can't make changes.

[raspberryjamcloth]

I am getting an error with this mod -

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/rbjc/public_html/shop/admin/includes/functions/html_output.php on line 262

here is line 262 -

if ( ($checked == true) || (isset($GLOBALS[$name]) && is_string($GLOBALS[$name]) && ($GLOBALS[$name] == 'on')) || (isset($value) && isset($GLOBALS[$name]) && (stripslashes($GLOBALS[$name]) == $value)) || (zen_not_null($value) && zen_not_null($compare) && ($value == $compare)) ) {


I have a test order in and there is no export button just the error.

[raspberryjamcloth]

Anybody??

[Fireflyz]

I am getting an error with this mod -

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/rbjc/public_html/shop/admin/includes/functions/html_output.php on line 262

here is line 262 -

if ( ($checked == true) || (isset($GLOBALS[$name]) && is_string($GLOBALS[$name]) && ($GLOBALS[$name] == 'on')) || (isset($value) && isset($GLOBALS[$name]) && (stripslashes($GLOBALS[$name]) == $value)) || (zen_not_null($value) && zen_not_null($compare) && ($value == $compare)) ) {


I have a test order in and there is no export button just the error.

Anybody??

I found the solution. Apparently some legacy codes in Zen Cart are not compatible with php5 and that's the reason for error. Update your html_output.php files with the ones on this page:
http://www.zen-cart.com/forum/showpo...0&postcount=10
and that should resolve your issue.
cheers!

[raspberryjamcloth]

Thank you! Fixed!!

[Fireflyz]

I am getting an error with this mod -

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/rbjc/public_html/shop/admin/includes/functions/html_output.php on line 262

here is line 262 -

if ( ($checked == true) || (isset($GLOBALS[$name]) && is_string($GLOBALS[$name]) && ($GLOBALS[$name] == 'on')) || (isset($value) && isset($GLOBALS[$name]) && (stripslashes($GLOBALS[$name]) == $value)) || (zen_not_null($value) && zen_not_null($compare) && ($value == $compare)) ) {


I have a test order in and there is no export button just the error.

I have the same exact problem. Running v1.3.8a