Simple Invoices - Forum

hey techker

re Processing...
have you changes the language to French?
- it so, french version has got issues with the current release - am working on it now
- if not refer the 'how to not display errors on screen' in this page http://simpleinvoices.org/wiki/how_to_display_php_errors_on_screen#how_to_not_display_php_errors_on_screen

re french characters
- is this for your inputted data
- or in the menus etc..

cheers

justin

nice that did the trick.when the french updates is fixed can you notify please?

hey techker

re french
- the problem is some php setting that im not aware of
- basically french works on some systems but not others
-- ok on fedora 11 - not centos5 or ubuntu 9.04 - i think
- stay tuned to the blog for updated

cheers

justin

any updates on this?

please??need to do another install...

I need help with this. I am getting errors, and it just stalls at ..Processing, please wait ..

Notice: Undefined variable: preference in /var/www/html/simpleinvoices/modules/payments/manage.php on line 30
Notice: Undefined variable: customer in /var/www/html/simpleinvoices/modules/payments/manage.php on line 31

Notice: Undefined variable: customers in /var/www/html/simpleinvoices/modules/customers/manage.php on line 21

I get these all over the place, anywhere where it trys to query a list.

I was also getting this, but has gone away?
Fatal error: Call to undefined function iconv_strpos() in /var/www/html/simpleinvoices/library/Zend/Locale/Format.php on line 659

This is the current version from your site, as of yesterday. I have re-created the database several time, and re-installed simple invoice several times.

Any help would be great
thanks

By the way,

Am running
Mandriva 2010.0
Mysql version: 5.1.40
PHP Version 5.3.1RC2


Also, at the bottom of the config file. do I need to make changes there also, or is this something different.

; Staging site configuration data inherits from production and
; overrides values as necessary
[staging : production]
database.params.dbname = simple_invoices_staging
database.params.username = devuser
database.params.password = devsecret

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

The version from 2008 seems to work just fine. Is there a required package thats different from 08 to 09 that I may be missing?

Can anybody help get this working. I have installed just about every PHP module I can think of. As you can see above, I've recreated the database and re-installed different versions of the program. And still end with the same thing. ""Processing, Please Wait""

I have installed PhreeBooks, and it seems to work just fine. But I really don't want something that complex. I would really like to get simpleinvoice running.

hey guys

re errors and processign please wait
- edit config.ini and set as below

debug.error_reporting = 0
phpSettings.display_startup_errors = 0
phpSettings.display_errors = 0


re iconv
- search this forum for iconv
- there is some php modules that provides this - php-iconsv or something similar

cheers

justin

Hi, Thanks for the reply. I didn't seem to change a thing. Here is my config file.

database.adapter = pdo_mysql
database.utf8 = true
database.params.host = localhost
database.params.username = gizmo
database.params.password = XXXXXXXX
database.params.dbname = simpleinvoice
database.params.port = 3306

authentication.enabled = false
authentication.http =

export.spreadsheet = xls
export.wordprocessor = doc
export.pdf.screensize = 800
export.pdf.papersize = A4
export.pdf.leftmargin = 15
export.pdf.rightmargin = 15
export.pdf.topmargin = 15
export.pdf.bottommargin = 15

local.locale = en-gb
local.precision = 2

email.host = localhost
email.smtp_auth = false
email.username =
email.password =
email.smtpport = 25
email.secure =
email.ack = false

version.name = 2009.1 - stable

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


; Staging site configuration data inherits from production and
; overrides values as necessary
[staging : production]
database.params.dbname = simple_invoices_staging
database.params.username = devuser
database.params.password = devsecret

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

Any other ideas?
Thanks

Dont know if this helps. This is from firefox error console


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

Warning: Error in parsing value for 'top'. Declaration dropped.
Source File: http://192.168.1.10/simpleinvoices/library/blackbirdjs/blackbird.css
Line: 17

Warning: Error in parsing value for 'left'. Declaration dropped.
Source File: http://192.168.1.10/simpleinvoices/library/blackbirdjs/blackbird.css
Line: 17

Warning: Unknown property 'zoom'. Declaration dropped.
Source File: http://192.168.1.10/simpleinvoices/include/jquery/cluetip/jquery.cluetip.css
Line: 294

Warning: Error in parsing value for 'filter'. Declaration dropped.
Source File: http://192.168.1.10/simpleinvoices/templates/default/css/jquery-ui/tab.css
Line: 122

Warning: Expected ',' or '{' but found '@media'. Ruleset ignored due to bad selector.
Source File: http://192.168.1.10/simpleinvoices/templates/default/css/jquery-ui/tab.css
Line: 2

Warning: Expected ':' but found ';'. Declaration dropped.
Source File: http://192.168.1.10/simpleinvoices/templates/default/css/jquery-ui/tab-screen.css
Line: 677

