error message mySQL database

[aykay]

Hi everybody!

When I installed the Phoca gallery I received an error message that in line 140 of mySQL database was an error. I installed the rest of the modules without any error message. Uploading pictures works, but they are not displayed. I receive the following error message:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/www/u14790/html_www.xxxxxx.de/libraries/joomla/database/database/mysql.php on line 344

Can anyone give me a hint how to fix this?

Thanks in advance!

aykay

[Benno]

Hi,
check if all tables were created during installation process.

Kind regards,
Benno

[aykay]

Hi Benno!

I de-installed the PhocaGallery and installed the version 2.7.9 for joomla 1.5

MySQL Version that is installed: 5.0.51a

Unfortunately I receive the following error warning:

Phoca Gallery not successfully installed:
DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(11) NOT NULL Default '0', `videocode` text, `vmproductid` int(11) NOT NULL' at line 15 SQL=CREATE TABLE `jos_phocagallery`( `id` int(11) unsigned NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `filename` varchar(250) NOT NULL default '', `description` text, `date` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `latitude` varchar(20) NOT NULL default '', `longitude` varchar(20) NOT NULL default '', `zoom` int(3) NOT NULL default '0', `geotitle` varchar(255) NOT NULL default '', `userid` varchar(255) int(11) NOT NULL Default '0', `videocode` text, `vmproductid` int(11) NOT NULL default '0', `imgorigsize` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `approved` tinyint(1) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `params` text, `metakey` text, `metadesc` text, `extlink1` text, `extlink2` text, `extid` varchar(255) NOT NULL default '', `extl` varchar(255) NOT NULL default '', `extm` varchar(255) NOT NULL default '', `exts` varchar(255) NOT NULL default '', `exto` varchar(255) NOT NULL default '', `extw` varchar(255) NOT NULL default '', `exth` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `catid` (`catid`,`published`) ) ENGINE=MyISAM CHARACTER SET `utf8`;

[Jan]

Hi, I am trying to see the code for error, but cannot find any in this query , maybe the uppercase

try to change Default to default or (this will be better) and run this sql manually

Jan

[aykay]

I assume that my host does not have the GD library running on the server. May that be a possibility? And can I install that via FTP?

thanks again
aykay

[m1tr0]

Hi,
i install joomla 1.7.1 and com_phocagallery_v3.0.2, but when i go to "Category" in Phoca Gallery i have next warning...

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /srv/disk3/842004/www/eldesign.myartsonline.com/libraries/joomla/database/database/mysqli.php on line 305

Can anyone give me a hint how to fix this

[Jan]

Hi, enable debug mode and see:
https://www.phoca.cz/documents/2-phoca-g ... em-solving
https://www.phoca.cz/documents/16-joomla ... rs-on-site

Jan