The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3
This category contains miscellaneous, uncategorised user contributions, (templates, modules, plugins and hacks) relating to older versions of Kunena that are no longer supported.
This category may also contain a few topics relating to K 1.6 that may have been moved here possibly by mistake.
The topics in this category are for historical interest only. Owing to the structural differences between K 1.6 and K 1.7, these ideas in these topics will not work with later versions and, for that reason, the topics are locked.
Yeah, I was sloppy with crtl+z to return to your original code for pasting it here. It's been
Code:
$query = "SHOW COLUMNS FROM #__comprofiler LIKE {$cb}";
if I remember correctly. Sorry for the faulty paste.
Using the usual debugging methods I found out that $cbf is always empty with that query. Iirc SHOW COLUMNS supports the LIKE statement, but even using '{$cb}' wouldn't help. $cb is passed on correctly, $query is a seemingly okay string, but it wouldnt produce any results whatsoever. And I dont know why. Maybe you should just forget about the whole SHOW COLUMNS part and replace it with a query that you can actually use later on - mySQL will return an error message if the field's name is not valid and you could go with the warning from there.
$query = "SHOW COLUMNS FROM #__comprofiler LIKE '{$cb}'";
and it works on 2 sites for me. The only point I can give you is, that you set up the wrong birthday field in the modul. Did you insert the name of your CB birthday field correctly in the module backend?
Btw. pls always post what versions you are using fron Kunena/CB and the module.
I am using 1.6.3 and it doesn't work with the above statement. It does work if I pass/cheat on your test but with the above mentioned errors like people had birthday yesterday are announced for tomorrow and the wrong order of output.
As for my system:
Apache/2.2.9
PHP Version 5.2.6-1
mySQL/mySQLi 5.0.51a
Joomla 1.5.20
CB 1.2.3
Kunena 1.6.0-RC1
iLucato wrote: Hey LDA, thanks for sharing this module!
A suggestion for a new module:
You would create a module to show the latest topics posted in Kunena or also a module to allow to put a link with the filter results from a word, so I would just show post with certain criteria/words.
I think that's all for a while. Well, just a suggestion. ;0)
mervyn wrote:
Using the usual debugging methods I found out that $cbf is always empty with that query. Iirc SHOW COLUMNS supports the LIKE statement, but even using '{$cb}' wouldn't help. $cb is passed on correctly, $query is a seemingly okay string, but it wouldnt produce any results whatsoever. And I dont know why. Maybe you should just forget about the whole SHOW COLUMNS part and replace it with a query that you can actually use later on - mySQL will return an error message if the field's name is not valid and you could go with the warning from there.
When $cbf is alsways empty then he don't find your CB field you defined in the modul configuration. I will test a bit around as soon as I have time.
iLucato wrote: Hey LDA, thanks for sharing this module!
A suggestion for a new module:
You would create a module to show the latest topics posted in Kunena or also a module to allow to put a link with the filter results from a word, so I would just show post with certain criteria/words.
I think that's all for a while. Well, just a suggestion. ;0)
Need your advise, after enable module I got error message as below.
Warning: require_once(public_html/administrator/components/com_kunena/libraries/api.php) [function.require-once]: failed to open stream: No such file or directory in /public_html/modules/mod_sw_kbirthday/helper.php on line 15
Fatal error: require_once() [function.require]: Failed opening required '/public_html/administrator/components/com_kunena/libraries/api.php' (include_path='.:/usr/local/php5/lib/php') in /public_html/modules/mod_sw_kbirthday/helper.php on line 15
