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.
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
atfer update from github the users table is empty
-
- Posts: 146
- Joined: Wed Dec 23, 2020 12:28 pm
- nuBuilder Version: 4.5
- Location: Russia, Volgograd
- Has thanked: 1 time
- Contact:
Re: atfer update from github the users table is empty
Current nubuilder4.sql on GitHub:kev1n wrote:Which version did you update from?
My version-- 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";
Wbr, miasoft.
-
- Posts: 146
- Joined: Wed Dec 23, 2020 12:28 pm
- nuBuilder Version: 4.5
- Location: Russia, Volgograd
- Has thanked: 1 time
- Contact:
Re: atfer update from github the users table is empty
Something wrong:
zzzzsys_user table in MySql is OK, but browse Users (from globeadmin menu) is empty. I can login only as globeadmin.
zzzzsys_user table in MySql is OK, but browse Users (from globeadmin menu) is empty. I can login only as globeadmin.
Wbr, miasoft.
-
- nuBuilder Team
- Posts: 3884
- Joined: Sun Oct 14, 2018 6:43 pm
- nuBuilder Version: 4.5
- Has thanked: 2 times
- Been thanked: 9 times
- Contact:
Re: atfer update from github the users table is empty
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)
Are there any rows in zzzzsys_access?
Can you paste the generated Browse SQL of the user form ? (CTRL+SHIFT+I)
-
- Posts: 146
- Joined: Wed Dec 23, 2020 12:28 pm
- nuBuilder Version: 4.5
- Location: Russia, Volgograd
- Has thanked: 1 time
- Contact:
Re: atfer update from github the users table is empty
Before update I have two records in zzzzsys_access: admin and userkev1n wrote: Are there any rows in zzzzsys_access?
Can you paste the generated Browse SQL of the user form ? (CTRL+SHIFT+I)
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
Wbr, miasoft.
-
- nuBuilder Team
- Posts: 3884
- Joined: Sun Oct 14, 2018 6:43 pm
- nuBuilder Version: 4.5
- Has thanked: 2 times
- Been thanked: 9 times
- Contact:
Re: atfer update from github the users table is empty
Could you add the rows again in zzzzsys_access?
-
- Posts: 146
- Joined: Wed Dec 23, 2020 12:28 pm
- nuBuilder Version: 4.5
- Location: Russia, Volgograd
- Has thanked: 1 time
- Contact:
Re: atfer update from github the users table is empty
Yes, after insert rows in zzzzsys_access all works.kev1n wrote:Could you add the rows again in zzzzsys_access?
Wbr, miasoft.