Security module error

Scriptcase 9 General
, ,
#1

Hi, there is my error when i install security module : my database is Mysql and character setting is UTF-8MB4 turkish ci
…
Fatal error: Uncaught mysqli_sql_exception: Specified key was too long; max key length is 1000 bytes in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php:764 Stack trace: #0 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php(764): mysqli_query(Object(mysqli), ‘CREATE TABLE s...', 0) #1 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1169): ADODB_mysqli->_query('CREATE TABLE s…’, false) #2 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1151): ADOConnection->Execute(‘CREATE TABLE s...', false) #3 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(2227): ADOConnection->Execute('CREATE TABLE s…’) #4 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(1981): nmPageSecurityModule2->CreateTables(‘conn_mysql’, 'sec’, ‘N’, ‘N’) #5 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(1896): nmPageSecurityModule2->do_action(Array) #6 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPage.class.php(2471): nmPageSecurityModule2->DisplayContent() #7 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmSite.class.php(96): nmPage->Display() #8 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\base_ini.inc.php(1654): nmSite->Run() #9 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\base_ini.inc.php(2): sg_load(‘68ABBE04C7C5024…’) #10 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\iface\security_module2.php(23): include_once(‘C:\Program File…’) #11 {main} thrown in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php on line 764

i choose before error now my new error is this :

**

Fatacase\prod\third\adodb\drivers\adodb-mysqli.inc.php:764 Stack trace: #0 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php(764): mysqli_query(Object(mysqli), ‘DROP TABLE sec_…’, 0) #1 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1169): ADODB_mysqli->query('DROP TABLE sec…’, false) #2 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1151): ADOConnection->Execute('DROP TABLE sec…’, false) #3 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(2134): ADOConnection->Execute(‘DROP TABLE sec_…’) #4 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(1976): nmPageSecurityModule2->DropTables(‘conn_mysql’, ‘sec_’, ‘N’, ‘N’) #5 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(1896): nmPageSecurityModule2->do_action(Array) #6 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPage.class.php(2471): nmPageSecurityModule2->DisplayContent() #7 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmSite.class.php(96): nmPage->Display() #8 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\base_ini.inc.php(1654): nmSite->Run() #9 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\base_ini.inc.php(2): sg_load(‘68ABBE04C7C5024…’) #10 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\iface\security_module2.php(23): include_once(‘C:\Program File…’) #11 {main} thrown in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php on line 764l error: Uncaught mysqli_sql_exception: Unknown table ‘bimtestdata.sec_settings’ in C:\Program Files\NetMake\v9-php81\wwwroot\script

**

AGAIN !!!
Fatal error: Uncaught mysqli_sql_exception: Specified key was too long; max key length is 1000 bytes in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php:764 Stack trace: #0 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php(764): mysqli_query(Object(mysqli), ‘CREATE TABLE s...', 0) #1 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1169): ADODB_mysqli->_query('CREATE TABLE s…’, false) #2 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1151): ADOConnection->Execute(‘CREATE TABLE s...', false) #3 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(2227): ADOConnection->Execute('CREATE TABLE s…’) #4 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(1981): nmPageSecurityModule2->CreateTables(‘conn_mysql’, 'sec’, ‘N’, ‘N’) #5 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(1896): nmPageSecurityModule2->do_action(Array) #6 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPage.class.php(2471): nmPageSecurityModule2->DisplayContent() #7 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmSite.class.php(96): nmPage->Display() #8 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\base_ini.inc.php(1654): nmSite->Run() #9 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\base_ini.inc.php(2): sg_load(‘68ABBE04C7C5024…’) #10 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\iface\security_module2.php(23): include_once(‘C:\Program File…’) #11 {main} thrown in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php on line 764

#2

