Support Forums - All Posts - XOOPS Web Application System

511

Re: wg modules

2022/1/8 18:21
alain01
Just can't stay away
Posts: 530
Since: 2003/6/20

Thank you Goffy for you good job on awesome modules !

What about the wgblocks ?
Admin managment of blocks ?
Please, give us some information about this module.

Alain

512

Re: wg modules

2022/1/5 15:15
heyula
Theme Designer
Posts: 594
Since: 2008/4/24

Thanks for all the great modules.

513

Re: wg modules

2022/1/5 13:53
Mamba
Moderator
Posts: 11375
Since: 2004/4/23

Awesome work!!!

Thank you for the updates and for all your hard work to keep the modules current!

Happy New Year to you and your family as well!

Resized Image

Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

514

wg modules

2022/1/4 8:46
goffy
Just can't stay away
Posts: 535
Since: 2010/12/27

Hi

first of all: happy new year to everyone :)

all my wg modules are uptodate now:
- wgdiaries
- wggallery
- wggithub
- wgsimpleacc
- wgsitenotice
- wgteams
- wgtimelines
- wgtransifex
- wgblocks

all modules are ready for PHP 8

Requirements:
- XOOPS 2.5.11 Beta 1;
- XOOPS Admin 1.2;
- PHP 7.4 or higher;
- MySQL 5.5;

Tests:
PHP 8.0
MariaDB 10.4.10
MySql 8.0.16
Apache 2.4.41

Demos:
Various demos you can find onhttps://xoops.wedega.com

Translation:
German language files are mostly included, but you can find them also onhttps://www.myxoops.org/modules/wgtransifex/
For most of the modules you can find translations on Transifexhttps://www.transifex.com/xoops

Please help testing and report bugs as issues onhttps://github.com/

515

Happy Holidays & Happy New Year

2021/12/24 16:39
Mamba
Moderator
Posts: 11375
Since: 2004/4/23

[size=x-large]Wishing everybody Happy Holidays and Happy New Year!!!

Your XOOPS Team[/size]

Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

516

Tag 2.35.0 Beta 4

2021/12/16 0:45
Mamba
Moderator
Posts: 11375
Since: 2004/4/23

XOOPS Tag 2.35.0 Beta 4 released for testing/contributions!

The Tag module is designed for site-wide tag management, handling tag input, display and stats for each module that enables tag plugin.

DOWNLOAD: https://github.com/mambax7/tag/releases

FORK:https://github.com/mambax7/tag/

ISSUES/BUGS: Please report all issues on GitHub

REQUIREMENTS:
- XOOPS 2.5.10
- PHP 7.3+

It was tested on PHP 7.4.26 and PHP 8.1.0

New in this release:

