Brugs sql error?

Watch Reply
More
Mark unread Print Skip to new
Terry Murfreesboro, TN(Zone 7a) Jul 21, 2003

Dave, when I tried to search for Snow Cone or Snow in Brugmansias.com, here's the error message I got:

Database error: Invalid SQL: select a.pid, b.common, b.cultivar, b.family, b.genus, b.species from pdb_search a, pdb_master b where a.name like '%Snow%' and a.pid = b.pid and ((genus = 'Brugmansia' or genus = 'Datura'))
MySQL Error: 1052 (Column: 'genus' in where clause is ambiguous)
Session halted.

Here's the link to the search results page: http://brugmansias.com/search.php?search_text=Snow

Post #589139
Quote
dave Jul 21, 2003

Thanks, this is fixed.

Dave

Post #589183
Quote

Post a Reply to this Thread

Please or sign up to post.
Back to Forum Homepage

More DG Site Updates Threads

Go to all DG Site Updates threads
BACK TO TOP