Fatal error: Uncaught Swift_RfcComplianceException: Address in mailbox given [adictus60277] does not comply with RFC 2822, 3.6.2. in C:\Program Files\NetMake\v9-php73\wwwroot\scriptcase\prod\third\swift\classes\Swift\Mime\Headers\MailboxHeader.php:348 Stack trace: #0 C:\Program Files\NetMake\v9-php73\wwwroot\scriptcase\prod\third\swift\classes\Swift\Mime\Headers\MailboxHeader.php(263): Swift_Mime_Headers_MailboxHeader->_assertValidAddress(‘adictus60277’) #1 C:\Program Files\NetMake\v9-php73\wwwroot\scriptcase\prod\third\swift\classes\Swift\Mime\Headers\MailboxHeader.php(106): Swift_Mime_Headers_MailboxHeader->normalizeMailboxes(Array) #2 C:\Program Files\NetMake\v9-php73\wwwroot\scriptcase\prod\third\swift\classes\Swift\Mime\Headers\MailboxHeader.php(63): Swift_Mime_Headers_MailboxHeader->setNameAddresses(Array) #3 C:\Program Files\NetMake\v9-php73\wwwroot\scriptcase\prod\third\swift\classes\Swift\Mime\SimpleMimeEntity.php(592): Swift_Mime_Headers_MailboxHeader->setFieldBodyModel(Array) #4 C:\Program Files\NetMake\v9-php7 in C:\Program Files\NetMake\v9-php73\wwwroot\scriptcase\prod\third\swift\classes\Swift\Mime\Headers\MailboxHeader.php on line 348

#3

Dear,

Please, if possible, tet us know if the reported errors still persist in the latest version of Scriptcase (9.10.001).

Best regards!

#4

Yes, it is in latest version . but i fix this error. Now i have ner error of this in latest version :

**

> Fatal error: Uncaught mysqli_sql_exception: Duplicate entry ‘session_expire’ for key ‘guv_settings.PRIMARY’ in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php:764 Stack trace: #0 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php(764): mysqli_query(Object(mysqli), ‘INSERT INTO guv…’, 0) #1 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1169): ADODB_mysqli->_query(‘INSERT INTO guv…’, false) #2 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1151): ADOConnection->_Execute(‘INSERT INTO guv…’, false) #3 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(1882): ADOConnection->Execute(‘INSERT INTO guv…’) #4 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(4981): nmPageSecurityModule2->addSettings(Object(ADODB_mysqli)) #5 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(4805): nmPageSecurityModule2->populateUsr(Object(ADODB_mysqli)) #6 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(1674): nmPageSecurityModule2->populateGrp(Object(ADODB_mysqli)) #7 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(567): nmPageSecurityModule2->populate(Object(ADODB_mysqli)) #8 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(113): nmPageSecurityModule2->generate_step(‘4’) #9 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(71): nmPageSecurityModule2->CheckAjax() #10 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmSite.class.php(95): nmPageSecurityModule2->__construct() #11 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\base_ini.inc.php(1654): nmSite->Run() #12 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\base_ini.inc.php(2): sg_load(‘68ABBE04C7C5024…’) #13 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\iface\security_module2.php(23): include_once(‘C:\Program File…’) #14 {main} thrown in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php on line 764

**

#5

Hi new eror from latest version security module :slight_smile:

Fatal error: Uncaught mysqli_sql_exception: Duplicate entry ‘session_expire’ for key ‘sec_settings.PRIMARY’ in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php:764 Stack trace: #0 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php(764): mysqli_query(Object(mysqli), ‘INSERT INTO sec…’, 0) #1 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1169): ADODB_mysqli->_query(‘INSERT INTO sec…’, false) #2 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1151): ADOConnection->_Execute(‘INSERT INTO sec…’, false) #3 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(1882): ADOConnection->Execute(‘INSERT INTO sec…’) #4 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(4981): nmPageSecurityModule2->addSettings(Object(ADODB_mysqli)) #5 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(4805): nmPageSecurityModule2->populateUsr(Object(ADODB_mysqli)) #6 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(1674): nmPageSecurityModule2->populateGrp(Object(ADODB_mysqli)) #7 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(567): nmPageSecurityModule2->populate(Object(ADODB_mysqli)) #8 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(113): nmPageSecurityModule2->generate_step(‘4’) #9 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmPageSecurityModule2.class.php(71): nmPageSecurityModule2->CheckAjax() #10 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\page\nmSite.class.php(95): nmPageSecurityModule2->__construct() #11 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\base_ini.inc.php(1654): nmSite->Run() #12 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\base_ini.inc.php(2): sg_load(‘68ABBE04C7C5024…’) #13 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\iface\security_module2.php(23): include_once(‘C:\Program File…’) #14 {main} thrown in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php on line 764

#6

I have the same problem, what did you do to solve it?