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.
Hi,
If I activate the Advanced-forum-module, the information is not indicated in the table cell "Last post" any more (is "blank").
If I deactivate the module, the data are correctly indicated me for the forum.
What does this go wrong?
Thanks
Frank
Comment | File | Size | Author |
---|---|---|---|
#19 | screen.jpg | 97.21 KB | mcarrera |
Comments
Comment #1
MichelleTry clearing the cache.
Michelle
Comment #2
frazras CreditAttribution: frazras commentedI'm having the same issue, however I was able to see all the last posts up to before I installed advanced forums, it seems as if the module doesn't register the last post information. Eg. I upgraded/installed the forums to advanced forms six days ago and the last posts I am seeing are from six days ago. The new posts are not being registered.
Comment #3
MichelleThat function is no longer cached.
Michelle
Comment #4
frazras CreditAttribution: frazras commentedThis is a snippet that can be used to clear cache, just add it to a page in php mode
Comment #5
MichelleThanks, but that's a moot point. The function is no longer cached.
Michelle
Comment #6
Frank.dev CreditAttribution: Frank.dev commentedExcuse me, however, my problem still exists.
Also after I have clearing the Cache, the "Last post" are not indicated me.
So far to my experiences with the version alpha5 of the module.
After I have updated the module on the version alpha6, the problem always exists furthermore.
Now, however, in addition, my visits are accompanied in the forum by the following error message:
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 'SELECT title, created AS time, query: SELECT n.title AS topictitle, r.title AS replytitle, r.time timestamp, r.type AS replytype, n.type AS topictype, n.nid AS topicid, t.tid, r.cid AS cid, r.uid, u.name FROM hartz4empfaenger_node AS n INNER JOIN ( (SELECT title, created AS time, nid, uid, type, 'cid' AS cid FROM hartz4empfaenger_node ) UNION (SELECT subject, timestamp, nid, uid, 'comment', cid FROM hartz4empfaenger_comments INNER JOIN hartz4empfae in /htdocs/drupal/includes/database.mysql.inc in Zeile 172.
Frank
Comment #7
Frank.dev CreditAttribution: Frank.dev commentedSupplement:
The problem cannot hang together with the theme and the integration of _phptemplate_variables - this was my first supposition.
I have tried out the advanced-forum module with different themes - also with Garland and from you configured template.php file.
Frank
Comment #8
Frank.dev CreditAttribution: Frank.dev commentedTo information:
I use MySQL v 4.0.27 and PHP 4.4.8.
Comment #9
ixeft CreditAttribution: ixeft commentedI think that is a drupal 5.7 issus because it work with a drupal 5.3 (my test website) but it don't work with my drupal 5.7
(i'm french, so excuse my english ;) )
Comment #10
MichelleI'll leave this open for a while in case someone else has an idea, but it's working fine on all my sites so I don't have an answer for you.
Michelle
Comment #11
millions CreditAttribution: millions commentedI'm having this problem as well. If anyone finds a solution, please let me know.
Comment #12
fe CreditAttribution: fe commentedsame problem here. maybe this could help: it worked as it should on my localhost installation. after porting the site to the webserver the "Last Post" information disappeared. localhost and live site are exactly the same versions! more testing later...
Comment #13
millions CreditAttribution: millions commentedyeah it works on my local host also, just not the live site. wish it was the other way around!
Comment #14
andrewknowstech CreditAttribution: andrewknowstech commentedi have the same problem.It is only on the main forum home.my error message:
user warning: Got error 134 from storage engine query: SELECT n.title AS topictitle, r.title AS replytitle, r.time timestamp, r.type AS replytype, n.type AS topictype, n.nid AS topicid, t.tid, r.cid AS cid, r.uid, u.name FROM node AS n INNER JOIN ( (SELECT title, created AS time, nid, uid, type, 'cid' AS cid FROM node ) UNION (SELECT subject, timestamp, nid, uid, 'comment', cid FROM comments WHERE comments.status = 0 ) ORDER BY time DESC ) AS r ON n.nid=r.nid INNER JOIN term_node AS t ON n.nid = t.nid INNER JOIN users AS u ON r.uid = u.uid WHERE n.status = 1 GROUP BY tid; in /home/whoknows/public_html/includes/database.mysql.inc on line 172.
Is there any fix?
Comment #15
Michelle"Is there any fix?"
Nope. Can't fix something that isn't broken for me.
Michelle
Comment #16
andrewknowstech CreditAttribution: andrewknowstech commentedWait so that error message is supposed to show?Is there any way to remove that message?Has anyone else removed the "message"?
Comment #17
andrewknowstech CreditAttribution: andrewknowstech commentedGuys i fixed it all i did was repair all the mysql tables.hope this helps
Comment #18
Michelle"Wait so that error message is supposed to show?"
No... There's nothing wrong with that query on any of my sites other than being dog slow. I don't know why some people are getting an error message. Sounds it's a database problem if repairing the tables fixed it.
Michelle
Comment #19
mcarrera CreditAttribution: mcarrera commentedIn forum list, the colum last post gives me a post title and a date, although the forum has actually 0 posts (see attached file, jornada forum).
The posts were deleted from /admin/content/node. The problem is fixed deleting advanced_forum_alllasttopics row from cache table.
FYI: drupal-5.7, Apache/2.2.8 (Win32) PHP/5.2.5, MySql5.0.51a-community-nt-log
Comment #20
MichelleI'm marking this a duplicate even though it came first because http://drupal.org/node/248652 actually has the solution. This is a PHP 4 issue.
Michelle