Welcome to the nuBuilder forums!

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

Problem when creating database

Questions related to installing, updating, setting up and configuring
Post Reply
nferrara
Posts: 2
Joined: Mon Mar 27, 2023 8:27 pm
nuBuilder Version: 4.5

Problem when creating database

Unread post by nferrara »

Hello,
Following the documentation, the creation of nubuilder database was ok exempt with the following statement (nubuilder 4.5 version) :

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `zzzzsys_object_list` AS SELECT `information_schema`.`tables`.`TABLE_NAME` AS `zzzzsys_object_list_id` FROM `information_schema`.`TABLES` WHERE (`information_schema`.`tables`.`TABLE_SCHEMA` = database()) ;
------------------------------
Erreur
Requête SQL : Documentation
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `zzzzsys_object_list` AS SELECT `information_schema`.`tables`.`TABLE_NAME` AS `zzzzsys_object_list_id` FROM `information_schema`.`TABLES` WHERE (`information_schema`.`tables`.`TABLE_SCHEMA` = database())
MySQL a répondu : Documentation
#1054 - Champ 'information_schema.tables.TABLE_NAME' inconnu dans field list <============================
-----------------------------------
phpMyAdmin SQL Dump
-- version 4.9.11
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : lun. 27 mars 2023 à 21:41
-- Version du serveur : 10.6.12-MariaDB
-- Version de PHP : 7.4.33
Thanks for help.
Nicole
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: Problem when creating database

Unread post by kev1n »

Hi,

What version of nuBuilder are you using?

Try the latest from Github:
https://github.com/nuBuilder/nuBuilder- ... master.zip
nferrara
Posts: 2
Joined: Mon Mar 27, 2023 8:27 pm
nuBuilder Version: 4.5

Re: Problem when creating database

Unread post by nferrara »

Hi,
Great thanks ; it works now with your new version 4.5
Sincerely
Post Reply