Simple Invoices - Forum

Great. Good to see all the progress. Could you tell me when the stable version is planned? I'm thinking of using it for my (new) company (supershackle.com)

I am new to SImpleInvoices. I have been using it for a few weeks and I have been using the current stable version along side the beta version. All the core functionality seems to be working fine in both versions. Before I upgrade my current beta 3 to beta 4, can anyone tell me if there are any database changes from beta 3 to beta 4?

hey srosa

re beta 3 to beta 4
- there is a new tables added (si_extensions)
- you wont have to manually do anything to mysql - when you first run beta 4 it'll prompt and run the sql upgrade for you

let us know how you go

cheers

justin

@ikbenivo

the current beta is pretty stable - just some things a re still a work-in-progress

i would say that the stable 2009.1 should be release in a month or so

Cheers

Justin

Hi Guys,

theres a demo online of 2009.1 beta 4 http://simpleinvoices.org/beta

Cheers

Justin

thanks Justin. Looking forward to the stable version!

no worries ikbenivo,

just subscribe http://simpleinvoices.org/subscribe to the blog and you'll hear the latest Simple Invoices news when they happens

cheers

justin

Just to let you know. When you upgrade from the last stable version (20080629 stable), every other table works fine, but when you go to see the invoices list, if there are already invoices in it from a previous version (like 2008, before beta stages) it stalls and hangs on processing. Will not go any further to show the invoices. You can add just fine, but even when you add it will not display any of them, just hangs. So something is happening when the upgrade is done, the table for invoices is not getting upgraded right.

I did get this error when doing the initial upgrade of the db:

SELECT count(*) as count FROM si_invoices where domain_id = :domain_id limit 2
Unknown column 'domain_id' in 'where clause'

I also cannot get into the manage patches under settings. Is this supposed to be right now?

thanks jfreak53 for reporting this! - this is exactly the type of stuff i'm trying to ensure works 100% by the time 2009.1 stable is released

can you run the below sql in mysql
ALTER TABLE `si_invoices` ADD `domain_id` INT NOT NULL AFTER `id` ;

then try the manage invoices page

let me know how you go

sql_patch 142 is supposed to add this column into the invoices tables -- hmm..

note: i did a fresh download of 20080629 created the db - did some invoices then upgraded to beta 4 and manage invoices worked for me
- so maybe your server doesn't like the above sql - we'll see

cheers

justin

hmm..Well I went ahead and did a fresh upgrade again, patch 142 it says is upgraded and if I go into the DB table and look at it after the upgrade it is there "domain_id" after the id in invoices. Now that error only appears when I'm at the upgrade page when I launch the index.php the first time and when it goes back to the upgrade page after the update and says that all the patches are applied, it doesn't appear in the main window after the patches.

before patch - SQL patch 142, Add domain_id to invoices table has not been applied to the database
after patch - SQL patch 142, Add domain_id to invoices table has been applied to the database

Is this and error with my system or something else? Like I said it will display all other lists but it hangs on processing only invoices. But in the DB the domain_id is there right after the id field and it's not empty, it shows 1.

Hi Justin,

Just upgraded from 2008-06-29 stable (Debian Lenny, MySQL 5.x, PHP5)- and working fine.
A couple of minor issues to report:

1. I received the same message as jfreak53 on the UPGRADE screen - reporting a problem with the 'domain_id'. But the message disappeared after the upgrade, and I've since added the field manually using the SQL from patch 142, with no further problems.

2. It appears all the decimal fields are calculated to 6 decimal places. Reducing these to 2 (25,2) seemed to fix some of the report layouts and makes a bit more sense in GBP.

3. The currency sign changed from a £ sign to a capital 'A' with a chevron, while the collation remained 'utf8_general_ci'. Since changing it back again in invoice preferences, all seems fine.


Thank you for all your hard work!

Hi Justin,

I just performed the upgrade from beta 3 to beta 4. All went well. I was a little confused when I looked at the si_extensions table and it had only one entry, while the Essential-Data.sql script appeared to insert two almost identical records ino the si_extensions table. I assumed that the upgrade did the right thing.

regards,

Hello,

