Skip to Content

ERROR db portals: Column login_url cannot be null

How to fix ERROR db portals: Column 'login_url' cannot be null when trying to upgrade Ezeelogin to the latest version?

1. Take a full backup of current Ezeelogin installation. Run below command to take the backup

root@gateway ~]# /usr/local/sbin/backup_ezlogin.php

Refer detailed article to take the backup of the current Ezeelogin installation.

How to create a complete backup of Ezeelogin installation?

2. Run the below command to clear the login_url field.

root@gateway ~]# php /usr/local/ezlogin/ez_queryrunner.php "update prefix_portals set login_url = ' ' where login_url IS NULL"

3. After running the above command, proceed with Ezeelogin upgrade. Replace the Ezeelogin package name, database root username, and password. tp upgrade Ezeelogin with a single command.

root@gateway ~]# sh ezlogin_7.xx.x_phpxx.bin -- -dbsuser <enter (root)db username> -dbspass <enter_(root)db_password> -skipgeolite -auto -force -ACCEPT_SETTINGS -I_ACCEPT_EULA -skipbackup -update

Refer detailed article to upgrade Ezeelogin to the latest version.

Upgrade Ezeelogin Jump server to the latest version

 

Related Articles

ERROR db user: Incorrect datetime value: ’0000-00-00 00:00:00’ for column ’expiry’ at row 1

header1 : ERROR db gwactivity_logs: Incorrect string value: ’\xDDerrsssi...’ for column ’status’ at row 1"

ERROR granting access for DB user: Access denied for user 'root'@'%' to database during upgrade

How to create a complete backup of Ezeelogin installation?

Upgrade Ezeelogin Jump server to the latest version