XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk


« 1 ... 189 190 191 (192) 193 194 195 ... 29425 »


1911
fabou78
Re: 2.5.10 - User profile won

  • 2019/9/5 15:20

  • fabou78

  • Friend of XOOPS

  • Posts: 43

  • Since: 2012/6/16


Thanks Mamba for your help got it sorted now.

I can update mysql on my server but my hosting provider won't so need to stick to the version I have.
Topic | Forum


1912
Mamba
Re: 2.5.10 - User profile won

  • 2019/9/3 20:34

  • Mamba

  • Moderator

  • Posts: 11377

  • Since: 2004/4/23


No, try changing the line 51 to:

KEY `sort` (`step_order`, `step_name`(240))


The issue is with the MySQL key length limitations: it's 767 bytes is the stated prefix limitation for InnoDB tables in MySQL version 5.6 (and prior versions). It's 1,000 bytes long for MyISAM tables.
In MySQL version 5.7 and upwards this limit has been increased to 3072 bytes.

The indexes worked fine with utf8_unicode_ci, since it uses 3 bytes per character, but when you're using utf8mb4_unicode_ci, you're adding extra byte, as it is using 4 bytes, and you're going over the limit.

MySQL 5.7 avoids the problem. Consider upgrading
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs
Topic | Forum


1913
fabou78
Re: 2.5.10 - User profile won't install when using utf8mb4

  • 2019/9/3 14:01

  • fabou78

  • Friend of XOOPS

  • Posts: 43

  • Since: 2012/6/16


Doing the change as requested moved the problem to table "profile_regstep" (line 43 in same file you mentioned)

So I have then changed
`step_name`       varchar(255)
to
`step_name`       varchar(200)
(line 45) and it installed the module fine.

Do you have an idea on what is going on?
Topic | Forum


1914
Mamba
Re: 2.5.10 - User profile won't install when using utf8mb4

  • 2019/9/3 11:50

  • Mamba

  • Moderator

  • Posts: 11377

  • Since: 2004/4/23


The utf8mb4_unicode_ci is supported, but it looks like it needs more space for the Unique Key than the database has.

So in the Profile's MySQL file (/sql/mysql.sql) change line 30 to something like:

UNIQUE KEY `field_name` (`field_name`(200)),


and try again.

If the problem is still there, go lower with the number, let's say:
175, 150, 125, 100

That should fix the issue.
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs
Topic | Forum


1915
fabou78
2.5.10 - User profile won't install when using utf8mb4

  • 2019/9/3 10:39

  • fabou78

  • Friend of XOOPS

  • Posts: 43

  • Since: 2012/6/16


Setup of the server:
XOOPS Version XOOPS 2.5.10
PHP Version 7.2.22
mySQL Version 5.7.27-0ubuntu0.16.04.1 - (Ubuntu)
OS Linux Ubuntu Server

Creating database at install won't work with my current provider so I need to create database beforehand. The default charset for my provider is utf8mb4_unicode_ci.

When using this, I can't install the user profile module and it is showing the following MySQL related error.
0.000255 - CREATE TABLE profile_field ( `field_id` int(12) unsigned NOT NULL auto_increment, `cat_id` smallint(5) unsigned NOT NULL default '0', `field_type` varchar(30) NOT NULL default '', `field_valuetype` tinyint(2) unsigned NOT NULL default '0', `field_name` varchar(255) NOT NULL default '', `field_title` varchar(255) NOT NULL default '', `field_description` text, `field_required` tinyint(1) unsigned NOT NULL default '0', `field_maxlength` smallint(6) unsigned NOT NULL default '0', `field_weight` smallint(6) unsigned NOT NULL default '0', `field_default` text, `field_notnull` tinyint(1) unsigned NOT NULL default '0', `field_edit` tinyint(1) unsigned NOT NULL default '0', `field_show` tinyint(1) unsigned NOT NULL default '0', `field_config` tinyint(1) unsigned NOT NULL default '0', `field_options` text, `step_id` smallint(3) unsigned NOT NULL default '0', PRIMARY KEY (`field_id`), UNIQUE KEY `field_name` (`field_name`), KEY `step` (`step_id`, `field_weight`) ) ENGINE=MyISAM
Error number: 1071
Error message: Specified key was too long; max key length is 1000 bytes



If I force the database into utf8_general_ci the installation would work fine.

I have read somewhere that since MySQL 5.5.3 is advised.

Is there no support yet for XOOPS runing on utf8mb4_unicode_ci?

I have little understanding of the issue nor the effect of changing character set on database but I ham fully admin on my server so can run any commands for debug if required.

My aim is to reproduce an environment as close as possible to our hosting service for future website migration.
Topic | Forum


1916
goffy
Re: Problem with xNewsletter

  • 2019/8/30 20:07

  • goffy

  • Just can't stay away

  • Posts: 535

  • Since: 2010/12/27


hi

no idea for the moment. can you create an admin login for me and send me the user/pwd by PM?
Topic | Forum


1917
Zap_English
Re: Problem with xNewsletter

I guess the cron job does it

but I'm still getting errors

Error sending newsletter: 5 of 5 newsletters not sent

but there are 15 emails in the list with failed-> Could not instantiate mail function.
Topic | Forum


1918
Zap_English
Re: Problem with xNewsletter

I had them set up a cron job to send 10 every 10 minutes

So do I have to click on the send icon to initiate it, or will cron.php do it?
Topic | Forum


1919
Zap_English
Re: Problem with xNewsletter

I gave my host all the options available in xNewsletter and they told me to use php mail()

And they tell me my limit is 200 emails per hour
Topic | Forum


1920
goffy
Re: Problem with xNewsletter

  • 2019/8/30 10:34

  • goffy

  • Just can't stay away

  • Posts: 535

  • Since: 2010/12/27


Hi

if you work with newsletters you have to take care about a few things:
1) if you use php sendmail function normally the provider has a limit how much you can send per hour/day. you have to look into your website host settings to find out this limit or to contact your hoster.
if you exceed this limit you get "failed-> Could not instantiate mail function."

it seems (what I see in your posting) you exceeded this limit, because once you reached it it doesn't matter whether you want to send 1 or 100 mail

2) if you use existing email via smtp then you have to check the limit of your email account

3) sending in blocks:
if you have e.g. a limit of 100 mails per hour you can set the preference to e.g. 90 every hour.
the first 90 mails are sended immediately, then xnewsletter is waiting for a new call.
the call must be done by cron.php
as XOOPS itself has no cron function you have to set it up e.g. in your hosting package. most of hoster which provides webspace and email provides also the possibility to set up a cron job. This external cron job must call cron.php each hour.
if you are not sure how to set up a cron job then ask your provider, because this is different in the various existing systems

for more information you should also read https://app.gitbook.com/@xoops/s/xnewsletter-tutorial/
Topic | Forum



TopTop
« 1 ... 189 190 191 (192) 193 194 195 ... 29425 »



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

412 user(s) are online (102 user(s) are browsing Support Forums)

Members: 0

Guests: 412

more...

Donat-O-Meter

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

Latest GitHub Commits