Installation error

[Benno]

Hi,
1. ) first of all, if you want to change anything in your database, make a complete database backup before!!!
2.) see: https://www.phoca.cz/documents/2-phoca-g ... em-solving
3.) Try the same with Phoca Menu install.bak
Kind regards,
Benno

[straykat]

I am having the same problem. The instructions at the link are to difficult for me to understand. How do I install them manually? The install.bak file is giant! FYI I'm try to install the gallery and restaurant menu. I have phpmyadmin installed and can add tables and such, but the install.bak file has me very confused.

[Benno]

Hi,
which version of joomla! and which version of Phoca Restaurant Menu do you use?
Which error message do you receive (if you enable debug mode)?

Kind regards,
Benno

[straykat]

Hi Benno- I'm so glad to see your reply! I have not enabled debug mode.
OS Linux Ubuntu
Joomla 2.5.4
Phoca menu 2.0.2
Phoca gallery 3.2.0

[straykat]

FYI I have now enabled debug mode.
All kinds of error info is available.
Error 500 is the first and most obvious one.
To much info to list untill I know exactly what you want to look at.

Error: 500

JDatabaseMySQLi::query: 1146 - Table 'testsite.ef4do_phocagallery' doesn't exist SQL=SELECT a.*, i.id as imageid, i.alias as imagealias, i.filename as imagefilename, ic.id as imagecatid, ic.alias as imagecatalias, i.extid as imageextid, i.exts as imageexts, i.extm as imageextm, i.extl as imageextl, i.extw as imageextw, i.exth as imageexth, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as imageslug, CASE WHEN CHAR_LENGTH(ic.alias) THEN CONCAT_WS(':', ic.id, ic.alias) ELSE ic.id END as imagecatslug FROM ef4do_phocamenu_item AS a LEFT JOIN ef4do_phocagallery AS i ON i.id = a.imageid LEFT JOIN ef4do_phocagallery_categories AS ic ON ic.id = i.catid WHERE a.published = 1 AND a.type = 1 ORDER BY ordering ASC

[Benno]

Hi,
try to compare your database tables with the install.bak.sql files of Phoca Gallery zip-package and Phoca Menu zip-package. If tables are missing create them manually.
1. Unzip Phoca Gallery and Phoca Menu local on your PC.
2. Open e.g. Phoca Menu install.bak.sql file.
3. Inside this file you find six SQL-Queries to create six database tables.
4. For example, if the table jos_phocamenu_day is missing, copy and paste this SQL-Query:

Code: Select all

CREATE TABLE IF NOT EXISTS `jos_phocamenu_day` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`type` int(3) NOT NULL default '0',
`title` datetime NOT NULL default '0000-00-00 00:00:00',
`alias` varchar(100) NOT NULL,
`published` 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',
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) DEFAULT CHARSET=utf8;

in your phpMyAdmin "Run SQL query/queries" window and click the "Go" button.

5. Now you will find the table jos_phocamenu_day in your database.
6. But as I wrote above, before you do any changes in your database, please run a complete database backup!!

Kind regards,
Benno

[straykat]

Benno You are indeed a Phoca Hero! Thank you
FYI my 6 phocamenu items were created just fine, it was the phocagallery items that I was missing, just as the error message correctly reported.

[Benno]

Well done!

Kind regards,
Benno