Simple Invoices - Forum

fyi

you can test out 2009.1 beta 3 at http://simpleinvoices.org/beta/

cheers

justin

Hi Justin,

congrats for new beta release...

Let me just say I did not give up on fixing Postgres, but real-life is simply kicking me out at the moment :-(


Sincerely,
Gour

hi,

thanks for the new release. SimpleInvoices looks very promising to me. We successfully ran older versions of simpleinvoices, but I'm waiting for the new version before we use it productively as we need to adjust some templates (especially more space for bank info). However, the new beta always returns


===========================================
Simple Invoices error
===========================================
The file ./tmp/log/si.log has to be writeable

I chmod-777ed /tmp and /simpleinvoices/tmp (dirs, subdirs & files each) ... and it occurs on two different servers. Do I miss something here or is it a bug of the new version?

thanks for spotting this flax

just noticed that the log file si.log wasn't included in the release - i assume zend_framework logging would auto create one if it doesnt find it - but that appears to be wrong

the quick fix is to

touch ./tmp/log/si.log

and i'll make sure the problem is fixed in the next beta release

thansk for testing and finding this issue!

cheers

justin

@Gour

thanks

re postgres
- theres no rush - so whenever you get time it would be great
- i understand real world issues comes first

cheers

justin

thanks justin, that fixed it.

another question - on one of my servers, simpleinvoices runs terribly slow. Opening invoices for example takes minutes(!) to load, and all data in the DB are from your script.
Any ideas which php.ini setting could be to blame? We have a typo3 environment running on it which feels normal speedwise...

Any hints?

Hello just notice that flax was having the same issue I'm having.I see the fix" touch ./tmp/log/si.log" but does not make sense to me what exactly what do we do create a file put it where can you be a little more specific tahnk you .

Simple Invoices error
===========================================
The file ./tmp/log/si.log has to be writeable

brabago, you have to create an empty file, call it "si.log" and upload it to your server in the simpleinvoices subdirectory [i]/tmp/log/[/i]
In addition you need to set the folder properties to the directory [i]/tmp[/i] so all users and groups have full read/write access to it. This can be done by using the chmod 777 command or by using an ftp client tool.

Hope this helps!

flax,

Thanks for the information tried it but no joy for me still get the error checked and made sure to have the writeable evrything looks right but I must be missing something I'm trying to install it on slicehost on Ubuntu but can't seem to get it to go well if you think of anyhting else I can try let me know or if anybody else has loaded simple invoices on Slicehost using Ubuntu . Once again thanks for the information appreciate it.

flax,

That worked what had happen was when I saved the file it was saved as si.log.txt removed the txt and there was joy thank you very much appreciate it.

@flax
- thanks for this info !

@brabago
- i've fixed this issue in our development version. In 2009.1 beta 4 it'll auto create this log file if its not there

Cheers

Justin

@justin: I checked with my hoster why SI is running so slow, here's the answer:

by opening SimpleInvoices, an SQL query is being made:

""SELECT 1 FROM INFORMATION_SCHEMA.TABLES where table_name = :table LIMIT 1";"

he doesn't see sense in this. That's why he modified /include/sql_queries.php by commenting this query out and just returning true as value. Commented out lines:

2095 - 2105

Value TRUE set to lines:
2106
2120

this fixed our issue and I think it's something you should look into. Apparently what we have now is a workaround, not a real fix.

Rgds
Flax

thanks flax for getting this info

the sql query is used by the language system to do some stuff

re :table - we use prepared statements with PDO in Simple Invoices for our sql queries - refer: http://au2.php.net/manual/en/pdo.prepared-statements.php

i've recoded what was calling that query - so in the next release is should all be OK

cheers

justin

After a fresh Beta 3 install, I'm unable to add a new customer through the interface. I have to manually enter a new customer in the database and after that, the customer appears in the list and the title "MANAGE CUSTOMERS:ADD A CUSTOMER" appears on the "People - Customers" page.

After that, even if I click on the link "Add a customer", I can fill all the fields and I can save the new customer, but the new record doesn't appear in the list (and it's not in the database).

Is it a known issue?

Note: I tried the link on the dashboard to add a client and I have the same problem. The new record is not saved even if I fill the form and click on save.

Thank you.


Eric

Hey Justin!

I just took a breeze around your beta 3 demo via provided link in your post in the beginning of this thread. You've made some big changes since the last stable version, and it looks great. :)

However, two things i happened to notice in my perusing of the demo:

Is there no way to Log Out of the program? Can't find the button for this...

