Admin error: You may not name a column "index" because it is a reserved word after moving to MariaDB

[maddmac]

Getting this error on several admin pages after migrating site to MariaDB. Everything else seems to be ok. Any suggestions on finding where this error is occurring and what to do about it? 

 

Thanks in advance 

[BitPoet]

Do you have the old site still running somewhere? If yes, this query should give you the schema and table with the offending column (if it's in fact a column with that name and not some other issue with SQL syntax):

select * from INFORMATION_SCHEMA.columns WHERE column_name = 'index';