I have a question concerning running queries. The following are the instructions for the mod pdf_order_center_1.1.1.zip (edited).
I do not have a localhost test server. All of my files are on my host server. Does the querie make changes to the files contained in the mod? If I run the querie through my admin panel on my host server, do I need to first upload the files contained in the extract zip then run the querie, or do I run the querie first then upload the rest of the files?
[1] Run the queries in the SQL file pdfoc.sql.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
You can run the SQL file in one of two ways: either using the
Admin::Tools::Install SQL Patches tool, or using a program like phpMyAdmin. <<<This part is located on my host server, not localhost.
The Admin SQL Patch tool unfortunately chokes when uploading the SQL file (it creates
an SQL error somehow), so you will need to copy and paste the text from the file
into the Patch tool instead.
There is a line in the SQL file that changes the auto increment value for
the orders_invoices table. This has the effect of starting off your invoices with
the number of your choosing (instead of having them start at 1). You should edit
this value as needed in the corresponding SQL file before running the query. The
line in question is:
ALTER TABLE orders_invoices auto_increment=2060000;
(* If you have already implemented a different invoicing system, you will need to
alter the PDFOC code to use your existing system instead.)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
[3] Upload all the files in the contribution to your store, following the exact directory structure. <<<Upload to my host server before or after running the SQL queries on my host server?



