Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Whenever I create a quote type node, it gives an sql error;
* user warning: Table 'mydatabase.quotes' doesn't exist query: INSERT INTO quotes (nid, vid, author, citation, promote) VALUES (200, 200, '', '', 1) in /home/mywebsite.com/includes/database.mysql.inc on line 172.
* user warning: Table 'mydatabase.quotes' doesn't exist query: SELECT q.author AS quotes_author, q.citation AS quotes_citation, q.promote AS quotes_promote FROM quotes q WHERE q.vid = 200 in /home/mywebsite.com/includes/database.mysql.inc on line 172.
* user warning: Table 'mydatabase.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/mywebsite.com/includes/database.mysql.inc on line 172.
Also I get another sql error when I want to show it in a block. I created my block but it gives this error:
user warning: Table 'mydatabase.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/mywebsite.com/includes/database.mysql.inc on line 172.
What is the problem exactly?
Comments
Comment #1
nancydruHave you read http://drupal.org/node/244082?
Comment #2
turco commentedThanks but does it have the solution?
Comment #3
nancydruThe problem is that you didn't see an error when you installed the module. For some reason, the quotes table did not get created. The only situations I know of that have caused this have been fixed in the 5.x-1.3 release, which is what you say you are using. At this point, all I can suggest is to disable, uninstall, and re-install the module, paying attention to the installation messages.
Comment #4
nancydruClosed due to lack of response.