Simple Invoices - Forum

There is three steps to the basic installer, Step 1: Install Database Step 2: Import essentail data Step 3: Import sample data . After step 2, the program reverts back to step 1 again, it does not take you to step three and it does not complete the installation.

The previous sql table was causing my issues, I deleted the old sql table and all worked great.

I get the following errors when I try to email an invoice, the errors go away within 10 seconds and the invoice does get emailed just fine.

Notice: Undefined variable: block_stage2 in /home/content/d/y/b/dybedahl/html/3SH/billing/modules/invoices/email.php on line 41

Notice: Use of undefined constant pref_inv_wording - assumed 'pref_inv_wording' in /home/content/d/y/b/dybedahl/html/3SH/billing/modules/invoices/email.php on line 82

Notice: Undefined variable: block_stage3 in /home/content/d/y/b/dybedahl/html/3SH/billing/modules/invoices/email.php on line 101

The only user that you can add is an admin, it does not allow you to add teh role of a user or a viewer.

Does this program have the ability to allow customers to login and pay their account?

simpleinvoices.2009.1.beta5.zip

Installed on Windows Server 2003, after modifying php.ini include_path to include =".;" SimpleInvoices started right up.

Just can't logout? No logout button in GUI. Tried to use browser to: http://localhost/modules/auth/logout.php but got Fatal error: 'Zend_Session' not found in 'path to\modules\auth\logout.php on line 15

Thanks. Great GUI and web app. Please do keep up the excellent workmanship.

xEightBit

Hey Guys

@Zacm

re email
- yep - know issues - should be resolved

re add user
- different user types - ie. customer login etc.. are still a work-in-progress

@xEightBit
- re logout
- if authentication is enabled in the config/config.ini file then there will be a logout link on the top right of page ie. -> your username | Help | Logout
-- if authentication is not enabled on config.ini there will be no logout or login button up the top as its not required

Cheers

Justin

Tested using a new database, improvements noticed so far include:

