Skip to content

Fail to save tool config and dashboard with PG #305

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

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions