Open Source Training Seminar FreePBX Paid Support

Ticket #1792 (closed Feature Requests: invalid)

Opened 1 year ago

Last modified 2 weeks ago

ivr module fails to install under sqlite3

Reported by: diego_iastrubni Assigned to: diego_iastrubni
Priority: minor Milestone: 2.5
Component: Sqlite3 Version:
Keywords: sqlite Cc:
Confirmation: Confirmed SVN Revision (if applicable):
Backend Engine: All Backend Engine Version:

Description

as in ticket:1773 , the install.sql is broken, and has been recoded into install.php. see file attached.

the install still fails in this code: 

if (version_compare($ivr_modcurrentvers, "2.2", "<")) {
	echo "<p>Start 2.2 upgrade</p>";
	$sql = "ALTER TABLE ivr CHANGE COLUMN announcement announcement VARCHAR ( 255 )";
    $result = $db->query($sql);
    if(DB::IsError($result)) {
            die($result->getDebugInfo());
    } else {

Attachments

sqlite3-support.dpatch (2.9 kB) - added by diego_iastrubni on 02/17/07 21:13:10.
sqlite3 support
sqlit3-new.patch (4.1 kB) - added by diego_iastrubni on 06/27/07 02:54:44.
new patch for sqlite3 support - problems...?

Change History

02/17/07 21:13:10 changed by diego_iastrubni

  • attachment sqlite3-support.dpatch added.

sqlite3 support

05/06/07 03:08:29 changed by lazytt

will the resolution of #1773 work here too?

06/20/07 06:48:53 changed by p_lindheimer

  • version changed from 2.2.1 to 2.3-branch.

06/27/07 02:53:57 changed by diego_iastrubni

  • owner set to diego_iastrubni.
  • status changed from new to assigned.

I am trying to import my patch, but I found a problem: 

-sql('CREATE TABLE IF NOT EXISTS ivr_dests ( ivr_id INT NOT NULL, selection VARCHAR(10), dest VARCHAR(50))');
...

+$sql = "CREATE TABLE IF NOT EXISTS ivr_dests (
+       ivr_id INTEGER NOT NULL,
+       selection VARCHAR(10),
+       dest VARCHAR(50),
+       ivr_ret TINYINT(1) NOT NULL DEFAULT 0
+);";

On my code (from 2.2.x) there is another database column: ivr_ret. What should I do? commit without that column? Attaching a new patch.

06/27/07 02:54:44 changed by diego_iastrubni

  • attachment sqlit3-new.patch added.

new patch for sqlite3 support - problems...?

06/30/07 09:50:26 changed by p_lindheimer

  • component changed from IVR Module to Sqlite3.

07/26/07 08:16:22 changed by p_lindheimer

  • version changed from 2.3-branch to SVN-HEAD.
  • milestone changed from 2.3 to 3.0.

moving to post 2.3 (unless someone wants to get these in soon)

11/27/07 23:34:59 changed by p_lindheimer

  • confirmation set to Confirmed.
  • version deleted.
  • milestone changed from 2.4 to 3.0.

deferring from lack of progress

06/23/08 20:53:27 changed by p_lindheimer

  • type changed from Bugs to Feature Requests.

07/06/08 13:43:19 changed by lazytt

  • status changed from assigned to closed.
  • resolution set to invalid.

please update the patch against 2.4

Donate



Support
Download
Develop
Forums
News
Documentation
Paid Support
About

Paid Ads