Open-School

soulconnect · April 17, 2016, 3:37am

Hi

I tried to go to open-school.org/pricing but server down or domain expired.

One question also, is it possible to register more than one Institution (School or Campus)?

traprajith · May 18, 2016, 11:06am

Sorry for the late reply.

let me know your email id, I will forward the details.

traprajith · May 18, 2016, 11:09am

Ovais:

I am receiving the following error on step 2 of installation of open school

include(mysqli.php): failed to open stream: No such file or directory

/var/www/html/openschool/core/YiiBase.php(421)

409 {

410 foreach(self::$_includePaths as $path)

411 {

412 $classFile=$path.DIRECTORY_SEPARATOR.$className.’.php’;

413 if(is_file($classFile))

414 {

415 include($classFile);

416 break;

417 }

418 }

419 }

420 else

421 include($className.’.php’);

422 }

423 else // class name with namespace in PHP 5.3

424 {

425 $namespace=str_replace(’\\’,’.’,ltrim($className,’\\’));

426 if(($path=self::getPathOfAlias($namespace))!==false)

427 include($path.’.php’);

428 else

429 return false;

430 }

431 return class_exists($className,false) || interface_exists($className,false);

432 }

433 return true;

Stack Trace

#0

/var/www/html/openschool/core/YiiBase.php(421): YiiBase::autoload()

#1

unknown(0): YiiBase::autoload("mysqli")

#2

–

/var/www/html/openschool/protected/modules/Install/controllers/DefaultController.php(140): spl_autoload_call("mysqli")

135 $model->attributes=$_POST[‘ConfigForm’];

136 $model->password=$_POST[‘ConfigForm’][‘password’];

