I just upgraded to 4.5.2 and noticed two possible bugs.

  • It seems that new posts without comments do not show up in the tracker.
  • Manually changing the publish/not published status of a comment causes an error: "Fatal 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 '' at line 1 query: SELECT title FROM node WHERE nid = in /home/code0/domains/code0range.net/public_html/includes/database.mysql.inc"

Is anyone else having these issues?

Comments

cel4145’s picture

Yes. On the two sites I have upgraded, tracker is having a problem on each. And it's not just new posts, but old ones as well.

bjornarneson’s picture

Same problem on my site.
--
Bjorn
http://choirgeek.com
because there's no 'I' in ensemble

grohk’s picture

I think this bug fix -- http://drupal.org/node/15500 -- might be the source of the problem. It was committed a few days ago and I was testing the patch, since it does fix a serious problem with unpublished spam comments. But the patch was committed and the new version was released, so I just upgraded this morning. Now, without further testing, I cannot be certain.

---
Code Orange: Drink Your Juice

vincent’s picture

New posts do not appear on the new site.

frjo’s picture

Just upgraded xdeb.org from 4.4.2 to 4.5.2 and I see this tracker bug also.

okhroust’s picture

I am also having the same problem with broken SQL query when I edit a comment:
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 '' at line 1 query: SELECT title FROM node WHERE nid = in /u/Groups/CIC/HTML/includes/database.mysql.inc on line 125.

Any solution for this?
Thanks

grohk’s picture

Double check that you are running the latest revision of *all* your modules from contributions. If you don't know how to use the web frontend to the Drupal CVS archive:

http://cvs.drupal.org/viewcvs/drupal/contributions/modules/

then download the tarball archives from here:

http://drupal.org/project/releases
---
Code Orange: Drink Your Juice

jbrauer’s picture

I've had the same tracker issue. Same for new and old posts - only those with comments show up in tracker now.

Josh

Adding Understanding

Update: The code to remove to get tracker back as it was is here http://www.addingunderstanding.com/node/653 - Not sure what it breaks when this is done, I can only presume it was put in for a reason since that seems to be the only change to the tracker module.

--

grohk’s picture

There is a patch for this issue attached to followup #18 on this node:

http://drupal.org/node/15500

---
Code Orange: Drink Your Juice

Drupy-1’s picture

This is what I got using MySQL after upgrading to 4.5.2

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 '' at line 1
query: SELECT title FROM node WHERE nid = in /home/domain/public_html/includes/database.mysql.inc on line 125.
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 'AND s.stype = "node"' at line 1
query: SELECT u.uid, u.name, u.mail FROM users u INNER JOIN subscriptions s ON u.uid = s.uid WHERE s.sid = AND s.stype = "node" in /home/domain/public_html/includes/database.mysql.inc on line 125.

warning: Cannot modify header information - headers already sent by (output started at /home/domain/public_html/includes/common.inc:344) in /home/domain/public_html/includes/common.inc on line 155.

tinycg’s picture

I have the exact same error going from 4.5.1 to 4.5.2. Glad I did a backup as it won't even let me into the admin section right now. I guess its back to 4.5.1 until these issues are resolved. And I'll patch it for security.

grohk’s picture

It was the contributed Subscriptions module. You probably need to upgrade to the latest revision of that module, which can be found here:

http://cvs.drupal.org/viewcvs/drupal/contributions/modules/subscriptions...

As, of now, that would be revision 1.22.2.3

If that does not do it, check to make sure that your other contrib modules are up-to-date.

---
Code Orange: Drink Your Juice

media girl’s picture

I have the tracker omissions problem, and subscriptions is 1.22.2.4.

I will look at uploading the 4.5.1 version of tracker.

Funny thing: Once a post gets a comment, then it does show up on tracker. But for most posts, not until then.

--
mediagirl.org

grohk’s picture

The subscriptions module was causing me headaches as noted above, but the "recent posts" problem is related to a bug in the tracker.module introduced by the 4.5.2 release. The fix is extremely small and simple, you can find the details here:

http://drupal.org/node/15500

or download the new tracker.module here:

http://cvs.drupal.org/viewcvs/drupal/drupal/modules/tracker.module?only_...

---
Code Orange: Drink Your Juice

media girl’s picture

Just pulled that one tracker.module file out of the older tarball, uploaded it, and all was hunky dory.

--
mediagirl.org

grohk’s picture

You can by all means use the 4.5.1 tracker.module, but the problem (bug #15500) with unpublished (spam or otherwise) comments bringing nodes to the top of "Recent Posts" will persist. Unless you are closing your comments on older nodes, your tracker might have issues with the 4.5.1 module.

---
Code Orange: Drink Your Juice

rouvas@drupal.org’s picture