? 4.5.0 Recipe Error:

user error: 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 'n.status=1 AND n.type = 'recipe'' at line 1
query: SELECT COUNT(*) FROM node n INNER JOIN node_access na ON (na.nid = 0 OR na.nid = n.nid) JOIN users u ON n.uid = u.uid WHERE na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0')n.status=1 AND n.type = 'recipe' in /www/goes-to/my/path/drupal/includes/database.mysql.inc on line 125.

Tables were created successfully. Taxonomy/Vocabulary/Term properly utilized & 1st recipe created successfully. 1st recipe created and promoted to front page and appears there when users goes to 'Home'. Recipe will not show up anywhere else, in searches etc. And clicking 'Recipes' in the navagation block produces the above error. Problem is when looking at the recipe.mysql file indicated in the error, there only 16 lines in the file (no 125).

Is this nubee doing something wrong ?

Comments

Anonymous’s picture

(not verified) commented

oops :(

I messed up, was looking at the wrong file duh. So looking at the correct file at line 125 I see:

}
else {
trigger_error(mysql_error() ."\nquery: ". htmlspecialchars($query), E_USER_ERROR);
}
}

But still have no idea ??

Anonymous’s picture

(not verified) commented

oops :(

I messed up, was looking at the wrong file duh. So looking at the correct file at line 125 I see:

}
else {
trigger_error(mysql_error() ."\nquery: ". htmlspecialchars($query), E_USER_ERROR);
}
}

But still have no idea ??

moshe weitzman’s picture

moshe weitzman commented
Anonymous’s picture

(not verified) commented