Camel Case

I've been having a problem for a while with the servers (localhost with Xampp) and remote not finding files that are obviously right where they are supposed to be. I read in another post that Camel Case file names and in general can be an issue.

Unfortunately I have used this throughout my project.

My questions are: Is this a problem or is it just a red herring that has nothing to do with my problem? If it is an issue, does anyone have a work around?

Hi Rod,

Camel Case should not be an issue. I have used it and even Wappler itself uses it. Spaces will cause headaches.

Can you ive an example of a file name you are having issues with?

Thanks for getting back to me Brad. Here is what I see in Developer Tools in Chrome:



This is from my page in Wappler:

Wappler file structure showing the query file in API:

And the file structure on my remote site:

There is some error with your serve action. Please check:

This is what comes back:

Just took a look at the page through localhost and it's even worse


Drops the actual file folder from path for all of the Wapper generated files.

Yet this is the setup for Localhost:


Test connection says everything works. BTW, when I add the folder under Local Folder it never holds it. Finds it. I save and then go back and it's gone.

I dont use XAMPP but I use MAMP that is almost the same. Insead of localhost you need to use the Localhost IP that commonly is 127.0.0.1. But you need to enable access XAMPP via ip.

And I see that a lot of files are missing to publish or move in the server.

I will look into this. Thanks Chackmool

Makes no difference. Dang.

Well this happens as locally you are working in a subfolder in the server root, and your links are set up relative to site root. Your server root is http://localhost so links are relative to it.

Curiously I changed the base href to ../ and the files are all found. However, I have one last error. This is from the Chrome developer tool:
file: D:\Inetpub\vhosts\rodgilchrist.com\httpdocs\promotables\dmxConnectLib\lib\db\Connection.php
Line: 105
Message: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: No such host is known.

You can simply change the site links to document relative in the project settings and resave the pages. Don't edit the base href.

This error means there is something wrong with your database connection. For example wrong address entered.

This is what I get when I go into the Globals and test my connection:
image

Where is your database located? Is it the same hosting as the server your site runs on? How do you connect to it? Does it allow remote connections?

The database (MySql) is hosted by the same company that hosts my site in Canada. I connect to it using the Wappler interface. Everything shows up in the Database Manager. I see all my tables. When I test the queries they return the expected results. Is this what you mean?

That error message talks about (e.g.) mod_security, Wappler is not connecting to the DB directly, but rather some PHP file of the Wappler framework to run a test query

Edit: Forget it Teodor, I thought you were replying to his last message literally :sweat_smile:

I can access the db through both phpMyAdmin and dbForge Studio no problem.

Please contact your hosting provider and ask them for the correct database connection details that you need to use.
Testing connection directly from the Globals might not work if they have some restrictions running, but the connection from your server when you upload the site should work when using the correct connection details.