Yii Framework Forum

Open-School


(Traprajith) #81

pls rename the folder to a single word like ‘os’ . enable php-curl.

and enable apache rewrite_module

restart ur all server services

make \protected\runtime and \assets folders writable .


(Traprajith) #82

pls rename the folder to a single word like ‘os’ . enable php-curl.

and enable apache rewrite_module

restart ur all server services

make \protected\runtime and \assets folders writable .


(Traprajith) #83

Thank you very much :) :)

i will convey this to our designing team !! :)


(Som2dara) #84

I have some problem while install OpenSchool in step 3 it show the error message like this :

========================

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1289 The ‘InnoDB’ feature is disabled; you need MySQL built with ‘InnoDB’ to have it working. The SQL statement executed was:

– Database: os_new


– Table structure for table additional_exams

CREATE TABLE IF NOT EXISTS additional_exams (

id int(11) NOT NULL AUTO_INCREMENT,

additional_exam_group_id int(11) DEFAULT NULL,

subject_id int(11) DEFAULT NULL,

start_time datetime DEFAULT NULL,

end_time datetime DEFAULT NULL,

maximum_marks int(11) DEFAULT NULL,

minimum_marks int(11) DEFAULT NULL,

grading_level_id int(11) DEFAULT NULL,

weightage int(11) DEFAULT ‘0’,

event_id int(11) DEFAULT NULL,

created_at datetime DEFAULT NULL,

updated_at datetime DEFAULT NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1

C:\wamp\www\osv2.0-CE - Copy\core\db\CDbCommand.php(336)

===========================

What is the solution ?

Thanks.


(Traprajith) #85

That is your Mysql configuration problem

http://codex.galleryproject.org/MySQL:Enabling_InnoDB_on_Windows


(R Alfarizy) #86

I had some problem while install OpenSchool in step 3 it show the error message like this :


  CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1005 Can't create table 'os_new.#sql-405_7d' (errno: 121). The SQL statement executed was:


--

-- Constraints for dumped tables

--


--

-- Constraints for table `authassignment`

--

ALTER TABLE `authassignment`

ADD CONSTRAINT `authassignment_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE


/home/riza/public_html/os/core/db/CDbCommand.php(336)


324             return $n;

325         }

326         catch(Exception $e)

327         {

328             if($this->_connection->enableProfiling)

329                 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().')','system.db.CDbCommand.execute');

330             $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;

331             $message = $e->getMessage();

332             Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',

333                 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');

334             if(YII_DEBUG)

335                 $message .= '. The SQL statement executed was: '.$this->getText().$par;

336             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',

337                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);

338         }

339     }

340 

341     /**

342      * Executes the SQL statement and returns query result.

343      * This method is for executing an SQL query that returns result set.

344      * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative

345      * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing

346      * them in this way can improve the performance. Note that if you pass parameters in this way,

347      * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.

348      * binding methods and  the input parameters this way can improve the performance.


Stack Trace

#0 	

–

 /home/riza/public_html/os/protected/modules/Install/controllers/DefaultController.php(191): CDbCommand->execute()


186                 //create db schema

187                 $sql = $this->getSql($this->module->structuresPath);

188                 $sqlArr =  $this->splitQueries($sql);

189                 foreach ($sqlArr as $script) {

190                     if (preg_match('/(CREATE\s+TABLE|DROP\s+TABLE|ALTER\s+TABLE|CREATE\s+VIEW|DROP\s+VIEW)/i', $script))

191                         $result = $connection->createCommand($script)->execute();

192                 }

193                 

194                 //insert example data

195                 $dataPath = $this->module->dataPath;

196                 if (isset($_POST['example']) === true) {


#1 	

+

 /home/riza/public_html/os/core/web/actions/CInlineAction.php(50): DefaultController->actionStep3()

#2 	

+

 /home/riza/public_html/os/core/web/CController.php(300): CInlineAction->runWithParams(array("r" => "Install/default/step3"))

#3 	

+

 /home/riza/public_html/os/core/web/CController.php(278): CController->runAction(CInlineAction)

#4 	

+

 /home/riza/public_html/os/core/web/CController.php(257): CController->runActionWithFilters(CInlineAction, array())

#5 	

+

 /home/riza/public_html/os/core/web/CWebApplication.php(277): CController->run("step3")

#6 	

+

 /home/riza/public_html/os/core/web/CWebApplication.php(136): CWebApplication->runController("Install/default/step3")

#7 	

+

 /home/riza/public_html/os/core/base/CApplication.php(158): CWebApplication->processRequest()

#8 	

–

 /home/riza/public_html/os/install.php(39): CApplication->run()


34 

35 // remove the following line when in production mode

36 defined('YII_DEBUG') or define('YII_DEBUG',true);

37 require_once($yii);     

38 

39 Yii::createWebApplication($config)->run();

what the solution ?


(Traprajith) #87

completely delete your database. download the app again and try installing.


(Traprajith) #88

New Module

Teachers Portal

Login:teacher

Password:teacher


(Rajuvs1974) #89

Hi Rajith

I just saw OpenSchool website. it is truly fantastic. Actually i am planning to develop a Attendance and Marks Management systems for engineering college. In future i want to make it a community edition also. I want to spread open source to more number of engineering colleges in Andhra Pradesh in which this will be first step. Actually how much time we need to spend on this to develop a complete solution. As i am doing my Ph.D can i complete this task. I hope depending on your experience you can suggest me

Regards


(Traprajith) #90

Thanks :)

Yes you can. we took just 4 months for the first phase with a 5 member team.


(Traprajith) #91

Glad News!!

Our All new Community Edition (Free Version) is Releasing soon :)


(Trond) #92

Awesome.

Is there a feature comparison between the Community edition and the commercial edition somewhere?


(Traprajith) #93

Simply community version includes 5 basic module . Paid version with 21 modules.


(Traprajith) #94

For shared Host like Godaddy

all you need to do is

1 - have a copy of yii framework folder

2 - generate a new yiic webapp folder

3 - upload both folders, the framework folder can go to some hidden place yoursite.com/wawa/framework/yii, and you can just upload the files in your webapp folder to yoursite.com/

4 - edit the index.php in your generated web app, so it know where your framework/yii folder is. than you are set

5 - just make different copy of your webapp folder, so you don’t need to generate them if you dont want to. just use different names, wont make a difference, as long as the webapp index.php knows where your framework folder is, than it will work

Note: our yii folder is /core


(Shashi2235) #95

Is there any documentation for Community version.

I’m unable to use collect fee using community version.

Thanks.


(Traprajith) #96

yes contact us at skype : chat.os


(Mubashar Na K) #97

hi

great software.

i am reporting the error on employes manage section when we apply (present/former) status filter. Below the error detail.

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘is_active’ in ‘where clause’. The SQL statement executed was: SELECT COUNT(*) FROM employees t WHERE is_deleted=:ycp0 and employee_department_id = :employee_department_id and joining_date = :joining_date and is_active = :status. Bound with :ycp0=‘0’, :employee_department_id=‘5’, :joining_, :status=‘1’


(Mubashar Na K) #98

I fixed. :rolleyes:


(Traprajith) #99

in the community edition, right?


(Mubashar Na K) #100

yes in the community edition.