Page 1 of 1

Cloner Error : Connection to the nuBuilder database failed: SQLSTATE[HY000] [1049] Unknown database 'fc_dev'

Posted: Fri Sep 29, 2023 2:01 pm
by kernowquack
I have created a form which I would like to clone using Database>>Cloner. I have created a Cloner 'Job' when I try and run the job I get the following error:-
Connection to the nuBuilder database failed: SQLSTATE[HY000] [1049] Unknown database 'fc_dev'

Verify and update the settings in nuconfig.php

Restart your browser after modifying nuconfig.php in order for changes to be reflected

nuconfig.php settings:

Code: Select all

	$nuConfigDBHost					= "127.0.0.1";				
	$nuConfigDBName					= "fc_builder";				
	$nuConfigDBPort					= 3306;
phpMyAdmin shows that the fc_builder database exists and I have been creating, running and editing forms etc without and problems so far so am at a loss as to what is happening.

I have:
Restarted Browser(after every troubleshooting step)
Cleared Browser Cache
Restarted Apache
Restarted MariaDB
Edited nuconfig.php (removed $ConfigDBName and re-entered, then saved)

Any help will be greatly appreciated

Re: Cloner Error : Connection to the nuBuilder database failed: SQLSTATE[HY000] [1049] Unknown database 'fc_dev'

Posted: Fri Sep 29, 2023 2:16 pm
by kev1n
Hi,

Somehow, the database 'fc_dev' is used in the Cloner. Where is this database set? IIRC, the cloner is using the connection details in nuconfig.php

Re: Cloner Error : Connection to the nuBuilder database failed: SQLSTATE[HY000] [1049] Unknown database 'fc_dev'

Posted: Mon Oct 02, 2023 12:53 pm
by kernowquack
Hi,
Thanks for the reply, I have worked around the problem atm by recreating the forms I was trying to clone. I will however continue to investigate in case someone else has the same problem.

Cheers

Re: Cloner Error : Connection to the nuBuilder database failed: SQLSTATE[HY000] [1049] Unknown database 'fc_dev'

Posted: Thu Oct 12, 2023 4:06 pm
by kernowquack
Hi,
Sorry for the delay, life happened :)

System
Windows 11 2H22
Chrome Browser: Version 117.0.5938.152 (Official Build) (64-bit)
Opera GX: LVL5 (core: 102.0.4880.90) Chromium version:116.0.5845.188

What I have found so far is this.
On Chrome I deleted all cookies using the browser's built in function. Problem Not Fixed
Deleted Chrome cookies using Glary Utilities. Problem Fixed
I then went to the Opera GX browser which still had the error. In Opera GX I have the Cookie Editor extension installed. On the home page logged in as globeadmin, I looked in Cookie Editor and saw that there was just a session cookie. Nor really thinking deleting that cookie would make much difference I deleted it anyway. I then restarted browser and logged in as globeadmin and cloner started working. I have no idea what deleting the session cookie did but it worked. For better brains than mine to workout :)

So if someone else gets this error clear cookies seems to work.
Thanks Kev1n