-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Cannot Reproduce
-
Affects Version/s: 13
-
Fix Version/s: None
-
Component/s: WakeUp Calls
-
Labels:None
-
ToDo:
-
Asterisk Version:11.25.1
-
Distro Version:13.0.192.16
-
Distro:FreePBX Distro
I get this error when trying to change the Wake Up Caller ID settings:
4. PDOException/var/www/html/admin/modules/hotelwakeup/Hotelwakeup.class.php158
3. PDOStatement execute/var/www/html/admin/modules/hotelwakeup/Hotelwakeup.class.php158
2. FreePBX\modules\Hotelwakeup saveConfig/var/www/html/admin/modules/hotelwakeup/Hotelwakeup.class.php131
1. FreePBX\modules\Hotelwakeup showPage/var/www/html/admin/modules/hotelwakeup/page.hotelwakeup.php31
0. include/var/www/html/admin/config.php555
PDOException (23000)
HELP
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6' for key 'PRIMARY'
/var/www/html/admin/modules/hotelwakeup/Hotelwakeup.class.php # public function saveConfig($options) {
- if(empty($options)) {
- return false;
- }
- $options['operator_extensions'] = str_replace("\n",",",$options['operator_extensions']);
- $sql = "UPDATE `hotelwakeup` SET `maxretries` = ?, `waittime` = ?, `retrytime` = ?, `extensionlength` = ?, `cnam` = ?, `cid` = ?, `operator_mode` = ?, `operator_extensions` = ? LIMIT 1";
- $sth = $this->db->prepare($sql);
- return $sth->execute(array($options['maxretries'], $options['waittime'], $options['retrytime'], $options['extensionlength'], $options['cnam'], $options['cid'], $options['operator_mode'], $options['operator_extensions']));
- }
Server/Request Data
| SCRIPT_URL | /admin/config.php |
| SCRIPT_URI | http://pbx.madisoncorelabs.com/admin/config.php |
| HTACCESS | on |
| HTTP_HOST | pbx.madisoncorelabs.com |
| HTTP_CONNECTION | keep-alive |
| CONTENT_LENGTH | 165 |
| HTTP_CACHE_CONTROL | max-age=0 |
| HTTP_ORIGIN | http://pbx.madisoncorelabs.com |
| HTTP_UPGRADE_INSECURE_REQUESTS | 1 |
| HTTP_USER_AGENT | Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36 |
| CONTENT_TYPE | application/x-www-form-urlencoded |
| HTTP_ACCEPT | text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,/;q=0.8 |
| HTTP_REFERER | http://pbx.madisoncorelabs.com/admin/config.php?display=hotelwakeup |
| HTTP_ACCEPT_ENCODING | gzip, deflate |
| HTTP_ACCEPT_LANGUAGE | en-US,en;q=0.8 |
| HTTP_COOKIE | lang=en_US; searchHide=1; PHPSESSID=7kncl19tj6osujlhv9fsvie9q6; _ga=GA1.2.1110216919.1501280798; _gid=GA1.2.76064573.1503929788 |
| PATH | /sbin:/usr/sbin:/bin:/usr/bin |
| SERVER_SIGNATURE | <address>Apache/2.2.15 (CentOS) Server at pbx.madisoncorelabs.com Port 80</address> |
| SERVER_SOFTWARE | Apache/2.2.15 (CentOS) |
| SERVER_NAME | pbx.madisoncorelabs.com |
| SERVER_ADDR | 174.37.247.11 |
| SERVER_PORT | 80 |
| REMOTE_ADDR | 24.96.187.129 |
| DOCUMENT_ROOT | /var/www/html |
| SERVER_ADMIN | root@localhost |
| SCRIPT_FILENAME | /var/www/html/admin/config.php |
| REMOTE_PORT | 51502 |
| REMOTE_USER | admin |
| AUTH_TYPE | Basic |
| GATEWAY_INTERFACE | CGI/1.1 |
| SERVER_PROTOCOL | HTTP/1.1 |
| REQUEST_METHOD | POST |
| QUERY_STRING | display=hotelwakeup |
| REQUEST_URI | /admin/config.php?display=hotelwakeup |
| SCRIPT_NAME | /admin/config.php |
| PHP_SELF | /admin/config.php |
| PHP_AUTH_USER | admin |
| PHP_AUTH_PW | mcorelabs120 |
| REQUEST_TIME | 1504015376 |
GET Data
| display | hotelwakeup |
POST Data
| action | settings |
| operator_mode | 1 |
| extensionlength | 11 |
| operator_extensions | 00 01 |
| waittime | 30 |
| retrytime | 15 |
| maxretries | 6 |
| callerid | "Wake Up Calls" <2568500075> |
Filesempty
Cookies
| lang | en_US |
| searchHide | 1 |
| PHPSESSID | 7kncl19tj6osujlhv9fsvie9q6 |
| _ga | GA1.2.1110216919.1501280798 |
| _gid | GA1.2.76064573.1503929788 |
Session
| langdirection | ltr |
| AMP_user | ampuser Object ( [username] => freepbxuser [id] => [password:ampuser:private] => [extension_high:ampuser:private] => [extension_low:ampuser:private] => [sections:ampuser:private] => Array ( [0] => * ) [mode:ampuser:private] => database [opmode:ampuser:private] => [deptname] => [_lastactivity] => 1504015376 ) |
| module_name | hotelwakeup |
| module_page | hotelwakeup |
| FOP2 | Array ( [context] => [key] => l5xfXz6uyHdTVD6Yan2TlxKg9 [extension] => 101 [language] => en [vpath] => /var/spool/asterisk/voicemail [permit] => all [admin] => 1 [phonebook] => yes ) |
Environment Variablesempty
Registered Handlers0. Whoops\Handler\PrettyPageHandler
