Yii - 手动设置模型的表名

Question

I wrote my own, little admin script in Yii. Made and tested on localhost, works fine.

Now, when I've transferred my files to a hosting environment, I get errors like:

'The table `News` for active record class `News` cannot be found in the database.'

It happens, because Yii is looking for 'News' table, while in the database there is only a lower-cased news one.

I think there are some settings in MySQL that makes my db tables case sensitive or something. Anyway I can't change these settings, as I don't own the server.

Yii inherits table name from class name, is there any way to change it? Like assing some new table name to some variable? Couldn't find the solution.

Thanks

Answer 1

You should keep your table name as lower case. Because in Windows the case sensitive of table never change. Once you put the script in Linux it 'll change all to lower case.. every hosting might be a Linux server ... So keep it in mind.