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
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.
Problem when creating database
-
- Posts: 2
- Joined: Mon Mar 27, 2023 8:27 pm
- nuBuilder Version: 4.5
-
- nuBuilder Team
- Posts: 3984
- Joined: Sun Oct 14, 2018 6:43 pm
- nuBuilder Version: 4.5
- Has thanked: 5 times
- Been thanked: 14 times
- Contact:
Re: Problem when creating database
Hi,
What version of nuBuilder are you using?
Try the latest from Github:
https://github.com/nuBuilder/nuBuilder- ... master.zip
What version of nuBuilder are you using?
Try the latest from Github:
https://github.com/nuBuilder/nuBuilder- ... master.zip
-
- Posts: 2
- Joined: Mon Mar 27, 2023 8:27 pm
- nuBuilder Version: 4.5
Re: Problem when creating database
Hi,
Great thanks ; it works now with your new version 4.5
Sincerely
Great thanks ; it works now with your new version 4.5
Sincerely