Just started to evaluate Simple Invoices. On my host I've got a similar problem as user flax had in the beta 3 thread; all page loads take an extremely long ammount of time, in the range of minutes. He found a temporary fix http://simpleinvoices.org/forum/discussion/740/simple-invoices-20091-beta-3-released/#Item_13 but obviously due to progress the code he suggests commenting out has moved, and as as he didn't give a detailed description I am unable to try it for myself. (i'm considering downloading the Beta 3 to take a look at the older file anyway)

php code runs fine in the other scripts on my host, Drupal and BambooInvoice (anothre invoice script I'm evaluating)

(my host is running php: 5.2.6 mysql: 5.0.67) same results in both IE8 and Firefox 3.5b4

(also, the menu system doesn't work in firefox, it's all blue text and overlapping the main content, like the css file hasn't been loaded properly but in IE8 everything is fine)

Hi all,

Am I the only one getting the Undefined errors? :



Notice: Undefined variable: block_stage2 in .../simpleinvoices/modules/invoices/email.php on line 41

Notice: Use of undefined constant pref_inv_wording - assumed 'pref_inv_wording' in .../simpleinvoices/modules/invoices/email.php on line 82
Message could not be sent.
Mailer Error: Language string failed to load: recipients_failed

Hmmm, I've tried to change the

$PHPMAILER_LANG["recipients_failed"] = 'SMTP Error: The following ' .
'recipients failed: ';

to

$PHPMAILER_LANG["recipients_failed"] = 'SMTP Error: The following recipients failed: ';

but no joy.

Then I've commented out the whole "thingy" but again, no joy.

As a last resort I've renamed the php file to ..../simpleinvoices/library/mail/language/phpmailer.lang-en.php1 and.... this worked!

Needless to point out that I'm a PHP noob ;)

No warning and the mail got sent!

Love the program btw!

@stevenvanderzwan
re email
- thanks for reporting this issue
- i haven't tried sending emails in the 2009.1 beta series for ages - will give it a go as soon as possible and fix up any errors

cheers

justin

@adfad666

re taking ages to load
- i've just removed that query in the development version
- in the next release 2009.1 beta 5 it should be all OK

find function checkTableExists in include/sql_queries.php

and replace the entire checkTableExists function with


function checkTableExists($table = "" ) {
$table == "" ? TB_PREFIX."biller" : $table;

global $LANG;
global $dbh;
global $config;
switch ($config->database->adapter)
{

case "pdo_pgsql":
$sql = 'SELECT 1 FROM pg_tables WHERE tablename = '.$table.' LIMIT 1';
break;

case "pdo_sqlite":
$sql = 'SELECT * FROM '.$table.'LIMIT 1';
break;
case "pdo_mysql":
default:
//mysql
//$sql = "SELECT 1 FROM INFORMATION_SCHEMA.TABLES where table_name = :table LIMIT 1";
$sql = "SHOW TABLES LIKE '".$table."'";
break;
}

//$sth = $dbh->prepare($sql);
$sth = dbQuery($sql);
if ($sth->fetchAll())
{
return true;
} else {
return false;
}

}


if you can retest and let me know how it goes

Cheers

Justin

@srosa

re extensions
- thanks for pointing that out
- i've now removed the duplicate 'core' rows from the sql

note: in the next release - to do a fresh install - there will be no need to import and .sql files - theres a new mini installer to sort all this out

cheers

justin

Hi Justin,

Thanks for the reply, I managed to edit the sql_queries.php myself I simply commented out the offending code, but I also had to do this to checkfieldExists too:


function checkTableExists($table) {

global $LANG;
global $dbh;
global $config;
switch ($config->database->adapter)
{

case "pdo_pgsql":
$sql = 'SELECT 1 FROM pg_tables WHERE tablename = :table LIMIT 1';
break;

case "pdo_sqlite":
$sql = 'SELECT * FROM :table LIMIT 1';
break;
case "pdo_mysql":
default:
//mysql
$sql = "SELECT 1 FROM INFORMATION_SCHEMA.TABLES where table_name = :table LIMIT 1";
break;
}

$sth = $dbh->prepare($sql);
{
/* if ($sth && $sth->execute(array(':table' => $table))) {
if ($sth->fetch()) {
return true;
} else {
return false;
}
} else { */
return true;
}

}

function checkFieldExists($table,$field) {

global $LANG;
global $dbh;
global $db_server;

$sql = "SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name = :field AND table_name = :table LIMIT 1";
if ($db_server == 'pgsql') {
// Use a nicer syntax
$sql = "SELECT 1 FROM pg_attribute a INNER JOIN pg_class c ON (a.attrelid = c.oid) WHERE c.relkind = 'r' AND c.relname = :table AND a.attname = :field AND NOT a.attisdropped AND a.attnum > 0 LIMIT 1";
}

$sth = $dbh->prepare($sql);
{
/* if ($sth && $sth->execute(array(':field' => $field, ':table' => $table))) {
if ($sth->fetch()) {
return true;
} else {
return false;
}
} else { */
return true;
}
}


Also, as far as my issues with firefox are concerned, the beta updated itself to an RC and now everything is working fine!

Also, I tried to change the language of Simple invoices to Czech, and it completely broke the script; all pages simply came up blank. I couldn't figure out how to change it back manually so I had to reinstall from scratch, and I've since hacked the default template with a bit of guidance from the EURO template and changed the writing there.

Maybe the cs lang.php is outdated and broken, I don't know, but I'll wait until B5 is released to have a go at seeing if I can fix and update it for you, along with some other customizations I've needed to do specific for the Czech system.

Adam

Hey Adam

thanks for the update

re Czech,
- the czech lang file is a bit stuffed in beta 4 - has been fixed and will be in beta 5 (which will be out in a week or so)

Cheers

Justin

aha, I came by to say I've just had a look at the Czech file and a lot of the custom symbols have been replaced with question marks... Also, I had a quick scan, and some of the 'translations' are a bit funny, for example 'custom field' has been translated as custom = optional (a reasonable enough translation) but field has been translated as the place where crops grow... :D

The summer is coming so I'll have a some extra free time to work on it, what with clients going on holidays etc. It might be easier for me to start from scratch when B5 is here.

hey adam

re translations
- i believe the problem has been fix in this release: http://simpleinvoices.googlecode.com/files/simpleinvoices.2009.1.beta4-3.zip
- you might want to download that and give it a go - let us know how you go

re translations
- thanks for the update
- if you have time please feel free to corrrect any mistakes - just download the latest files from http://code.google.com/p/simpleinvoices/source/browse/#svn/trunk/lang

cheers

justin

I am getting a blank screen for the index page. any suggestions?

hey ecksfiler

try the beta 5 version and let us know how you go

refer: http://simpleinvoices.org/blog/simple_invoices_2009.1_beta_5_released

try the

Justin,

Beta 5 worked fine, thanks!

@ ecksfilter

thanks for the update

great to hear it works now!!

cheers

justin