Unknown column 'mail.links_language' in 'field list'

jamirae

Hi.. I'm getting this error whenever I try to start a new campaign. It seems to have come in with a recent update. I checked my database integrity and get this message:

Column links_language missing in #__acym_mail
[ERROR]Could not add the column links_language on the table #__acym_mail : Row size too large. 
The maximum row size for the used table type, not counting BLOBs, is 8126. 
This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

Anyone know how to resolve this? Do I need to make some changes to my table in PhpMyAdmin?

running version AcyMailing Essential 6.10.2 on Joomla 3.9.18
thanks in advance!

jvstratum

Hi,

Have you tried to run a database integrety check? You can find this in Configuration->Security onm the bottom of the page.

jamirae

jvstratum -- LOL. that was the message I got when I ran the check 😆

mihha

Hello,

It seems that the mail table is too large for your database. You could try editing the table xxx_acym_mail and change the size of the "type" column from 200 to 30, then process the "Check database integrity" again to add the links_language column

Regards,
Igor

desun

mihha so...., we need an official patch to change the some column type to BLOB or TEXT in order to insert the new cloumn ‘links_language’ to this table.

jamirae

mihha thanks.. I did some research on StackExchange and discovered the problem was in the MYSQL server configuration which I cannot change being on a shared hosting plan. I have AcyMailing 6 installed on a different account with a different hosting provider and no issues with that. Compared the tables and saw that the links_language field is set at varchar(50).

So, using your advice, I changed the length of one of the other varchar fields that are all set to 255. Dont think they need to be that long, so I changed the "bcc" field to 200, then ran the "check database integrity" again and voila! it worked. Thank you!

desun

the same for me, i tried mihha said, not resolved.

jamirae

desun this didn't work for you? did you re-run the database integrity check after changing the field size in *_acym_mail?

desun

jamirae resolved, perfect! thank you!

jvstratum

Hi,

Glad you were able to solve this and to share the solution. Enjoy your Acymailing!

degagee

jamiraes answer worked for me too, changed "bcc" to "200" and the problem disappeared, THANKS!