PitzKey
December 24, 2024, 3:00pm
1
Hello,
I am trying to restore a backup from a FreePBX 15 onto a FreePBX 17.
I updated the server settings (internal and external addresses) under EPM Global Settings and then I went to a template to rebuild it and I am getting the below error as soon as I hit Save & Rebuild.
PDOException (42S22)
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'plarNumber' in 'field list'
COPY
Stack frames (5)
4
PDOException
/var/www/html/admin/modules/endpoint/functions.inc/functions_common.php1644
3
PDOStatement execute
/var/www/html/admin/modules/endpoint/functions.inc/functions_common.php1644
2
endpoint_save_template
/var/www/html/admin/modules/endpoint/views/page.endpoint.php392
1
unknown
/var/www/html/admin/modules/endpoint/page.endpoint.php10
0
include
/var/www/html/admin/config.php658
/var/www/html/admin/modules/endpoint/functions.inc/functions_common.php
ICueOKi/A1dktJQEkNbPIvZR3JTJQGXdYDrVSbEKNL1CBeTKTuv3ALXIOGGRP1cqC/cuvmFrQyxi
g9DmNY4BVmu+aA+TgNb0v2OCmKMQmz/CzUCWtQ/VDkokETJOLfoidrYpE3y0aNxMzBn2/+Swn4bq
cqnsOncjOP86wLa0NWqln0J6Mplnh9JXPjKq+NkB2wEaz/+jZdZNpHCKmsnzpt08IgUIE17F87yt
NKagp8v2iXUpt4OuaGx4Um5GrapO1KM+8aYjDZL9b3XHT+pgODpUCzo17OQjQ1ViqLEzrsFtaPsN
AXSuFs9eVZVQ5Mv1kjc7vxLGmbbenX99Qh82wwmu2mbsiiwMY5As459Y+hhiaUQ2URGJngfp1piU
zG5ZdAKq5b/DejNU3g+RlQzzw4FNx0zuLpQ6pxH6EIKDd9D5uXlYIUREUp0W+XcJOHjcL2yYaBQP
mYfKSMmzLYjGp5KXf/B47220Ke+yY4B/KEfsx5ct6GQyNaZ1bYz/Hc4L0cDF7dDWEm5Wgff+TXsM
6igzMQTR2lN16uwc5XVPQ0SYcDytTizHSxDrlfE7KEyE2pfc3ubjS77N8Ft3SirJNpVzg6pnFxV6
OUIZBHSvp7uXc29XXPE6FmQkEIG8q1BivAWK5d6iGOpCEj59iaHL993azRUCZqVtlcmWMpcaAUl0
sFOZoc9+bFVLEzl54F+4SlwcS2jr+i0nmER7wNF/FelfXRz5+xIBoqU3dV45usyHslhnfALKoBD4
CzgPCigdgEfFyPR3NGfITmB7Pi6BiBdg4iZtGh8Sks9UWa+e4v/fv9mUooJDKftQu0iAFISSfEya
4V6QwpfxmKdWk/UOebQ778ZJvaAvydBXzL9FRQ8IvG9zpJYTFHc3c1gjNgs+CY9phvJ1nCU9ByC4
N8tX7HgKqFJJ16/oT6Qp4/7prNdXItEDL7nrMUJHOd2j63W9rxkXiMPSFnMHbvtfysaf1o44syFL
tb1OBrF/zmOJbsNfR477Z62DiuuQ+16oUUxAI8C2A9c4hOFokrOV98ZPBsBdHbgcySGb9FM3ZREP
D0fJdaKvl+LLIugl+uJ5DeMc2YWGZqGpocIbqt0UiCI2+JZWW6xa3/tmRmwEqQpBAGlCp+FgL7wA
UoWoPfgIIqnfHAk0qJLphqLviIlszthCVFcOqaHCQw5weExLlb49DLc7KjW8b6eaIz/coU0mjoCb
Swg+Rn5LXySd2/tm59dbzmXTw8XtS48CPBGaqVh5LUSSVmv9R2uiSfuOJDLti6vwFXc8qwDnq5Bm
O/iqXEPhlT9jJUKAbqD1bl8onluXoN6WZ8e6auP6ldNT6irQjRA/Q3bXm7hePc64rwCbZEUiy5hO
x5i0og0YVBjlTorPFX09cKrBLz/7pY5ilOVNr8XZtcrqIcvwU0R97QnhHzT1QJU+pqkolb86vy9+
D8Ni6bQYJZxqMeuGx634tVOGh1bs66P6Ber8SneO2rOrd2rMvd2yXBTHxQqDcBotxFeZpL5AObVi
P+BTFr9ZWvPeudA9gYw0MUUEHF07oQ1M4DUBdYTE0GHOpAMUcpDOcFgZDCKEHaWauGkEpneJIo7g
Jdj2J7LmTCLpDYei2wFKDaQ5eu2m2AYMtI0ernCGv1rjyjUwHMp+UjqBvsK4E9ZOakyHLvDC+Qkp
KzmUPUl7/Q7c0cpPY88+SCcGoKIIracNbA8Nx4kKM+J1JSy2cILngYsZRaQhmpU/yKD9I5auWLGF
uJwEV9AoEU4kcuY/kxXjDGAEh+NMlsDflP6L0X/YCe2/3PpRBYbZrrhu0si62RBpWp/5rOJpJyWl
Go9/WhWQ8yEuK6aVee6Q0+0qWpVT+OQgNsNTxyQuQw+dp2trEymfuV5CQL6IlIJo91ldzlTZ8N31
TPj+nB/FiBIEM4kDIOw2VhszxDd6xjAWEDtxauk5J+1CwxgJx+dSvLhgKj8QqYJ5YjmpvmWh/wVA
xMt+Kms3+2TzHZ29/6vwVnnps0reBWrcXLRT0tJx7XLA16rFZ94gJC+hm2WtgHyXPiQ3Ezk2fBDa
838iHfeGTWcWrOR/ZolMMEoivuRnSPC6C2DnTtLWyXcrm2BaeyJx7kVwrXDmHC0gIZl9It5Wc2BO
sIk/zT9JX+KGp9cSHwbnLjlBstVRPvQEMM0oNTW3gTcM6Hnu4o+FmdwgjgbWwJx2Rv5U6qCqSme5
yaj136uA5Gl2eDX51Hc8gaZwc6uHnjCQK1QqdsYCEnpz5qbkryJRTH3hv3O00sdh/oAMaSRKENS9
x589EKk793ZPiYZYnF+1l59KNaJKxSALaKfVuIQnKITDK1wjAjmavxeS42PeRB8aNbMHDpfd5Nf6
+cVON60Z5KInGbAHAyTGbG6zXP5xNFO9iu0EKN1rSHagT+y2lsJkEOsw3mSdz8VPR+MV35voIXOm
5zhqeXb4W7vF/2QPE5wpqCaiMGlVzawhTd9UjDdeXYsEKKpGL1Azyld3et09ngIxX96AOZZO/n6H
PXbKRQdNAI+ZtoZ+eUh5KNVrQ5o/7u0uVKb6QM2uifGKPYbaWCjTpQXYnnmLSPD5ragQZtGkkwRP
UaQpSWcHo+wconBOPmln8Q057KeomYlmoCw2UjM18PzXTrzT4qVeBY4b4fH14ZttrZshYs+F8V3U
G2e4w0eGDIrDYRPHVdujLA+jeo/HKXU1fZirT+IQ8FS7Y2CiAVU7l2KWPvZGFm2kuje+aej3ajIx
SdBXyAQdxScnv2Yg7myKc9d6rTERfCJ0b08Q9BSoTclZl+39MtrT5vVJ/dZo7JkrVwfVKk2pnEon
kr0UX/bDGYUZEOHwn/oBZWjurbjve7DA6WOEfSmRn9Bg6Raaei6GWVtBtYsFJaJ1Un/DCSA05Rx1
rb7V0cL7HlTwC2CRoivFuYs+iyewWzVM2UVBnbWw6XrjdEij6bfdmc7mj7NEXd5dZPMkZXJsKLor
lK5i49fMDBEachN6zIvDy0qagW+Cvijo+yUrMiCHsoNXO2gxw2E4+BXeWAmKkj/bhP98P7vQu2UD
Arguments
"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'plarNumber' in 'field list'"
PitzKey
December 30, 2024, 9:39pm
2
Bump… Does anyone know which table this column is supposed to be?
Have you looked at the tables on the v15 system?
PitzKey
December 30, 2024, 9:48pm
4
I started reviewing some… It’s a hella work going through all the tables, it could be any table in the entire database.
I started with the brands, models then templates. It is in the endpoint_templates table. It exists in my v17 system.
MariaDB [asterisk]> show columns from endpoint_templates;
+----------------------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------------------+---------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| brand | varchar(20) | YES | | NULL | |
| default | varchar(2) | YES | | NULL | |
| template_name | varchar(45) | YES | | NULL | |
| destination | varchar(40) | YES | | NULL | |
| focus | varchar(1) | YES | | NULL | |
| answer | varchar(1) | YES | | NULL | |
| mute | varchar(1) | YES | | NULL | |
| barge | varchar(1) | YES | | NULL | |
| offhook | varchar(1) | YES | | NULL | |
| stutter | varchar(1) | YES | | NULL | |
| timeout | varchar(2) | YES | | NULL | |
| toneset | varchar(12) | YES | | NULL | |
| time_server | varchar(1) | YES | | NULL | |
| time_server_1 | varchar(30) | YES | | NULL | |
| time_server_2 | varchar(30) | YES | | NULL | |
| time_server_3 | varchar(30) | YES | | NULL | |
| timezone | varchar(30) | YES | | NULL | |
| protocol | varchar(10) | YES | | NULL | |
| ftpuser | varchar(40) | YES | | NULL | |
| ftppass | varchar(40) | YES | | NULL | |
| ftpserver | varchar(250) | YES | | NULL | |
| extra | varchar(400) | YES | | NULL | |
| ext | varchar(80) | YES | | NULL | |
| missed | varchar(1) | YES | | NULL | |
| volume | varchar(2) | YES | | NULL | |
| echo | varchar(1) | YES | | NULL | |
| callwaiting | varchar(2) | YES | | NULL | |
| features | varchar(1024) | YES | | NULL | |
| background | varchar(256) | YES | | NULL | |
| outgoing | varchar(256) | YES | | NULL | |
| firmware | varchar(1) | YES | | 0 | |
| multicastAddress | varchar(1024) | YES | | NULL | |
| multicastEnable | varchar(2) | YES | | NULL | |
| lineLabel | varchar(2) | YES | | NULL | |
| daylight | varchar(2) | YES | | NULL | |
| dialpattern | varchar(512) | YES | | NULL | |
| models | varchar(200) | YES | | 0 | |
| backupDest | varchar(40) | YES | | NULL | |
| backupPort | varchar(10) | YES | | NULL | |
| outboundProxy | varchar(40) | YES | | NULL | |
| outboundProxyPort | varchar(10) | YES | | NULL | |
| backupOutboundProxy | varchar(40) | YES | | NULL | |
| backupOutboundProxyPort | varchar(10) | YES | | NULL | |
| country | varchar(3) | YES | | NULL | |
| wEnable1 | varchar(2) | YES | | NULL | |
| wssid1 | varchar(64) | YES | | NULL | |
| wsecurity1 | varchar(2) | YES | | NULL | |
| wWEPBits1 | varchar(5) | YES | | NULL | |
| wWPAPSKPass1 | varchar(64) | YES | | NULL | |
| wWPAPSKKey1 | varchar(64) | YES | | NULL | |
| hotline | varchar(2) | YES | | NULL | |
| hotlineDest | varchar(254) | YES | | NULL | |
| internalDefault | varchar(3) | YES | | NULL | |
| externalDefault | varchar(3) | YES | | NULL | |
| backlightActive | varchar(4) | YES | | NULL | |
| backlightInActive | varchar(4) | YES | | NULL | |
| labelScroll | varchar(4) | YES | | NULL | |
| headset | varchar(4) | YES | | NULL | |
| lldp | varchar(2) | YES | | NULL | |
| lldpPacket | varchar(5) | YES | | NULL | |
| vVlan | varchar(5) | YES | | NULL | |
| vVlanP | varchar(5) | YES | | NULL | |
| dVlan | varchar(5) | YES | | NULL | |
| dhcpVlan | varchar(2) | YES | | NULL | |
| vlanMode | varchar(2) | YES | | NULL | |
| vlanIdentity | varchar(20) | YES | | NULL | |
| vlanPass | varchar(64) | YES | | NULL | |
| ldapNameFilter | varchar(60) | YES | | NULL | |
| ldapNumberFilter | varchar(60) | YES | | NULL | |
| ldapServerAddress | varchar(60) | YES | | NULL | |
| ldapPort | varchar(60) | YES | | NULL | |
| ldapBase | varchar(80) | YES | | NULL | |
| ldapUsername | varchar(128) | YES | | NULL | |
| ldapPassword | varchar(60) | YES | | NULL | |
| ldapMaxHits | varchar(4) | YES | | NULL | |
| ldapDisplayName | varchar(60) | YES | | NULL | |
| ldapSearchDelay | varchar(4) | YES | | NULL | |
| lldpProtocol | varchar(2) | YES | | NULL | |
| ldapLookupCall | varchar(2) | YES | | NULL | |
| ldapSort | varchar(2) | YES | | NULL | |
| ldapNameAttributes | varchar(60) | YES | | NULL | |
| ldapNumberAttributes | varchar(60) | YES | | NULL | |
| language | varchar(2) | YES | | NULL | |
| entryTimeout | varchar(2) | YES | | NULL | |
| dialFirstDigit | varchar(2) | YES | | NULL | |
| shortPressIdleState | varchar(20) | YES | | NULL | |
| shortPressInUseState | varchar(20) | YES | | NULL | |
| longPressIdleState | varchar(20) | YES | | NULL | |
| longPressInUseState | varchar(20) | YES | | NULL | |
| longPressRingState | varchar(20) | YES | | NULL | |
| longPressIdleStateOpenEditButton | varchar(20) | YES | | NULL | |
| logoled | varchar(2) | YES | | NULL | |
| voicemailkey | varchar(2) | YES | | NULL | |
| menukey | varchar(2) | YES | | NULL | |
| menupin | varchar(20) | YES | | NULL | |
| keypressTone | varchar(2) | YES | | NULL | |
| voicemailTone | varchar(2) | YES | | NULL | |
| holdTone | varchar(2) | YES | | NULL | |
| holdToneDelay | varchar(2) | YES | | NULL | |
| acr | varchar(2) | YES | | NULL | |
| ssText | varchar(254) | YES | | NULL | |
| guiOverride | varchar(2) | YES | | NULL | |
| timeFormat | varchar(2) | YES | | NULL | |
| dateFormat | varchar(2) | YES | | NULL | |
| lcdLanguage | varchar(10) | YES | | NULL | |
| dialNow | varchar(4) | YES | | NULL | |
| backlightTimeout | varchar(4) | YES | | NULL | |
| powerStatus | varchar(20) | YES | | NULL | |
| ringingStatus | varchar(20) | YES | | NULL | |
| misscallsStatus | varchar(20) | YES | | NULL | |
| voicemessageStatus | varchar(20) | YES | | NULL | |
| activecallStatus | varchar(20) | YES | | NULL | |
| confCallRelease | varchar(2) | YES | | NULL | |
| contactPhoto | varchar(2) | YES | | NULL | |
| remoteDisconnect | varchar(2) | YES | | NULL | |
| phoneApps | varchar(5) | YES | | NULL | |
| browserNote | varchar(2) | YES | | NULL | |
| fontSize | varchar(2) | YES | | NULL | |
| ssSchedule | varchar(1024) | YES | | NULL | |
| dstSM | varchar(2) | YES | | NULL | |
| dstSW | varchar(2) | YES | | NULL | |
| dstSD | varchar(2) | YES | | NULL | |
| dstST | varchar(2) | YES | | NULL | |
| dstEM | varchar(2) | YES | | NULL | |
| dstEW | varchar(2) | YES | | NULL | |
| dstED | varchar(2) | YES | | NULL | |
| dstET | varchar(2) | YES | | NULL | |
| phoneLabel | varchar(64) | YES | | NULL | |
| handsetsendVolume | varchar(4) | YES | | NULL | |
| headsetsendVolume | varchar(4) | YES | | NULL | |
| handsfreesendVolume | varchar(4) | YES | | NULL | |
| transfermModeDSSKey | varchar(4) | YES | | NULL | |
| qualifyfrequency | varchar(10) | YES | | NULL | |
| backupdestEnable | varchar(2) | YES | | NULL | |
| brightness | varchar(4) | YES | | NULL | |
| contrast | varchar(4) | YES | | NULL | |
| dim_backlight | varchar(4) | YES | | NULL | |
| backlight_dim_level | varchar(4) | YES | | NULL | |
| idleStatus | varchar(20) | YES | | NULL | |
| ringing | varchar(20) | YES | | NULL | |
| on_the_phone | varchar(20) | YES | | NULL | |
| sipkeepaliveEnable | varchar(2) | YES | | NULL | |
| sipkeepaliveinterval | varchar(4) | YES | | NULL | |
| setringtone | varchar(20) | YES | | NULL | |
| tranblfwithoutprefix | varchar(2) | YES | | NULL | |
| use_native_apps | varchar(4) | YES | | 0 | |
| preprimarysipserverEnable | varchar(2) | YES | | NULL | |
| registerexpiration | varchar(5) | YES | | NULL | |
| multicastInterrupt | varchar(2) | YES | | NULL | |
| lockRingingvol | varchar(2) | YES | | NULL | |
| dialpatterntimeout | varchar(100) | YES | | NULL | |
| phonelabel_option | varchar(2) | YES | | NULL | |
| callCompletedElsewhere | varchar(2) | YES | | NULL | |
| quickBLFTransfer | varchar(2) | YES | | NULL | |
| monitorCall | varchar(2) | YES | | NULL | |
| quickBLFVMTransfer | varchar(2) | YES | | NULL | |
| blfDirectedCallPickup | varchar(2) | YES | | NULL | |
| preferredPJSIPTransport | varchar(3) | YES | | NULL | |
| callLogfetchEnteries | varchar(4) | YES | | NULL | |
| vlanXMode | varchar(2) | YES | | NULL | |
| vlanXIdentity | varchar(20) | YES | | NULL | |
| displayContactGroup | varchar(30) | YES | | NULL | |
| displayContactName | varchar(11) | YES | | NULL | |
| setInsecureSSL | varchar(2) | YES | | NULL | |
| plarNumber | varchar(255) | YES | | NULL | |
| plarTimeout | varchar(2) | YES | | 0 | |
+----------------------------------+---------------+------+-----+---------+----------------+
167 rows in set (0.003 sec)
PitzKey
December 30, 2024, 9:59pm
6
I created these -works now
Thanks much!
They didn’t exist in your v17 system?
PitzKey
December 30, 2024, 10:12pm
8
Nope. There were two missing columns plarNumber and plarTimeout
PitzKey
December 30, 2024, 11:04pm
9
V17 was installed around a month ago but we only restored a couple of days ago, not sure what went wrong. I’m glad it was a quick fix. Thanks for your help, Tom!
Wondering why those fields were missing. They’ve existed since at least v16.
PitzKey
December 30, 2024, 11:33pm
11
I guess that’s the reason. This was a restore from a V15 (see title)
Which is why I asked if they existed on the v15 system in the table. I don’t have one I can compare to.
system
January 6, 2025, 11:45pm
13
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
