Hello,
On 03/22/2017 08:51 PM, Teijo wrote:
> Hello,
>
> Unfortunately patch did not solve the problem.
>
> As to SQLite3 versions, Ubuntu 16.04 it is
> SQLite version 3.11.0 2016-02-15 17:29:24
> and in Jessie
> SQLite version 3.8.7.1 2014-10-29 13:59:56
There are two similar places in sql-sqlite.c
Please make sure to fix the SQLite3 (rather than SQLite2) code branch:
case SQLITE_ERROR:
sqlite3_finalize(pStmt);
udm_snprintf(db->errstr, sizeof(db->errstr),
"sqlite3 driver: (%d) %s",
sqlite3_errcode(UdmSQLite3Conn(db)),
sqlite3_errmsg(UdmSQLite3Conn(db)));
if (!strstr(db->errstr,"unique") && !strstr(db->errstr,"UNIQUE"))
{
UdmSetErrorCode(db, 1);
return UDM_ERROR;
}
return UDM_OK;
break;
>
> Best regards,
>
> Teijo
>
> 22.3.2017, 16:52, Alexander Barkov kirjoitti:
>
>> Hello Teijo,
>>
>>
>> SQLite changed the error message in one of the recent releases,
>> from "unique" in lower case to "UNIQUE" in upper case.
>>
>>
>> Please apply this patch to src/sql-sqlite.c:
>>
>>
>>
>> - if (!strstr(db->errstr,"unique"))
>> + if (!strstr(db->errstr,"unique") &&
>> !strstr(db->errstr,"UNIQUE"))
>>
>>
>>
>>
>>
>>
>> On 03/22/2017 06:39 PM, Alexander Barkov wrote:
>>> Hello Teijo,
>>>
>>>
>>> On 03/22/2017 03:44 PM, Teijo wrote:
>>>> Hello,
>>>>
>>>> I have installed Mnogosearch 3.4.1 from source both to Ubuntu 16.04 and
>>>> Debian Jessie.
>>>>
>>>> In Ubuntu I cannot use Mysql as database because there seem to be some
>>>> compatibility issues with Mysql 5.7. In Jessie where Mysql version is
>>>> 5.5x there are no such problems.
>>>>
>>>> I thought to use Sqlite3 in Ubuntu. Database setup goes without errors
>>>> with indexer --create. But when I try to make index with simply typing
>>>> indexer, I get similar to the following:
>>>>
>>>> [33572]{--} indexer from mnogosearch-3.4.1-sqlite3 started with
>>>> '/usr/local/mnogosearch/etc/indexer.conf'
>>>> [33572]{01} Error: 'DB: sqlite3 driver: (19) UNIQUE constraint failed:
>>>> url.url'
>>>>
>>>> There seem to be similar problems with Sqlite3 in Jessie as well.
>>>>
>>>> I am not familiar with Mnogosearch and Sqlite3 so is there something I
>>>> have missed when setting up the environment? Only changes I have
>>>> made in
>>>> indexer.conf are Dbaddress and server definitions. Dbaddress is just
>>>> that it's in the example of Sqlite3 definition in indexer.conf-dist.
>>>
>>> Which exact version of SQLite are you using?
>>>
>>>
>>> Can you please send your indexer.conf and the output for:
>>>
>>> ./indexer --sqlmon --exec="SELECT rec_id, url FROM url"
>>>
>>> to b...@mnogosearch.org
>>>
>>> Thanks.
>>>
>>>
>>>
>>>>
>>>> Best regards,
>>>>
>>>> Teijo
>>>> _______________________________________________
>>>> General mailing list
>>>> General@mnogosearch.org
>>>> http://lists.mnogosearch.org/listinfo/general
>>> _______________________________________________
>>> General mailing list
>>> General@mnogosearch.org
>>> http://lists.mnogosearch.org/listinfo/general
>>>
> _______________________________________________
> General mailing list
> General@mnogosearch.org
> http://lists.mnogosearch.org/listinfo/general
_______________________________________________
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general
