Open Source Training Seminar FreePBX Paid Support

Ticket #1779 (closed Feature Requests: fixed)

Opened 2 years ago

Last modified 2 months ago

phpagiconf does not install it's DB on sqlite

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

Description

The install.sql does not work on sqlite. Same as ticket:1773.

Attachments

php-agiconf-sqlite3.patch (1.2 kB) - added by diego_iastrubni on 07/07/07 23:41:53.
Another fix for this module

Change History

02/14/07 19:47:46 changed by diego_iastrubni

The module is still non-functional, since the function: phpagiconf_add contains a bad SQL command set. This should be fixed. (I still have no working code)

04/21/07 23:44:17 changed by diego_iastrubni

  • keywords changed from sqlit3 to sqlite3.

The attached code fixes the phpagiconf_add. I am still not comitting, since i would like someone to review my code.

diegolocal@turing:~/Proj/freepbx/freepbx-modules/branches/2.3/phpagiconf$ svn diff
Index: functions.inc.php
===================================================================
--- functions.inc.php   (revision 3931)
+++ functions.inc.php   (working copy)
@@ -52,7 +52,20 @@
        } else {
                $asmanager = array ($amp_conf['AMPDBUSER'], $amp_conf['AMPDBPASS']);
        }
-       $results = sql("INSERT INTO phpagiconf SET `debug`=$p_debug, error_handler=$p_error_handler, err_email='$p_err_email', hostname='$p_hostname', tempdir;
+       $results = sql("INSERT INTO phpagiconf SET `debug`=$p_debug");
+       $results = sql("INSERT INTO phpagiconf SET `error_handler`=$p_error_handler");
+       $results = sql("INSERT INTO phpagiconf SET `err_email`='$p_err_email'");
+       $results = sql("INSERT INTO phpagiconf SET `hostname`='$p_hostname'");
+       $results = sql("INSERT INTO phpagiconf SET `tempdir`='$p_tempdir'");
+       $results = sql("INSERT INTO phpagiconf SET `festival_text2wave`='$p_festival_text2wave'");
+       $results = sql("INSERT INTO phpagiconf SET `asman_server`='$p_asman_server'");
+       $results = sql("INSERT INTO phpagiconf SET `asman_port`=$p_asman_port");
+       $results = sql("INSERT INTO phpagiconf SET `asman_user`='".$asmanager[0]."'");
+       $results = sql("INSERT INTO phpagiconf SET `asman_secret`='".$asmanager[1]."'");
+       $results = sql("INSERT INTO phpagiconf SET `cepstral_swift`='$p_cepstral_swift'");
+       $results = sql("INSERT INTO phpagiconf SET `cepstral_voice`='$p_cepstral_voice'");
+       $results = sql("INSERT INTO phpagiconf SET `setuid`=$p_setuid");
+       $results = sql("INSERT INTO phpagiconf SET `basedir`='$p_basedir'");
 }

 ?>

06/25/07 05:08:21 changed by p_lindheimer

  • version changed from 2.2.1 to 2.3-branch.

06/30/07 10:45:17 changed by p_lindheimer

  • owner set to diego_iastrubni.
  • component changed from Other Module to Sqlite3.

07/07/07 23:40:55 changed by diego_iastrubni

  • status changed from new to assigned.

I am attaching a new patch - this one does the same work with an atomic "insert into". Both seem to work, but I like the first one better as it slides out of the code a lot less more.

07/07/07 23:41:53 changed by diego_iastrubni

  • attachment php-agiconf-sqlite3.patch added.

Another fix for this module

07/08/07 01:36:41 changed by diego_iastrubni

(yes me again)

The new patch is the correct one, the older one just fails :(

07/26/07 08:14:11 changed by p_lindheimer

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

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

11/27/07 23:31:57 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:52:10 changed by p_lindheimer

  • type changed from Bugs to Feature Requests.

07/02/08 14:32:26 changed by lazytt

  • status changed from assigned to closed.
  • resolution set to fixed.
Donate



Support
Download
Develop
Forums
News
Documentation
Paid Support
About

Paid Ads