And also, on Home - Dashboard, under the section labeled "Don't Forget To" ... the "Backup your Database Now" button links to the manage customers page. Oops!

Keep up the great work!

PHP Version 5.2.8:

Warning: require_once(Zend/Loader.php) [function.require-once]: failed to open stream: No such file or directory in /home/diversif/public_html/simpleinvoices/include/init.php on line 9

Fatal error: require_once() [function.require]: Failed opening required 'Zend/Loader.php' (include_path='.:/usr/lib/php:/usr/local/lib/php:./include/class:./library/:./library/pdf') in /home/diversif/public_html/simpleinvoices/include/init.php on line 9

http://diversifieddentalusa.com/simpleinvoices/phpinfo.php

My path: http://diversifieddentalusa.com/simpleinvoices/path.php

<?php<br />
echo get_include_path();

?>

Results:
.:/usr/lib/php:/usr/local/lib/php

Hope it helps,

-Zeke

@mrmeech

re logout
- on the beta site http://simpleinvoices.org/beta login is turned off - so there is no need for a Logouff menu
- if you enable login - then a logout menu will be shown
note: even with login turned off - you still get the hello [email protected] stuff at the top - as even with login turned off a session is still created so info on actions can be logged

re backup
- thanks - i've now updated the link in svn - it'll be right in the next release

thanks for pointing these out

Cheers

Justin

@Zeke

can you check is there is a Zend folder in the ./library directory

if you go to http://diversifieddentalusa.com/simpleinvoices/library/Zend it says its not there

note: this folder may be there just needs the correct permissions for the webserver to access it

let us know how you go

Cheers

Justin

@justin

sorry im not sure how to do that, im on a shared server through HostGator.com

i will see if i can enter a ticket to find out about how to reach it.

Thanks

-Zefex

Zefex

in your ftp program that you probably uploaded Simple Invoices with

go into the Simple invoices directory - and then into the 'library' folder - and see if there is a folder called Zend

let me know how you go

Cheers

Justin

@Justin

GacK!!!! Zend folder, Its missing!! oh man.

wow, i remember something going wrong in the FTP upload and it terminating abruptly, i restarted the ftp upload but i guess it skipped that file....SmartFTP

well a proper install should fix this right up! Thanks so much for you kind help.

update:
Love the beta! wow!

After i create the file si.log i got a error and had to add db settings in config/config.ini

-Zeke

I was away for a week, and I now have time again to look into the beta of si.

I use the SVN version.

Yesterday I checked out the new version, and now I do not have a working version any more (was around rev2175, is now rev2229).

First error were a few syntax errors in define.php, starting from the line with: <<<<<<<<<<< .mine<br />It looked like some leftover code, so I just commented it out.


The second error was 'pdaadpater', which should be pdoadapter (in sqlqueries.php, change already committed).

Retrying gives me an empty page, so I've set the error-level to E_ALL, to find the following error:

===========================================
Simple Invoices database connection problem
===========================================
Could not connect to the Simple Invoices database

For information on how to fix this pease refer to the following database error:
--> could not find driver

If this is an Access denied error please make sure that the database.params setting in config/config.ini are correct
===========================================

I have $environment="dev", and my db-settings in dev.config.ini (in config folder)

This hasn't changed from the version of feb 19th, when all was still working.

It appears a few things have changed setting up the db, but I am not familiar with how it should work, and I do not see where this error is generated (which file).

Any help would be appreciated.

Marcel

thanks for spotting this marcel

my bad :)

have commited the fix to svn

let me know how you go

cheers

justin

I now 'see' more then befor, thanks justin.

However, I do get several errors now, about missing variables.

Notice: Undefined variable: invoices in /home/marcel/si/trunk/modules/invoices/manage.php on line 24
Notice: Undefined variable: spreadsheet in /home/marcel/si/trunk/modules/invoices/manage.php on line 26
Notice: Undefined variable: word_processor in /home/marcel/si/trunk/modules/invoices/manage.php on line 27

The table says: Processing, please wait.....
and this takes forever.

Logging level is 'ALL'

If I do 'new invoice', the biller/customer/products/taxes drop-down lists are all filled with database data, that does not seem to be the problem.

Any suggestions?

Marcel

thanks marcel for this info

Simple Invoices still doesn't run happy on E_ALL for errors - put it on ERROR and it'll be ok

the manage pages wont work yet on E_ALL - it fails to the be xml file used to create the grids
- if you install firebug in firefox - then load the manage page and check the firebug console and view the output of the GET you'll see the problem
- think it'll be easy fix - just haven't had any time to look at it

cheers

justin

I did the E_ALL to find out what went wrong.
The notices also messed up the XML processing. That is not so obvious in the firebug console, but it is when visiting
/index.php?module=invoices&view=xml

Putting it back to E_Error made things working again, thanks for the help.

Marcel

no worries marcel

i'll try and make Simple Invoices work with E_ALL

cheers

justin

Hi
I just successfully install beta 3 on my server, so fare so good. Now I found out that I have same problem as Marcel - if I click on Invoices, Customers, Billers, Users or Manage Products I get "Processing, please wait ..." in the table below. How can I fix this problem?
George

Hey George

open ./config/define.php in an editor and set php errors and change it from

#####################
/* Error reporting */
#####################
#
#error_reporting(E_STRICT);
#error_reporting(E_ALL);
#error_reporting(E_WARNING);
#error_reporting(E_ERROR);
#error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
#error_reporting(0);

to

#####################
/* Error reporting */
#####################
#
#error_reporting(E_STRICT);
#error_reporting(E_ALL);
#error_reporting(E_WARNING);
error_reporting(E_ERROR);
#error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
#error_reporting(0);


Let us know how you go

Cheers

Justin

Hi Justin

No luck, still that endless "Processing, please wait ...". Any other suggestion?

peace
George

Hey George,

php.ini's error reporting setting may be overriding this setting in ./config/define.php

stick this in config/define.ph and give it a go
ini_set('display_errors','Off');

let us know how you go

Cheers

Justin

Nop, nop, still the same. And also in php.ini is set 'display_errors' to 'Off'.
This is really a pain in the ass, this beta3 is such a nice system and I cant play with it. :((((
Please, please help.

peace/george

hey george

in php.ini what is error_reporting set to?

cheers

justin

I checked php.ini and it was set to "error_reporting = E_ALL" than I changed that to "error_reporting = E_ERROR" but again no luck, that "Processing, please wait ..." is still there.
Any other suggestion???

George

hey george

1 - use firefox
2 - install firebug
3 - go to Manage page and open firebug console
4 - click on the GET in the firebug console and click show contents/load - or whatever it is
5 - read the output and post the error message - or all the output

cheers

justin

I found this was often due to errors in the xml output. Due to the design though, you do not see them.

try to do the following (yes, not nice, I know, but it can give you some answers):

If your normal URL is:

http://my.host.name/si/

Then point it to:

http://my.host.name/si/modules/invoices/xml.php

or one of the other modules. There will be some errors (as required libraries are not loaded), but
should see some (XML) output. I expect you will see an error and this error would be very informative, can you post it here?

Marcel

Hey Justin
Hmmm... I installed this firebug and to tell you the truth I cant find any serious errors except some css issues like padding and borders.

And Marcel you also wont be happy with my answer coz if I do as you told me I get only this:

"XML Parsing Error: no element found
Location: http://*************/modules/invoices/xml.php
Line Number 1, Column 1:"

Im wandering what Im doing wrong???

George

That is strange! You should get an 'undefined function dbQuery()', because dbQuery is defined in another file which is not included when calling the file like this.

Instead it looks like you do not have any output at all!

If you do:

http://**************/index.php?module=invoices&view=xml

What do you get?

(this way all necessary files are included, and you simulate the call from the non-functional table).

Marcel

Hi Marcel

Yeah I know what you mean, strange, but I get exactly same output:

XML Parsing Error: no element found
Location: http://simpleinvoices.e-pro.si/index.php?module=invoices&view=xml
Line Number 1, Column 1:

George

I have several small bugs with Beta3.

I did a fresh install with just Beta3. Imported the .sql's from the databases/Mysql folder.

On the HOME>All Reports
When I click on Database Log, I get an error telling me that si_users table does not exist. I checked and sure enough it does not. I checked the .sql files included and this table does not exist.

When I click on "Total Owned per Customer" report I get OOOOps There's an error. There's an error on your SQL query. (No other info, havent dug down yet to figure out what it is looking for)

Most all the reports have 6 decimal spaces instead of 2.


On the HOME>Dashboard
The Hide this forever link does not hid the information box on any screen.

--fancy graph here -- --some links on right (I do not see any graph)


On the MONEY>Payments
When I click on the payments link I do not get any results for the payments that have processed. This page is always blank with the menu bar.
If I go to Invoices and click Process Payment, I get redirected to the Payments tab for the current payment only. After I submit the payment it redirects to the payment tab with no results.

On the MONEY>Invoice>Process Payment
The amount field shows more than 2 decimal places.

On the Products>Manage Products
When editing a product the Product Unit Price always shows 6 decimal points.

On the Products>Add Product
The default tax box does not pull its settings from the System Preferences (Not sure if it is suppose to or not?)


Derek

Hi there,

Just my idea on the latest beta:

The config file does not have a .php extension and therefore if people enter the URL they can see the whole config file, including mysql password etc. I am not sure if this is just a beta/svn thing and if it will be fixed in the proper release or not?

I would like to do some development on simpleinvoices, mainly looking at creating an interface/class/similar which allows third-party applications to integrate with the simpleinvoices database in a sane manner (IE using the same functions/methods as simpleinvoice). I assume I should be doing this with the beta/svn codebase rather than the stable one, right? The reason I am looking at extending simpleinvoices in this way is so I can integrate it into some existing websites and systems I have. Is there anybody else who is interested in this sort of functionality?


Rene

Hey Rene,

re config
- yep - known issues
- in svn there is a .htaccess file which disables read access to .ini files and stops directory browsing
- example http://simpleinvoices.org/beta/config/ http://simpleinvoices.org/beta/config/config.ini
- this is apache only - and not the best solution
- renaming the .ini to .pnp and a minor change should fix it but i havent tested it yet

re development
- great - use svn trunk for sure as its alot different from the last stable release
- there was some work done on a simple xml type api for Simple Invoices - search Remote Framework in the forum
- but no work has been done it for ages
- a new nice and fancy interface/api would be great - as long it handle authentication setc..
- im definetly interested - i'll chat to you on irc when im on next

Cheers

Justin

Hi Justin,

Good to hear back from you. I will look into the things you mentioned.
Just thought I would give a bit of a background to how I use SI now and and how I plan to use it if/once I make an API. Hopefully this will give others ideas as to how they might be able to use it.

Currently I use simpleinvoices in 2 situations. The first is a small web hosting company, reselling VPSes, shared hosting and other such things. I am hoping to be able to create a separate app which hooks into the customers and invoices and lets customer log in and view their invoices, payments, account balance etc. All customers pay us in NZD (New Zealand Dollars) but the item price for some products is set in USD. I use a custom field in each product, and have a script which loops through the product database, and when given the current USD-NZD exchange rate will update the NZD price for that product.

I also had the idea to make a "subscriptions" module. This would basically map each customer to the "service" (product) they subscribe to. I could then use the API each month to run a script and automatically generate (and maybe e-mail) invoices.

The second situation is a private ski lodge with ~40 members. We currently use a web-based booking system (which I developed myself to fit the lodges needs). I am looking at modifying simpleinvoices so I can use our existing member database as a customer database (shouldn't be too hard). I then also want to use the API to handle automatic generation of invoices based on the bookings people have made, and also integrate info such as account balance, invoices, payments etc into the booking system so customers can log in and view this information.

Hopefully this is useful information,

Rene
[edit: fix grammar]

hey rene

your ideas sounds great - keep us in the loop - hopefully you can add alot of good stuff to Simple Invoices

cheers

justin

@derek

thanks for pointing these issues out - a few were listed in the known issues on the release blog

by the time of the full release these should all be fixed up

let us know if and when you find more issues - the more the better!

cheers

justin

thanks Justin i managed to make it work and i love it!!!
you are a champ :)

no worries dario!

cheers

justin

Hey,


I got probably a small problem with the beta last beta release.

I installed simple invoices on a CentOS 5 machine. Everything should be working and everything but one thing. Probably the most important one.

I don't get any views. I can add invoices, add users etc etc. but when I click on manage. nothing shows up. It says processing please wait for hours.

When checking with firefox error console, the only relevant thing that shows up is:

Error: no element found
Source File: http://**************/billing/index.php?module=invoices&view=xml
Line: 1

What I must say tho is, I first installed it on a CentOS 4 machine. It worked perfectly except the xsl part with php5 because there are no rpms for that on CentOS 4.

Since I really needed the reports, I moved my DB and files, adjusted the config.ini file to match DB of course and everything worked again.

Reports work, i get the results.

Anyone knows what's wrong?

Cheers,
Yahya

Hey Yahya,

re manage pages
- this is most liekly to do with the known issue of the with level of error reporting that your PHP is on
- if on show warnings then the xml (that the manage page used to display the grid) isn't generated correctly

note: this is still to be fixed in svn - i haven't looked at it yet - just need to review how the code for the manage pages work as PHP doesnt like on section of it

Cheers

Justin

I fixed my issue, but I think there's another way which I still didn't figure out.

I just changed in php.ini

error_reporting = E_ALL

to

error_reporting = E_ALL & ~E_NOTICE

and it worked