- refactor tagBar() function into a class (mamba)
- various cosmetics (mamba)
- trigger_error() (mamba)
- fixed update_stats(): replaced ADD with AND in $criteria->add(new \Criteria('tag_modid', $modid), 'ADD'); (mamba)
- reversed missing tag_modid in getByLimit() (mamba)
- updated sample.php (mamba)
- reversed some changes in blocks.php (mamba)
- lowered limit_cloud_list from 100 to 10 (mamba)
- added xmnews plugin (mage)
- updated instructions for creating a plugin (mage)
- fix: when using the tags for the first time, the id was displayed in the field (maga)
- added Blocksadmin (mamba)
- PHP 8.1 cosmetics and type hinting (mamba)
- $module_name in tag_index.tpl (alain01/mamba)
- fix for int required in TagHandler (alain01/mamba)https://github.com/mambax7/tag/issues/12
- added pull for summary for Publisher (alain01/mamba)
- deleted include/functions.php (mamba)
- fixed bug Number of tags (alain01/mamba)https://github.com/mambax7/tag/issues/13
- fixed bug in tag_block_cloud.php (alain01/mamba)https://github.com/mambax7/tag/issues/15
- deleted /test folder (alain01/mamba)https://github.com/mambax7/tag/issues/17
- commented out the code for the new flash cumules block (alain01/mamba)
- added Bootstrap 4 templates ((alain01) (see the /extra folder)

Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

517

Re: where utf8mb4 protector table can not creat

2021/12/9 17:47
zyspec
Module Developer
Posts: 1095
Since: 2004/9/21

Thanks for the information.

As you stated above, the current code looks like:


CREATE TABLE log (

  lid mediumint(8) unsigned NOT NULL auto_increment,

  uid mediumint(8) unsigned NOT NULL default 0,

  ip varchar(255) NOT NULL default '0.0.0.0',

  type varchar(255) NOT NULL default '',

  agent varchar(255) NOT 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(255) NOT NULL default '0.0.0.0',

  request_uri varchar(255) NOT NULL default '',

  malicious_actions varchar(255) NOT NULL default '',

  expire int NOT NULL default 0,

  KEY (ip),

  KEY (request_uri),

  KEY (malicious_actions),

  KEY (expire)

) ENGINE=MyISAM;

Can you try the following to see if it resolves the issue you're seeing? As you have determined the keys are too long for MySQL 8. I've made some minor changes to what you've found to attempt to minimize the length of keys where appropriate to cover a majority of the cases. Unfortunately it's difficult to set an exact key length for some of the keys since the length of data in those fields can vary quite a bit.


CREATE TABLE log (

  lid mediumint(8) unsigned NOT NULL auto_increment,

  uid mediumint(8) unsigned NOT NULL default 0,

  ip varchar(255) NOT NULL default '0.0.0.0',

  type varchar(255) NOT NULL default '',

  agent varchar(255) NOT NULL default '',

  description text,

  extra text,

  timestamp DATETIME,

  PRIMARY KEY (lid) ,

  KEY (uid) ,

  KEY (ip (50)) ,

  KEY (type(64)) ,

  KEY (timestamp)

) ENGINE=MyISAM;



CREATE TABLE access (

  ip varchar(255) NOT NULL default '0.0.0.0',

  request_uri varchar(255) NOT NULL default '',

  malicious_actions varchar(255) NOT NULL default '',

  expire int NOT NULL default 0,

  KEY (ip(50)),

  KEY (request_uri(192)),

  KEY (malicious_actions(128)),

  KEY (expire)

) ENGINE=MyISAM;

518

Re: where utf8mb4 protector table can not creat

2021/12/9 13:13
cadch
Just popping in
Posts: 48
Since: 2007/12/17

mySQL 8.0.27-0

519

Re: where utf8mb4 protector table can not creat

2021/12/6 15:31
zyspec
Module Developer
Posts: 1095
Since: 2004/9/21

Can you tell us what version of MySQL you are using?

520

Re: where utf8mb4 protector table can not creat

2021/12/4 15:50
cadch
Just popping in
Posts: 48
Since: 2007/12/17

OR SET KEY LENGTH:


CREATE TABLE log (

  lid mediumint(8) unsigned NOT NULL auto_increment,

  uid mediumint(8) unsigned NOT NULL default 0,

  ip varchar(255) NOT NULL default '0.0.0.0',

  type varchar(255) NOT NULL default '',

  agent varchar(255) NOT 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(255) NOT NULL default '0.0.0.0',

  request_uri varchar(255) NOT NULL default '',

  malicious_actions varchar(255) NOT NULL default '',

  expire int NOT NULL default 0,

  KEY (ip(128)),

  KEY (request_uri(250)),

  KEY (malicious_actions(250)),

  KEY (expire)

) ENGINE=MyISAM;

Stats
Goal:	$100.00
Due Date:	Jun 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: wg modules

Re: wg modules

Re: wg modules

wg modules

Happy Holidays & Happy New Year

Tag 2.35.0 Beta 4

Re: where utf8mb4 protector table can not creat

Re: where utf8mb4 protector table can not creat

Re: where utf8mb4 protector table can not creat

Re: where utf8mb4 protector table can not creat

Login

Search

Recent Posts

Re: Xlanguage Module - Default Language Issue

Re: Xlanguage Module - Default Language Issue

Re: Xlanguage Module - Default Language Issue

Re: Xlanguage Module - Default Language Issue

Re: Xlanguage Module - Default Language Issue

Re: Xlanguage Module - Default Language Issue

Re: New Admin Theme for XOOPS

Re: New Admin Theme for XOOPS

Re: New Admin Theme for XOOPS

Re: New Admin Theme for XOOPS

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}