Page 1 of 1

Problems with version 4.1.2

Posted: 22 Nov 2014, 17:30
by 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

Re: Problems with version 4.1.2

Posted: 22 Nov 2014, 17:54
by 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 :wink:

Groetjes, Christine

Re: Problems with version 4.1.2

Posted: 22 Nov 2014, 19:38
by 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

Re: Problems with version 4.1.2

Posted: 22 Nov 2014, 20:16
by 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 :wink:

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 :wink:

Groetjes, Christine

Re: Problems with version 4.1.2

Posted: 22 Nov 2014, 20:59
by 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?

Re: Problems with version 4.1.2

Posted: 22 Nov 2014, 21:20
by 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

Re: Problems with version 4.1.2

Posted: 23 Nov 2014, 14:52
by 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

Re: Problems with version 4.1.2

Posted: 23 Nov 2014, 21:03
by 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

Re: Problems with version 4.1.2

Posted: 24 Nov 2014, 14:59
by rickextra
Zal ik doen.