Database Management System in CyberPanel

st

stainlesscomputers Feb. 6, 2023, 10:28 p.m. #1

I got the following error while trying to save to the database through a PHP application I installed on CyberPanel. No such error while on Cpanel hosting. I suggest the error is from the database management system because when I connect to a remote DB on Cpanel, it works without the error

Ooops Database Error: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: ‘’ for column

@usmannasir
@die2mrw007
@shoaibkk

RM

Rana Muhammad Usman Nasir Feb. 7, 2023, 4:06 a.m. #2

I am sorry, I do not understand your problem correctly. Are you trying to create a remote access user for a database?

Also please check the related guide How to allow remote access to MySQL/MariaDB | by Natan Cabral | Medium

st

stainlesscomputers Feb. 7, 2023, 7:27 a.m. #3

I mean the php app (GitHub - igweze/wizgrade: wizGrade is a complete and robust school management system written in PHP) is showing the error while I tried to save to the database. And no such error while I install same app on cpanel. Possibly CyberPanel MariaDB is different from cpanel.

st

stainlesscomputers Feb. 9, 2023, 9 a.m. #4

@usmannasir

jo

josephgodwinke Feb. 9, 2023, 9:07 a.m. #5

Hello @stainlesscomputers

Does the script try to install this sql wizgrade/wizGrade.sql at master · igweze/wizgrade · GitHub and then fails ?

If not kindly post the sql or script that you are trying to run

st

stainlesscomputers Feb. 9, 2023, 9:09 a.m. #6

I find a way to install it, but when saving to database, error

Ooops Database Error: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: ‘’ for column