Simple Invoices - Forum

Hi Justin,

I have now upgraded my database with Simnple Invoice 2009.1.

There is still problems with the Swedish letters

Gunilla,
SI have 3500 files. The lang.php file is not enough. I changed 45 files till now. For me the problem is only in the xml file. I'm going now to update and see.

Thanks Justin for the update.

By the way, when updating will it be possible to get only the files changed? I'm going to send by FTP all files. So many files...

Cheers,
Jos

Jos

hey gunilla

re swedish
- yep that fille is in our svn trunk - which will become 2009.2
- 2009.1 update 1 was just a minor update of 2009.1 to try and fix a few things

cheers

justin

Hi Justin,

I have now got the Swedish characters to function in the latest version 2009.1 but in this upgrade the products, customers and earlier invoices don´t show up in the program. The program doesn´t reflect the database. That was not the problem in version 2009. When I click on the daschboard I get the following error: Fatal error: Call to a member function bindValue() on a non-object in /home/v/varkstad/www/faktura3/include/sql_queries.php on line 109. When I click on customers the program tells me that there have been no customers created although there ar a lot of customers in the database. The same for invoices and products.

Gunilla

hey gunilla

when you say that no products etc.. show up

does the product page say 'No products listed - click here to add one' or does the 'grid' continually say 'Processing, please wait..' ?

cheers

justin

Hi Justin,

It says 'No products listed - click here to add one'.

Gunilla

That's strange... Now, I don't know if I upgraded correctly.
I uploaded all files from the new release and copy the old config and my lang file.
All is fine... (I'm working from my online server)

Jos

hey jose

there is a new config option in config.ini
- you might be best to just edit the default config.ini that comes with the release

so everything is working ok?

cheers

justin

@gunilla
- i assume in config/config.ini the db is pointing to the correct database
- if its is pointing to the correct db and you have records in the products tables etc.. then you definitely should not get that 'No products listed ..' error
- just might want to check the db config

cheers

justin

Hi Justin,

Yes, I have the right database in config.ini.
I have now done three different upgrades with the same result.
I can detect the products in the reports but not under the heading Products.
I can detect the customers from the new invoice but not under the heading Customers.
There is impossible to view older invoices.
When I want to write a new invoice I have no product list and when I click on New row the page is loading and loading and no new row appears.
When I click on Payments I get the following error message: Fatal error: Call to a member function bindValue() on a non-object in /home/v/varkstad/www/faktura3/include/sql_queries.php on line 109
When I click on the dashborad button I get this error message: Fatal error: Call to a member function bindValue() on a non-object in /home/v/varkstad/www/faktura3/include/sql_queries.php on line 109
There must be something wrong somewhere.

Gunilla

hey justin, looks like the .htaccess file is missing in this release.

Reinstalled complete new version.

All seems good except when adding a user, you can choose what "role" the user is, but it is either blank or Administrator, if you choose the blank role, that user does not show up as a user, but it is shown in the mysql database. You have to use the phpmyadmin to change the role of that user in order to correct it and view it.

I would love to see a customer "role" which would allow them to log in and make a payment towards their account. Do you see this happening anytime in the near future?

Thanks,

hey zacm

roles dont really do much at the moment :)

plan on have customer login etc.. so you can give them access to all their info and they can pay online etc..
- work in progress

cheers

justin

Hi.
Im just setting this up, and discovered that the sorting in the products module don't work as expected. It only sorts ID's asc/desc.

Seems to be an issue in modules/products/xml.php - 48:
$validFields = array('id', 'biller_id','customer_id');

It does not validate the input from manage.js.php and thus falls back to sorting by ID.

Fix:
$validFields = array('id','description','unit_price');

My first install of SI was 20080629. Then, I installed 2009.1 beta 3 and ran it in parallel (same data in each database) with 20080629. I would make the exact same entries twice, once in 20080629 and once in beta3. The upgrade from beta3 to beta4 went smoothly. Well, I upgraded from beta4 to beta5 and then from beta5 to RC1 and then finally to the current 2009.1u1 release. All the database updates appeared to go smoothly and I could start SI smoothly, but now I have lost my ability to produce PDFs (or to do any exports for that matter).

My environment is: WIMP (Windows, IIS, MySQL 5.1.34, PHP 5.2.2)

I checked to make sure that tmp/cache and pdf/fpdf directories were writeable by all.

GD and xsl are installed. GD version 2.0.34.

PHP memory limit is set to 128M and max execution time is 600 seconds

The html2ps/pdf/demo works successfully and renders the google web page as a pdf.

All the documents (pdf, doc, xls) that I try to create through export come up empty. I looked at the invoices and they are not empty.

When I upgrade, I typically copy my existing database to a new name, unzip the latest release into its own directory on the webserver, update its config file to point to the copied database and open SI, which of course takes me to the database update screen. Since beta5, the database update goes smooth, but the document creation, export yields blank screens. Should I be unzipping the latest release over the top of my existing release?

The only other thing that I noticed was when I ran a system config check from the html2ps/pdf/demo, it appears that it complains about some missing fonts. I have Gimp, Ghostscript and Ghostgum installed, but I usually install them in non-traditional locations. It appears from the messages and some of the other config files that the html2ps demo is looking for fonts in c:\gs\fonts. Could it be that I need to redirect where the pdf code pulls its fonts?

Any other clues or things that I can look for is appreciated.

Thanks, Scott

@bape

- thanks for reporting this - will get it fixed
- has been added to our todo list http://code.google.com/p/simpleinvoices/wiki/todo

@scott
- re upgrading - your doing the right thing - create a new folder for each release - don't unzip ontop of the old version
- re PDF
-- you might want to try using the latest WAMP release and the latest Simple Invoices - some people are reporting PDF etc.. is now working OK using this combo
- let us know how you go

cheers

justin