Team Room

[Matheus]

Hey everyone,

A new tool is available on the site called Team Room. You can use it like a forum between you and your bigbrother/bigsister, also developers with the same bb can talk amongs each other through the Team Room posts and their comments.

Feel free to use it, and please report me any bugs. I will be on correct them as soon as possible.

Thanks,
Matheus

[Miha Petelin]

Well, so far it appears to be empty, to me at least.

Whenever I select a person from dropdown lists, I get the following error:

Error 500: <h1>CDbException</h1>
<p>CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user_id=40)' at line 1. The SQL statement executed was: SELECT COUNT(*) FROM `tbl_trpost` `t` WHERE ((deleted=0) AND (user_id != -1 AND 1)) AND (added_by=:ycp0 user_id=40). Bound with :ycp0='36' (/c2/yii-1.1.10.r3566/framework/db/CDbCommand.php:528)</p><pre>#0 /c2/yii-1.1.10.r3566/framework/db/CDbCommand.php(425): CDbCommand->queryInternal('fetchColumn', 0, Array)
#1 /c2/yii-1.1.10.r3566/framework/db/ar/CActiveRecord.php(1536): CDbCommand->queryScalar()
#2 /c2/yii-1.1.10.r3566/framework/web/CActiveDataProvider.php(179): CActiveRecord->count(Object(CDbCriteria))
#3 /c2/yii-1.1.10.r3566/framework/web/CDataProvider.php(193): CActiveDataProvider->calculateTotalItemCount()
#4 /c2/yii-1.1.10.r3566/framework/web/CActiveDataProvider.php(129): CDataProvider->getTotalItemCount()
#5 /c2/yii-1.1.10.r3566/framework/web/CDataProvider.php(137): CActiveDataProvider->fetchData()
#6 /c2/yii-1.1.10.r3566/framework/zii/widgets/CBaseListView.php(105): CDataProvider->getData()
#7 /c2/yii-1.1.10.r3566/framework/zii/widgets/grid/CGridView.php(269): CBaseListView->init()
#8 /c2/yii-1.1.10.r3566/framework/web/CBaseController.php(148): CGridView->init()
#9 /c2/yii-1.1.10.r3566/framework/web/CBaseController.php(173): CBaseController->createWidget('zii.widgets.gri...', Array)
#10 /c2/site/protected/views/trpost/user_posts.php(89): CBaseController->widget('zii.widgets.gri...', Array)
#11 /c2/yii-1.1.10.r3566/framework/web/CBaseController.php(127): require('/c2/site/protec...')
#12 /c2/yii-1.1.10.r3566/framework/web/CBaseController.php(96): CBaseController->renderInternal('/c2/site/protec...', Array, true)
#13 /c2/yii-1.1.10.r3566/framework/web/CController.php(870): CBaseController->renderFile('/c2/site/protec...', Array, true)
#14 /c2/site/protected/views/trpost/admin.php(36): CController->renderPartial('user_posts', Array)
#15 /c2/yii-1.1.10.r3566/framework/web/CBaseController.php(127): require('/c2/site/protec...')
#16 /c2/yii-1.1.10.r3566/framework/web/CBaseController.php(96): CBaseController->renderInternal('/c2/site/protec...', Array, true)
#17 /c2/yii-1.1.10.r3566/framework/web/CController.php(870): CBaseController->renderFile('/c2/site/protec...', Array, true)
#18 /c2/yii-1.1.10.r3566/framework/web/CController.php(783): CController->renderPartial('admin', Array, true)
#19 /c2/site/protected/controllers/TrpostController.php(272): CController->render('admin', Array)
#20 /c2/yii-1.1.10.r3566/framework/web/actions/CInlineAction.php(50): TrpostController->actionAdmin()
#21 /c2/yii-1.1.10.r3566/framework/web/CController.php(309): CInlineAction->runWithParams(Array)
#22 /c2/yii-1.1.10.r3566/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(CInlineAction))
#23 /c2/yii-1.1.10.r3566/framework/web/filters/CFilter.php(41): CFilterChain->run()
#24 /c2/yii-1.1.10.r3566/framework/web/CController.php(1146): CFilter->filter(Object(CFilterChain))
#25 /c2/yii-1.1.10.r3566/framework/web/filters/CInlineFilter.php(59): CController->filterAccessControl(Object(CFilterChain))
#26 /c2/yii-1.1.10.r3566/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#27 /c2/yii-1.1.10.r3566/framework/web/CController.php(292): CFilterChain->run()
#28 /c2/yii-1.1.10.r3566/framework/web/CController.php(266): CController->runActionWithFilters(Object(CInlineAction), Array)
#29 /c2/yii-1.1.10.r3566/framework/web/CWebApplication.php(276): CController->run('admin')
#30 /c2/yii-1.1.10.r3566/framework/web/CWebApplication.php(135): CWebApplication->runController('trpost/admin')
#31 /c2/yii-1.1.10.r3566/framework/base/CApplication.php(162): CWebApplication->processRequest()
#32 /c2/site/index.php(25): CApplication->run()
#33 {main}</pre>

[Matheus]

Thanks for your feedback!

I corrected the code, so it displayes the accurate count of posts on your sidebar and even filtering is working now.

PS.: In your Team Room environment there aren't any posts to be displayed.

[James Gillmore]

Is the dropdown thing fixed? I seems developers should only be able to post to their team room or respond to private messages. In that case the dropdown isn't needed at all. The dropdown is only needed for developers if we want to give them the feature to privately message more managers and admins then their big bro. I don't think we need that. They can just post to the team room and their sibblings can see it. It provides a community atmosphere everyone can learn from. 

So in short for the developer user remove the dropdown and infer the user's action to be posting to his own team room. And for private messages he can only respond to messages. Actually remove that feature. And for big bro users make it so there is no dropdown as well; and no personals grid. They can only post to their team. Less is more because less complications mean more people use the tools. Private messages can be accomplished through user profile to dos or in a rare case via email. For the admin and manager users, have only a dropdown to choose the teamroom, and of course remove the personal grid as well.

Don't worry we will one day add ur private message feature back, but in a separate unrelated page. And maybe with autocomplete instead of a user dropdown like gmail. And with an inbox and outbox grid. The link to this section would be in the nav bar.

--
 
 

[Matheus Simon]

Done. Only Non-Provate posts exist.

2012/9/6 James Gillmore <jamesg...@gmail.com>

--