Hi,

when running update.php, the Drupal database update outputs errors when upgrading from 1.0 to 1.1:

Warning:

user warning: Table '{database}.currencyapi' doesn't exist query: ALTER TABLE currencyapi CHANGE timestamp timestamp int NOT NULL default '0' in /var/www/{site}/includes/database.mysql.inc on line 172.

Results:

The following queries were executed
currency_api module
Update #1
Failed: ALTER TABLE {currencyapi} CHANGE timestamp timestamp int NOT NULL default '0'

{database} is the Drupal database (MySQL), {site} is the directory this Drupal installation in running from.

Regards, -asb

Comments

kbahey’s picture

kbahey commented
Status: Active » Postponed (maintainer needs more info)

This means the table has not existed from the start, which is bad.

Try uninstalling the module and then reinstalling it (i.e. go to the Uninstall tab after you disable the module).

asb’s picture

asb commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Hi Khalid,

thank you for the hint; even with the errors, the "Currency Exchange" seemed to work properly.

However, I disabled, uninstalled and reinstalled the module; that procedure went smoothly.

Thanks & greetings, -asb

scedwar’s picture

scedwar commented

I had the same problem and the same solution. However, I only had the Currency Api module enabled as a dependency for the Money module.

lyricnz’s picture

lyricnz commented

I had the same issue, when updating from Currency API for D4.7 to D5.0. It didn't create the DB table, and it tried to perform update-1 (when it didn't exist).