nuBuilder Forum

Posted: **Tue Oct 05, 2021 8:43 am**

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.

Posted: **Tue Oct 05, 2021 10:10 am**

kev1n wrote: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 (6.15 KiB) Viewed 2114 times

Posted: **Tue Oct 05, 2021 10:31 am**

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

Posted: **Tue Oct 05, 2021 4:08 pm**

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)

Posted: **Tue Oct 05, 2021 5:03 pm**

kev1n wrote: 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 (26.91 KiB) Viewed 2084 times

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

Posted: **Tue Oct 05, 2021 5:19 pm**

Could you add the rows again in zzzzsys_access?

Posted: **Tue Oct 05, 2021 5:31 pm**

kev1n wrote:Could you add the rows again in zzzzsys_access?

Yes, after insert rows in zzzzsys_access all works.

nuBuilder Forum

atfer update from github the users table is empty

atfer update from github the users table is empty

Re: atfer update from github the users table is empty

Re: atfer update from github the users table is empty

Re: atfer update from github the users table is empty

Re: atfer update from github the users table is empty

Re: atfer update from github the users table is empty

Re: atfer update from github the users table is empty