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
