Error message on enabling module
markzahn - September 17, 2007 - 20:17
| Project: | Flickr Rippr |
| Version: | 5.x-1.3 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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.
#1
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;