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

CommentFileSizeAuthor
#19 screen.jpg97.21 KBmcarrera
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Michelle’s picture

Status: Active » Postponed (maintainer needs more info)

Try clearing the cache.

Michelle

frazras’s picture

I'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.

Michelle’s picture

Status: Postponed (maintainer needs more info) » Fixed

That function is no longer cached.

Michelle

frazras’s picture

This is a snippet that can be used to clear cache, just add it to a page in php mode

<?php
<?php
// the following code is shamelessly yanked from devel.module.
// please see that module for possible changes / bug fixes.
// this is function `devel_cache_clear()`

drupal_clear_css_cache();

$core = array('cache', 'cache_content', 'cache_filter', 'cache_menu', 'cache_page', 'cache_views');
$alltables = array_merge($core, module_invoke_all('devel_caches'));
foreach ($alltables as $table) {
      cache_clear_all('*', $table, true);
}
drupal_set_message('Cache cleared.');
drupal_goto('/');
?>
Michelle’s picture

Thanks, but that's a moot point. The function is no longer cached.

Michelle

Frank.dev’s picture

Version: 5.x-1.0-alpha5 » 5.x-1.0-alpha6
Status: Fixed » Active

Excuse 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 &#039;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, &#039;cid&#039; AS cid FROM hartz4empfaenger_node ) UNION (SELECT subject, timestamp, nid, uid, &#039;comment&#039;, cid FROM hartz4empfaenger_comments INNER JOIN hartz4empfae in /htdocs/drupal/includes/database.mysql.inc in Zeile 172.

Frank

Frank.dev’s picture

Version: 5.x-1.0-alpha6 » 5.x-1.0-alpha7

Supplement:

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

Frank.dev’s picture

To information:

I use MySQL v 4.0.27 and PHP 4.4.8.

ixeft’s picture

I 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 ;) )

Michelle’s picture

Category: bug » support

I'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

millions’s picture

I'm having this problem as well. If anyone finds a solution, please let me know.

fe’s picture

same 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...

millions’s picture

yeah it works on my local host also, just not the live site. wish it was the other way around!

andrewknowstech’s picture

i 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?

Michelle’s picture

"Is there any fix?"

Nope. Can't fix something that isn't broken for me.

Michelle

andrewknowstech’s picture

Wait so that error message is supposed to show?Is there any way to remove that message?Has anyone else removed the "message"?

andrewknowstech’s picture

Guys i fixed it all i did was repair all the mysql tables.hope this helps

Michelle’s picture

Status: Active » Fixed

"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

mcarrera’s picture

FileSize
97.21 KB

In 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

Michelle’s picture

Status: Fixed » Closed (duplicate)

I'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