OPNsense Forum

English Forums => Sensei => Topic started by: Antaris on May 30, 2021, 04:39:22 pm

Title: Whitelist problem
Post by: Antaris on May 30, 2021, 04:39:22 pm
With this version comes tabbed White/Black lists.
When I'm trying to add domain it returns:

"1220 - SQLite3..prepare(). Unable to prepare statement. 1, table custom_web_category_sites has no column named category_type (errno=2)"

with no success to add the domain.
Title: Re: Whitelist problem
Post by: sy on May 31, 2021, 04:30:30 pm
Hi Antaris,

Please run the following commands;

echo -n "alter table custom_web_category_sites add category_type TEXT default 'domain'"| /usr/local/bin/sqlite3 /usr/local/sensei/userdefined/config/settings.db

then

echo -n "update custom_web_category_sites set category_type='domain' where category_type = ''"| /usr/local/bin/sqlite3 /usr/local/sensei/userdefined/config/settings.db

Title: Re: Whitelist problem
Post by: Antaris on June 02, 2021, 06:49:06 am
Hi sy,

There is a improvement: it not returns error, but domains are still not shown in the list:
Title: Re: Whitelist problem
Post by: sy on June 02, 2021, 03:05:15 pm
Hi Antaris,

Please send a bug report by selecting sensei config and logs.
Title: Re: Whitelist problem
Post by: Antaris on June 02, 2021, 06:08:39 pm
Full report sent.
Title: Re: Whitelist problem
Post by: Antaris on June 02, 2021, 08:48:19 pm
Solved by Matt via mail.
Last command was:
Code: [Select]
echo -n "alter table custom_web_category_sites add is_global INTEGER default 0"| /usr/local/bin/sqlite3 /usr/local/sensei/userdefined/config/settings.dbIf anyone is in the same situation.