Edit Orders v4.0 Support Thread

any resolutions?

Using Zen Cart 1.5 and PHP Version 5.3.5
This was a clean install of 1.5 as I was using shop-scrip for the past 10 years or so.

Have edit orders 4.03 and Super Orders 4.02 installed. Also Image Handler 4 v 4.0.
fedex web services, USPS services, and ceon processing

(although in admin/edit orders version it says 4.02) Don't remember what I installed as this hasn't been working for a few months and don't remember what I installed from as I have Version 4.03 on my computer. So maybe I installed 4.02 and downloaded 4.03 but never got around to upgrading?

Anyway, my issue is that I cannot add a product. It lets me choose the product but when I click Add Now I get "WARNING: An Error occurred, please refresh the page and try again." which gets loopy if I actually follow that instruction.

I can go into customers and select New Order which creates the order but I cannot add any products.

Wondering if you can tell me which file might not have updated and I can either replace it or use win-merge to update.

Thanks!!

charliea:

Using Zen Cart 1.5 and PHP Version 5.3.5
This was a clean install of 1.5 as I was using shop-scrip for the past 10 years or so.

Have edit orders 4.03 and Super Orders 4.02 installed. Also Image Handler 4 v 4.0.
fedex web services, USPS services, and ceon processing

(although in admin/edit orders version it says 4.02) Don't remember what I installed as this hasn't been working for a few months and don't remember what I installed from as I have Version 4.03 on my computer. So maybe I installed 4.02 and downloaded 4.03 but never got around to upgrading?

Anyway, my issue is that I cannot add a product. It lets me choose the product but when I click Add Now I get "WARNING: An Error occurred, please refresh the page and try again." which gets loopy if I actually follow that instruction.

I can go into customers and select New Order which creates the order but I cannot add any products.

Wondering if you can tell me which file might not have updated and I can either replace it or use win-merge to update.

Thanks!!

Are asking about Edit Order or whatever manual order add-on you installed?? Either way you need to post your error log results so we don't have to GUESS what the issue is..

... Anytime an order is updated, and that includes adding, changing or deleting product the following message stack appears at the top of the screen. Warning: Nothing to change. The order was not updated...
This is talked about in the readme under "Potential Future Enhancements". As far as I know it does not break any functionality.

DivaVocals:

Are asking about Edit Order or whatever manual order add-on you installed?? Either way you need to post your error log results so we don't have to GUESS what the issue is..

Ok - found it.....
[26-Jan-2013 21:07:08] PHP Fatal 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 'S Cinnamon Chips',
products_price = '89.0000',
f' at line 5 :: insert into orders_products set
orders_id = 3883,
products_id = 5,
products_model = '14672',
products_name = 'HERSHEY'S Cinnamon Chips',
products_price = '89.0000',
final_price = '89',
products_tax = '0',
products_quantity = 1,
onetime_charges = 0; in /home/my_server/my_store/www/includes/classes/db/mysql/query_factory.php on line 101

Here's the code preceding line 101 which starts with trigger_eror
function show_error() {
if ($this->error_number == 0 && $this->error_text == DB_ERROR_NOT_CONNECTED && !headers_sent() && file_exists('nddbc.html') ) include('nddbc.html');
echo '<div class="systemError">';
if (defined('STRICT_ERROR_REPORTING') && STRICT_ERROR_REPORTING == true)
{
echo $this->error_number . ' ' . $this->error_text;
echo '<br />in:<br />[' . (strstr($this->zf_sql, 'db_cache') ? 'db_cache table' : $this->zf_sql) . ']<br />';
} else {
echo 'WARNING: An Error occurred, please refresh the page and try again.';
}
trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql, E_USER_ERROR);

Problem is with the extra apostrophe in the product name. It has been awhile since I have looked at the 4.0x branch of Edit Orders... But ...

Try changing all instances in "edit_orders.php" of the following (line 1383, 1394) from:

products_name = '" . str_replace("'", "'", $p_products_name) . "',

to

products_name = '" . $db->prepare_input($p_products_name) . "',

This will let Zen Cart's DB abstraction layer handle preparing the inputted product name including any required escaping for the database :)

lhungil:

Problem is with the extra apostrophe in the product name. It has been awhile since I have looked at the 4.0x branch of Edit Orders... But ...

Try changing all instances in "edit_orders.php" of the following (line 1383, 1394) from:

products_name = '" . str_replace("'", "'", $p_products_name) . "',

