Some problems in report

GoogleCodeExporter commented 9 years ago

What steps will reproduce the problem?
1. Go to index.php?module=reports&view=database_log
2. See that the last patch was not applied
3. click "update"

What is the expected output? What do you see instead?
===========================================
Simple Invoices - SQL problem
===========================================

The following sql statement:
ALTER TABLE si_customers ADD tax_id VARCHAR(16) AFTER `name`;

had the following error code: 1060
with the message of:Duplicate column name 'tax_id'

===========================================

It seems that the patch is applied but the system does not recognize it.

Original issue reported on code.google.com by r.luthi...@gmail.com on 28 Dec 2011 at 11:15

GoogleCodeExporter commented 9 years ago

Fixed in r3840

Original comment by buchs.en...@gmail.com on 16 Jan 2012 at 11:00

Changed state: Closed-Fixed

GoogleCodeExporter commented 9 years ago

hey buchs

think can leave sql_patch 257 in 

maybe the tax_id was already in the .sql files for the install
- the sql_patches and whats in teh .sql install files might be out of sync

have a look at the install files and see if you can find the issue

cheers

justin

Original comment by jus...@kelly.org.au on 17 Jan 2012 at 10:36

google-code-export / simpleinvoices

Some problems in report #204