Question Birthday Modul

Thank you! Now the error message is gone but there are still no birthdays displayed.
I installed another modul, mod_birthdays for CB, and it works just fine with the same field. But: I'd rather use the Kunena module since I'd love to have a topic for each birthday. What could be another error I made configuring Kunena?

Hi, just came back from holiday, I will look into it. Thank you for the report.

Hey LDA, thanks for sharing this module!

Here are some feedback:

1st, here goes attached the translation for Brazilian Portuguese (Portuguese-BR - pt-BR)



2nd, here are some comments:
- In the .ini file, we don't get to translate the "Kunena Birthdaybot" text;
- In the .ini file, we don't get to translate the "default" in the template dropdown list;
- At the reference time, in English, the tiptool is showing "SW_KBIRTHDAY_TIMEFROM_DESC" instead of the correct description;
- I'm not native with English too, but I think there is a misspelling at "Fill in the name off", it should be "of" instead "off";
- on the same line there is another grammar error "It have to begin", it should be "It has" (When using 3rd person the verb to be is He/She/It HAS and I/You/They HAVE).
- Another misspelling at "choose theire timezone", it should be "their" instead of "theire".


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)

Cheers.

Okay, I located the error that caused the warning:

Somehow your $query is faulty, it produces no result.
Since this passage is just a test if any data is in $cb, I changed it to It is too long ago that I used to write PHP code so I cant see where the error is right now. But, with my "fix", the module starts producing results.
New Problem: If someone had its birthday yesterday, the module lists the user as "has birthday in one day".
Also the results are not in the right order - the output is listed in the same order as found in the database.

Everything else seems to work fine now.

This query is truly wrong and not from my files.

What Version of Kunena/CB and the Modul you are using?

Yeah, I was sloppy with crtl+z to return to your original code for pasting it here. It's been 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.