1
cadch
Re: where utf8mb4 protector table can not creat
  • Yesterday 15:50

  • cadch

  • Just popping in

  • Posts: 32

  • Since: 2007/12/17


OR SET KEY LENGTH:
CREATE TABLE log (
  
lid mediumint(8unsigned NOT NULL auto_increment,
  
uid mediumint(8unsigned NOT NULL default 0,
  
ip varchar(255NOT NULL default '0.0.0.0',
  
type varchar(255NOT NULL default '',
  
agent varchar(255NOT NULL default '',
  
description text,
  
extra text,
  
timestamp DATETIME,
  
PRIMARY KEY (lid) ,
  
KEY (uid) ,
  
KEY (ip(128)) ,
  
KEY (type(250)) ,
  
KEY (timestamp)
ENGINE=MyISAM;

CREATE TABLE access (
  
ip varchar(255NOT NULL default '0.0.0.0',
  
request_uri varchar(255NOT NULL default '',
  
malicious_actions varchar(255NOT NULL default '',
  
expire int NOT NULL default 0,
  
KEY (ip(128)),
  
KEY (request_uri(250)),
  
KEY (malicious_actions(250)),
  
KEY (expire)
ENGINE=MyISAM;



2
cadch
where utf8mb4 protector table can not creat
  • Yesterday 10:47

  • cadch

  • Just popping in

  • Posts: 32

  • Since: 2007/12/17


where mysql CHARACTER SET utf8mb4 have some errorQuote:
Creating tables...Specified key was too long; max key length is 1000 bytes

FILE:
Quote:
\htdocs\xoops_lib\modules\protector\sql\mysql.sql

CODE:
CREATE TABLE log (
  
lid mediumint(8unsigned NOT NULL auto_increment,
  
uid mediumint(8unsigned NOT NULL default 0,
  
ip varchar(255NOT NULL default '0.0.0.0',
  
type varchar(255NOT NULL default '',
  
agent varchar(255NOT NULL default '',
  
description text,
  
extra text,
  
timestamp DATETIME,
  
PRIMARY KEY (lid) ,
  
KEY (uid) ,
  
KEY (ip) ,
  
KEY (type) ,
  
KEY (timestamp)
ENGINE=MyISAM;

CREATE TABLE access (
  
ip varchar(255NOT NULL default '0.0.0.0',
  
request_uri varchar(255NOT NULL default '',
  
malicious_actions varchar(255NOT NULL default '',
  
expire int NOT NULL default 0,
  
KEY (ip),
  
KEY (request_uri),
  
KEY (malicious_actions),
  
KEY (expire)
ENGINE=MyISAM;

EDIT:
CREATE TABLE log (
  
lid mediumint(8unsigned NOT NULL auto_increment,
  
uid mediumint(8unsigned NOT NULL default 0,
  
ip varchar(128NOT NULL default '0.0.0.0',
  
type varchar(250NOT NULL default '',
  
agent varchar(255NOT NULL default '',
  
description text,
  
extra text,
  
timestamp DATETIME,
  
PRIMARY KEY (lid) ,
  
KEY (uid) ,
  
KEY (ip) ,
  
KEY (type) ,
  
KEY (timestamp)
ENGINE=MyISAM;

CREATE TABLE access (
  
ip varchar(128NOT NULL default '0.0.0.0',
  
request_uri varchar(250NOT NULL default '',
  
malicious_actions varchar(250NOT NULL default '',
  
expire int NOT NULL default 0,
  
KEY (ip),
  
KEY (request_uri),
  
KEY (malicious_actions),
  
KEY (expire)
ENGINE=MyISAM;

OR:(use utf8mb3)
CREATE TABLE log (
  
lid mediumint(8unsigned NOT NULL auto_increment,
  
uid mediumint(8unsigned NOT NULL default 0,
  
ip varchar(255CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default '0.0.0.0',
  
type varchar(255CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default '',
  
agent varchar(255NOT NULL default '',
  
description text,
  
extra text,
  
timestamp DATETIME,
  
PRIMARY KEY (lid) ,
  
KEY (uid) ,
  
KEY (ip) ,
  
KEY (type) ,
  
KEY (timestamp)
ENGINE=MyISAM;

CREATE TABLE access (
  
ip varchar(255CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default '0.0.0.0',
  
request_uri varchar(255CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default '',
  
malicious_actions varchar(255CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default '',
  
expire int NOT NULL default 0,
  
KEY (ip),
  
KEY (request_uri),
  
KEY (malicious_actions),
  
KEY (expire)
ENGINE=MyISAM;



3
cadch
Re: XoopsCore25-2.5.11-Beta1 On PHP Version 8.0.13 protector some error,get_magic_quotes_gpc() returns undefined
  • Yesterday 10:38

  • cadch

  • Just popping in

  • Posts: 32

  • Since: 2007/12/17


ok



4
cadch
XoopsCore25-2.5.11-Beta1 On PHP Version 8.0.13 installer page_moduleinstaller.php some error, Undefined constant "_AM_SYSTEM_DBUPDATED"
  • 2021/12/3 15:06

  • cadch

  • Just popping in

  • Posts: 32

  • Since: 2007/12/17


FILE:
Quote:
htdocs\install\page_moduleinstaller.php

MOVE THE CODE TO LINE 25
if (!@include_once "../modules/system/language/{$wizard->language}/admin.php") {
    include_once 
'../modules/system/language/english/admin.php';
}

OR LINE 21 ADD
define('_AM_SYSTEM_DBUPDATED''Database Updated Successfully!');



5
cadch
XoopsCore25-2.5.11-Beta1 On PHP Version 8.0.13 installer page_theme.php some error, Undefined constant "_AM_SYSTEM_DBUPDATED"
  • 2021/12/3 15:00

  • cadch

  • Just popping in

  • Posts: 32

  • Since: 2007/12/17


FILE:
Quote:
\htdocs\install\page_theme.php

LINE:43 ADD
if (!@include_once "../modules/system/language/{$wizard->language}/admin.php") {
    include_once 
'../modules/system/language/english/admin.php';
}

OR ADD
define('_AM_SYSTEM_DBUPDATED''Database Updated Successfully!');



6
cadch
XoopsCore25-2.5.11-Beta1 On PHP Version 8.0.13 uploader.php some error, get_magic_quotes_gpc() returns undefined
  • 2021/12/3 14:27

  • cadch

  • Just popping in

  • Posts: 32

  • Since: 2007/12/17


FILE:
Quote:
\htdocs\class\uploader.php

LINE:234
$this->mediaName = @get_magic_quotes_gpc() ? stripslashes($_FILES[$media_name]['name'][$index]) : $_FILES[$media_name]['name'][$index];

CHANGE TO:
$this->mediaName $_FILES[$media_name]['name'][$index];



LINE:249
$this->mediaName = @get_magic_quotes_gpc() ? stripslashes($media_name['name']) : $media_name['name'];

CHANGE TO:
$this->mediaName $media_name['name'];



7
cadch
XoopsCore25-2.5.11-Beta1 On PHP Version 8.0.13 installer some error, get_magic_quotes_gpc() returns undefined
  • 2021/12/3 14:18

  • cadch

  • Just popping in

  • Posts: 32

  • Since: 2007/12/17


FILE:
Quote:
\htdocs\class\module.textsanitizer.php

LINE:523
if (!@get_magic_quotes_gpc()) {
            
$text addslashes($text);
        }

chang to
$text addslashes($text);



LINE:797
if (@get_magic_quotes_gpc()) {
            
$text stripslashes($text);
        }

DEL THE CODE
Because some installer used function addSlashes,On PHP 8.0.13 installer Can not continue.



8
cadch
XoopsCore25-2.5.11-Beta1 On PHP Version 8.0.13 protector some error,get_magic_quotes_gpc() returns undefined
  • 2021/12/3 14:12

  • cadch

  • Just popping in

  • Posts: 32

  • Since: 2007/12/17


\htdocs\xoops_lib\modules\protector\class\protector.php
LINE:627
$val = @get_magic_quotes_gpc() ? stripslashes($val) : $val;

DEL THE LINE.



9
cadch
XoopsCore25-2.5.11-Beta1 On PHP Version 8.0.13 installer some error, Undefined constant XOOPS_VAR_PATH
  • 2021/12/3 14:05

  • cadch

  • Just popping in

  • Posts: 32

  • Since: 2007/12/17


When https://XOOPS_URL/install/index.php
have error
Quote:
Fatal Error Undefined constant "XOOPS_VAR_PATH" file: /home/sc/public_html/include/license.php : 24

Edit
\htdocs\install\include\common.inc.php
LINE:63
ADD
if (!defined('XOOPS_VAR_PATH')) {
    
define('XOOPS_VAR_PATH''');
}



10
cadch
Re: lostpass.php Have some error,On user by Gmail
  • 11/24 2:54

  • cadch

  • Just popping in

  • Posts: 32

  • Since: 2007/12/17


Yes,But my Code not smart~




TopTop
(1) 2 »



Login

Username:
Password:

Lost Password? Register now!

Who's Online

56 user(s) are online (37 user(s) are browsing Support Forums)


Members: 0


Guests: 56


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Dec 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits