Phoca Forum

After installing 3.0.0 RC4 on joomla 1.6.1 I get this message:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /Applications/XAMPP/xamppfiles/htdocs/Joomla_1.6/libraries/joomla/database/database/mysqli.php on line 345

I found the way: I uninstalled the component and installed it again. Now it works.



But when I try to upload images, get this massage:

Error during applet initialization!
Have a look in your Java console (java.lang.refelct.InvocationTargetException).

What does it mean?

Hi, some problem with loading java applet in your java environment, try to check your OS and java environment, try to search similar problems in this forum or google (the java has some problems on some environments - os + browser + server settings )

Jan

thanks!

I'm having this same problem, with Joomla 1.6.3. Any ideas? I tried uninstalling and reinstalling several times but no luck... Every time I try clicking on Images or Categories in the back end I get this error:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/juniors/public_html/libraries/joomla/database/database/mysqli.php on line 345

If I create a category I can see it in the jos_phocagallery_categories table using phpMyAdmin, but it doesn't show up in the component.



Any help is most appreciated...
Chris

As a test, I installed 3.0.0 RC4 on another Joomla 1.6.3 installation on the same server and it worked fine... No errors. Now I'm really confused!

Chris

I turned on debug mode and discovered more information on the error:

"500 - An error has occurred.
JDatabaseMySQL::query: 1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT..........."

I checked with phpMyAdmin, and on the Joomla installation where Phoca Gallery is working, all of the tables are collation type "utf8_general_ci." This site was created by downloading Joomla 1.6 from the official Joomla site and running the typical installation.

On the other installation, installed via Cpanel's Fantastico feature, most of the tables are of this type:

"utf8_unicode_ci"

... except that the Phoca tables are of another type:

"utf8_general_ci"

This is all beyond me - does anyone know what I can do to get Phoca Gallery working? Since there are different collation types, shouldn't Phoca somehow ensure it selects the one that will match the current Joomla installation?

Thanks...

Chris

Hi, hmmm, no idea there, Phoca Gallery does not set such settings in SQL queries

It only sets that is should be utf8 ???

I'll keep trying to figure it out... If I learn anything, I'll post back here

Chris

I still have no idea how my database ended up with two different character set types, but by changing all the tables so they had a single type I was able to make the errors disappear in Phoca Gallery. Here's what I did, in case anyone else ever runs into this...

1) Backed up the site with Akeeba Backup.

2) I created a small PHP file called collate.php and ran it. I used the instructions here to change the collation for all the columns to utf8_general_ci:



3) Using phpMyAdmin, I followed the instructions here to change all the charset of all the columns to utf8_general_ci:


Everything's working now

Chris