Error when trying to work in admin/Can't save any entries

Phoca Restaurant Menu - restaurant menu manager
troyboy1
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 16 Apr 2011, 06:46

Error when trying to work in admin/Can't save any entries

Post by troyboy1 »

At the top of the Daily Menu page I have the following warning:

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

If I try to enter a menu item, I get this:

Save failed with the following error: TablePhocaMenuGroup: :store failed
Table 'wwwdanvi_jo151.jos_phocamenu_group' doesn't exist SQL=INSERT INTO `jos_phocamenu_group` (`title`,`alias`,`ordering`) VALUES ('','','1')

I there a solution to fixing this?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48386
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error when trying to work in admin/Can't save any entrie

Post by Jan »

Hi, this seems like the Phoca Restaurant was not successfully installed, the tables were not created in the database, try to install them manually, you can find the queries in install.sql.bak file, see for similar problem:
https://www.phoca.cz/documents/2-phoca-g ... em-solving (this is for phoca gallery, but should be the same for this component)

Jan
If you find Phoca extensions useful, please support the project
Post Reply