When upgrading from 4.7, I received this error:

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 '' at line 1 query: ALTER TABLE quotes ADD COLUMN title in /Applications/MAMP/htdocs/cleantech47to5-p1/includes/database.mysql.inc on line 172.

In quotes.install:

/**
 * Implementation of hook_update_N().
 * Removes the title column and adds the additional fields to
 * quotes_blocks to support cron.
 */
function quotes_update_4() {
  global $db_type;

  $items = array();

  $items[] = update_sql('ALTER TABLE {quotes} ADD COLUMN title');

  return $items;
}

My guess is the ADD should be DROP but the table at this point does not have a column 'title'

Comments

nancydru’s picture

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

Did 4.7 have the export function? I think it would be better to export from 4.7 and treat 5.7 as a new installation.

I never used this on 4.7 so I cannot even begin to reproduce it.

I do know that the quotes table shouldn't have a title column - that goes in the node table.

alexandreracine’s picture

alexandreracine commented

I upgraded too from 4.7 to 5.9 and I had the same error. Even if the error is there, it does not seems to affect the quotes module. Adding, deleting, the block, all work.

There is no export option in the quotes modules by the way. Well, not in 4.7 anyway.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Active » Closed (won't fix)

@aangel: As alexandreracine said the module should function correctly even with that update failing. Frankly I have no idea what it should be; that predates my involvement with Quotes.