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

[BlindSide]

Yes, SO is fully compatible with Zen Cart 1.3.6

[mkm]

Yes, SO is fully compatible with Zen Cart 1.3.6

Do you know if it works with Stock by Attributes by any chance? Can't wait to give it a try...

Thanks!

[Svanis]

What happened to the functionality of adding products on an existing order?
I found this very useful..

[tajul_ashyqin]

What happened to the functionality of adding products on an existing order?
I found this very useful..

fyi, its not included in this latest mod...

[Happyworker]

The so_* tables were not the problem, but rather the inserts made to the configuration table. Do a search in the SQL file for the following:

insert into configuration

See all that stuff? If you attempt and fail to run the SQL file, then run it again, it does not overwrite existing entries. Unless you know what you're doing, your best bet is to restore from the backup you made right before running the SQL file and try again. The file works if applied properly.

Or just read the whole README file. Most of it is covered in there. I'd like to comment on your installation procedures (which are great! ), in hopes they save others from this recurring issue...

This should typically be a given. The file should be run using a tool that already knows which DB to run on (i.e. phpmyadmin). Your step 2 would be the correct procedure if using the command line (which most shared hosts don't allow).

(Aside: As an FYI, I have a dedicated server like you, and I never use the command line. I think you'll find it far easier to maintain your DB's using phpMyAdmin. Just my opinion, though.)

Bolding is my emphasis. This is for everyone who gets "duplicate entry" errors when running the SQL. Re-running the file simply won't work; comment out the duplicate line ('cause it went in properly on the first try), or reload your DB, fix the problem that caused the first failure, and try again.

See? DB properly selected; SQL file and DB properly configured; alls well!

I'm having this problem

1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]

and I can't re-install my db from a backup because it's too old [I know for next time]. Just wondering how I can solve this problem. I can't see Admin-->Config-->Super orders and my Tax # is not displaying in on my invoices.

Any help would really be appreciated.
Thanks for your patience as this was probably covered, I just don't understand.
Cheers,
Happyworker

[BlindSide]

I understand this stuff can be tough for a beginner, but did you even read the message you quoted, Happy? Let's try again...

This is for everyone who gets "duplicate entry" errors when running the SQL. Re-running the file simply won't work; comment out the duplicate line ('cause it went in properly on the first try)...

You cant properly re-run the SQL file without first resetting your DB to the way it was before running it the first time. It sets up tables and entries that cannot be duplicated.

Commenting out the offending line only solves a fraction of the problem, as you'll undoubtedly have other duplicate lines. Since you don't have a viable backup, you'll now have to go through the SQL file line by line, and compare it to your DB's current state. Remove any duplicate entries it made (e.g. the `configuration` table is not set to prevent dupes), and manually execute each SQL statement that did not go in the first time.

Shame on you for not following all those big backup warnings.

[BlindSide]

What happened to the functionality of adding products on an existing order?
I found this very useful..

If you used any kind of attributes, it was totally broken with the latest versions of Zen Cart, so I scrapped it. Go back a few pages and you'll see a list of upcoming features. Adding new products is on there.

Do you know if it works with Stock by Attributes by any chance? Can't wait to give it a try...

The current version will be fine with that, as far as I know. Super Orders only changes order reporting output, not input. The next version includes adding products and doing returns and exchanges, which definitely will not work with Stocks by Attribute.

[Happyworker]

Thanks Blindside

Yes I read the text, I didn't understand the "commenting out of the offending line".
How do I comment this out and manually insert the sql that didn't go the first time?
I'm going to go through the configuration table and take out any duplicate.
Thanks again, much appreciated.

[BlindSide]

Thanks Blindside

Yes I read the text, I didn't understand the "commenting out of the offending line".
How do I comment this out and manually insert the sql that didn't go the first time?
I'm going to go through the configuration table and take out any duplicate.
Thanks again, much appreciated.

No problem, I'm sorry to see you suffering through. You can comment out a line in SQL by adding a double slash (//) double dash (--) to the beginning of the line. Whole sections can be commented using the /* */ format. In your case, I recommend you keep the file open and just copy and paste the necessary lines into the SQL field in phpMyAdmin. Go one line at a time to avoid further possible damage.

[Happyworker]

Thanks for the help Blindside,

Okay, everthing seems to be in order now and I see the admin-->config-->super orders.
Excellent

Now, just something has caught my eye....

When I click on the Invoices I notice that under the Tax column it says "None!".

Well I have set all my configurations to show tax and it shows it along the right hand side like normal....it's just underneath that column that it shows "None!"

Thanks again for your help
Cheers,
Happyworker