default table prefix to '' (empty)

Archives Feature Requests
1

Hi,

I’ve noticed that if no tablePrefix is declared on the DB component, table name resolution fails, and table ‘{{myatble}}’ is not found. To solve this, just declare an empty tablePrefix value.


		'db'=>array(

			'connectionString' => 'mysql:host=localhost;dbname=mydb',

			'emulatePrepare' => true,

			'enableParamLogging'=> true,

			'enableProfiling'=> true,

			'username' => 'user',

			'password' => '*******',

			'charset' => 'utf8',

			'tablePrefix' => '',	// <- here !

		),

It would be nice that even if no tablePrefix is declared, table name resolution would work by default like if it was declared as an empty string otherwise it become difficult to write a module dedicated to be distributed and that would integrate in the target app db.

Thanks

B)

2

Did you create a ticket for it? :)

3

http://code.google.com/p/yii/issues/detail?id=1834

4

oups … I did not see this ticket.

Ok so this is not considered as an acceptable feature request and not a bug… I’ll have to work a little bit more before releasing a module that includes tables and integrates ‘gracefully’.

B)

5

Had this same problem with one of my extensions, but i can live with declaring the table prefix to just an empty string, even though is not looking too nice.