good find!
This was defined in 0.8.0
classes/Notice.php:define('NOTICE_GATEWAY', -2);
but it's gone in the end of git branch 0.8.x
On Thu, Aug 13, 2009 at 11:22 AM, Paul W<[email protected]> wrote:
> 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
>
--
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
