Problems with the Invoices module

[mattg]

I installed the Invoices module (0.3), but I cannot find any way to calle the addedit script, meaning that while dp knows it's there, I don't seem to have any to invoke it. Any suggestions?

[pedroa]

See the projects module, when you select a project to view, it will show an extra tab "Invoices", there you can make a new invoice...

Pedro A.

[mattg]

Well, therin lies the rub, so they say. When I view a Project, it doesn't have an "Invoices" tab (I figured that was where it was supposed to be). I have the module installed turned on and visible. I also have two error messages on the view a project:

Notice: Undefined offset: 4 in F:\public_html\dotproject\classes\ui.class.php on line 295

and

Notice: Undefined offset: 0 in F:\public_html\dotproject\modules\projects\view.ph p on line 123

Are these related to the problem?

[pedroa]

Remove debugging options for those notices to go away...

Don't know if they are related but it seems that something is breaking the extras tab loader.

Pedro A.

[cyberhorse]

The extra tab loader update tabs only when you login, so for new tabs to show up, you have to logout and login again. Let us know if that fixes your problem.

[caseydk]

The Invoice module is a bit odd in how you create new invoices...

One most of the other modules that I've found, you can click on the top menu option and create a new one (project, companies, files, contacts), but the invoices module does not work this way. You have to click on the project, click on the tab, then hit "New Invoice".

Not complaining... just noting it.

[mheidt]

The invoice module doesn'twork at all in my case.
PHP-Errors when creating new invoice and when whatching at the invoice-tab as well.
But I will have a look into the code and report what I found

[mheidt]

1. Fatal errors occur, when you don't have a billingcode set.
In my opinion, this should be handled.

2. The generation of the documents doesn't work

3. If the task's amount is set to 0, fatal errors occor when inserting tasks to an invoice.

As most of the tasks shouldn't mention money, I needed to change the code to something like ($var + 0.0) instead of $var.

Beside those errors there are 3 reasons, why I deinstalled the invoice module
a) The task/parenttask relation is not displayed.
b) You cannot change the description.
c) A task doesn't show, if it is mapped to an invoice.

Therefore I inserted 3 customized fields in the tasks (InvoiceID, date, paymentdate)

[dmaodo]

Can somebody help me for the invoice module when i click on the invoice id i see on the screen theses warnings ?
Warning: Invalid argument supplied for foreach() in c:\program files\easyphp1-8\www\dotproject\modules\invoice\view.php on line 78
Warning: Invalid argument supplied for foreach() in c:\program files\easyphp1-8\www\dotproject\modules\invoice\view.php on line 224
Warning: Invalid argument supplied for foreach() in c:\program files\easyphp1-8\www\dotproject\modules\invoice\view.php on line 241.
What is the issue of it ?

[pedroa]

Seems like you don't have any billing code so you can't invoice.
System Admin., Billing codes

Pedro A.

[dmaodo]

I have put the billing code in sys admin but the error is generated by the following lines:

ERROR: c:\program files\easyphp1-8\www\dotproject\classes\query.class.php(590): query failed(SELECT
billingcode_id,
billingcode_name,
billingcode_value,
billingcode_desc FROM `billingcode` WHERE company_id = ) - error was: Erreur de syntaxe pr賠de '' ࠬa ligne 5
Backtrace:
0 c:\program files\easyphp1-8\www\dotproject\classes\query.class.php:590 dprint('c:\\program files\\easyphp1-8\\www\\dotproject\\classes\\query.class.php',590, 0,'query failed(SELECT
billingcode_id,
billingcode_name,
billingcode_value,
billingcode_desc FROM `billingcode` WHERE company_id = ) - error was: Erreur de syntaxe pr賠de \'\' ࠬa ligne 5')
1 c:\program files\easyphp1-8\www\dotproject\modules\invoice\view.php:70 exec()
2 c:\program files\easyphp1-8\www\dotproject\index.php:324 require('c:\\program files\\easyphp1-8\\www\\dotproject\\modules\\invoice\\view.php')
ERROR: c:\program files\easyphp1-8\www\dotproject\includes\db_adodb.php(84): Invalid object passed to db_num_rows
Backtrace:
0 c:\program files\easyphp1-8\www\dotproject\includes\db_adodb.php:84 dprint('c:\\program files\\easyphp1-8\\www\\dotproject\\includes\\db_adodb.php',84,0,' Invalid object passed to db_num_rows')
1 c:\program files\easyphp1-8\www\dotproject\modules\invoice\view.php:71 db_num_rows(false)
2 c:\program files\easyphp1-8\www\dotproject\index.php:324 require('c:\\program files\\easyphp1-8\\www\\dotproject\\modules\\invoice\\view.php')

Fatal error: Call to a member function on a non-object in c:\program files\easyphp1-8\www\dotproject\includes\db_adodb.php on line 85

[pedroa]

No company_id ???

Pedro A.

[gwp-1]

Ok, on the INVOICES PENDING tab I get the following:

