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

[carlvt88]

a.k.a. query builder. I don't know if there's a good interface into it, but I've used the query_builder table in the database, added a query, and used it for custom newsletter addressing.

[Andy_GS]

Hello, right i've tried to do an upgrade of an older version of super orders. I followed the instructions to install super orders then did the instructions of the upgrade.txt

When i ran the sql patch i got this error:

1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]
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. 

Then when i went to run the upgrade.php

1146 Table 'db_name.payment_purchase_order' doesn't exist
in:
[select * from payment_purchase_order]
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. 

We only use super orders to do the follow:

• batch processing
• and to ammend shipping addresses once orders have been placed.

as far as i can tell the site is still working.

The reason we needed to upgrade was when clicking on the buttons within super orders it would cause tables to lock up. The way round this was not to click directly on the buttons but to click somewhere within the block element, however people in this office can't always remeber to do that so they asked me to fix it.

Any ideas?

regards

Andy.

[remoteone]

Yes, i just did a new install (on localhost test machine) and got a similar error when running the sql.

SQL query:
-- EDIT EXISTING TABLES
ALTER TABLE orders ADD date_completed datetime default NULL ;
MySQL said: Documentation
#1146 - Table 'db_name.orders' doesn't exist

("db_name" is not my real dB prefix)
What does it all mean?
Cheers

[philip_clarke]

Yes, i just did a new install (on localhost test machine) and got a similar error when running the sql.


("db_name" is not my real dB prefix)
What does it all mean?
Cheers

id you install the patch using your shop admin ? because in all likelihood the table is called zen_orders and won't run through a mysql console.

Philip.

[DivaVocals]

id you install the patch using your shop admin ? because in all likelihood the table is called zen_orders and won't run through a mysql console.

Philip.

To add on: hence why you got the error that the table doesn't exist. (db_name.orders should be db_name.zen_orders)

So you can either manually edit the SQL to correct the table names (not advised) OR take Phillips excellent advice and run the script using the Zen Cart admin SQL update tool (the admin tool makes the correction for you as it runs the SQL script)

[remoteone]

Hello,
Thanks for advice and fast reply. By "Zen Cart admin SQL update tool " you mean "SQL Query Executor" under "install SQL patches".
Looking at the INSTRUCTIONS, I see it clearly states to:

3. Run the super_orders_sql.sql file on your database. Will work with
the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches).

For those the likes of myself, perhaps it should say:

3. Upload the super_orders_sql.sql file on your database. Will ONLY reliably work with
the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches) by UPLOADing the .sql file.

Since most Mod's Ive installed seem to prefer the cut-n-paste code method, I default to using it to install SQL script by cut-n-paste the code using phpMyAdmin. Assuming the Mod's script has been written to be compatible, and not need correction.

So Upload the .sql file (as instructed) I now get this error:

1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO db_name_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]
If you were entering information, ..blah blah blah....

Which I hope is ok. I guess it just means that the table already exists from my previous attempts.
So it should work now ???
cheers

[philip_clarke]

yes. (this message needs 7 characters)

[remoteone]

Ok that was step 3.
Step 4. ...theres no "Store Phone" or "Store Fax" showing under [Config> My Store]. (Apache restarted and Cache cleared)
Maybe I need to restore my previous SQL table and start again.

[philip_clarke]

Ok that was step 3.
Step 4. ...theres no "Store Phone" or "Store Fax" showing under [Config> My Store]. (Apache restarted and Cache cleared)
Maybe I need to restore my previous SQL table and start again.

It would be better to remove the lines that give you problems in the Install SQL patches. The sequence of sql is probably falling over at the first error.

[remoteone]

I restored previous sql database and Uploaded the super_orders_sql.sql file. Got this error:

1366 Incorrect integer value: '' for column 'configuration_id' at row 1
in:
[INSERT INTO mydBprefix_configuration VALUES ('', 'Store Fax', 'STORE_FAX', '', 'Enter the fax number for your store.
You can call upon this by using the define STORE_FAX.', 1, 4, now(), now(), NULL, NULL);]
If you were entering information, etc etc...

Still no "Store Phone" or "Store Fax".

It would be better to remove the lines that give you problems in the Install SQL patches. The sequence of sql is probably falling over at the first error.

Thanks Philip,
Well I'm not sure where to start with that, but I do want to be able to define "Store Phone" separately to the Store Address.
As it stands there is currently no STORE_FAX nor STORE_PHONE [configuration_key] after uploading the .sql.
Cheers