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]>:
> Ive 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 cant find what it is looking for.
>
> Running 0.8.1dev .. the db originally was a 0.7.4
>
> Ive 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
