I'm getting this error on enabling the Flickr Ripper module:

user warning: Table 'ideapeep_drpl1.flickrusers' doesn't exist query: SELECT u.name, u.uid, flickrusername from flickrusers f INNER JOIN users u ON f.uid = u.uid ORDER BY u.name in /home/ideapeep/public_html/foxcitiesfocus/includes/database.mysql.inc on line 172.

I'm using Drupal 5.1, MySQL 4.1.22, PHP 4.4.4. Hosting on HostGator. Any ideas? I've tried disabling, deleting and reloading it and always get this message. I did apply for a Flickr API key and it let me enter it and save it.

Comments

Anonymous’s picture

Anonymous (not verified) commented

The SQL query in flickrrippr.install for creating the table 'flickrusers' has a duplicate request to create the column 'flickrusers'.

Running this SQL query into your database (via phpmyadmin or whatever you are using) will fix it.

CREATE TABLE flickrusers(
uid int( 11 ) NOT NULL ,
flickrusername text NOT NULL ,
cachejpegs tinyint( 1 ) NOT NULL default 0,
PRIMARY KEY ( uid )
) ENGINE = InnoDB;

Shiny’s picture

Shiny commented
Status: Active » Closed (won't fix)

ah, the D5 version only works in postgres - i don't have much mysql experience.
try the Drupal 6 version

patches for mysql welcome