Page 1 of 1
atfer update from github the users table is empty
Posted: Tue Oct 05, 2021 8:43 am
by 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.
Re: atfer update from github the users table is empty
Posted: Tue Oct 05, 2021 10:10 am
by miasoft
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 2221 times
Re: atfer update from github the users table is empty
Posted: Tue Oct 05, 2021 10:31 am
by miasoft
Something wrong:
zzzzsys_user table in MySql is OK, but browse Users (from globeadmin menu) is empty. I can login only as globeadmin.
Re: atfer update from github the users table is empty
Posted: Tue Oct 05, 2021 4:08 pm
by 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)
Re: atfer update from github the users table is empty
Posted: Tue Oct 05, 2021 5:03 pm
by miasoft
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 2191 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
Re: atfer update from github the users table is empty
Posted: Tue Oct 05, 2021 5:19 pm
by kev1n
Could you add the rows again in zzzzsys_access?
Re: atfer update from github the users table is empty
Posted: Tue Oct 05, 2021 5:31 pm
by miasoft
kev1n wrote:Could you add the rows again in zzzzsys_access?
Yes, after insert rows in zzzzsys_access all works.