I have upgraded from 4.6 to 4.7 and "reinstalled" the quotes module... but the blocks do not show. Now, I am not sure if I need to do something with the quotes.install file - which contains the sql code for the tables associated with this module? I dont know what and how to use that to change the sql tables using this quotes.install file..

what do I need to do?

Comments

liza’s picture

liza commented

BUMP!

I am having exactly the same problem.

Here's the error messages that are littering my watchdog table --and I am serious about the littering. I have over 1 MILLION of these messages logged since midnight today.

Unknown column 'q.vid' in 'on clause' query: quotes_get_quote SELECT COUNT(*) FROM quotes q INNER JOIN node n ON n.vid = q.vid WHERE n.status = 1 AND n.type = 'quotes' AND q.promote = 1 AND 1 in /home/liza/domains/culturekitchen.com/public_html/includes/database.mysql.inc on line 120.

I also have this :

Unknown column 'q.vid' in 'where clause' query: quotes_load SELECT q.author AS quotes_author, q.promote AS quotes_promote FROM quotes q WHERE q.vid = 5849 in /home/liza/domains/culturekitchen.com/public_html/includes/database.mysql.inc on line 120.

What is weird is that when I updated the module using the modules panel, there were no error messages logged about the DB. So I assumed the DB was updated.

Any thoughts on how to fix this will be greatly appreciated.

Liza Sabater, Publisher
www.culturekitchen.com

peetah’s picture

peetah commented

I made it work by editing the file quotes.module, searched for all instances of q.vid and changing it to q.nid.

I found that out by looking at the structure of the quotes table. There were three columns called nid, author, and promote. A quick look at the SQL statement showed that q.vid was an identifier for the quotes table and it wanted to join the tables quotes and nodes together. Since q.vid doesn't exist, it had to be q.nid, a row id for the quotes table.

Hope this helps!

jhriggs’s picture

jhriggs commented
Status: Active » Closed (fixed)

It sounds like you didn't run update.php after upgrading. Remember, in 4.7 (and 5) you have to run update.php every time you install or upgrade a module. Had you run update.php, it would have performed all of the necessary database updates.