Ticket #3513 (closed Bugs: fixed)

Opened 4 years ago

Last modified 4 years ago

Uncaught DB::Error in cdr-log.php

Reported by: Nick_Lewis Assigned to:
Priority: minor Milestone: 2.6
Component: Reports Version: 2.5-branch
Keywords: Cc:
Confirmation: Unreviewed Distro:
Backend Engine: All Distro Ver:
Backend Ver: SVN Revision (if applicable):

Description

$res = $DBHandle -> query($QUERY); $num = $res -> numRows();

should be

$res = $DBHandle -> query($QUERY); if(DB::isError($res)){die($res->getDebugInfo());} $num = $res -> numRows();

Attachments

call-log.php.patch (362 bytes) - added by Nick_Lewis on 02/05/09 04:06:15.

Change History

02/04/09 12:03:34 changed by Nick_Lewis

After making this change one can see a more meaningful message. In my case it was:

[nativecode=1146 ** Table 'asteriskcdrdb.cdr' doesn't exist]

This is on a clean install so I may have missed an installation step

02/04/09 12:26:28 changed by Nick_Lewis

During installation I built the cdr database ok but forgot the table.

mysql -p asteriskcdrdb < SQL/cdr_mysql_table.sql

Note that this bug is similar to #2829 which was noticed by jonnywifi when the cdr database was not built

mysqladmin -p create asteriskcdrdb

02/04/09 12:59:52 changed by mbrevda

Nick, thanks for debugging this. Please attache a patch in .diff format. Thanks

02/05/09 04:06:15 changed by Nick_Lewis

  • attachment call-log.php.patch added.

02/05/09 04:10:04 changed by Nick_Lewis

Please find patch attached

05/02/09 16:19:12 changed by p_lindheimer

  • status changed from new to closed.
  • resolution set to fixed.

(In [7628]) fixes #3513 check/report db error

05/06/09 14:34:40 changed by p_lindheimer

(In [7646]) Merged revisions 7352-7407,7409-7460,7462-7481,7483-7519,7521,7524-7529,7531-7543,7545-7551,7553-7590,7596,7598-7637,7639,7641-7645 via svnmerge from http://svn.freepbx.org/freepbx/branches/2.5

........

r7410 | mickecarlsson | 2009-01-07 10:02:26 -0800 (Wed, 07 Jan 2009) | 1 line

re #3463, updated the amp.pot file and Swedish language

........

r7420 | mickecarlsson | 2009-01-27 10:01:03 -0800 (Tue, 27 Jan 2009) | 1 line

Closes #3484 updated spanish language for core (and modules)

........

r7423 | mickecarlsson | 2009-01-27 10:24:35 -0800 (Tue, 27 Jan 2009) | 1 line

Closes #3438 updated amp.po file for french language

........

r7441 | mickecarlsson | 2009-02-01 10:46:43 -0800 (Sun, 01 Feb 2009) | 1 line

Closes #3503 adds chinese language to core

........

r7460 | mickecarlsson | 2009-02-16 12:35:51 -0800 (Mon, 16 Feb 2009) | 1 line

Closes #3539 updates Bulgarian language to core and ari. Thank you chocho

........

r7551 | mickecarlsson | 2009-03-26 04:36:44 -0700 (Thu, 26 Mar 2009) | 1 line

Closes #3596, adds Danish language to Ari. Thank you danielz

........

r7572 | mickecarlsson | 2009-04-06 11:20:22 -0700 (Mon, 06 Apr 2009) | 1 line

Closes #3616 adds Portuguese (Brasil) language to amp. Thank you Flavio E. Goncalves. Please feel free to do the Brazilian translations fro FreePBX

........

r7614 | p_lindheimer | 2009-05-02 10:35:40 -0700 (Sat, 02 May 2009) | 1 line

fixes #3449 path is relative to admin and not admin/views directory

........

r7616 | p_lindheimer | 2009-05-02 10:44:53 -0700 (Sat, 02 May 2009) | 1 line

closes #3556

........

r7625 | p_lindheimer | 2009-05-02 11:58:49 -0700 (Sat, 02 May 2009) | 1 line

fixes 641 hardcoded path

........

r7628 | p_lindheimer | 2009-05-02 13:19:12 -0700 (Sat, 02 May 2009) | 1 line

fixes #3513 check/report db error

........

r7629 | p_lindheimer | 2009-05-02 13:29:44 -0700 (Sat, 02 May 2009) | 1 line

fixes #3525 HTML errors

........

r7645 | p_lindheimer | 2009-05-06 09:36:46 -0700 (Wed, 06 May 2009) | 1 line

fixes #3658 module_admin PHP error when online repository not available

........