ERROR: /home/.eeney/johnalan/johnalan.org/dotproject/includes/db_adodb.php(61): Error executing: SELECT
user_first_name,
user_last_name
FROM users
WHERE user_id=2

Backtrace:
0 /home/.eeney/johnalan/johnalan.org/dotproject/includes/db_adodb.php:61 dprint('/home/.eeney/johnalan/johnalan.org/dotproject/includes/db_adodb.php',61,0,'Error executing: SELECT
user_first_name,
user_last_name
FROM users
WHERE user_id=2
')
1 /home/.eeney/johnalan/johnalan.org/dotproject/includes/db_connect.php:131 db_exec('
SELECT
user_first_name,
user_last_name
FROM users
WHERE user_id=2
')
2 /home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/vw_inc.php:50 db_loadlist('
SELECT
user_first_name,
user_last_name
FROM users
WHERE user_id=2
')
3 /home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/vw_pend.php:4 invoices(1)
4 /home/.eeney/johnalan/johnalan.org/dotproject/style/default/overrides.php:83 require('/home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/vw_pend.php')
5 /home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/index.php:47 show()
6 /home/.eeney/johnalan/johnalan.org/dotproject/index.php:324 require('/home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/index.php')


At the bottom of the screen as an error descriptor I have:

Unknown column 'user_first_name' in 'field list'

[pedroa]

Aren't you using an old version, because this user_first_name is from dP 1 in dP 2 this should be contact_first_name.

Pedro A.

[gwp-1]

Where can I check to double-check the version? I'm pretty sure I downloaded the most recent version this past Saturday...

Addendum to above:

I just went back into my system at home where I downloaded the zip file. It IS v2.0.1 according to the file name.

Again, just to be doubly sure... is there somewhere in the software I can pull a version code to be sure?

[pedroa]

http://sourceforge.net/project/showfiles.php?group_id=70930&package_id=117225

Pedro A.

[gwp-1]

Yep, exactly what I had. But just to be sure, I uninstalled it, deleted the folder INVOICE in MODULES and re-extracted, uploaded, installed the most recent version of invoice.

Now I'm getting invoice #1 on the INVOICE OPEN list (even though I haven't done any invoices since deleting the module and reinstalling it -- I'm assuming it's pullling data from the db) but if I go to edit that invoice in comes up with a "create invoice" screen. Trying to create the invoice gives me:

ERROR: /home/.eeney/johnalan/johnalan.org/dotproject/classes/query.class.php(590): query failed(INSERT INTO `invoice_task_queue`(`task_invoice`,`task_amount`, `task_log_id`) values (1,,2)) - error was: 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 '2)' at line 1
Backtrace:
0 /home/.eeney/johnalan/johnalan.org/dotproject/classes/query.class.php:590 dprint('/home/.eeney/johnalan/johnalan.org/dotproject/classes/query.class.php',590,0,'query failed(INSERT INTO `invoice_task_queue`(`task_invoice`,`task_amount`, `task_log_id`) values (1,,2)) - error was: 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 \'2)\' at line 1')
1 /home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/invoice.class.php:44 exec()
2 /home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/do_invoice_aed.php:37 store()
3 /home/.eeney/johnalan/johnalan.org/dotproject/index.php:272 require('/home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/do_invoice_aed.php')
ERROR: /home/.eeney/johnalan/johnalan.org/dotproject/classes/query.class.php(590): query failed(INSERT INTO `invoice_task_queue`(`task_invoice`,`task_amount`, `task_log_id`) values (1,,3)) - error was: 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 '3)' at line 1
Backtrace:
0 /home/.eeney/johnalan/johnalan.org/dotproject/classes/query.class.php:590 dprint('/home/.eeney/johnalan/johnalan.org/dotproject/classes/query.class.php',590,0,'query failed(INSERT INTO `invoice_task_queue`(`task_invoice`,`task_amount`, `task_log_id`) values (1,,3)) - error was: 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 \'3)\' at line 1')
1 /home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/invoice.class.php:44 exec()
2 /home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/do_invoice_aed.php:37 store()
3 /home/.eeney/johnalan/johnalan.org/dotproject/index.php:272 require('/home/.eeney/johnalan/johnalan.org/dotproject/modules/invoice/do_invoice_aed.php')

Warning: Cannot modify header information - headers already sent by (output started at /home/.eeney/johnalan/johnalan.org/dotproject/includes/main_functions.php:532) in /home/.eeney/johnalan/johnalan.org/dotproject/classes/ui.class.php on line 515

[pedroa]

The problem seems to be that the invoice does not have an amount.

I really don't use this module, I tryed it and I am not intending to use it the way it is behaving, but I don't really have the time to revamp it.

Cyberhorse made this module and you should search the forums for invoice and keep chating in those threads...

Sorry but I can't help you much more on this one...

Pedro A.

[gwp-1]

Thanks Pedro! Hey, you solved my LINKS issue... I'm grateful.

[cyberhorse]

make sure you have cost codes assigned for your tasklogs and also costcodes defined in the system administration.