Skip to content

Fail to save tool config and dashboard with PG #305

@CzyerChen

Description

@CzyerChen
  • Opensips 3.5
  • Opensips-cp 9.3.5
  • PGSQL 13/11
  • Php7.4
  • CentOS7.9

init db with db_schema.psql

Fail to show dashboard page:
within page:

Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "order" LINE 1: select `name`, id, content, positions, `order` from ocp_dash... ^ )

in httpd logs:

[Tue Nov 12 10:00:51.006873 2024] [php7:notice] [pid 11741] [client 192.168.1.143:49778] unknown widget panel_1_widget_7, referer: http://192.168.5.169/cp/tools/system/dashboard/dashboard.php?action=display_panel&panel_id=1
[Tue Nov 12 10:00:51.018262 2024] [php7:notice] [pid 11516] [client 192.168.1.143:49781] unknown widget panel_1_widget_11, referer: http://192.168.5.169/cp/tools/system/dashboard/dashboard.php?action=display_panel&panel_id=1
[Tue Nov 12 10:00:51.029298 2024] [php7:notice] [pid 12119] [client 192.168.1.143:49780] unknown widget panel_1_widget_3, referer: http://192.168.5.169/cp/tools/system/dashboard/dashboard.php?action=display_panel&panel_id=1
[Tue Nov 12 10:00:51.041126 2024] [php7:notice] [pid 12060] [client 192.168.1.143:49782] unknown widget panel_1_widget_4, referer: http://192.168.5.169/cp/tools/system/dashboard/dashboard.php?action=display_panel&panel_id=1
[Tue Nov 12 10:00:51.053003 2024] [php7:notice] [pid 12456] [client 192.168.1.143:49776] unknown widget panel_1_widget_2, referer: http://192.168.5.169/cp/tools/system/dashboard/dashboard.php?action=display_panel&panel_id=1
[Tue Nov 12 10:00:51.065012 2024] [php7:notice] [pid 12569] [client 192.168.1.143:49777] unknown widget panel_1_widget_6, referer: http://192.168.5.169/cp/tools/system/dashboard/dashboard.php?action=display_panel&panel_id=1
[Tue Nov 12 10:00:51.076269 2024] [php7:notice] [pid 11741] [client 192.168.1.143:49778] unknown widget panel_1_widget_15, referer: http://192.168.5.169/cp/tools/system/dashboard/dashboard.php?action=display_panel&panel_id=1

These works fine with Mysql5.7, but failed with pg 11&13.
Whether there is a dependency mismatch.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions