OLD Super Orders 2.0 (See v3.0 thread instead)

[Happyworker]

Nevermind about the last post....figured it out.

Thanks again for your help.

Cheers,
Happyworker

[BlindSide]

No problem, glad you got it all straight. Enjoy!

[mtgDoofy]

I would like to be able to send an email similar to the new order email after I edit the order. I don't see a way to do this in Super Orders. I don't mind doing coding myself, but I was wondering if someone (who has had more experience with this code) had any advice on where I should be looking. I started last night and found myself copying over a bunch of stuff from the catalog (including the order class as well as several others that it needs) in order to resend the email (although parts of it still aren't working such as the totals and customer info. Any advice would be greatly appreciated.

[SnowBlind]

Hi All and thanks for an excellent cart.
I'll buy ya all a cup of coffe as soon as I get rich off this thing. I have a question about installing the superorders mod, AND,... I'm a total newbie to php, mysql, phpadmin, apache, etc,... In short not a total dummass, but lacking in experience and knowledge. I do have a fair IQ though and have figured out apache, ssl, php, mysql, all the needed supporting modules and so forth required for a fully functioning website with cart, some basics of the entire process required and do have a cart working now with full functions and some basic customizations (V1.3.6). Pardon my ignorance though if I get something wrong here, education is the only cure to ignorance so I'm asking for some please.

Basically, I have the database working and backed it up, followed the install process (super_orders_2.0rev45) and got an error "1064...line 1,..." at the start of the import process using the sql patch in the admin. I followed a lot of threads here and got that phpmyadmin would get over this, but it didn't. I took a look at the raw data of the files and the tables and so forth and believe the problem is the table names. All the tables in my database start with zencart_whatever_table, the tables created by the script do not and I think this is the reason. Also one table, "catalog.orders" does not exsist at all even with the zencart_ prefix. Am I right in assuming that editing the .sql script to write the tables as zencart_this_or_that will solve the error ? Or is this an even deeper issue ? I'm using the latest phpmyadmin 2.9.1.1, Apache 2.2.3, mod_ssl 2.2.3, openssl 0.9.8d, php 5.1.6 and MySQL 5.0.20 I have not found any issues with these versions except the strict mode with mysql which I disabled. I'm hoping this isn't too complicated an issue, any input would be greatly appreciated.

Thanks,
Snowblind

[SnowBlind]

Apologies to everyone, I'm having some weird errors trying to get this going.
Is there any reason to think that my versions of the programs installed on my system act differently than what appears to be the expected behavior of the install instructions for super orders? Several tries later and still some odd things.
Parts of SO work, and some don't. Errors when trying out the mod are from columns don't exist to tables don't exist or even double entries. I'm starting to think my cart is not right in some way. I rechecked the install steps and edits several times and have had partial success, partial failures, but not completely one or the other. Is there something about ZC 1.3.6 that requires altering the install process for SO that I've missed ? Maybe it's mySQL version ?

[SnowBlind]

Um,... I can't seem to edit my posts.
I got this error after completely restoring everything, database and (catalog folder);
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 'True', 'False'), ')' at line 1
in:
[INSERT INTO zencat_configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array('True', 'False'), ');]
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.

When I got this last time I edited the sql file and it did other errors, so I think it's something about the po module gone wrong. I copied the commands from below the po module ones to a new file "inserts.sql"and ran it through the sql patch tool and didn't get any errors, the database took the edits without error as I can see. Please stop me if i'm gone insane or will this run the SO properly ? I installed the po module from the admin>modules>payment and it seems all is well. should I jump now or hold on to the ledge a while longer?

If I made a booboo somewhere I can't see it, but thanks to Blindside for a very cool mod.

[SnowBlind]

Just an update on my issues if anyone is interested.

I ran the install per instructions (SO Rev45) and had a failure when the sql script got to the purchase orders part. I snipped the script below that part and ran it without errors. So maybe it's a unique or blind dummy thing I did that caused the failure. But with so many posts about the 1064 error and so many different reasons I thought I'd toss in my resolution. As I can see it if you have ZC 1.3.6 and MySQL 5.0.20 and PhP 5.1.6 :) then run the SO*.sql script through the sql patch tool and be sure to comment out the part about the purchase order inserts that look like this before running it:

-- Purchase Order payment module configs
INSERT INTO configuration VALUES (NULL, 'Enable Purchase Order ...
INSERT INTO configuration VALUES (NULL, 'Make payable to:', ...
INSERT INTO configuration VALUES (NULL, 'Sort order of display.', ...
INSERT INTO configuration VALUES (NULL, 'Payment Zone', ...
INSERT INTO configuration VALUES (NULL, 'Set Order Status', ...

AFTER doing the file edits (which BTW, most of those values were already in my *php files) then install the P.O. module from admin >modules >payment. This seems to have resolved all the little issues I was having with getting it to work and it now runs very well, Thank you BlindSide, Thank you ZC Team.

(Your Coffee is coming I promise )

[BlindSide]

I would like to be able to send an email similar to the new order email after I edit the order. I don't see a way to do this in Super Orders. I don't mind doing coding myself, but I was wondering if someone (who has had more experience with this code) had any advice on where I should be looking. I started last night and found myself copying over a bunch of stuff from the catalog (including the order class as well as several others that it needs) in order to resend the email (although parts of it still aren't working such as the totals and customer info. Any advice would be greatly appreciated.

So you want to resend message previously sent out through your store? I recommend you check out another of my modules: E-mail Archive Search. You need to turn on e-mail archiving for it to work, but then you can use it to resend messages previously sent at the click of a button.

[BlindSide]

@SnowBlind: I appreciate your letting us know what the problem was. I'll see about removing those SQL statements for the next release.

[Chrome Orange]

Blindside

this is some lovely code, real nice to edit/add to!

Thanks for the contribution.

Andy