FATAL SQL ERROR creating extensions on new Stable-5.211.65-13

Looks like there is some problem with database. Installed and reinstalled FreePBX distro from scratch and problem persists.

Post the errors here. We can’t do anything without seeing what the error is.

Also uninstall OSS Endpoint Manager, as that is most-likely your issue.

OK, the poblem is easy to reproduce. Just intall the iso (I use IPv4 with dhcp) and try to create an IAX or SIP extension. Looks like there is some problem creating some database tables, some tables are missing.
Tomorrow I will post exact errors but as I said it’s easy to reproduce.

Thanks.

Works fine here.

Same problem here, brand new download & install.

PBX Firmware: 5.211.65-13
PBX Service Pack: 1.0.0.0

This is part of what shows up.

FATAL SQL ERROR! ::::: SELECT var_name, value FROM endpointman_global_vars [nativecode=1146 ** Table ‘asterisk.endpointman_global_vars’ doesn’t exist]SQL -
array(5) {
[0]=>
array(7) {
[“file”]=>
string(72) “/var/www/html/admin/modules/endpointman/includes/abstraction/freepbx.inc”
[“line”]=>
int(31)
[“function”]=>
string(9) “sql_error”
[“class”]=>
string(20) “epm_data_abstraction”
[“object”]=>
object(epm_data_abstraction)#54 (3) {
[“db”]=>
object(freepbx_DB_mysql)#2 (26) {
[“phptype”]=>
string(5) “mysql”
[“dbsyntax”]=>
string(5) “mysql”
[“features”]=>
array(7) {
[“limit”]=>
string(5) “alter”
[“new_link”]=>
string(5) “4.2.0”
[“numrows”]=>
bool(true)
[“pconnect”]=>
bool(true)
[“prepare”]=>
bool(false)
[“ssl”]=>
bool(false)
[“transactions”]=>
bool(true)
}
[“errorcode_map”]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
[“connection”]=>
resource(34) of type (mysql link)
[“dsn”]=>
array(9) {
[“phptype”]=>
string(5) “mysql”
[“dbsyntax”]=>
string(5) “mysql”
[“username”]=>
string(11) “freepbxuser”
[“password”]=>
string(12) “999fd480a59b”
[“protocol”]=>
string(3) “tcp”
[“hostspec”]=>
string(9) “localhost”
[“port”]=>
bool(false)
[“socket”]=>
bool(false)
[“database”]=>
string(8) “asterisk”
}
[“autocommit”]=>
bool(true)
[“transaction_opcount”]=>
int(0)
["_db"]=>
string(8) “asterisk”
[“fetchmode”]=>
int(1)
[“fetchmode_object_class”]=>
string(8) “stdClass”
[“was_connected”]=>
NULL
[“last_query”]=>
string(51) “SELECT var_name, value FROM endpointman_global_vars”
[“options”]=>
array(8) {
[“result_buffering”]=>
int(500)
[“persistent”]=>
bool(false)
[“ssl”]=>
bool(false)
[“debug”]=>
int(0)
[“seqname_format”]=>
string(6) “%s_seq”
[“autofree”]=>
bool(false)
[“portability”]=>
int(0)
[“optimize”]=>
string(11) “performance”
}
[“last_parameters”]=>
array(0) {
}
[“prepare_tokens”]=>
array(0) {
}
[“prepare_types”]=>
array(0) {
}
[“prepared_queries”]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) “”
["_error_class"]=>
string(8) “DB_Error”
["_expected_errors"]=>
array(0) {
}
}
[“amp_conf”]=>
NULL
[“global_cfg”]=>
NULL
}
[“type”]=>
string(2) “->”
[“args”]=>
array(1) {
[0]=>
object(DB_Error)#56 (8) {
[“error_message_prefix”]=>
string(0) “”
[“mode”]=>
int(1)
[“level”]=>
int(1024)
[“code”]=>
int(-18)
[“message”]=>
string(23) “DB Error: no such table”
[“userinfo”]=>
string(127) “SELECT var_name, value FROM endpointman_global_vars [nativecode=1146 ** Table ‘asterisk.endpointman_global_vars’ doesn’t exist]”
[“backtrace”]=>
array(12) {
[0]=>
array(6) {
[“file”]=>
string(22) “/usr/share/pear/DB.php”
[“line”]=>
int(966)
[“function”]=>
string(10) “PEAR_Error”
[“class”]=>

Uninstall endpointman module which is the OSS End Point Manager module. Seems it has a issue.

Hi,

I am also experiencing this problem when trying to add an extension i.e. the asterisk.endpointman_gloval_vars table doesn’t exist as seemingly referenced by the file /var/www/html/admin/modules/endpointman/includes/abstraction/freepbx.inc

I have uninstalled the endpointman module which also required the disabling of the restapps module.

Having applied the changes and rebooted for good measure I am still faced with the same issue.

I must confess to being very new to the PBX game and am trying out freepbx for the first time but I am reasonably certain I’m unable to proceed without the ability to add extensions?

Any ideas most appreciated. Am happy to edit a config file in the meantime. Seems to reference an include file which is presumably redundant if the module has been uninstalled? Comment out the php include reference perhaps?

Heck I’ll give it a shot. Got nothing to lose at this point :wink:

Thanks guys!

Having tried and failed I am conceding defeat. Need an expert to point in right direction at least…

You uninstalled the wrong module. Uninstall OSS Endpoint Manager, not Endpoint. They are two different modules.

I know you uninstalled Endpoint because that has the rest apps dependency, OSS does not.

I uninstalled OSS Endpoint Manager and now get a different fatal error.
FATAL ERROR

SELECT * FROM cxpanel_users WHERE user_id = ‘’ [nativecode=1146 ** Table ‘asterisk.cxpanel_users’ doesn’t exist]SQL -
SELECT * FROM cxpanel_users WHERE user_id = ‘’

Trace Back

Ok so now uninstall cxpanel

I removed iSymphonyV3 and the fatal error is now gone, is this a problem with my system or does some changes need to be made to the latest iso download.

Removing OSS Endpoint Manager solved the problem. I can create SIP extensions now. But when I login to User Control Panel I get a white screen (500 internal server error accesing /recordings). That was working fine in the previous iso release.

amportal a dbug

To go the white page

Post errors here.

PHP Fatal error: Cannot use object of type DB_Error as array in /var/www/html/recordings/modules/settings.module on line 0, referer: http://10.55.0.40/admin/config.php

No news about errors?

Thanks.

I would try a new install. Something is really jacked on yours.

The errors have been fixed but its hard to keep track of threads here. It’s regression from endpoint manager.

rm /var/www/html/admin/recordings/modules/phonesettings.module