Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

atfer update from github the users table is empty

Questions related to installing, updating, setting up and configuring
Post Reply
miasoft
Posts: 146
Joined: Wed Dec 23, 2020 12:28 pm
nuBuilder Version: 4.5
Location: Russia, Volgograd
Has thanked: 1 time
Contact:

atfer update from github the users table is empty

Unread post 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.
Wbr, miasoft.
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

Unread post 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
05.10_1.png (6.15 KiB) Viewed 2067 times
Wbr, miasoft.
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

Unread post 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.
Wbr, miasoft.
kev1n
nuBuilder Team
Posts: 3801
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

Unread post 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)
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

Unread post 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
05.10_2_3.png (26.91 KiB) Viewed 2037 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
Wbr, miasoft.
kev1n
nuBuilder Team
Posts: 3801
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

Unread post by kev1n »

Could you add the rows again in zzzzsys_access?
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

Unread post by miasoft »

kev1n wrote:Could you add the rows again in zzzzsys_access?
Yes, after insert rows in zzzzsys_access all works.
Wbr, miasoft.
Post Reply