My site is displaying this, and I don't know how to correct it or what the bug is:

user warning: Unknown column 'aid' in 'from clause' query: SELECT a.aid AS quotes_aid, a.name AS quotes_author, a.bio AS quotes_bio, q.citation AS quotes_citation, q.promote AS quotes_promote FROM quotes q JOIN quotes_authors a USING (aid) WHERE q.vid = 2 in /web/drupal6/sites/all/modules/quotes/quotes.module on line 354.

It shows up on the home page all the time and the /quotes page.

Comments

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Active » Postponed (maintainer needs more info)

Just a wild guess here: You just updated the module and didn't run update.php (database update). Or this can be a duplicate of #431924: Error in query: ... AND (q.aid IN (none)) ... which is fixed in the current -dev release.

somatics’s picture

somatics commented

I did run the update script, so that doesn't seem to be it.

So, I went the next step you mentioned and just now installed the current -dev release (http://ftp.drupal.org/files/projects/quotes-6.x-1.x-dev.tar.gz)

Then I ran update, which indicated there were no updates available for the Quotes module, and got this error message:

"user warning: Unknown column 'aid' in 'from clause' query: SELECT a.aid AS quotes_aid, a.name AS quotes_author, a.bio AS quotes_bio, q.citation AS quotes_citation, q.promote AS quotes_promote FROM quotes q JOIN quotes_authors a USING (aid) WHERE q.vid = 2 in /web/drupal6/sites/all/modules/quotes/quotes.module on line 362."

What to do I do now?

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

Can you look at the "quotes_authors" table and tell me what columns it has, please. I don't see how you could have the table and not that column.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

No further update

ari-meetai’s picture

ari-meetai commented
Status: Closed (fixed) » Active

user warning: Unknown column 'none' in 'where clause' query: SELECT n.nid FROM drupal_quotes q INNER JOIN drupal_node n ON q.vid=n.vid WHERE n.status=1 AND n.type='quotes' AND q.promote = 1 AND (q.aid IN (none)) ORDER BY RAND() LIMIT 0, 1 in [...]sites/all/modules/quotes/quotes.module on line 1203.

That's what I'm getting now. After an update to the module. I've run update.php

ari-meetai’s picture

ari-meetai commented
Status: Active » Needs review

Went to the settings page and just saved the page. Went to the blocks page and saved the block. Both without changes.

Problem solved.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

#3 -- Please tell me what tables and columns are in the database.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Needs review » Postponed (maintainer needs more info)
ari-meetai’s picture

ari-meetai commented
Status: Postponed (maintainer needs more info) » Needs review

the problem looks fixed now. You still need that data? I can't recall what was there before, when the error was active.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Needs review » Fixed

"Needs review" is a status for when patches are submitted to let people know to check them out.

If an issue is fixed, there is a status for "fixed." It would indicate, among other things that you don't wish to (or cannot) pursue it any further.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Fixed » Closed (fixed)