Page 1 of 1

Guest book installation trouble

Posted: 27 Jun 2011, 06:44
by na_krul
Hello, i installed Phoca Guestbook and everything seem's allright but when i am entering to Items or to Guestbooks i recive error messages.
In Items:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/virtual_client/umc-go/www/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/virtual_client/umc-go/www/libraries/joomla/database/database/mysql.php on line 344

Warning: array_unshift() [function.array-unshift]: The first argument should be an array in /var/www/virtual_client/umc-go/www/administrator/components/com_phocaguestbook/views/phocaguestbooks/view.html.php on line 48

Warning: Invalid argument supplied for foreach() in /var/www/virtual_client/umc-go/www/libraries/joomla/html/html/select.php on line 68

In Guestbooks:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/virtual_client/umc-go/www/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/virtual_client/umc-go/www/libraries/joomla/database/database/mysql.php on line 344

Tables in database are not created. I cannot see them in phpmyadmin.

Re: Guest book installation trouble

Posted: 27 Jun 2011, 06:55
by na_krul
Tables are created after this modification of queries:
From this:
TYPE=MyISAM CHARACTER SET `utf8`;
To:
ENGINE=MyISAM CHARACTER SET `utf8`;

In the end of the query. But i still have that error messages. :(

Re: Guest book installation trouble

Posted: 27 Jun 2011, 07:07
by na_krul
Solved.
You have double symbol "_" in the name of the tables. After deleting everything is OK.

Re: Guest book installation trouble

Posted: 27 Jun 2011, 12:09
by Benno
Well done! :twisted:

Kind regards,
Benno