> to
> ```
products_name = '" . $db->prepare_input($p_products_name) . "',

This will let Zen Cart's DB abstraction layer handle preparing the inputted product name including any required escaping for the database :)

Very cool... Thanks - worked like a charm!!!

I still see this at the top when I update:
"Warning: Nothing to change. The order was not updated."

I've seen other postings (in this thread) but no answers as yet??

Thanks again!!

can i please get a link to the installation instructions - they did not come with my download. thanks.

lidlchris:

can i please get a link to the installation instructions - they did not come with my download. thanks.

The installation instructions are in the fileset that is part of the download.. they aren't available elsewhere..

Hi.

I am having difficulty in loading Edit Orders 4.0. Here is some background:

I am in the process of upgrading from 1.3.8 to 1.5.1 on a test server, so this in not live.
Upgrade goes well.
I upgraded the template that I use (Cherry Zen); no problems.
I use Edit Orders on my old site.
PHP is 5.2.17
MySQL is 5.0.91

When I FTP the files to my server, then go to the admin page to activate the auto install I get a blank page. This has happened multiple (5-6) times. It happens when it is the first plugin I install, or if I do it after others (such at Ty Package Tracker which works fine).

I feel like I am missing something simple. I have gone through the installation process in the readme file many times, I don't think I am doing anything wrong.

Could something be interfering with the auto install on this? I don't really know what else could do this.

Any ideas? Thanks is advance.

--Greg

GregC:

Hi.

I am having difficulty in loading Edit Orders 4.0. Here is some background:

I am in the process of upgrading from 1.3.8 to 1.5.1 on a test server, so this in not live.
Upgrade goes well.
I upgraded the template that I use (Cherry Zen); no problems.
I use Edit Orders on my old site.
PHP is 5.2.17
MySQL is 5.0.91

When I FTP the files to my server, then go to the admin page to activate the auto install I get a blank page. This has happened multiple (5-6) times. It happens when it is the first plugin I install, or if I do it after others (such at Ty Package Tracker which works fine).

I feel like I am missing something simple. I have gone through the installation process in the readme file many times, I don't think I am doing anything wrong.

Could something be interfering with the auto install on this? I don't really know what else could do this.

Any ideas? Thanks is advance.

--Greg
Blank page = error. Post the results of the error log.. There is an article in the FAQs which explains blank pages and in the FAQs or the Zen Cart users docs will tell you where to find the error logs..

Thanks DivaVocals.

Here is what I found in the error logs:

"[08-Feb-2013 15:59:49] PHP Fatal error: Cannot redeclare zen_get_country_id() (previously declared in ***/admin/includes/functions/extra_functions/edit_orders.php:34) in ***/admin/includes/functions/extra_functions/edit_orders_functions.php on line 44"

GregC:

Thanks DivaVocals.

Here is what I found in the error logs:

"[08-Feb-2013 15:59:49] PHP Fatal error: Cannot redeclare zen_get_country_id() (previously declared in ***/admin/includes/functions/extra_functions/edit_orders.php:34) in ***/admin/includes/functions/extra_functions/edit_orders_functions.php on line 44"

Sounds like you might have leftover code from your previous Edit Orders install.. Suggest rolling back, and removing ALL the old Edit Orders files from your store, then try re-installing Edit Orders again..

GregC:

... PHP Fatal error: Cannot redeclare zen_get_country_id() (previously declared in ***/admin/includes/functions/extra_functions/edit_orders.php:34) in ***/admin/includes/functions/extra_functions/edit_orders_functions.php on line 44"
Looks like you have an older version of "Edit Orders" still installed. You should delete the older "extra_functions/edit_orders.php". You may want to first uninstall and remove all traces of both this version and older versions... then re-install just the latest version.

Note: Beaten to the answer again! GG DivaVocals! I wish there was a "xyz is posting on this topic" or a "someone posted while you were writing... would you like to review their post before submitting?" option :P

lhungil:

Looks like you have an older version of "Edit Orders" still installed. You should delete the older "extra_functions/edit_orders.php". You may want to first uninstall and remove all traces of both this version and older versions... then re-install just the latest version.

Note: Beaten to the answer again! GG DivaVocals! I wish there was a "xyz is posting on this topic" or a "someone posted while you were writing... would you like to review their post before submitting?" option :P
:laugh: What's that they say about great minds..

Does anybody has the installation instructions for Edit Orders V4.0? I downloaded the files to my computer however there is no installation instructions on the readme file. Thanks.

lidlchris:

can i please get a link to the installation instructions - they did not come with my download. thanks.

DivaVocals:

The installation instructions are in the fileset that is part of the download.. they aren't available elsewhere..

tomka:

Does anybody has the installation instructions for Edit Orders V4.0? I downloaded the files to my computer however there is no installation instructions on the readme file. Thanks.

The installation instructions are in the zip file that contains the COMPLETE package (installer files and instructions). You need to unzip the file to read the readme..

how do you go to the main page and activate the auto install for Edit Orders 4. I uploaded the files but nothing happens. Here is my info:

Server OS: Linux 2.6.18-194.11.4.el5 Database: MySQL 5.0.96-community
Server Date: 02/13/2013 12:38:34 Database Date: 02/13/2013 12:38:34
Server Up Time: 12:38:34 up 33 days, 9:57, 0 users, load average: 1.38, 1.41, 1.45 HTTP Server: Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 50M

lidlchris:

can i please get a link to the installation instructions - they did not come with my download. thanks.

DivaVocals:

The installation instructions are in the fileset that is part of the download.. they aren't available elsewhere..

tomka:

how do you go to the main page and activate the auto install for Edit Orders 4. I uploaded the files but nothing happens. Here is my info:

Server OS: Linux 2.6.18-194.11.4.el5 Database: MySQL 5.0.96-community
Server Date: 02/13/2013 12:38:34 Database Date: 02/13/2013 12:38:34
Server Up Time: 12:38:34 up 33 days, 9:57, 0 users, load average: 1.38, 1.41, 1.45 HTTP Server: Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 50M
If you follow the instructions you will,

Login into your admin
Upload the EO files
Click ANY LINK in your admin to install

This is all laid out in the readme file.. If any part of the install instructions are not clear it helps if you can let me know what section you need clarification on..

DivaVocals:

If you follow the instructions you will,

Login into your admin
Upload the EO files
Click ANY LINK in your admin to install

This is all laid out in the readme file.. If any part of the install instructions are not clear it helps if you can let me know what section you need clarification on..

I followed the instructions in the readme. I renamed the folders to my admin folder name, I logged into the admin panel, I uploaded the two folders to the root of my store and in the admin panel clicked on a link, in my case I just clicked on admin home. But its seems nothing happened, I waited for over 20mins and never got a confirmation message.

Is there way to manually install this without using the auto-install which for some reason is not working .

Thank you
Scott