Anope IRC Services

Anope Support => 2.0.x/1.9.x Support => Topic started by: Paul on November 16, 2017, 03:38:08 PM

Title: Mysql error
Post by: Paul on November 16, 2017, 03:38:08 PM

Hi guys probably something really stupid im missing but need ya help to resolve this issue when i oper up i get this error msg but not sure how to fix

Code: [Select]

M_SQL_OPER: Expected column named "opertype" but one was not found
i understand the error theres no column named opertype in the table but does it auto add it or do i do it manually if so what do i add please

thx in advance

Title: Re: Mysql error
Post by: CrazyCat on November 17, 2017, 09:41:27 AM

Did you enable the m_sql_oper module ?
If yes, I think you didn't read the comments:

Quote

This module allows granting users services operator privileges and possibly IRC Operator privileges based on an external SQL database using a custom query.

It means you must have your own table (not an anope one) which must have an opertype field and account name or ip address.