atfer update from github the users table is empty

[miasoft]

some days ago I try to update nuBuilder from GitHub (from nubuilder4.sql) and my zzzzsys_user is empty in result.
p.s. I cannot replay in News&Ann group, so I write here.

[miasoft]

Which version did you update from?

Current nubuilder4.sql on GitHub:

-- phpMyAdmin SQL Dump
-- version 5.1.2-dev+20210713.aae0630b78
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 02, 2021 at 11:41 AM
-- Server version: 10.4.20-MariaDB
-- PHP Version: 8.0.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

My version

05.10_1.png

[miasoft]

Something wrong:
zzzzsys_user table in MySql is OK, but browse Users (from globeadmin menu) is empty. I can login only as globeadmin.

[kev1n]

I just tested the update process from V.4.5-2021 09.08.00 to the latest Github version and do not see any issues here.

Are there any rows in zzzzsys_access?

Can you paste the generated Browse SQL of the user form ? (CTRL+SHIFT+I)

[miasoft]

Are there any rows in zzzzsys_access?
Can you paste the generated Browse SQL of the user form ? (CTRL+SHIFT+I)

Before update I have two records in zzzzsys_access: admin and user

05.10_2_3.png

After update zzzzsys_access is empty.

This is my sql for nuuser form after update

Code: Select all

SELECT *
FROM zzzzsys_user 
INNER JOIN zzzzsys_access ON zzzzsys_access_id = sus_zzzzsys_access_id
WHERE
(

    ( 
        ('#nuBrowseTitle9_select#' LIKE '#%' AND  (sus_expires_on > NOW() OR sus_expires_on IS NULL)) OR
        ('#nuBrowseTitle9_select#' = 'Expired' AND sus_expires_on < NOW()) OR 
        ('#nuBrowseTitle9_select#' = '')
    ) 
     AND
     (sus_team = '#nuBrowseTitle8_select#' OR '#nuBrowseTitle8_select#' LIKE '#%' OR '#nuBrowseTitle8_select#' = '')
     AND
    (sus_position = '#nuBrowseTitle6_select#' OR '#nuBrowseTitle6_select#' LIKE '#%' OR '#nuBrowseTitle6_select#' = '')
    AND
    (sus_department = '#nuBrowseTitle7_select#' OR '#nuBrowseTitle7_select#' LIKE '#%' OR '#nuBrowseTitle7_select#' = '')
)
ORDER BY sus_name

[kev1n]

Could you add the rows again in zzzzsys_access?

[miasoft]

Could you add the rows again in zzzzsys_access?

Yes, after insert rows in zzzzsys_access all works.