Simple Invoices logo
    • CommentAuthortechker
    • CommentTimeOct 16th 2009
     permalink
    hey guys i hade the older version of simple invoice and my server was recently attacked so i lost all of the index pages..any ways.so i downloaded the newer version and had my hosting companie install the PDO.that is done but in invoices i always get a Processing, please wait .....

    and it does not show the french caracters..??

    buy the way i did not tuch the database.it upgraded the version only.
    • CommentAuthorjustin
    • CommentTimeOct 16th 2009
     permalink
    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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthortechker
    • CommentTimeOct 26th 2009
     permalink
    nice that did the trick.when the french updates is fixed can you notify please?
    • CommentAuthorjustin
    • CommentTimeOct 27th 2009
     permalink
    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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthortechker
    • CommentTimeDec 13th 2009
     permalink
    any updates on this?
    • CommentAuthortechker
    • CommentTimeDec 13th 2009
     permalink
    please??need to do another install...
    • CommentAuthorlfields
    • CommentTimeDec 14th 2009 edited
     permalink
    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
    • CommentAuthorlfields
    • CommentTimeDec 14th 2009 edited
     permalink
    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
    • CommentAuthorlfields
    • CommentTimeDec 14th 2009
     permalink
    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?
    • CommentAuthorlfields
    • CommentTimeDec 15th 2009
     permalink
    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.
    • CommentAuthorjustin
    • CommentTimeDec 16th 2009
     permalink
    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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorlfields
    • CommentTimeDec 16th 2009
     permalink
    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
    • CommentAuthorlfields
    • CommentTimeDec 16th 2009
     permalink
    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
    • CommentAuthorjustin
    • CommentTimeDec 17th 2009
     permalink
    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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorlfields
    • CommentTimeDec 17th 2009
     permalink
    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?
    • CommentAuthorjustin
    • CommentTimeDec 17th 2009
     permalink
    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 ?SmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorjonkristian
    • CommentTimeDec 17th 2009 edited
     permalink
    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
    • CommentAuthorlfields
    • CommentTimeDec 18th 2009 edited
     permalink
    ""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.
    • CommentAuthorlfields
    • CommentTimeDec 19th 2009
     permalink
    Are we going to be able to make this work? Should I just run the 2008 version until we can get 2009 version working?
    • CommentAuthorozzie
    • CommentTimeDec 22nd 2009
     permalink
    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
    • CommentAuthorjustin
    • CommentTimeDec 24th 2009
     permalink
    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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorjonkristian
    • CommentTimeJan 4th 2010 edited
     permalink
    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
    • CommentAuthorTha_Duck
    • CommentTimeJan 4th 2010
     permalink
    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!
    • CommentAuthorjustin
    • CommentTimeJan 5th 2010 edited
     permalink
    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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorjonkristian
    • CommentTimeJan 5th 2010 edited
     permalink
    justin, you are a champ! I Will test this one:)

    EDIT: Works perfectly!
    • CommentAuthorjustin
    • CommentTimeJan 5th 2010
     permalink
    thanks jon for the update

    cheers

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorTha_Duck
    • CommentTimeJan 7th 2010
     permalink
    Here still no luck, keeps saying: Processing, please wait.

    Removed the 2009.1 completely, made a new DB and still this error :(
    • CommentAuthorjustin
    • CommentTimeJan 7th 2010
     permalink
    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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorlfields
    • CommentTimeJan 7th 2010
     permalink
    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.
    • CommentAuthorjustin
    • CommentTimeJan 7th 2010
     permalink
    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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorTha_Duck
    • CommentTimeJan 10th 2010
     permalink
    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
    • CommentAuthorlfields
    • CommentTimeJan 11th 2010
     permalink
    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
    • CommentAuthorjustin
    • CommentTimeJan 11th 2010 edited
     permalink
    @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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorlfields
    • CommentTimeJan 11th 2010
     permalink
    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
    • CommentAuthorjustin
    • CommentTimeJan 12th 2010
     permalink
    re 2009.1
    - yep - you can do both taxed and non-taxed - made a wording mistake in my previous post :)

    cheers

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorShimmy
    • CommentTimeJan 13th 2010 edited
     permalink
    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)
    • CommentAuthorjustin
    • CommentTimeJan 14th 2010
     permalink
    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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthortony77_7
    • CommentTimeJan 15th 2010
     permalink
    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,
    TonyThanks,
    • CommentAuthorkoko
    • CommentTimeJan 29th 2010
     permalink
    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?
    • CommentAuthorkoko
    • CommentTimeFeb 4th 2010
     permalink
    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?
    • CommentAuthorjustin
    • CommentTimeFeb 5th 2010
     permalink
    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

    justinSmarterInvoices.com Simple Invoices hosting | SixHQ.com Simple Invoices custom development | Me
    • CommentAuthorosvaldo
    • CommentTimeMar 2nd 2010
     permalink
    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'
    WHEN Age <= 30 THEN '15-30'
    WHEN Age <= 60 THEN '31-60'
    WHEN Age <= 90 THEN '61-90'
    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;