In "lib/search_engines.php"
$this->target->whereAdd('notice.is_local != ' . NOTICE_GATEWAY)
NOTICE_GATEWAY is not defined anywhere else in the entire app ..
Is suspect the query should be notice.is_local != 0
Paul Willard
-------------------------------------------------
Web Site: www.mcrides.co.nz
Where New Zealand motorcyclists go
-------------------------------------------------
-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of Paul W
Sent: Tuesday, 11 August 2009 9:51 a.m.
To: [email protected]
Subject: Re: [Laconica-dev] search error
Yes .. I can confirm this.
So how do I fix it on a running laconic ?
Paul Willard
-------------------------------------------------
Web Site: www.mcrides.co.nz
Where New Zealand motorcyclists go
-------------------------------------------------
-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of [email protected]
Sent: Monday, 10 August 2009 10:08 p.m.
To: [email protected]
Subject: Re: [Laconica-dev] search error
I believe that the error is like this:
2009-08-10 07:16:56 LOG_ERR: PEAR error: DB Error: no such field : SELECT *.
FROM notice.
.
WHERE ( notice.is_local != NOTICE_GATEWAY ) AND ( MATCH(content)
AGAINST ('ssss' IN BOOLEAN MODE) ).
.
.
ORDER BY created desc..
LIMIT 0, 21 [nativecode=1054 ** Unknown column 'NOTICE_GATEWAY' in
'where clause']
I have this error when i go to http://mysite/search/notice?q=somenote
It's because there is some fields missing in my db. Running
installation script must fix this problem.
Greetings,
Milen
Quoting Paul Willard <[email protected]>:
> Hi Brenda,
> what is "our database log" ?
> Are you saying enable logging in my.cnf?
>
>
> Paul Willard
> -------------------------------------------------
> Web Site: www.mcrides.co.nz
> Where New Zealand motorcyclists go
> -------------------------------------------------
>
>> -----Original Message-----
>> From: [email protected] [mailto:laconica-dev-
>> [email protected]] On Behalf Of Brenda Wallace
>> Sent: Monday, 10 August 2009 9:33 a.m.
>> To: [email protected]
>> Subject: Re: [Laconica-dev] search error
>>
>> Hi Paul - can you check our database's log file - does it say which
>> field it is missing?
>>
>> 2009/8/9 Paul Willard <[email protected]>:
>> > I’ve got a “search notices” error
>> >
>> > http://squeak.im/search/notice?q=sdvolihjew
>> >
>> > the log file says
>> >
>> > 2009-08-09 09:50:21 LOG_ERR: PEAR error: DB Error: no such field
>> >
>> > I can’t find what it is looking for.
>> >
>> > Running 0.8.1dev .. the db originally was a 0.7.4
>> >
>> > I’ve run rebuilddb.sh .. still nothing
>> >
>> > Any ideas?
>> >
>> > Paul Willard
>> >
>> > -------------------------------------------------
>> >
>> > Web Site: www.mcrides.co.nz
>> >
>> > Where New Zealand motorcyclists go
>> >
>> > -------------------------------------------------
>> >
>> > _______________________________________________
>> > Laconica-dev mailing list
>> > [email protected]
>> > http://mail.laconi.ca/mailman/listinfo/laconica-dev
>> >
>> >
>>
>>
>>
>> --
>> www.br3nda.com
>> www.coffee.geek.nz
>> "Support living artists - the dead ones don't need it." - Collette Rene
>> Fergus
>> _______________________________________________
>> Laconica-dev mailing list
>> [email protected]
>> http://mail.laconi.ca/mailman/listinfo/laconica-dev
>
> _______________________________________________
> Laconica-dev mailing list
> [email protected]
> http://mail.laconi.ca/mailman/listinfo/laconica-dev
>
----------------------------------------------------------------
Zdravei.bg - myasto kydeto vseki moje da nameri po neshto za sebe si.
Spodelete svoite snimki, video klipove, blogove, sreshtnete novi
priateli. Kajete: Zdravei, tova sum az!
_______________________________________________
Laconica-dev mailing list
[email protected]
http://mail.laconi.ca/mailman/listinfo/laconica-dev
_______________________________________________
Laconica-dev mailing list
[email protected]
http://mail.laconi.ca/mailman/listinfo/laconica-dev
_______________________________________________
Laconica-dev mailing list
[email protected]
http://mail.laconi.ca/mailman/listinfo/laconica-dev
