Error when installing the phoca font component...

[javtor75]

I get the following error when installing the phoca font component:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /./././content/libraries/joomla/database/database/mysql.php on line 344



I found the code in .../libraries/joomla/database/database/mysql.php on line 344.

function getNumRows( $cur=null )
{
return mysql_num_rows( $cur ? $cur : $this->_cursor );
}


But, I'm not sure if to about it, if anything at all.???

[Jan]

Hi, really no idea there, this is a Joomla! core code, Phoca extension only gives the xml and Joomla! installs it

Try to enable debug mode while installing, you should get info from the database, I think, the code in core Joomla! is Ok, but there is some problem while installing it - in database, so the debug mode should display the error message.

Which version you are using (component) and which version of mysql (maybe there can be problem with type=myisam code which should be changed to engine=myisam

Jan

[javtor75]

I get that message in the "Font" tab of the component in J!. When install it it says that the "component installed successfully"...I have MySQL 5.0.77 and the version of the component I'm adding is 1.0.2. J! vs is 1.5.22. I have tried installing and enabling the plugin to see what happens and I still get that message.

Any info is greatly appreciated.

[Jan]

The debug says something?

[Jonathan]

Hello, Jan.

I have the same problem as javtor75. In the Fonts tab of Phoca Fonts, ther are three lines of text above the Filter text field. All three lines are the same:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../.../.../libraries/joomla/database/database/mysql.php on line 317

After trying to install com_phocafont_domesticmanners.zip, the displayed message is: "New font not installed Data could not be saved in database"

I'm on Joomla 1.6.3, MySQL version is 5.0.92, com_phocafont is v2.0.0, plg_phocafont is v2.0.1.

Thanks.

Regards,
Jonathan

[Jan]

Hi, enable debug mode to get information from the database.
https://www.phoca.cz/documents/16-joomla ... rs-on-site
Jan

[javtor75]

I found this (see link below) and I changed the "#" from the following in the install.bak file:

DROP TABLE IF EXISTS `#__phocafont_font`;
CREATE TABLE `#__phocafont_font` (


then installed...it worked. Not sure if that was a proper fix though.

link: https://www.phoca.cz/documents/2-phoca-g ... em-solving

[Jan]

Ok