Simple Invoices news 20061128

[Justin Kelly]

Hi All,

just a quick update re Simple Invoice happenings

hopefully in the next 2-3 weeks we'll be able to get a new release of
Simple Invoices out.

The main new features will be
- Custom fields/labels
- Nice icons on the index page
- translation update

for more info refer:
http://code.google.com/p/simpleinvoices/issues/detail?id=30&can=2&q=&sort=priority
http://code.google.com/p/simpleinvoices/issues/detail?id=32&can=2&q=&sort=priority
http://code.google.com/p/simpleinvoices/issues/detail?id=43&can=2&q=&sort=priority
http://code.google.com/p/simpleinvoices/issues/detail?id=55&can=2&q=&sort=priority

http://code.google.com/p/simpleinvoices/issues/list?can=2&q=&sort=priority&colspec=ID%20Type%20Status%20Priority%20Milestone%20Owner%20Summary

This is taken abit longer than expected as the custom field work
affects alot of areas and the invoice templates will be rewritten

Also a bug shoutout to Petri Hartoma for the great work in looking
after the lang files and work on getting all of Simple Invoices
translatable

Cheers

Justin

--
email: jus...@kelly.org.au

jabber: jus...@jabber.org.au
gtalk: linu...@gmail.com
msn: justinja...@hotmail.com
yahoo im: justinjameskelly
icq: 202893989

[Stuart Steele]

I have been trying to edit customers details and It keeps telling me something went wrong and to try again ( to know avail)  There isn't anything specific and it works okay otherwise

any clues

Stuart

--
Stuart Steele

StuWeb Race Management Services
www.stuweb.co.uk

[Justin Kelly]

HI Stuart

the most likey cause of this is that the database upgrade manager
needs to be run

basically, in some releases of Simple Invoices the database structure
changes (ie new fields,etc..) when this happens you need to run the
Database Upgrade Manager (from the Options menu) to upgrade you
database to work with the new Simple Invoices

note: in the last release of Simple Invoices a notes field was added
to customers,billers, and products.

Please let me know if running the Database Upgrade Manager fixes your problem
note: in future releases there'll be a warning note on the index page
to indicate it you need to run the upgrade

Cheers

Justin

[Stuart Steele]

well I thought that however all the patches appeared to be done, I ran it anyway (after backup, and it didn't change anything)

Stuart

[Justin Kelly]

Hey Stuart,

Question: Can you edit products and billers ok ?

[Stuart Steele]

yeah, just disabled a few billers ( e.g sample data)

is there a was to switch on verbose output to see what goes wrong?

Stuart

[Justin Kelly]

Hi Stuart

I havent as yet included any error output stuff in Simple Invoices

but....

a couple of things you could try

1. edit conf/config.php and add the following 2 lines

#Error reporting
error_reporting(E_ALL);

:note this will display a whole lot of errors on the screen(due to some
problems with the menus - you can ignore them and just watch for error
when you edit the customer)

2. if that doesnt give you the info you can edit your php.ini file
(assuming your running Simple Invoices on your own server) (restart
apache after the edit)

php.ini
edit the log_errors section to be on
###
log_errors = on
###

then watch the apache error log when you edit the customer and
hopefully if tell you more info about the error

tail -f /var/log/apache2/error.log

let me know how you go

Cheers

Justin
jus...@kelly.org.au

[Justin Kelly]

Hi Stuart

another thing.

could you please check that in the si_customers table in the database
is there a field called c_notes (should be type TEXT)

note: sql patch 22 was the last sql patch to alter the customers table
########
$sql_patch_name_22 = "Add note field to customer";
$sql_patch_22 = "ALTER TABLE `si_customers` ADD `c_notes` TEXT
NULL AFTER `c_email`";
$sql_patch_update_22 = "INSERT INTO si_sql_patchmanager (
sql_id ,sql_patch_ref , sql_patch , sql_release , sql_statement )
VALUES ('',22,'$sql_patch_name_22',20061026,'')";
########

cheers

Justin

> >http://code.google.com/p/simpleinvoices/issues/detail?id=30&can=2&q=&...
>
> >http://code.google.com/p/simpleinvoices/issues/detail?id=32&can=2&q=&...
>
> >http://code.google.com/p/simpleinvoices/issues/detail?id=43&can=2&q=&...
>
> >http://code.google.com/p/simpleinvoices/issues/detail?id=55&can=2&q=&...
>
> >http://code.google.com/p/simpleinvoices/issues/list?can=2&q=&sort=pri...

>
> > > > > > This is taken abit longer than expected as the custom field work
> > > > > > affects alot of areas and the invoice templates will be rewritten
>
> > > > > > Also a bug shoutout to Petri Hartoma for the great work in looking
> > > > > > after the lang files and work on getting all of Simple Invoices
> > > > > > translatable
>
> > > > > > Cheers
>
> > > > > > Justin
>
> > > > > > --
> > > > > > email: jus...@kelly.org.au
>
> > > > > > jabber: jus...@jabber.org.au

> > > > > > gtalk: linux...@gmail.com
> > > > > > msn: justinjameske...@hotmail.com

[Stuart Steele]

Thanks,

I looked in the database manager and it said that patch 22 had already been applied I looked at the structure and it wasn't there!

I pushed the sql statement from the PHP into the PHPmyadmin SQL box and the field appeared, customers section now working as it should.

Many thanks

STuart

[Justin Kelly]

Hey Stuart

Great to hear to works now!!

im abit concerned that it said that patch 22 was applied but the c_note
field didnt get added, - i'll look into that

Cheers

Justin

[Stuart Steele]

it might have been my porting/upgrade route?

Stuart

[Stuart Steele]

infact I think i know how I did it.

I moved from version of xammp to another created the database in mysql then copied over the table manually?

STuart

[Justin Kelly]

Hey Stuart,

yeah, its a possibility that in your migration that something got
messed up

Cheers

Justin