Database Error: Table doesnt exist (but it does)

So, me and my colleague have been working on our dolphin installation locally/offline for quite some time now. Recently, we uploaded our latest build onto our server, including the new database, and changed the entries in the header accordingly. Just as an exclaimer: Everything works locally. 
Now, when we try to access pretty much anything, like member.php for example, we get following error:

Query:

SELECT * FROM `Profiles` WHERE `Email`='(censored)' LIMIT 1

Mysql error: Table 'censored.Profiles' doesn't exist

Found error in the file (root)/inc/utils.inc.php' at line 452.
Called 'getRow' function with erroneous argument #0.

(excuse the censoring)

 

What follows is a gigantic error backtrace, containing the above mentioned error over 7000 times. If this doesnt smell like something looping already, I also want to add that my colleague gets a "Allowed memory size exhausted" error on his firefox (not on chrome tho, and I dont get it as well), which only got worse after we increased the memory limit. It's being thrown BxDolDb.php (495), which is part of the backtrace process as far as I saw.

If I peek into the phpmyadmin that we installed (which is accessible) and look at our database, the profiles table actually is right there. Even the requested accounts (the admin account, as I saw in the backtrace) is in that table.

We are completely baffled as to what is going on and have no clue what to do. This problem neither occured on our own PCs nor with the old installation on our server. Any tips on what we could do?

Quote · 30 Jun 2017

I am assuming you were running some sort of server stack on the PC; which one?  How did you transfer the site to the actually server?

Geeks, making the world a better place
Quote · 30 Jun 2017

We use XAMPP on our PCs, then upload via FTP. We've done it before, it never caused this problem, which is why we are so confused right now.

Quote · 30 Jun 2017

Try changing the email in the database for the profile to something simple and then see if it fixes the problem.  Or if you like, you can PM me the actual error message so I can have the full idea of what is happening.  In this case, I need to see what you censored.

Geeks, making the world a better place
Quote · 30 Jun 2017

I just noticed that I cant PM you, as I am currently not a premium member :(
But I dont think the censored stuff would matter all that much, all it was is (in order) the admin-email, the database name, and the root directory. And those are not wrong, they are they same as they've always been.

Quote · 30 Jun 2017

my guess xampp is using profiles and not Profiles ...  another words lower case p.

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 1 Jul 2017

... why does this actually work, I feel really, really stupid right now. 

But good to know SQL is case-sensitive. Learning new stuff everyday.

 

Thanks jay, very much appreciated. Now it throws out another error, but we will tackle that one on monday and hopefully on our own this time ;)

Quote · 1 Jul 2017

your welcome.

 

If you place lower_case_table_names=2 

in your my.ini file for mysql then it will hold the case sensitive table names when you import and export from windows and linux ...  

 

there maybe other table names and columns that are case sensitive in dolphin... 

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 1 Jul 2017

Interesting; I have exported databases using phpMyAdmin from AMPPS stack without it changing the case name.  Could it be the phpMyAdmin version?

Geeks, making the world a better place
Quote · 1 Jul 2017

no its the mysql version on xampp ...  it just defaults to lower case in windows

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 1 Jul 2017
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.