atfer update from github the users table is empty

Questions related to installing, setting up and configuring nuBuilder Forte

atfer update from github the users table is empty

Unread postby miasoft » Tue Oct 05, 2021 4:13 pm

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: 100
Joined: Wed Dec 23, 2020 8:58 pm
nuBuilder Version: 4.5

Re: atfer update from github the users table is empty

Unread postby miasoft » Tue Oct 05, 2021 5:40 pm

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 230 times
Wbr, miasoft.
miasoft
 
Posts: 100
Joined: Wed Dec 23, 2020 8:58 pm
nuBuilder Version: 4.5

Re: atfer update from github the users table is empty

Unread postby miasoft » Tue Oct 05, 2021 6:01 pm

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.
miasoft
 
Posts: 100
Joined: Wed Dec 23, 2020 8:58 pm
nuBuilder Version: 4.5

Re: atfer update from github the users table is empty

Unread postby kev1n » Tue Oct 05, 2021 11:38 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)
kev1n
nuBuilder Team
 
Posts: 2063
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: atfer update from github the users table is empty

Unread postby miasoft » Wed Oct 06, 2021 12:33 am

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 200 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.
miasoft
 
Posts: 100
Joined: Wed Dec 23, 2020 8:58 pm
nuBuilder Version: 4.5

Re: atfer update from github the users table is empty

Unread postby kev1n » Wed Oct 06, 2021 12:49 am

Could you add the rows again in zzzzsys_access?
kev1n
nuBuilder Team
 
Posts: 2063
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: atfer update from github the users table is empty

Unread postby miasoft » Wed Oct 06, 2021 1:01 am

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

Yes, after insert rows in zzzzsys_access all works.
Wbr, miasoft.
miasoft
 
Posts: 100
Joined: Wed Dec 23, 2020 8:58 pm
nuBuilder Version: 4.5


Return to Installation

Who is online

Users browsing this forum: No registered users and 5 guests