Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fail to save tool config and dashboard with PG #305

Open
CzyerChen opened this issue Nov 12, 2024 · 0 comments
Open

Fail to save tool config and dashboard with PG #305

CzyerChen opened this issue Nov 12, 2024 · 0 comments

Comments

@CzyerChen
Copy link

  • 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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant