nuBuilder Forum

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

Hi,

What version of nuBuilder are you using?

Try the latest from Github:
https://github.com/nuBuilder/nuBuilder- ... master.zip

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