spanjeta / yii2-backup Goto Github PK

Exception 'yii\db\Exception' with message '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 'group' at line 1
The SQL being executed was: SHOW CREATE TABLE group'

in /home/vagrant/Code/linet-admin/vendor/yiisoft/yii2/db/Schema.php:636

Error Info:
Array
(
    [0] => 42000
    [1] => 1064
    [2] => 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 'group' at line 1
)

Stack trace:
#0 /home/vagrant/Code/linet-admin/vendor/yiisoft/yii2/db/Command.php(930): yii\db\Schema->convertException(Object(PDOException), 'SHOW CREATE TAB...')
#1 /home/vagrant/Code/linet-admin/vendor/yiisoft/yii2/db/Command.php(376): yii\db\Command->queryInternal('fetch', NULL)
#2 /home/vagrant/Code/linet-admin/vendor/spanjeta/yii2-backup/helpers/MysqlBackup.php(107): yii\db\Command->queryOne()
#3 /home/vagrant/Code/linet-admin/vendor/spanjeta/yii2-backup/commands/BackupController.php(46): spanjeta\modules\backup\helpers\MysqlBackup->getColumns('group')
#4 [internal function]: spanjeta\modules\backup\commands\BackupController->actionCreate()
#5 /home/vagrant/Code/linet-admin/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#6 /home/vagrant/Code/linet-admin/vendor/yiisoft/yii2/base/Controller.php(156): yii\base\InlineAction->runWithParams(Array)
#7 /home/vagrant/Code/linet-admin/vendor/yiisoft/yii2/console/Controller.php(128): yii\base\Controller->runAction('create', Array)
#8 /home/vagrant/Code/linet-admin/vendor/yiisoft/yii2/base/Module.php(523): yii\console\Controller->runAction('create', Array)
#9 /home/vagrant/Code/linet-admin/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction('backup/backup/c...', Array)
#10 /home/vagrant/Code/linet-admin/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction('backup/backup/c...', Array)
#11 /home/vagrant/Code/linet-admin/vendor/yiisoft/yii2/base/Application.php(380): yii\console\Application->handleRequest(Object(yii\console\Request))
#12 /home/vagrant/Code/linet-admin/yii(17): yii\base\Application->run()
#13 {main}

 	/* Added by CARDA Consultants Inc., Daniel Pineault */
	public function actionDownload()
	{
	    $file=Yii::$app->request->get('file');
	    $path=Yii::$app->request->get('path');
	    if (file_exists($path.$file)) {
	    	return Yii::$app->response->sendFile($path.$file);
	    } else {
	    	throw new \yii\web\NotFoundHttpException("{$file} is not found!");
	    }
	}

<?php
use yii\helpers\Html;
use yii\grid\GridView;
use yii\helpers\Url;

echo GridView::widget ( [ 
		'id' => 'install-grid',
		'dataProvider' => $dataProvider,
		'columns' => array (
				'name',
				'size:shortSize',
				'create_time:datetime',
				array (
						'header' => 'Actions',
						'class' => 'yii\grid\ActionColumn',
						'template' => '{restore} {download} {delete}', /* Modified by CARDA Consultants Inc., Daniel Pineault	*/
						'buttons' => [ 
								'delete' => function ($url, $model) {
									return Html::a ( '<span class="glyphicon glyphicon-remove"></span>', $url, [ 
											'title' => Yii::t ( 'app', 'Delete this backup' ) ,
											'data' => [
								                'confirm' => 'Are you sure you want to delete this backup?',  /* Added by CARDA Consultants Inc., Daniel Pineault	*/
								                'method' => 'post',
								            ],
									] );
								},
								
								'restore' => function ($url, $model) {
									return Html::a ( '<span class="glyphicon glyphicon-save"></span>', $url, [ 
											'title' => Yii::t ( 'app', 'Restore this backup' ) ,
											'data' => [
								                'confirm' => 'Are you sure you want to restore this version of your database and permanently crush any existing data?',  /* Added by CARDA Consultants Inc., Daniel Pineault	*/
								                'method' => 'post',
								            ],
									] );
								},

								/* Added by CARDA Consultants Inc., Daniel Pineault	*/
								'download' => function ($url, $model) {
									return Html::a ( '<span class="glyphicon glyphicon-cloud-download"></span>', $url, [ 
											'title' => Yii::t ( 'app', 'Download this backup' ),
											'data-method'=>'post',
									] );
								} 
						],
						'urlCreator' => function ($action, $model, $key, $index) {
							
								$url = Url::toRoute ( [ 
										'default/' .$action,
										'file' => $model ['name'] ,
										'path'=>\Yii::getAlias('@backend').'/db/' /*Added by CARDA Consultants Inc., Daniel Pineault */
								] );
								return $url;
							
						} 
				)
				 
		) 
] );
?>

public function addslashesFix($val)
{
    if ($val === null)
    {
        return null;
    }
    else
    {
        return "$val";
    }
}

foreach ($dataReader as $data)
    {
        $itemNames = array_keys($data);
        $itemNames = array_map("app\utiles\Backup::addslashesFix", $itemNames);
        $items = join('`,`', $itemNames);
        $itemValues1 = array_values($data);
        $itemValues2 = array_map("app\utiles\Backup::addslashesFix", $itemValues1);
        $valueString1 = json_encode($itemValues2);
        $valueString2 = str_replace("[", "(", $valueString1);
        $valueString3 = str_replace("]", ")", $valueString2);
        $values = "\n" . $valueString3;
        if ($values != "")
        {
            $data_string .= "INSERT INTO `$tableName` (`$items`) VALUES" . rtrim($values, ",") . ";" . PHP_EOL;
        }
    }

Database Exception – yii\db\Exception
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
The SQL being executed was: SELECT * FROM `auth_assignment` WHERE `user_id`='1'