Whitelist problem

[Antaris]

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.

[sy]

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

[Antaris]

Hi sy,

There is a improvement: it not returns error, but domains are still not shown in the list:

[sy]

Hi Antaris,

Please send a bug report by selecting sensei config and logs.

[Antaris]

Full report sent.

[Antaris]

Solved by Matt via mail.
Last command was:

Code Select Expand

echo -n "alter table custom_web_category_sites add is_global INTEGER default 0"| /usr/local/bin/sqlite3 /usr/local/sensei/userdefined/config/settings.db
If anyone is in the same situation.