new install routine worked flawlessly
special characters now display properly
language selection now works
home -> Dashboard link now works (didn't for me in B4)

and so far no regressions from B4

Adam

thanks for testing adam

can you let me know if special chacters work ok in PDF and in the 'Manage' pages?

cheers

justin

I like the fact I now have the choice between the line invoice input and a total input.. Really nice!
I did notice that exporting is not working anymore. Either PDF, XLS or DOC, the export is gone. Export as PDF the header is there, but just an empty screen and for .doc it is just a 0 bytes file.
Also.. in admin settings choosing your prefered incoive template is empty. I can say I want to edit it and choose the prefered template. It then says it has been saved correctly, but in the overview it is again empty. Perhaps that is why export is having a problem?

That's all I could find for now ;) Great work Justin!

Cheers,
Charly

thanks charly

re export
- yep - most likely caused by the empty invoice template issue
- i'll test this out tonight

question: - was this a new install or did you upgrade from an old install?

cheers

justin

Hi Justin,

This was an upgrade.. Do you want me to create a new install?

Cheers,
Charly

There is an error in IE but not in firefox.

IE says:


Line: 23
Character: 1286
Code: 0
URI: http://www.xxx.com/include/jquery/jquery-1.2.6.min.js

Both IE and Firefox dont able to load the list of "PAYMENTS" but able to load list of "INVOICES"

Got the following error when I tried to do the install (click through to http://192.168.42.8/invoice/index.php?module=install&view=structure):

[Tue Jul 07 15:07:11 2009] [error] [client 81.187.92.23] PHP Warning: fopen(./tmp/log/si.log) [function.fopen]: failed to open stream: Permission denied in /usr/share/simpleinvoices/include/init.php on line 41

The file /usr/share/simpleinvoices/tmp/log/si.log didn't exist before the page was called and afterwards it exists with the following privs:

[root@simpleinvoices ~]# ls -l /usr/share/simpleinvoices/tmp/log/
total 4
-rw-r--r-- 1 apache apache 0 Jul 7 15:33 si.log

So it has permissions to create the file, but not to open it for writing, it would appear.

Any ideas?

Following on...

I hardcoded the absolute path into include/init.php rather than using './tmp/log/si.log' and it now doesn't barf when it creates the file, but Firefox still doesn't display anything...

The last lines of the HTML output are:

not sure what you mean by 'manage' pages, but they display properly on a quick browse of some pages I could find with the special characters; Invoice main page, Quick view, Manage products, Customers and Custom fields. So far it all seems to be displaying properly.

As for PDF... I'm currently unable to test this as my hosting wasn't up to scratch and I'm now in the process of upgrading it to be able to use that nifty feature.

Adam

Hey Justin,

Thanks for this. I'm off to test.

Just a reminder about the 'individual invoice or estimate number for each biller' feature, when you have the time.
http://simpleinvoices.org/forum/discussion/101/

Edit.
Found this. Thanks.
http://simpleinvoices.org/forum/discussion/692/seperate-numbers-for-invoices/#Item_0

George Supreeth

Just tried doing a database backup and restore, from a linux host to a local WampServer host, but it failed.

the backup appeeared to go without a hitch on the linux server, I downloaded the backup file and tried to import it again in phpmyadmin on the wampserver, but it failed with the error:

Fatal error: Maximum execution time of 300 seconds exceeded in C:\wamp\apps\phpmyadmin3.1.3.1\libraries\sqlparser.lib.php on line 477

CPU usage was at 100% during this time, and ultimately nothing was imported into the database. The data isn't a lot, one biller two customers and 8 or 9 invoices; the sql files is only 33kb.

Adam

hey guys

re payments pages
- thanks for spotting this - just an error with how the data is loaded - will fix it up asap

cheers

justin

@vitell

edit config/config.ini

from
debug.error_reporting = 0
to
debug.error_reporting = E_ALL

to post what errors are displayed on screen

cheers

justin

@adam

re special characters
- thanks - yep - just meant on the Invoices, Products, etc.. page that have the grid

re backup
- did you use the Simple Invoices backup or the phpMyAdmin one?

cheers

justin

@charly

re template
- what version where you upgrading from?
- do you have a copy of the database pre upgrade - if so any chance i can review it (pre and post upgrade) so i can find the problem
-- you can strip whatever details you want out of the file

cheers

justin

I can not get past the install database step. The front page shows fine with the correct info for the database. But when I click on install database I get a blank page. I have tried turning on debug but still get nothing. the url is "http://mdpuk2.co.uk/simpleinvoices/index.php?module=install&view=structure".

Any ideas of a way forward.

Mark

Hi,

Changed config.ini to "debug.error_reporting = E_ALL" as requested. There is no output to screen or in the partial HTML that's produced.

However, /var/log/httpd/error.log contains the following:

[Thu Jul 09 14:17:10 2009] [error] [client 81.187.93.22] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';\n\n--\n-- Database: `simple_invoices`\n--\n\n-- ------------------------------------' at line 10' in /usr/share/simpleinvoices-beta/include/class/db.php:103\nStack trace:\n#0 /usr/share/simpleinvoices-beta/include/class/db.php(103): PDO->prepare('-- phpMyAdmin S...')\n#1 /usr/share/simpleinvoices-beta/modules/install/structure.php(14): db->query('-- phpMyAdmin S...')\n#2 /usr/share/simpleinvoices-beta/index.php(314): include_once('/usr/share/simp...')\n#3 {main}\n thrown in /usr/share/simpleinvoices-beta/include/class/db.php on line 103, referer: http://192.168.42.8/sibeta/

The authentication part from config.ini says:

database.params.host = localhost
database.params.username = sibeta
database.params.password = sibeta
database.params.dbname = sibeta

and I can confirm that the user 'sibeta' has full and complete access to the 'sibeta' database.

Does the latest version have any dependencies that the current stable one (which runs well on this fully up to date CentOS 5.3 box)?

Nick.

DELETED

I used the Simple Invoices internal backup. I assumed it would create a file just like the ones previously used to setup the betas through phpmyadmin before the new installation routine. I tried to import the backup file through phpmyadmin.

I cant get installed :S i have in my localserver first i edit config.ini with my db details, then when i point localhost/simpleinvoices/ its appears blank screen :S same here when i try the demo of simpleinvoices i only see blank page Thanks

@mark and nick

can you please download this file http://groups.google.com/group/simpleinvoices/web/no_comments.sql and save it over the file in ./databases/MySQL/1-Structure.sql in your Simple Invoices directory

i've removed the sql comments in this file - it may help with your install - as some mysql setups don't like comments in sql

please try and let me know how you go

also - please delete any tables in your Simple Invoices database first

@alexistkd
- thanks for pointing out the problem with the demo install - will fix up now
- re your install - edit config/config.ini and set the debug.error_reportin to E_ALL
-- refer http://simpleinvoices.org/forum/discussion/822/simple-invoices-20091-beta-5-released/#Item_21
- please test and let me know how you go

cheers

justin

@adam
-re backup
- on the linux server try using phpMyAdmin and then import into phpMyadmin on windows host and let me know if this works
- see if its a simple invoices backup problem or windows host problem

cheers

justin

Thanks justin so this are the steps to follow i have xampp for my webserver:

extract simpleinvoices in root dir next go to /config/config.ini and change to E_ALL then i have to test if it works?

no luck justin, i get blank screen i erase folder and then re extracted simpleinvoice to folder named facturacion i mean i change simplevoices for *facturacion* and the name of my db its facturacion too i change to E_ALL the point http://localhost/facturacion and i get blank screen

@alexistkd
- check that the ./tmp/cache and ./tmp/log/si.log directories and files are writeable
- the installerd checks this and it works in unix - not sure how it goes in windows

please try this and let me know how you go

cheers

justin

only unix? im using xammp windows i already checks logs, si.log its empty.

woh maybe we need to ensure to make work this great application in windows too.

@alexistkd

re windows
- it should work fine i windows - i used to run it on xampplite a while ago on one of my PCs
- just need to check if those files/folders are writeable

have you changed config/config.ini debig.error_reporting to E_ALL ?

cheers

justin

Yeah of course i changed to E_ALL that folders are writable i dont see nothing strange im administrator.

i just double check folders both are good writeable

database.adapter = pdo_mysql
database.params.host = localhost
database.params.username = root
database.params.password = 1357920
database.params.dbname = facturacion
database.params.port = 3306

database.params.dbname = simple_invoices_dev
debug.error_reporting = E_ALL
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1

debug.level = All
debug.error_reporting = E_ALL
phpSettings.date.timezone = UTC

i see something i set
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1

and then in localhost/facturacion i see:

Fatal error: Call to undefined method DB::getinstance() in D:\tkd\alexis\webdesign\webserver\xampp\htdocs\facturacion\include\init.php on line 106

i just added:

**include_once("./include/class/db.php");***
$db = db::getInstance();

in \include\init.php

now it works i see installer page.

justin wheres the fix for: I've just migrated from the 200805 stable version to beta 5. The database is upgraded but after clicking on Money > Payments I get a permanent Processing ... Please wait message. Payments page stuck in a loop

where is it?

Thanks

@alexistkd

thanks for spotting this

zend framework should auto-add the db.php class file - thats way there is no include for in

but as it causes this problem i'll adjust init.php to include it

let me know if the installer and the rest of Simple Invoices works ok now

cheers

justin

np bro im checking deeply this great application its just awesome i have to tell you :) the best for invoices

its works perfect only the error of Processing ... Please wait.

re processing please wait
- edit config/config.ini and change error_reporting and display_errors back to 0 and it might fix it up
- if that doesnt fix it - let me know which page is it on

cheers

justin

Strange i have it work for a while but now its Processing in all pages thats works with that :S , please wait again here my conf:

debug.level = All
debug.error_reporting = E_ALL
phpSettings.date.timezone = UTC
phpSettings.display_startup_errors = 0
phpSettings.display_errors = 0

[dev : production]
database.params.dbname = simple_invoices_dev
debug.error_reporting = E_ALL
phpSettings.display_startup_errors = 0
phpSettings.display_errors = 0

------------------------------------------------------------------------------------------------------
i see an error in generating .pdf invoice look:

http://localhost/facturacion/index.php?module=export&view=invoice&id=1&format=pdf

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 197940 bytes) in D:\tkd\alexis\webdesign\webserver\xampp\htdocs\facturacion\library\pdf\pdf.fpdf.php on line 2722

I know its memory limit in php.ini right? but i have 32M putting 64M i think its too much dont you?

change debug.error_reporting = E_ALL to debug.error_reporting = E_ERROR

unfortunately PDF does need 64M - its pretty crazy but it should work

cheers

justin

same error, i just restart xammp apache mysql for test. but same Processing, please wait ...

Edit: i fixed it i reinstalled everything putting 0 on error. reporting.