Warning: Expected declaration but found '0px'. Skipped to next declaration.
Source File: http://192.168.1.10/simpleinvoices/templates/default/css/jquery-ui/tab-screen.css
Line: 677

your config.ini file looks fine

its possible that PHP main php.ini file is over writing the error_reporting settings in your Simple Invoices config.ini file

search for php.ini on your system and change its error_reporting to E_ERROR or 0

let us know how you go

cheers

justin

It didn't seem to change anything.

This is what I get in the error console from firefox.

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

there is also several .css error, but I don't think those are important, are they?

if you open 192.168.1.10/simpleinvoices/index.php?module=invoices&view=xml in firefox does it print out xml similar to http://simpleinvoices.org/demo/index.php?module=invoices&view=xml ?

I also get this problem, "Processing, please wait"

PHP Notice: Undefined variable: sql_having in public_html/include/class/invoice.php on line 85, referer: http://domain.com
PHP Notice: Undefined variable: sql_having in public_html/include/class/invoice.php on line 197, referer: http://domain.com

There appears to be a typo in line 85 => $query = $_REQEUST['query'];
So I changed it to $query = $_REQUEST['query'];
but now I get:
PHP Notice: Undefined index: query in public_html/include/class/invoice.php on line 85
PHP Notice: Undefined index: qtype inpublic_html/include/class/invoice.php on line 86
PHP Notice: Undefined variable: sql_having in public_html/include/class/invoice.php on line 197
PHP Notice: Undefined index: query in public_html/include/class/invoice.php on line 85
PHP Notice: Undefined index: qtype in public_html/include/class/invoice.php on line 86
PHP Notice: Undefined variable: sql_having in public_html/include/class/invoice.php on line 197

""if you open 192.168.1.10/simpleinvoices/index.php?module=invoices&view=xml in firefox does it print out xml similar to http://simpleinvoices.org/demo/index.php?module=invoices&view=xml ? ""



No, actually I don't. The page comes up blank? Even in source view, there is just nothing. Does this give you any ideas?

Thanks for the help.

Are we going to be able to make this work? Should I just run the 2008 version until we can get 2009 version working?

FYI

On the endless processing, please wait... issue

I was having the same issue and what worked for me was to go over to the send website
http://www.bigwordsaregood.com/ZendFramework-1.9.4-minimal/library/Zend/Locale/Data/
and download the needed locale files into the zend/locale/data folder ones that were needed in my particular case were
en.xml and root.xml

Not sure if this will fix every ones issue but it worked for me.

currently im running
xampp 1.7.2 on portable drive
apache 2.2.12
php 5.2
mysql 5.1.37

thanks ozzie for posting this!

hopefully this can help some others

i'll try an update the version of Zend Framework we use as well

cheers

justin

No joy here, with ozzie's proposal.

Apart from the typo which I mentioned in my previous post, i also get:

[Mon Jan 04 16:53:08 2010] [error] [client 84.48.204.174] PHP Notice: Undefined variable: sql_having in include/class/invoice.php on line 197, referer: http://fqdn.com/index.php?module=invoices&view=manage

For me ozzie's hint doesn't help. Still keep the error Processing, please wait.

I am searching for a billing package, Simple Invoice looks good in the demo but it would be nice if it works at my own server too :)

Hope somebody can give a little help, thanks!

hey guys

you might want to try this: download and install this version of Simple Invoices http://simpleinvoices.googlecode.com/files/simpleinvoices.2010.1.zip and retry

- new version updated with latest Zend Framework and some edits

let us know how you go

note: this is a new release - will announce it soon on the blog etc..

cheers

justin

justin, you are a champ! I Will test this one:)

EDIT: Works perfectly!

thanks jon for the update

cheers

justin

Here still no luck, keeps saying: Processing, please wait.

Removed the 2009.1 completely, made a new DB and still this error :(

hey tha_duck

are you using xammp?

also have you set edit config.ini and set as below the below in your config.ini


debug.error_reporting = 0
phpSettings.display_startup_errors = 0
phpSettings.display_errors = 0

cheers

justin

No go here either. Tried ozzie's idea, didn't work. Updated to 2010 version and created a new database, didn't work either.

Is there a complete list of dependencies anywhere?

I don't know if there is something wrong with my install, or with the program.

hey lfields

anything todo with "Warning: Error in parsing" type issues is related to the php error_reporting level
- which can be set in your main php.ini file(s) for in the Simple Invoices config/config.ini file

re requirements
- a basic list is at http://simpleinvoices.org/requirements

cheers

justin

Hi Justin,

Tried the settings you gave, that fixes the error. But no data is displayed afterwards :( I added an user and a customer and both are not displayed :(

Hope you can help with that!

Btw: I am using IIS6 with PHP5.2.4.

Thanks!

Warm regards,

Tha_Duck

I tried changing the error level settings in both the php.ini, and in the config for simple invoices. Nothing seems to help. I see that error in the firefox error console.

I am currently running simple invoice 2008 while I try to figure this out. Is there a way to do taxed and non taxed items on the same invoice in 2008. Like if I had labor (non taxed), and also parts (taxed) on the same invoice?

Thanks for your help on this, and any more ideas to get me going would be much appreciated.

Thanks
Logan

@logan
- re taxed and non-taxed
-- support for this was added in 2009.1 release

@tha_duck
- the next release 2010.1 update 1 will have a bunch of fixes to try and fix the "Processing, please wait" problems
- should be out within a week or 2

cheers

justin

In the 09.1 release you can do taxed and non taxed inventory items, right?

I make a product (labor, non taxed) and other products (taxed).
Then create an invoice just adding the products from inventory.

That's how I thought it would work anyway.

Anyway, great work, and I can't wait until the next release so I can move up from 08.

Thanks
Logan

re 2009.1
- yep - you can do both taxed and non-taxed - made a wording mistake in my previous post :)

cheers

justin

Hi people,

got a similar problem now:
Just with me it seems related with APC and the Zend Framework
My error being '[apc-error] Cannot redeclare class zend_locale_math in /.../library/Zend/Locale/Format.php on line 293.'

Any of you got any experience with that? Couldn't find any real solutions to that yet

(Using 2010.1 on PHP 5.3.1 with APC 3.1.3p1)

hey shimmy

haven't used apc with simple invoices so can't say to much about that error - sorry :(

anyone else using APC with Simple Invoices ?

cheers

justin

Hi,
New here, just discovered your great soft that I would like to use but...also stuck with french + Processing, please wait ...
Do you have any ideas when the fix will be out ?
Can we help on that ?
Is is a server side bug or a client side bug ?
thanks and regards,
Tony

Hi,

I also have the problem with my install.The system I use is PHP 5.3 with the latest version of SI ...
Any help further?

Hi,

I have an update on the issue:

On my Xampp-server (PHP 5.3) I tried to get SI working, but that didn't work (see previous post). Now I tried it on other hosting with PHP5.2.x and that does work. Can anyone confirm this solution please?

hey koko

this issue is related to your php and apache server setup
- it happens on some servers and not others
- in the next version of Simple Invoices it should be fixed up so this problem doesn't happen

cheers

justin

hello,

In relation to processing, please wait.
I have been dealing with this issue also. After sometime I gave up with my server and uploaded everything to my web host and it worked fine for at least six months. Today it did not work and I got the same message. Then I erased the line (SELECT (coalesce(invoice_total,0) - coalesce(INV_PAID,0))) As owing, from the following query and it works again. However, it is not complete.

$sql ="
SELECT
iv.id,
b.name AS biller,
c.name AS customer,
c.phone AS phone,
(SELECT SUM(coalesce(ii.total, 0)) FROM " .
TB_PREFIX . "invoice_items ii WHERE ii.invoice_id = iv.id) AS invoice_total,
(SELECT SUM(coalesce(ac_amount, 0)) FROM " .
TB_PREFIX . "payment ap WHERE ap.ac_inv_id = iv.id) AS INV_PAID,
(SELECT (coalesce(invoice_total,0) - coalesce(INV_PAID,0))) As owing,
DATE_FORMAT(date,'%Y-%m-%d') AS date,
(SELECT IF((owing = 0), 0, DateDiff(now(), date))) AS Age,
(SELECT (CASE WHEN Age = 0 THEN ''
WHEN Age <= 14 THEN '0-14'<br /> WHEN Age <= 30 THEN '15-30'<br /> WHEN Age <= 60 THEN '31-60'<br /> WHEN Age <= 90 THEN '61-90'<br /> ELSE '90+' END)) AS aging,
iv.type_id As type_id,
pf.pref_description AS preference
FROM " . TB_PREFIX . "invoices iv
LEFT JOIN " . TB_PREFIX . "biller b ON b.id = iv.biller_id
LEFT JOIN " . TB_PREFIX . "customers c ON c.id = iv.customer_id
LEFT JOIN " . TB_PREFIX . "preferences pf ON pf.pref_id = iv.preference_id
$where
GROUP BY
iv.id
HAVING owing > 0
ORDER BY
$sort $dir
$limit";
break;

I think this software is way over my head. To bad, it looked great in the demo

just install php5-iconv

chromeriver.com
Chrome River offers online expense reporting & expense management software to automate your organization's accounts payable operations. Learn More Today!

quote:chromeriver.com
Chrome River offers online expense reporting & expense management software to automate your organization's accounts payable operations. Learn More Today!

ya at what price..simple invoice is free and really good once you get it all configured and installed..