Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By grohk on
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
problems with tracker on two sites
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.
same problem
Same problem on my site.
--
Bjorn
http://choirgeek.com
because there's no 'I' in ensemble
Possible Tracker Issue:
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
4.5.0 to 4.5.2
New posts do not appear on the new site.
Same here also
Just upgraded xdeb.org from 4.4.2 to 4.5.2 and I see this tracker bug also.
SQL problem
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
Check your contrib modules
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
Same here on the tracker issue
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.
--
Patch is available and works
There is a patch for this issue attached to followup #18 on this node:
http://drupal.org/node/15500
---
Code Orange: Drink Your Juice
This is what I got using MySQL
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.
Similar Error
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.
I found the problem with my site.
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
That's not it
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
Ah, the problems were not related.
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
I used the 4.5.1 version
Just pulled that one tracker.module file out of the older tarball, uploaded it, and all was hunky dory.
--
mediagirl.org
The newer module corrects an unpublished comments problem
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
for tracker.module use the 4.5.1 one for 4.5.2
chekc out
http://drupal.org/node/15781