Hi
I set my WAF to manage Global Blocking and I received this debug when users login the front end - see below.
I was surprised to find an upper case being used in the table name.
I corrected it by renaming the xxxx_ip2nationcountries table with an uppercase 'C' to match the table name in the SQL. I am using amazon RDS not a local MySQL, it has tables with a collation of latin1_swedish_ci. I think RDS tables are case sensitive, is this because of the collation? If I change the collation will this allow non-case sensitive SQL statements, what should I change it to (for a basic GB-english site)?
500 - JDatabaseMySQL::query: 1146 - Table 'bitnami_joomla.xxxx_ip2nationCountries' doesn't exist SQL=SELECT i.country FROM xxxx_ip2nationCountries c, xxxx_ip2nation i WHERE i.ip < INET_ATON("my.ip.address") AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1
I set my WAF to manage Global Blocking and I received this debug when users login the front end - see below.
I was surprised to find an upper case being used in the table name.
I corrected it by renaming the xxxx_ip2nationcountries table with an uppercase 'C' to match the table name in the SQL. I am using amazon RDS not a local MySQL, it has tables with a collation of latin1_swedish_ci. I think RDS tables are case sensitive, is this because of the collation? If I change the collation will this allow non-case sensitive SQL statements, what should I change it to (for a basic GB-english site)?
500 - JDatabaseMySQL::query: 1146 - Table 'bitnami_joomla.xxxx_ip2nationCountries' doesn't exist SQL=SELECT i.country FROM xxxx_ip2nationCountries c, xxxx_ip2nation i WHERE i.ip < INET_ATON("my.ip.address") AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1
