Open-School

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