Ticket #2026 (closed Bugs: fixed)

Opened 1 year ago

Last modified 1 year ago

Incoming routes SQL error

Reported by: vgster Assigned to:
Priority: major Milestone: 2.3
Component: Core - Trunks/Routing Version: 2.3-branch
Keywords: Cc:
Confirmation: SVN Revision (if applicable):
Backend Engine: All Backend Engine Version:

Description

Using the latest SVN and using --force-install=2.2.2.

SELECT * FROM incoming ORDER BY description,extension,cidnum [nativecode=1054 ** Unknown column 'description' in 'order clause']

Change History

06/26/07 09:00:14 changed by p_lindheimer

can you be more specific, please provide repro steps of what you do to make this error (I thought I added description in the upgrade code???)

06/26/07 10:33:21 changed by p_lindheimer

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

are you sure you have the tarball loaded from the mirror or sourceforge? This should be applied in the install_amp:

upgrades/2.30beta1/tables.php:

outn("Upgrading Inbound Routing to provide a description field..");

$sql = "SELECT description FROM incoming";                                                                                                                                                                        
$confs = $db->getRow($sql, DB_FETCHMODE_ASSOC);                                                                                                                                                                   
if (!DB::IsError($confs)) { // no error... Already done                                                                                                                                                           
  out("Not Required");                                                                                                                                                                                            
} else {                                                                                                                                                                                                          
  $sql = "ALTER TABLE incoming ADD description VARCHAR ( 80 ) NULL";                                                                                                                                              
  $results = $db->query($sql);                                                                                                                                                                                    
  if(DB::IsError($results)) {                                                                                                                                                                                     
          die($results->getMessage());                                                                                                                                                                            
  }                                                                                                                                                                                                               
  out("Done");                                                                                                                                                                                                    
}                                                                                                    

Double check, make sure that code is in your tables.php, and when running install_amp, check to see if it spits out the messages that it made this change. If the bug is still there (or this is not in the real tarball, etc.) reopen with more specifics of what you found.

For now closing as worksforme

06/26/07 15:00:58 changed by vgster

  • status changed from closed to reopened.
  • resolution deleted.

I'm using the SVN download from https://svn.sourceforge.net/svnroot/amportal/freepbx/trunk I've checked the tables.php and the above code isn't in it.

06/26/07 15:04:24 changed by vgster

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

Ah need to be using https://svn.sourceforge.net/svnroot/amportal/freepbx/branches/2.3/ and not trunk. I'll close this but you might need to sync trunk.

Donate



Support
Download
Develop
Forums
News
Documentation
Paid Support
About

Paid Ads