Type: error

Date: Monday, December 30, 2002 - 12:26

User: admin

Location: /drupal-4.1.0/module.php?mod=search

Message: user error: Unknown column 'b.abstract' in 'where clause' query: SELECT n.*, b.* FROM event b LEFT JOIN node n ON n.nid = b.nid AND n.lid = b.lid WHERE (n.title LIKE '%garmin%' OR b.abstract LIKE '%garmin%' OR b.details LIKE '%garmin%' OR n.attributes LIKE '%garmin%') ORDER BY n.timestamp DESC LIMIT 20 in /web/htdocs/drupal-4.1.0/includes/database.mysql.inc on line 69.

Hostname: n/a


I created a poll, and was curious if polls showed up in searches. I tried the search with the term "garmin" in it, and got not hits. The watchdog module shows the above errors. This is a stock 4.1.0 install, with some modules installed.

v/r

Shane

shane@tuna.org

Comments

ax’s picture

ax commented
Title: unknown column b.abstract SQL error when trying to use search » event.module: Unknown column 'b.abstract' while searching
Version: 4.1.0 »
Component: search.module » Other

this is not an error with search.module, but with your event.module from contrib not being updated. watch the latest (http://cvs.drupal.org/viewcvs.cgi/contributions/modules/event/?root=contrib) event.module and event.mysql - neither contains a column "abstract" (it got dropped from event.mysql). marking as "Won't fix" and updating the title.

to the event.module maintainers - does event search actually work? the 1.2 revision contains a "TODO: fix search/indexing" ... would be a chance to do it now Only local images are allowed.

killes@www.drop.org’s picture

killes@www.drop.org commented
Title: event.module: Unknown column 'b.abstract' while searching » Re: [drupal-devel] bug #962 : event.module: Unknown column 'b.abstract' while searching

On 4 Jan 2003, ax wrote:

> 2003-01-04 17:37 : ax
> this is not an error with search.module, but with your event.module
> from contrib not being updated. watch the latest
> (http://cvs.drupal.org/viewcvs.cgi/contributions/modules/event/?root=contrib)
> event.module and event.mysql - neither contains a column "abstract" (it
> got dropped from event.mysql). marking as "Won't fix" and updating the
> title.
>
> to the event.module maintainers - does event search actually work? the

It is supposed to.

> 1.2 revision contains a "TODO: fix search/indexing" ... would be a
> chance to do it now

v1.2 in which branch? v1.10 is current in head.

Cheers,
Gerhard

ax’s picture

ax commented

On Saturday, January 04, 2003 6:12 PM [GMT+1=CET],
killes@www.drop.org wrote:

>> to the event.module maintainers - does event search actually work?
>
> It is supposed to.
>
>> 1.2 revision contains a "TODO: fix search/indexing" ... would be a
>> chance to do it now
>
> v1.2 in which branch? v1.10 is current in head.

HEAD branch, event.{module|mysql} v1.2. i just saw this TODO item browsing
http://cvs.drupal.org/viewcvs.cgi/contributions/modules/event/?root=contrib ...

can this bug be closed then?

killes@www.drop.org’s picture

killes@www.drop.org commented
Title: Re: [drupal-devel] bug #962 : event.module: Unknown column 'b.abstract' while searching » Re: bug #962 : Re: [drupal-devel] bug #962 : event.module: Unknown column 'b.abstract' while searching

On 4 Jan 2003, ax wrote:

> > v1.2 in which branch? v1.10 is current in head.
>
> HEAD branch, event.{module|mysql} v1.2. i just saw this TODO item
> browsing
> http://cvs.drupal.org/viewcvs.cgi/contributions/modules/event/?root=contrib
> ...

It is not in my currnt version on my hard drive, so it probably is
superfluous.

> can this bug be closed then?

Yes. Don't know how to do this per mail, though.

ax’s picture

ax commented
Priority: Minor » Critical