View Single Post
xyle
Junior Member
Join Date: Dec 2012
Location: Nevada
Old 12-22-2012 , 23:47   Re: Weird MYSQL 1146 Error
Reply With Quote #8

Thanks for the input I really appreciate it!

Maybe in the tutorial for setting up hlxstats for windows, someone may want to add a line in there about doing the following before the install.sql is imported into the database...
- After wamp or zamp is installed and running
- Stop the MySQL service
- Open the My.ini file for editing
- add the line "lower_case_table_names=0" without quotes to the end of the file, if the var is not present
- save the file
- restart the MySQL service in wamp or zamp

Doing this will insure the capitalization remains in the tables when the install.sql file is imported.

I scrubbed my old stats and did this so the database is the same between my windows server and the linux server.

Thanks!!
xyle is offline