Yii Framework Forum: CDbException:CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]:... - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

CDbException:CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]:... Base table or view not found: 1146 Table 'X_mts.AuthAssignment Rate Topic: -----

#1 User is offline   KBG 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 2
  • Joined: 18-April 12

Posted 18 April 2012 - 01:08 AM

I am using the latest yii framework yii-1.1.10.r3566.tar.gz
I did not have problems in my developing setup (windows 7, latest XAMPP 1.7.7)
but when I deployed my webapp to remote site ( I am using justhost linux env ... )
I got errors

CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'XXXX_mts.AuthAssignment' doesn't exist

I searched this issue from the web ,, there were similar issues in the previous yii too.. can not get solution ....

did I do anything wrong ..!

does anyone have good solutions ..? thx

I believe it is a bug ....


-KBG
0

#2 User is offline   Maurizio Domba Cerin 

  • Yii - Yesss It Is !!!
  • Yii
  • Group: Yii Dev Team
  • Posts: 4,317
  • Joined: 12-October 09
  • Location:Croatia

Posted 18 April 2012 - 03:42 AM

This is one of the most common error when changing from case insensitive OS like windows to a case sensitive OS like linux... check the case of your table it should be "AuthAssignment" - note the case.
Find more about me.... btw. Do you know your WAN IP?
0

#3 User is offline   KBG 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 2
  • Joined: 18-April 12

Posted 18 April 2012 - 04:58 AM

thx..
I am looking into the function where I can use php's strtolower function ...to handle it ...
anyone has any idea where should I added strtolower ...
-kbg
0

#4 User is offline   Maurizio Domba Cerin 

  • Yii - Yesss It Is !!!
  • Yii
  • Group: Yii Dev Team
  • Posts: 4,317
  • Joined: 12-October 09
  • Location:Croatia

Posted 18 April 2012 - 05:07 AM

try to set this property to all lowercase - http://www.yiiframew...entTable-detail

you will probably need to do the same for

http://www.yiiframew...ildTable-detail

and

http://www.yiiframew...temTable-detail
Find more about me.... btw. Do you know your WAN IP?
0

#5 User is offline   marianzburlea 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 6
  • Joined: 03-June 12
  • Location:London

Posted 11 September 2012 - 06:17 AM

I run this SQL and it works just fine:
RENAME TABLE `authassignment` TO `AuthAssignment` ;

Company profile: http://smartyii.co.uk
0

#6 User is offline   Entreated 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 4
  • Joined: 05-August 13

Posted 21 August 2013 - 07:53 AM

View PostMaurizio Domba, on 18 April 2012 - 03:42 AM, said:

This is one of the most common error when changing from case insensitive OS like windows to a case sensitive OS like linux... check the case of your table it should be "AuthAssignment" - note the case.



Thanks for this!
Sorted my errors out from 'development using wamp on windows' to going 'live on a linux server'.
Used a a few capitalizations in rule components for table names.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users