-
it says i have 19 patches to apply, they just wont apply, my list looks like this:
SQL patch 1, Create si_sql_patchmanger table has already been applied in release 20060514
SQL patch 2, Update invoice no details to have a default curren has already been applied in release 20060514
SQL patch 3, Add a row into the defaults table to handle the de has already been applied in release 20060514
SQL patch 4, Set the default number of line items to 5 has already been applied in release 20060514
SQL patch 5, Add logo and invoice footer support to biller has already been applied in release 20060514
SQL patch 6, Add default invoice template option has already been applied in release 20060514
SQL patch 7, Edit tax description field lenght to 50 has already been applied in release 20060526
SQL patch 8, Edit default invoice template field lenght to 50 has already been applied in release 20060526
SQL patch 9, Add consulting style invoice has already been applied in release 20060531
SQL patch 10, Add enabled to biller has already been applied in release 20060815
SQL patch 11, Add enabled to customters has already been applied in release 20060815
SQL patch 12, Add enabled to prefernces has already been applied in release 20060815
SQL patch 13, Add enabled to products has already been applied in release 20060815
SQL patch 14, Add enabled to products has already been applied in release 20060815
SQL patch 15, Add tax_id into invoice_items table has already been applied in release 20060815
SQL patch 16, Add Payments table has already been applied in release 20060827
SQL patch 17, Adjust data type of quantuty field has already been applied in release 20060827
SQL patch 18, 18 has not been applied to the database
SQL patch 19, 19 has not been applied to the database
SQL patch 20, 20 has not been applied to the database
SQL patch 21, 21 has not been applied to the database
SQL patch 22, 22 has not been applied to the database
SQL patch 23, 23 has not been applied to the database
SQL patch 24, 24 has not been applied to the database
SQL patch 25, 25 has not been applied to the database
SQL patch 26, 26 has not been applied to the database
SQL patch 27, 27 has not been applied to the database
SQL patch 28, 28 has not been applied to the database
SQL patch 29, 29 has not been applied to the database
SQL patch 30, 30 has not been applied to the database
SQL patch 31, 31 has not been applied to the database
SQL patch 32, 32 has not been applied to the database
SQL patch 33, 33 has not been applied to the database
SQL patch 34, 34 has not been applied to the database
SQL patch 35, 35 has not been applied to the database
SQL patch 36, 36 has not been applied to the database
------------------------
when I try an update, I get this:
Table 'si_payment_types' already exists
Skipping SQL patch 1, Create si_sql_patchmanger table as it has already been applied
Skipping SQL patch 2, Update invoice no details to have a default currency sign as it has already been applied
Skipping SQL patch 3, Add a row into the defaults table to handle the default number of line items as it has already been applied
Skipping SQL patch 4, Set the default number of line items to 5 as it has already been applied
Skipping SQL patch 5, Add logo and invoice footer support to biller as it has already been applied
Skipping SQL patch 6, Add default invoice template option as it has already been applied
Skipping SQL patch 7, Edit tax description field lenght to 50 as it has already been applied
Skipping SQL patch 8, Edit default invoice template field lenght to 50 as it has already been applied
Skipping SQL patch 9, Add consulting style invoice as it has already been applied
Skipping SQL patch 10, Add enabled to biller as it has already been applied
Skipping SQL patch 11, Add enabled to customters as it has already been applied
Skipping SQL patch 12, Add enabled to prefernces as it has already been applied
Skipping SQL patch 13, Add enabled to products as it has already been applied
Skipping SQL patch 14, Add enabled to products as it has already been applied
Skipping SQL patch 15, Add tax_id into invoice_items table as it has already been applied
Skipping SQL patch 16, Add Payments table as it has already been applied
Skipping SQL patch 17, Adjust data type of quantuty field as it has already been applied
I must admit, while I havent hacked any php/code in my SI's... I have had to add/hack in the DB to get certain things to work in the past.
I'd love a fresh new install, but need my data too... hrmmm -
Hey James,
looks like a patch 18 issue$sql_patch_name_18 = "Create Payment Types table";
$sql_patch_18 = "CREATE TABLE `si_payment_types` (`pt_id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,`pt_description` VARCHAR( 250 ) NOT NULL ,`pt_enabled` VARCHAR( 1 ) NOT NULL DEFAULT '1')";
$sql_patch_update_18 = "INSERT INTO si_sql_patchmanager ( sql_id ,sql_patch_ref , sql_patch , sql_release , sql_statement ) VALUES ('',18,'$sql_patch_name_18',20060909,'')";
$patch_count++
In the version you were running pre the upgrade did it have Payments? also what version was it?
Did you make any changes to the si_sql_patches table?
Depending on the answers to the above you may have to manually adjust the sql_patch table to so that it goes past patch 18 - let me know and we'll get this issue fixed
Cheers
JustinSmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au -
It did have payments, the previous version i was running: Version: 20060920 stable
now running : 2007-03-05 i think (in a different subfolder to the prev version i was running)
If i try to do a db update in the previous version I get the same error about the payments table already existing
looking at the sql, my si_payment_types table looks like this:
pt_id - int(10) - primary key
pt_description - varchar(250)
pt_enabled - int(1)
the data inside looks like this:
1 - cash - 1
2 - cheque - 1
3 - Direct Debit -
(where first col is ID, 2nd is description, third is enabled)
James -
great !!!
cheers
justinSmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
Categories
- All Discussions 2387
- English 2369
- Español 10
- Portuguese 5
- Deutsch 3