noalyss-commit
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Noalyss-commit] [noalyss] 196/323: Fix SQL


From: Dany De Bontridder
Subject: [Noalyss-commit] [noalyss] 196/323: Fix SQL
Date: Wed, 14 Mar 2018 17:38:48 -0400 (EDT)

sparkyx pushed a commit to branch master
in repository noalyss.

commit ed461f9d549a098416474813359c3ec4409f5143
Author: Dany De Bontridder <address@hidden>
Date:   Sat Feb 10 23:12:26 2018 +0100

    Fix SQL
---
 html/install.php                        | 2 +-
 include/sql/account_repository/data.sql | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/html/install.php b/html/install.php
index 0e414a1..c770c84 100644
--- a/html/install.php
+++ b/html/install.php
@@ -526,7 +526,7 @@ if ($account == 0 ) {
   
$cn->execute_script(NOALYSS_INCLUDE."/sql/account_repository/constraint.sql");
   /* update name administrator */
   $cadmin=NOALYSS_ADMINISTRATOR;
-  $cn->exec_sql("update ac_users set use_login=$1 where use_id=1",
+  $cn->exec_sql("update ac_users set use_login=$1,use_active=1 where use_id=1",
               array(strtolower($cadmin)));
 
   $cn->commit($cn);
diff --git a/include/sql/account_repository/data.sql 
b/include/sql/account_repository/data.sql
index 7cd908d..c97cbde 100644
--- a/include/sql/account_repository/data.sql
+++ b/include/sql/account_repository/data.sql
@@ -11,7 +11,7 @@ SET client_min_messages = warning;
 
 
 INSERT INTO ac_users (use_id, use_first_name, use_name, use_login, use_active, 
use_pass, use_admin, use_email) VALUES (4, 'demo', 'demo', 'demo', 0, 
'fe01ce2a7fbac8fafaed7c982a04e229', 0, NULL);
-INSERT INTO ac_users (use_id, use_first_name, use_name, use_login, use_active, 
use_pass, use_admin, use_email) VALUES (1, NULL, NULL, 'admin', 0, 
'b1cc88e1907cde80cb2595fa793b3da9', 1, NULL);
+INSERT INTO ac_users (use_id, use_first_name, use_name, use_login, use_active, 
use_pass, use_admin, use_email) VALUES (1, NULL, NULL, 'admin', 1, 
'b1cc88e1907cde80cb2595fa793b3da9', 1, NULL);
 
 
 



reply via email to

[Prev in Thread] Current Thread [Next in Thread]