Question Joomla search-kunena plugins

Found a creat way change the collations for the entire database.:woohoo:

---

How to change the collation for all tables in a MySQL database to UTF-8?

Changing the collation for all tables in a MySQL database can be time consuming depending on how many tables you have.

That's why we recommend using the following PHP script for changing the collation for all tables at a time:

<?php
$db = mysql_connect('localhost','myuser_mydbuser','mypassword');
if(!$db) echo "Cannot connect to the database - incorrect details";
mysql_select_db('myuser_mydbname'); $result=mysql_query('show tables');
while($tables = mysql_fetch_array($result)) {
foreach ($tables as $key => $value) {
mysql_query("ALTER TABLE $value COLLATE utf8_general_ci");
}}
echo "The collation of your database has been successfully changed!";
?>

Make sure to substitute in the above script:

- myuser_mydbname with your database name;

- myuser_mydbuser with your mysql username;

- mypassword with your password for the mysql user;

- utf8-general_ci with your new collation if different;

xillibit wrote: Hello,

try by this way :

It's works by taking this file from SVN : joomlacode.org/gf/project/kunena/scmsvn/...h%2Fkunenasearch.php

Replace this file in : plugins\search\

I have problem with search on my site, Kunena Search plugin installed, enabled - but Joomla search ignores forum...

and.. joomlacode.org/gf/project/kunena/scmsvn/...h%2Fkunenasearch.php this link si wrong

EDIT: Installed this plugin pizcar.com.ar/joomla/kunena/54-kunena-16-search-bot-plugin and kunena search from joomla works!

thnx

:silly: :woohoo: :woohoo:

It is working.
The search does the job now.
Finaly

The plugin did the job and

TNX

Do you know how long I have been looking for this, and tried everything. You the man...thx.