ERROR: "The database connection was not found"

Scriptcase 8 Discussion
#1

ERROR: The database connection was not found, contact the system administrator. Connection: conn_mysql

After using SC tools/express edit to turn on Security for all applications except the login I get the above error. I have since used the same process to remove security from all applications but the error remains. I had also just deployed the app (on the same server) if that gives any clues.

I hope someone has seen this before and knows how to direct me to fix it because I am dead in the water right now.
Thanks, Bill

#2

Where do you get this error? In dev or prod? If it is after deployment then setup your connection. yoururl/_lib Most likely you’re connection was deleted somehow. If it is in dev then probabely your connection was lost. Go to edit connection to check and setup a new one if necessary. If it’s also lost at your applications you can use the express edit to correct all apps in one go. Hope this helps.

#3

Hello aducom,
Thanks for the quick response. It is my development environment. I have edited the connection and all looks well there, testing connection is successful. I have also created a new connection and used express edit to apply this to all applications and still get the same error.
I appreciate your assistance with this issue very much.

#4

This might be helpful. After I created the new connection 'conn_mysql_1’ and applied it to all apps and regenerated source for all apps. I ran just one app and I received the same error but it is showing the connection as ‘conn_mysql’ not ‘conn_mysql_1’.

#5

UPDATE: I have created a new project with a unique connection name and a simple form app.
I get this error message when trying to run it.
Fatal error[SIZE=12px]: Call to a member function GetTag() on null in[/SIZE]/home/bwwalker/public_html/scriptcase/devel/class/generator/nmFontePHPForm.class.php[SIZE=12px]on line [/SIZE]13621

#6

UPDATE: None of my other projects will run in SC Development either all get same or similar error messages.

#7

It looks like you have a corrupt installation then. Best thing I can think of is the following:

create a full binary backup of your scriptcase folder, so on the directory xcopy to somewhere else, so you can easily recover if things go bad. Then create a full backup of your projects from within scriptcase. Next re-install scriptcase. Request for a new serial if you have to. Try to create a new project and see if the problem persists. If not, restore your backup’ed projects.

#8

UPDATE: I can deploy the project that does not work in DEV, re-make the production connection and all works well in PROD.
It is just SC DEV that is not working

#9

Aducom, I host SC on Hoo.st so I guess I will have to get them involved as I cannot do the re-install myself.
Thanks for your advise. I will report back the results.

#10

Yes, in that case you need support from them. Hope that they can resolve the issue fast for you.

#11

Hoos.st support has me back up and running smoothly. Very quickly too I must say.I have not heard what the exact issue was but hopefully that will come later.
Thanks for your help Aducom in determining a course to resolution.

#12

That’s why we are here for :wink:

#13

Well seems the issue was not SC or Hoo. They (Hoo) said it was a caching issue. Now I only run SC in one browser (Chrome) and everything else in say Firefox. So I can completely shut down Chrome from time to time avoiding the cache issue. Seems to be working.

#14

In general: if you are using different sessions within one browser then you will mix up the cookies. It’s not gonna work. Major sample of this is to have an administrator session in one tab and a user session in another. Therefore we always use different browsers.