Simple Invoices - Forum

fyi

the demo site http://simpleinvoices.org/demo/ has been updated to beta 1

feel free to try it out

cheers

justin

I can't get this beta version to run. I've installed it on a local WAMP server, but I keep getting:

"Fatal error: Uncaught exception 'PDOException' with message 'could not find driver ' in c:\wamp\www\simpleinvoices\include\sql_queries.php:27 ...."

Nullig

Hey Nullig,

1 - make suer the db connection details are correct in ./config/config.ini
2 - open phpinfo.php in your browser and check that WAMP has PDO_MYSQL driver enabled
-- you may need to enable the the various PDO db drivers in WAMP

let us know how you go

Cheers

Justin

That did the trick.

Thanks,
Nullig

Good to hear its now working

let me know if you have any more issues with the beta release

Cheers

Justin

Just a heads up for anyone using php 5.3 alpha1.

You're going to have to fix any magic methods (__get, __set, etc.) that are protected. Change the "protected" to "public". You'll know which ones when you try to run Simple Invoices.

Also, there are a lot of deprecated warnings that you'll see if you try to create a PDF file of an invoice. Not sure where, but somewhere along the way the PDF generator changes/sets some php ini settings 'ini_set()'. My temporary fix to get the PDF's to generate was to disable the ini_set() method in my php.ini - disable_functions = ini_set

Ryan

Hello Justin,
I'd really like to use the new version, is there any way to keep the old database?
Basically i just need to do an upgrade keeping the old data stored.

Thanks

Hey Dariovine,

just edit config/config.ini and point to to your existing database

when you open simple invoices next it will ask you to run an upgrade - just click Upgrade and it'll do all the work

note: back a backup of your database first

let us know how you go

Cheers

Justin

Thanks Ryan for that details

re pdf
- the html2pdf people tufat.com will hopefully release a php 5.3 version of html2pdf with all of these changes

Cheers

Justin

hi Justin

I am getting the following error on my system

Fatal error: Cannot redeclare class Zend_Loader in /usr/local/lib/php/Zend/Loader.php on line 31

Regards
Yusuf

Hey Yusuf

does your host have php 5.2 ?

check ./phpinfo.php - it'll tell you want version you have

let us know how you go

Cheers

Justin

I am getting this error:

"Fatal error: Class 'PDO' not found in /home/xxx/public_html/simpleinvoice/include/sql_queries.php on line 25"

Whats the solution?

Hi Justin

The PHP version my host have is PHP Version 5.2.6.

There is php 4 also installed on the server but I use a .htaccess file to use php5

Regards
Yusuf

Hi Justin

Here is the udrl for phpinfo

http://www.lenzinfo.org.za/simpleinvoices/phpinfo.php

drop the phpinfo.php and you will see the error I am getting

Regards
Yusuf

Hello is there anyone can help plz?

I am getting this error:

"Fatal error: Class 'PDO' not found in /home/xxx/public_html/simpleinvoice/include/sql_queries.php on line 25"

Whats the solution?

hey don

looks like you need php5.2 and to make sure you have the pdo extension enabled in php

http://simpleinvoices.org/demo/phpinfo.php is an example of a php setup with all the stuff you'll need
- note PDO and its available drivers

let us know how you go

cheers

justin

Hi Guys

Any news regarding my error see my post above

Regards
Yusuf

hey yusuf,

im not really sure

- you've got the required php level

only things i could find re google are

- http://www.zend.com/support/knowledgebase.php?kbid=81&view_only=1
- http://www.nabble.com/Cannot-redeclare-class-Zend_Loader--%3E-Zend-View-Helper-Partial-td18710136.html

but don't think they are a help to you

let us know if you can find anythign else out

anyone else got this error?

cheers

justin

Hi!

Finally found some free time to test latest beta with Postgres...

Some problems:

Dude, what happened to your query?:

SHOW TABLES LIKE 'si_sql_patchmanager'
ERROR: syntax error at or near "LIKE" LINE 1: SHOW TABLES LIKE 'si_sql_patchmanager' ^Dude, what happened to your query?:

