Row size too large

Im getting
1118 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 when I save

And I get
1062 Duplicate entry '0-1-first-aid-' for key 'idx_client_id_parent_id_alias_language'
When I saved a lesson category

I also get this error
Oops!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY u.id' at line 4

I have been getting errors for a while?
I thought I broke something in the comprofiler table? I had to get one from another database to replace it?
Could this be the datetime columns not using NULL default yet. ?

How do I fix this (syntax) with phpmyadmin?

(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use)

Thanks

You've hit the row size limit for your database. There is no workaround for that. You have to reduce the size of the row or you are not going to be able to create new fields. It's likely due to the collation being wrong, but you can't change the collation due to SQL_MODE blocking you from doing so due to zero dates not being allowed. I don't have any other workaround other than globally turning off blocking of zero dates. Run the following query in phpmyadmin.


Once done use the operation again as instructed below.

www.joomlapolis.com/forum/153-professional-member-support/244233-row-size-too-large?start=0#326053

See if this reduced row size and if you can create new fields again. I can't comment on your other database issues as they aren't related to CB.

Can you tell me how and the exact place to put
SET GLOBAL sql_mode = ''; I dont want to break anything.

please
In phpmyadmin

Thanks

It's a query you run directly under the SQL tab when viewing your database.

Im getting error when I run the query

SET GLOBAL sql_mode = ''
MySQL said: Documentation

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

How do I fix this
Thanks

Your database user doesn't have enough permissions to set it. Contact your host regarding this.

1062 Duplicate entry '0-1-first-aid-' for key 'idx_client_id_parent_id_alias_language'
When I saved a lesson category

That's on a Joomla table. Specifically the _menu table. You may have some Joomla core database structure issues. Looks like you're trying to save a menu item with an alias that already exists? I'm not sure.