Problems with version 4.1.2

[rickextra]

Dear mister/miss,

Last week I've updated Joomla to version 3.3.6. and also Phoca gallery updated to version 4.1.2. But now doesn't work it any more. See the link for the error message:

http://www.schutroe.nl/index.php/foto-s6

The problemsolving is nor been successful. I've tried a manual installation, but there is a complete map what is missing out of the zipfile what you use by the installation.

What should I now do to let it work?

Yours sincerely,
Rick

[christine]

Hi Rick,

kijk maar hier even: viewtopic.php?f=30&t=25731&start=10#p97433
Je moet het script (database) SQL veranderen. Leez maar in het thread van boven

Groetjes, Christine

[rickextra]

De front folder is er niet die bij de handmatige installatie moet kopiëren naar de map. Ik weet niet of dat iets uitmaakt, maar kijk maar eens op:

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

Groetjes, Rick

[christine]

Hallo Rick,

ik weet niet, wat je met: "frontfolder" bedoeld.
Maar miesschien is het makkelijker, als je het zo probeert > Hier het link: viewtopic.php?f=30&t=25731&start=20#p101270

Ik zal het even hier neerzetten, voor andere users in engelse taal

For other user, now in english (from above link):

It worked for me. For newbie with database like me, just log in in Phpmyadmin, copy this text in a text editor, replace all the table prefix (jm4) with yours, copy the text, go on phpmyadmin, click on "SQL", paste the text on the field and click "go". Done.

To migrate Phoca Gallery tables from 3.2.8 to 4.1.1:

Code: Select all

ALTER TABLE `jm4_phocagallery` ADD `format` TINYINT( 1 ) NULL DEFAULT '0' AFTER `filename`;
CREATE TABLE IF NOT EXISTS `jm4_phocagallery_styles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `filename` varchar(255) NOT NULL DEFAULT '',
  `menulink` text,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned 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,
  `language` char(7) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
INSERT INTO `jm4_phocagallery_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocagallery', 'phocagallery', 'phocagallery.css', '', 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', '', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Default', '', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*')

Ik denk, dat het so makkelijker is, dan die andere versie.
Meer weet ik nu ook niet. Als het nu te moelijk word, dan a.u.b. in engels voor Jan en Benno

Groetjes, Christine

[rickextra]

What I mean is that the installation folder is not complete, if I see the problem solving page. If you look at the manual installation there is a folder or file called front. But I can't find it in the unzip from the installation file, so the manual installation through ftp failed. Do you know how to fix this?

[christine]

Hi Rick,

Pls be informed, that your 1st post was belonging to below error response, something like this:

1146 - Table 'XXXX.myprefix_phocagallery_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM h25_phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

About above response, I sent the links for the solution.

But now, there is a NEW (other) response. Did you solve the databank error response before?
404 could mean: that the component is not actived? Check also your menu, whether or not the phoca gallery is actived.

Groetjes, Christine

[Benno]

Hi Rick,
Don't use this guide: https://www.phoca.cz/documents/2-phoca-g ... em-solving

3. Copy all folders and files (except front and language folders and their files) from phocagallery_tmp folder into your server's folder:

administrator/components/com_phocagallery

This guide was written for Joomla! v1.5 and therefore the folder front don't exist in Phoca Gallery 4

OT. Hallo Christine, schön Dich mal wieder hier begrüßen zu dürfen..

Kind regards,
Benno

[christine]

Hallo Benno,

ja freue mich auch, Dich hier zu sehen - wir 2 sind ja mal *drüben* mal *hier*

Danke für Deine Intervention in diesem Thread. Wie in vorigen posts erwähnt, war es zu anfangs der DB Fehler, danach 404
Deswegen konnte ich mit dem verlinkten 'Guide' auch nichts anfangen.

Aber: Seit gestern abend irgendwann, nach meinem letzten post, funktioniert die Phocagallery wieder.

Liebe Grüße, Christine

@ Rick: We zouden het leuk vinden, als je het thread op 'solved' gaat zetten ..... dank je

[rickextra]

Zal ik doen.