CREATE TABLE si_sql_patchmanager (sql_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,sql_patch_ref VARCHAR( 50 ) NOT NULL ,sql_patch VARCHAR( 255 ) NOT NULL ,sql_release VARCHAR( 25 ) NOT NULL ,sql_statement TEXT NOT NULL) TYPE = MYISAM
ERROR: syntax error at or near "AUTO_INCREMENT" LINE 1: ...TE TABLE si_sql_patchmanager (sql_id INT NOT NULL AUTO_INCRE... ^Step 2 - The SQL patch table has been created
Dude, what happened to your query?:

INSERT INTO si_sql_patchmanager ( sql_id ,sql_patch_ref , sql_patch , sql_release , sql_statement ) VALUES ('','1','Create si_sql_patchmanger table','20060514', :patch)
ERROR: invalid input syntax for integer: ""Step 3 - The SQL patch has been inserted into the SQL patch table


Any hint?


Sincerely,
Gour

I rebuilt the Apache for PDO which i miss, and now it is working perfectly.

Now waiting for stable version

Tnx

@don: you're using MySQL?


Sincerely,
Gour

@gour re pgsql
- thanks - i'll try and reset the postgres version again on my machine and give it a review
- most liekly the info in the postgres .sql is not as up to date as required

@done
- thanks for the update

cheers

justin

@justin: thank you.we're awaiting a new beta ;)


Sincerely,
Gour

@don: you're using MySQL?


Yes

Hi Justin,
i copied the folder and set up config.ini as i was using your previous version.
when i try to access to the main page it appears as blank...
i tried to enable and disable the authentification but still the same
any ideas?

hey dario

hmm - im not really sure

what version of Simple Invoices were you previously using?

also detail your server setup
- ie OS, PHP version etc..

cheers

justin

Justin,
the version i have istalled and working is Version: 20080629 and is reachable at www.planetcomputer.com.au/invoice
The new beta version that doesnt work is reachable at www.planetcomputer.com.au/simpleinvoices

i was thinking it might be someting wrong with the config.ini since i've edited in notepad and is really messy.
I will give it a try to edit it with dreamweaver.

About the php versione i guess is 5 or something and webserver is running on apache.
Regards
Dario

hey dario

i checked your php version and it all looks OK

if there is a problem with config.ini it should at least display some error

no idea why its just blank ???

try editing config.ini again and let us know how you go

cheers

justin

I'm trying to delete the folder and to the upload it again, also i've created a new DB to test the new version
Thanks for your help, i will let u know

no worries - will be interesting to see what the problem actually is

cheers

justin

Ok, maybe there is something wrong in what i do in config.ini
I've uploaded the folder again and still the same...blank page.
I edited just:
-database.params.username
-database.params.password
-database.params.dbname

If it can help i've tried to reach the page with the default config.ini file and i got the blank page, so i've edited it with my DB details and uploaded it again but still blank page.
this is really strange because the old version works really well
What can i try next? O_O

hey dario

im running out of ideas

only time ive seen this before (not in Simple Invoices though) is when the webserver didnt like the permissions on the files

ie - they were 777 and it wanted 644 or something
- refer: http://www.zzee.com/solutions/unix-permissions.shtml#numeric

try changinh index.php to 644 and see what happens

cheers

justin

Justin,

For those of us who have customized templates, are there any changes to the templates for things like the invoices?

George

Have downloaded the Beta, and my invoice template seems to work.

1 Issue.
when I create an invoice the prices for my products do not show up, unless I enter them on the invoice individually.

I copied my "production database" (export, import) and upgraded.

When I display my products the prices are there.

This is different from the demo.

P.S. Like the update.

George

Hey George

question:
when your in the new invoice screen and you select a product - does the red loading text display on the top right of the page as it does when your on
http://simpleinvoices.org/demo/index.php?module=invoices&view=itemised

to debug this issue what you'll need to do is install the firebug extension for firefox
- then when in the new invoice page press f12 in firefox to enable firebug - then click all the Console, Script and Net options
- then select a product and watch the Console tab to see if it displays any errors

let me know how you go

Cheers

Justin

Justin,

The loading "thingy" pop's up, no errors on firebug console.

in firebug have you click the Console option and are you watching the console tab and the loading thingy is going?

hmm. can't think exactly why this wouldn't work on you system - that product price thing is a simple jquery script that should just work

Cheers

Justin

Hi!

Any ETA about new beta with (hopefully) better support for Postgres?


Sincerely,
Gour

Hey Gour,

maybe a week or so - haven't had a chance to look at the postgres issue yet

Cheers

Justin

Sorry for the delay in getting back.

Just so I am clear. It works fine on a new database. When I convert/ update my "production database" I am having the problem.

Thanks GeorgeR,

one other quick question - what version are you upgrading from?

Cheers

Justin

Hi Justin,

Well after reading the whole day I see that you are probably the maintainer of this program. Firstly I must say that I take my hat off to you for the huge effort you have put into this program. I have played with the demo versions via the web and it looks great. I am a MAC user and have been searching for some kind of invoicing solution, from Quickbooks Pro to excell sheets and this looks like the one that rocks!!

I have a similar problem to * dariovine where I am just getting a blank screen. I am also using the version 20080926.

@dariovine: did you ever resolve your problem ?

@justin: any suggestions ? What other information would you need from me in order to debug this. (Once done, I will be more than happy to update the installation instructions on wiki)

Kind Regards,

Mike

hey mike

from your other post i assume you fixed the blank page issue - what did you do to resolve this?

cheers

justin

During writing out this report it worked, please see my notes below for full explanation.

Hey Justin,

Unfortunetly I did not resolve this issue, what I did was install the older version of simpleinvoices. The problem is I really need the new version as it gives the ability to have different prices for same products/services.
I am still unable to get the new version working.

I will try and document what I have done and what I was unable to do:

1. Unpacked the zip in the /MAMP/htdocs/ directory
2. Was unable to chown apache:apache cache:
[/Applications/MAMP/htdocs/simpleinvoices]
sudo chown apache:apache cache
Password:
chown: apache: Invalid argument
I looked through my /etc/passwd file and the only thing I could find related to the web server was this
_www:*:70:70:World Wide Web Server:/Library/WebServer:/usr/bin/false.
Instead used the shortcut as described later on in the doc chmod -Rv 777 cache*
0 drwxrwxrwx@ 2 mike staff 68 Sep 26 22:27 cache

3. Created database simple_invoices using phpMyAdmin.
4. Imported the database from /simpleinvoices/databases/MySQL (note this is different directory from document notes) and used SimpleInvoices-MySQL5_0.sql (also different from documentation).
Note: Using phpMyAdmin - 2.11.7.1 the user will need to click on the simple_invoice database and go to the SQL tab and from there locate the file and import it from there.
5. Updated the config.ini file in /simpleinvoices/config/ directory (different from documentation with regards to file name and value names that need to be changed).

WOW - It worked. I started playing with the config.ini file and watching tail -f /logs/php_error.log and saw the following:
[22-Jan-2009 10:41:02] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO)' in /Applications/MAMP/htdocs/simpleinvoices/include/sql_queries.php:27
Stack trace:
#0 /Applications/MAMP/htdocs/simpleinvoices/include/sql_queries.php(27): PDO->__construct('mysql:host=loca...', 'root', '')
#1 /Applications/MAMP/htdocs/simpleinvoices/include/sql_queries.php(8): db_connector()
#2 /Applications/MAMP/htdocs/simpleinvoices/include/init.php(70): include_once('/Applications/M...')
#3 /Applications/MAMP/htdocs/simpleinvoices/index.php(22): require_once('/Applications/M...')
#4 {main}
thrown in /Applications/MAMP/htdocs/simpleinvoices/include/sql_queries.php on line 27

So tried to change the password of root to YES in config.ini and got this:

[22-Jan-2009 10:45:22] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)' in /Applications/MAMP/htdocs/simpleinvoices/include/sql_queries.php:27
Stack trace:
#0 /Applications/MAMP/htdocs/simpleinvoices/include/sql_queries.php(27): PDO->__construct('mysql:host=loca...', 'root', '1')
#1 /Applications/MAMP/htdocs/simpleinvoices/include/sql_queries.php(8): db_connector()
#2 /Applications/MAMP/htdocs/simpleinvoices/include/init.php(70): include_once('/Applications/M...')
#3 /Applications/MAMP/htdocs/simpleinvoices/index.php(22): require_once('/Applications/M...')
#4 {main}
thrown in /Applications/MAMP/htdocs/simpleinvoices/include/sql_queries.php on line 27

Then went back to phpMyadmin and created a user test with password test - and it worked!!!

So it seems it was my bad initially when defining the config.ini file.

hey mike

thats for all that info - great to hear it all worked with a new db user

cheers

justin