PHP Warning: SQLSTATE[42S02]: Base table or view table not found: 1146

Hello Gibbon Team,
First of all, I should thank you guys for the hard work you put into creating Gibbon. My problem is with the database.
I have a gibbon installation on my laptop (Windows 10, WAMP), and I worked on it and populated it with data. Then after I was satisfied that all data is as they should I moved my gibbon installation on to my hosted server. I successfully imported the database and moved the gibbon file via FTP with no issues. Now nothing works, I get a blank page when I try to reach my gibbon on the hosted server. I rolled up my sleeves and began looking around for about a week to look for the problem. In the apache2 error logs, I find the titled description above. I verified that the MySQL server works and I can reach it, and the database credentials work. In the first line of the logs, I can see that the table ‘gibbonSetting’ does not exist but in the imported database, I can see the table ‘gibbonsetting’ but not ‘gibbonSetting’. Now knowing Linux is a case sensitive environment I wondered why this issue. My laptop has the table ‘gibbonsetting’ and not ‘gibbonSetting’. I did not change any code in the gibbon files so I did some digging around. There is a variable on the MySQL server ‘lower_case_table_names’ that has a value different for my hosted server and my Windows environment. The MySQL documentation says that in a Linux environment the value of this variable can only be set once prior to MySQL’s installation and can not be changed. Please team how do I get my gibbon working?

Hi @tejumann ,

Welcome to the Gibbon community.

I faced the same problem but thanks to @ross who guided me to fix and here is the thread for you.

https://ask.gibbonedu.org/discussion/2289/database-backup-from-local-host-to-cpanel#latest

Hi @tejumann ,

Welcome to the Gibbon community.

I faced the same problem but thanks to @ross who guided me to fix and here is the thread for you.

https://ask.gibbonedu.org/discussion/2289/database-backup-from-local-host-to-cpanel#latest

Hello ghulamabbas92,
Thank you very much. Unfortunately, this did not work for me. When I changed the value of the variable from 1 to 2 and ran Sandra’s script on my DB there were no changes to the table names from small case to camel case. I did this several times but nothing worked. I did notice that my MySQL client (Workbench 8.0 CE ) gave a warning that the variable has changed and will cause problems. My server is version 5.7. Out of frustration, I exported Gibbon’s DB into a file, wrote a small Java program that takes the correct table names in Sandra’s script, and changes the table names in the DB’s exported script into that found in Sandra’s. I then imported the edited script into my hosted server and now Gibbon works just fine. I double-checked the imported tables and found some tables are still in small case and this is as a result of some tables are not found in Sandra’s script. I will correct these manually in the edited script and reimport. The number of tables left to be corrected is about 20.

I am grateful to you and Sandra for her script.