Hi,

Have just installed this great module, but when I came to delete a few rogue user accounts I got the following SQL 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 '* FROM folk_navigate_favorites WHERE uid = '101'' at line 1 query: DELETE * FROM folk_navigate_favorites WHERE uid = '101' in /homepages/3/d67107590/htdocs/folk/includes/database.mysql.inc on line 174.

I'm using Drupal 5.12 and up to date versions of all modules.

Any ideas?

Cheers

Paul

Comments

fourtyfreak’s picture

fourtyfreak commented

Oops, I should have read the issues for *all* the versions of this module. Found the answer at http://drupal.org/node/331684 and have fixed the code on my sites. (around line 204 of navigate_favorites.module)

Cheers

Paul

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Closed (duplicate)

Marking this as a duplicate of #331684: deleting user with favorites turned on give sql error.