137 if($model->validate() === true) {

138 if($model->checkConnection() !== true) {

139 //Attemting To Create The Database

140 $conn = new mysqli($model->host, $model->username, $model->password);

141 $sql = "CREATE DATABASE $model->dbName";

142 if ($conn->query($sql) === TRUE) {

143 $flag_db_created = 1;

144 } else {

145 $flag_db_created = 0;

#3

/var/www/html/openschool/core/web/actions/CInlineAction.php(50): DefaultController->actionStep2()

#4

/var/www/html/openschool/core/web/CController.php(300): CInlineAction->runWithParams(array("r" => "Install/default/step2"))

#5

/var/www/html/openschool/core/web/CController.php(278): CController->runAction(CInlineAction)

#6

/var/www/html/openschool/core/web/CController.php(257): CController->runActionWithFilters(CInlineAction, array())

#7

/var/www/html/openschool/core/web/CWebApplication.php(277): CController->run("step2")

#8

/var/www/html/openschool/core/web/CWebApplication.php(136): CWebApplication->runController("Install/default/step2")

#9

/var/www/html/openschool/core/base/CApplication.php(158): CWebApplication->processRequest()

#10

–

/var/www/html/openschool/install.php(40): CApplication->run()

35

36 // remove the following line when in production mode

37 defined(‘YII_DEBUG’) or define(‘YII_DEBUG’,true);

38 require_once($yii);

39

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

Thanks.

Hello,

Our Community edition is built with PHP5.x , so I think PHP7 may cause such errors.

But Our Premium version is compatible with latest PHP.

https://open-school.org/pricing

traprajith · May 18, 2016, 11:10am

yes we have Multi-School version.

Please Contact with our sales team or let me know your email id.

traprajith · May 18, 2016, 11:11am

https://open-school.org/pricing

[size="6"]Open-School 2.5 Released[/size]

Try here http://tryopenschool.com/

ibon · November 12, 2016, 5:55am

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for ‘activity_time’. The SQL statement executed was:

–

– Database: os_important

–

– Table structure for table activity_feed

–

CREATE TABLE IF NOT EXISTS activity_feed (

id int(11) NOT NULL AUTO_INCREMENT,

initiator_id int(11) NOT NULL,

activity_type int(11) NOT NULL,

goal_id int(11) DEFAULT NULL,

goal_name varchar(120) DEFAULT NULL,

field_name varchar(120) DEFAULT NULL,

initial_field_value varchar(120) DEFAULT NULL,

new_field_value varchar(120) DEFAULT NULL,

activity_time timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’ ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

C:\wamp\www\aquatechschoolmanagement\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

–

C:\wamp\www\aquatechschoolmanagement\protected\modules\Install\controllers\DefaultController.php(222): CDbCommand->execute()

217 //create db schema

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

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

220 foreach ($sqlArr as $script) {

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

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

223 }

224

225 //insert example data

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

227 if (isset($_POST[‘example’]) === true) {

#1

C:\wamp\www\aquatechschoolmanagement\core\web\actions\CInlineAction.php(50): DefaultController->actionStep3()

#2

C:\wamp\www\aquatechschoolmanagement\core\web\CController.php(300): CInlineAction->runWithParams(array("r" => "Install/default/step3"))

#3

C:\wamp\www\aquatechschoolmanagement\core\web\CController.php(278): CController->runAction(CInlineAction)

#4

C:\wamp\www\aquatechschoolmanagement\core\web\CController.php(257): CController->runActionWithFilters(CInlineAction, array())

#5

C:\wamp\www\aquatechschoolmanagement\core\web\CWebApplication.php(277): CController->run("step3")

#6

C:\wamp\www\aquatechschoolmanagement\core\web\CWebApplication.php(136): CWebApplication->runController("Install/default/step3")

#7

C:\wamp\www\aquatechschoolmanagement\core\base\CApplication.php(158): CWebApplication->processRequest()

#8

–

C:\wamp\www\aquatechschoolmanagement\install.php(40): CApplication->run()

35

36 // remove the following line when in production mode

37 defined(‘YII_DEBUG’) or define(‘YII_DEBUG’,true);

38 require_once($yii);

39

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

traprajith · November 23, 2016, 9:25am

Did you solved this issue?

traprajith · April 21, 2017, 7:26am

https://open-school.org/pricing

[size="7"]Open-School 2.5.5 Released[/size]

Try here http://tryopenschool.com/

Sourav2017 · December 24, 2017, 8:13am

Hello Rajith, I am trying to install the free community version 2.2.3

I have installed WAMP.

I am having following error while installing. Please help

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for ‘lastvisit_at’. The SQL statement executed was:

– --------------------------------------------------------

–

– Table structure for table users

–

CREATE TABLE IF NOT EXISTS users (

id int(11) NOT NULL AUTO_INCREMENT,

username varchar(20) DEFAULT NULL,

password varchar(128) DEFAULT NULL,

email varchar(128) DEFAULT NULL,

activkey varchar(128) NOT NULL DEFAULT ‘’,

create_at timestamp NULL DEFAULT NULL,

lastvisit_at timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’,

superuser int(1) NOT NULL DEFAULT ‘0’,

status int(1) NOT NULL DEFAULT ‘0’,

PRIMARY KEY (id),

UNIQUE KEY email (email),

UNIQUE KEY username (username),

KEY status (status),

KEY superuser (superuser)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

C:\wamp\www\core\db\CDbCommand.php(336)

324 return $n;

325 }

326 catch(Exception $e)

327 {

328 if($this-&gt;_connection-&gt;enableProfiling)

329 Yii::endProfile(‘system.db.CDbCommand.execute(’.$this-&gt;getText().’)’,‘system.db.CDbCommand.execute’);

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

331 $message = $e-&gt;getMessage();

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

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

334 if(YII_DEBUG)

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

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

337 array(’{error}’=&gt;$message)),(int)$e-&gt;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=&gt;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

– C:\wamp\www\protected\modules\Install\controllers\DefaultController.php(222): CDbCommand-&gt;execute()

217 //create db schema

218 $sql = $this-&gt;getSql($this-&gt;module-&gt;structuresPath);

219 $sqlArr = $this-&gt;splitQueries($sql);

220 foreach ($sqlArr as $script) {

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

222 $result = $connection-&gt;createCommand($script)-&gt;execute();

223 }

224

225 //insert example data

226 $dataPath = $this-&gt;module-&gt;dataPath;

227 if (isset($_POST[‘example’]) === true) {

#1

C:\wamp\www\core\web\actions\CInlineAction.php(50): DefaultController-&gt;actionStep3()

#2

C:\wamp\www\core\web\CController.php(300): CInlineAction-&gt;runWithParams(array(&quot;r&quot; =&gt; &quot;Install/default/step3&quot;))

#3

C:\wamp\www\core\web\CController.php(278): CController-&gt;runAction(CInlineAction)

#4

C:\wamp\www\core\web\CController.php(257): CController-&gt;runActionWithFilters(CInlineAction, array())

#5

C:\wamp\www\core\web\CWebApplication.php(277): CController-&gt;run(&quot;step3&quot;)

#6

C:\wamp\www\core\web\CWebApplication.php(136): CWebApplication-&gt;runController(&quot;Install/default/step3&quot;)

#7

C:\wamp\www\core\base\CApplication.php(158): CWebApplication-&gt;processRequest()

#8

– C:\wamp\www\install.php(40): CApplication-&gt;run()

35

36 // remove the following line when in production mode

37 defined(‘YII_DEBUG’) or define(‘YII_DEBUG’,true);

38 require_once($yii);

39

40 Yii::createWebApplication($config)-&gt;run();

traprajith · March 28, 2018, 6:03am

[size="7"]New Community Edition released.[/size]

[size="6"]With latest Open-School Premium version[/size]

Source Forge

https://sourceforge.net/projects/php-open-school/files/latest/download?source=navbar

GitHub repository

samdark · April 2, 2018, 9:25am

Would you please add it to https://yiipowered.com/en? Thanks.

traprajith · July 4, 2018, 6:55am

Sure

traprajith · July 4, 2018, 7:14am

New Listing @ https://yiipowered.com/en/projects/536/open-school

traprajith · July 4, 2018, 7:24am

[size="7"]Latest version 2.7 released[/size]

traprajith · December 10, 2018, 7:13am

New Version will be released soon.

kgmm · December 13, 2018, 11:24am

How do you store clients data? Does your application use multi-tenant architecture with separate databases for tenants?

traprajith · January 24, 2019, 5:13am

Yes, having separate database for each tenant.

traprajith · June 13, 2020, 1:11pm

Open-School v3.0 Multi-School version has been released.

More details at - https://open-school.org/multischool

traprajith · February 15, 2022, 6:54am

[Update] We are planning to rewrite the Open-School using Yii3.

mwaigichuhi · February 24, 2022, 10:36am

Hi @traprajith,

I am developing an enterprise open source app framework here https://github.com/logicent/yii2-crudle perhaps we can collaborate where possible.

I would be interested to know what plans you have from an architectural stand-point notwithstanding the target app domain.

Regards,

Ken