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.???
Error when installing the phoca font component...
-
- Phoca Newbie
- Posts: 3
- Joined: 02 May 2011, 07:54
- Jan
- Phoca Hero
- Posts: 48402
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Error when installing the phoca font component...
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
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
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 3
- Joined: 02 May 2011, 07:54
Re: Error when installing the phoca font component...
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.
Any info is greatly appreciated.
- Jan
- Phoca Hero
- Posts: 48402
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Error when installing the phoca font component...
The debug says something?
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 1
- Joined: 29 May 2011, 21:07
Re: Error when installing the phoca font component...
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
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
- Phoca Hero
- Posts: 48402
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Error when installing the phoca font component...
Hi, enable debug mode to get information from the database.
https://www.phoca.cz/documents/16-joomla ... rs-on-site
Jan
https://www.phoca.cz/documents/16-joomla ... rs-on-site
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 3
- Joined: 02 May 2011, 07:54
Re: Error when installing the phoca font component...
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
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
- Phoca Hero
- Posts: 48402
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Error when installing the phoca font component...
Ok
If you find Phoca extensions useful, please support the project