Phoca Forum

Posted: **30 Jan 2009, 17:11**

I have Joomla 1.5.8 and I've just installed latest version of Phoca Gallery through Extensions/Install-Uninstall.

Afterwards I went to FTP components folder (then subfolder of Phoca Gallery) and set all permissions to files and folders to 777.

Now, when I go to Phoca Download Control Panel -> Files I see these errors

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

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

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/gameworld.gr/www/administrator/components/com_phocadownload/helpers/phocadownload.php on line 22

Warning: Invalid argument supplied for foreach() in /home/gameworld.gr/www/libraries/joomla/html/html/select.php on line 68

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/gameworld.gr/www/administrator/components/com_phocadownload/helpers/phocadownload.php on line 34

Warning: Invalid argument supplied for foreach() in /home/gameworld.gr/www/libraries/joomla/html/html/select.php on line 68

Any help?

Congrats for your work. I've seen your application in various sites and it works great!

Posted: **30 Jan 2009, 19:04**

Hi, see: https://www.phoca.cz/documents/2-phoca-g ... em-solving

part 1

Regards, Carolien

Posted: **31 Jan 2009, 00:43**

Ok, so now, after installing Phoca Gallery, I will have to copy-paste these sql commands to phpmyadmin?

Be careful and check if I'm posting them correctly. There is only one ALTER TABLE command at the end of install.bak document which (as tutorial says) I won't have to copy. Do i have to copy the rest commands like "NOT NULL" etc?

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

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

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

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

INSERT INTO `#__phocadownload_settings` VALUES (null, 'download_folder', 'phocadownload','', 'text');
INSERT INTO `#__phocadownload_settings` VALUES (null, 'allowed_file_types', '{hqx=application/mac-binhex40}

INSERT INTO `#__phocadownload_settings` VALUES (null, 'disallowed_file_types', '','', 'textarea');
INSERT INTO `#__phocadownload_settings` VALUES (null, 'upload_maxsize', '3000000','', 'text');
INSERT INTO `#__phocadownload_settings` VALUES (null, 'enable_flash', 1,'{0=No}{1=Yes}', 'select');

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

INSERT INTO `#__phocadownload_settings` VALUES (null, 'enable_user_statistics', 1,'{0=No}{1=Yes}', 'select');

Posted: **31 Jan 2009, 12:36**

Hi,

as far as I can read, you're creating tables for Phoca Download. Not for Phoca Gallery.

Regards, Carolien

Posted: **31 Jan 2009, 17:48**

Aaah, sorry! I've downloaded "Phoca Download" instead of "Phoca Gallery" (which I wanted). Sorry!

Phoca Forum

some errors after installation

some errors after installation

Re: some errors after installation

Re: some errors after installation

Re: some errors after installation

Re: some errors after installation