When someone would click on the blog name in navigation and navigate to that blog there is an error with n.type in that it doesn't exist in that context. This seems to be with content types added by the Storm module. The error was at line 390 in advanced_blog.module and the line of code there was this:

$query = "SELECT node.nid, node.created FROM {node} WHERE node.type = 'blog' AND node.status = 1 AND node.uid = " . $account->uid . " ORDER By node.created DESC";

I am not sure exactly why this was happening, but I was able to fix it by changing the code to this:

$query = "SELECT n.nid, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 AND n.uid = " . $account->uid . " ORDER By n.created DESC";

I am new to Drupal and not sure if this will cause a problem for anything else. Seems to be working fine for me, but wanted to get a second opinion from others who actually know what they are doing.

Thanks

Comments

jmmcatee’s picture

Status: Fixed » Needs review
mathieu_ch’s picture

Works for me.
Thx.

jmmcatee’s picture

Could someone enlighten me on how to go about trying to get his added as a patch or how that process might go?

svendecabooter’s picture

Status: Needs review » Fixed

This incorrect query has been rewritten during the code cleanup of this module. A new release of this module should be released soon, fixing this problem.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.