I've just uploaded the quotes module to my site and have activated in drupal, but when I go to the settings of the quotes module itself, I get an error on the configure blocks page:

user warning: Table 'dubber_drpl1.quotes_blocks' doesn't exist query: SELECT qb.* FROM quotes_blocks qb ORDER BY name ASC in /home/dubber/public_html/includes/database.mysql.inc on line 120.

My guess is the table hasn't bveen set up properly, but the install.txt file doesn't say anything about that, just to upload the module.

Any suggestions?

Comments

jhriggs’s picture

jhriggs commented

Did you run update.php after installing and activating the module?

Dubber Dan’s picture

Dubber Dan commented

Nope. It was never mentioned in the install.txt and my understanding is that it only needs to be run when updating a module. Is that not the case for this one?

jhriggs’s picture

jhriggs commented

Sorry, I misread your post. I thought it said you "updated the module on your site" rather than you "uploaded the module to your site." So, this was a fresh install? You activated the module and it didn't create the tables? That's strange. The only things I could suggest would be to either manually run the database install SQL from quotes.install or deactivate the module, run the following database query (assuming you have no database prefix), and try to install it again.

DELETE FROM system WHERE name = 'quotes' AND type = 'module';

jhriggs’s picture

jhriggs commented
Status: Active » Closed (fixed)

No followup. Closing.

EugeneMann’s picture

EugeneMann commented

I get the same error. I tried both version 5.x-1.2 and the development version.

Here is the error:

user warning: Table 'spe0810210282037.quotes' doesn't exist query: SELECT COUNT(*) FROM quotes q INNER JOIN node n USING(vid) WHERE n.status=1 AND n.type='quotes' AND q.promote = 1 AND 1=1 in /home/content/s/p/e/speakerservice/html/includes/database.mysql.inc on line 172.

nancydru’s picture

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

It's really not a good idea to post in a closed issue. Had I not gotten an email, I would never have seen this.

Did you get any error messages when you installed? Did you run update.php? Which version of Drupal?

Have you tried uninstalling and re-installing? This message would indicate that there was a problem installing for some reason.

EugeneMann’s picture

EugeneMann commented
Status: Closed (fixed) » Active

I got the error as soon as i installed it on drupal 5. I tried running update.php and re-installing the module, but no luck.

nancydru’s picture

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

There were no messages when you installed? Have you looked at the database to see if the quotes and quotes_blocks tables are there? Drupal 5.what? And which MySql?

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Version: 4.7.x-1.x-dev » 5.x-1.2
Assigned: Unassigned » nancydru
Status: Active » Postponed (maintainer needs more info)
KNerd Terry’s picture

KNerd Terry commented

I'm getting the same error as Eugene. Just installed Quotes, got an the same error about the table right away, so uninstalled it and tried again. The second time I tried to update, but that didn't do anything.

I'm using Drupal 5.7 and MySQL 5.0.32.

Thanks!

nancydru’s picture

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

I just rolled up all the changes into 5.x-1.3. Please try it and let me know. And please pay careful attention to any messages that appear during the install process.

KNerd Terry’s picture

KNerd Terry commented

I just tried your new release and its working perfectly! Thanks so much

nancydru’s picture

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

Thank you for the feedback.

nancydru’s picture

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