I just installed this module, and I get the following wrror. It seems like there was no author table created when the module was installed.

* user warning: Table '.... d5quotes_authors' doesn't exist query: SELECT qa.aid FROM d5quotes_authors qa WHERE qa.name='Dr. Michael Yessis' in .... includes/database.mysql.inc on line 174.
* user warning: Table '.... d5quotes_authors' doesn't exist query: INSERT INTO d5quotes_authors (name) VALUES ('Dr. Michael Yessis') in .... includes/database.mysql.inc on line 174.
* Quotes: insert author failed.
* user warning: Table '.... d5quotes_authors' doesn't exist query: SELECT aid FROM d5quotes_authors qa WHERE qa.name='Dr. Michael Yessis' in .... includes/database.mysql.inc on line 174.
* Quotes: get aid failed.
* user warning: Table '..... d5quotes_authors' doesn't exist 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 d5quotes q JOIN d5quotes_authors a USING (aid) WHERE q.vid = 4 in .... includes/database.mysql.inc on line 174.

Comments

nancydru’s picture

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

My first guess is that you haven't run update.php, which you need to do when updating a module.

vsr’s picture

vsr commented

This is from a clean install, no upgrade. I ran update and it did not fix. I removed it and installed the 17 version and it ran without a hitch. The 1.8 version did not make he author table in the database. The quote would show , but without the author.

nancydru’s picture

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

Did you get any errors on the install? Did you check the log to see if anything was recorded?

Okay, I went to a site that never had Quotes, and I get:

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show_citation INTEGER NOT NULL DEFAULT 0 max_length INTEGER NOT NULL ' at line 10 query: CREATE TABLE quotes_blocks ( bid INTEGER NOT NULL PRIMARY KEY, block_type INTEGER NOT NULL, cron_interval INTEGER NOT NULL, cron_step INTEGER NOT NULL, cron_last INTEGER NOT NULL, vid INTEGER NOT NULL, count INTEGER NOT NULL DEFAULT 1, show_titles INTEGER NOT NULL DEFAULT 0 show_citation INTEGER NOT NULL DEFAULT 0 max_length INTEGER NOT NULL DEFAULT 0 view_weight INTEGER NOT NULL DEFAULT 1 name VARCHAR(255) NOT NULL UNIQUE, nid_filter TEXT NOT NULL, rid_filter TEXT NOT NULL, uid_filter TEXT NOT NULL, tid_filter TEXT NOT NULL, view_text VARCHAR(64), more_text VARCHAR(64), ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\www\drupal\includes\database.mysql.inc on line 174.
* user warning: Key column 'name(255)' doesn't exist in table query: CREATE TABLE quotes_authors ( aid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, name TEXT NOT NULL, bio TEXT NULL, INDEX (`name(255)`) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\www\drupal\includes\database.mysql.inc on line 174.

This is much more useful information.

nancydru’s picture

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

Fix committed. Unfortunately, for you to see the results, you would have to uninstall rather than update.

vsr’s picture

vsr commented

I looked in my logs and got a lot of messages. The 1.7 version look nice. Hope that you can get the 1.8 version working.

The first one is

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show_citation INTEGER NOT NULL DEFAULT 0 max_length INTEGER NOT NULL D' at line 10 query: CREATE TABLE d5quotes_blocks ( bid INTEGER NOT NULL PRIMARY KEY, block_type INTEGER NOT NULL, cron_interval INTEGER NOT NULL, cron_step INTEGER NOT NULL, cron_last INTEGER NOT NULL, vid INTEGER NOT NULL, count INTEGER NOT NULL DEFAULT 1, show_titles INTEGER NOT NULL DEFAULT 0 show_citation INTEGER NOT NULL DEFAULT 0 max_length INTEGER NOT NULL DEFAULT 0 view_weight INTEGER NOT NULL DEFAULT 1 name VARCHAR(255) NOT NULL UNIQUE, nid_filter TEXT NOT NULL, rid_filter TEXT NOT NULL, uid_filter TEXT NOT NULL, tid_filter TEXT NOT NULL, view_text VARCHAR(64), more_text VARCHAR(64), ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /...../includes/database.mysql.inc on line 174.

The next one is

Key column 'name(255)' doesn't exist in table query: CREATE TABLE d5quotes_authors ( aid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, name TEXT NOT NULL, bio TEXT NULL, INDEX (`name(255)`) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in ..... /includes/database.mysql.inc on line 174.

And another

Table 'd5quotes_authors' doesn't exist query: SELECT qa.aid FROM d5quotes_authors qa WHERE qa.name='Cicero' in / ... /includes/database.mysql.inc on line 174.

And another

Table 'd5quotes_authors' doesn't exist query: INSERT INTO d5quotes_authors (name) VALUES ('Cicero') in ... /includes/database.mysql.inc on line 174.

nancydru’s picture

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

Those are the same ones I was able to reproduce. The next -dev release should be rolling up in the next few minutes, and this will be fixed.

ajqureshi’s picture

ajqureshi commented

Hi NancyDru,

where can I download the -dev release that containts the fix for the above mentionned problem. Thank you in advance.

nancydru’s picture

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

From the project page. At the top of this page you'll see the breadcrumbs, just click on the module name.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.