Hello, I have a problem with SC menus. I edit the connection at Login and when the login control pass the link to the menu, I get this error “An error occurred while connecting to the database:
Access denied for user ‘root’@‘localhost’ (using password: YES)”. If I change the connection of the menu manually, with the new connection, is working. In the past, menus worked very well with all connections. The problem is that I have many users belonging to different connections that are logging at the same URL. How can I solve that?
I’ve seen this happen before, and usually, it’s one of two things causing the headache.
First, double-check that your php.ini has the correct drivers enabled for the database type you’re trying to connect to - sometimes an update can reset those. Also, if you’re working in a local environment, make sure the database host isn’t just set to “localhost”; try using 127.0.0.1 instead, as that sometimes bypasses DNS resolution issues that Scriptcase can be picky about.
If those don’t work, try clearing the Scriptcase /_lib folder cache or regenerating the source code for the menu application. Sometimes the connection metadata gets “stuck” and just needs a fresh compile to recognize the new settings.
Thank you! I would like to mention that all the other apps, grids, forms, and blanks are working just fine. Only the menus have this problem. And… the menus I didn’t refresh and deployed in the lsat year are still working well. After the menu deployment started to block.