Yii Framework Forum: Bug Cdbhttpsession.php? - Yii Framework Forum

Jump to content

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

Bug Cdbhttpsession.php? failed to create session table Rate Topic: -----

#1 User is offline   rootbear 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 222
  • Joined: 17-June 11

Posted 21 February 2013 - 03:07 PM

error:

Quote

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Column, parameter, or variable #3: Cannot find data type BLOB.. The SQL statement executed was: CREATE TABLE [tbl_session] (
[id] CHAR(32) PRIMARY KEY,
[expire] int,
[data] BLOB
)


to fix: at line 141 in CDbHttpSession.php, added

elseif($driver==='sqlsrv')
  $blob='TEXT';

I enjoy the Yii.sy coding life here.
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