[SOLVED] Migration to Joomla 2.5

Phoca Guestbook - creating guestbooks in Joomla! CMS
User avatar
cicalone
Phoca Member
Phoca Member
Posts: 35
Joined: 27 Feb 2008, 07:53
Location: Italy

[SOLVED] Migration to Joomla 2.5

Post by cicalone »

Is it possible to import the guestbooks in 1.5 site to the new 2.5 site?
Thanks
Last edited by cicalone on 04 Apr 2012, 13:31, edited 1 time in total.
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9964
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Migration to Joomla 2.5

Post by Benno »

User avatar
cicalone
Phoca Member
Phoca Member
Posts: 35
Joined: 27 Feb 2008, 07:53
Location: Italy

Re: Migration to Joomla 2.5

Post by cicalone »

Thanks. Following your instructions I imported the guestbooks from the old site to the new one, and in the backend I can see the guestbooks and the posts. But in the frontend I'm not able to see the guestbook. When I try to go to the guestbook I receive this message: "You are not authorized to do this action".
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9964
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Migration to Joomla 2.5

Post by Benno »

Hi,
check the "Access" setting of your Guestbook.

Kind regards,
Benno
User avatar
cicalone
Phoca Member
Phoca Member
Posts: 35
Joined: 27 Feb 2008, 07:53
Location: Italy

Re: Migration to Joomla 2.5

Post by cicalone »

Both the guestbook and the menu voice are setted on "public"
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49138
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Migration to Joomla 2.5

Post by Jan »

Hi, try to recheck the menu link to the guestbook and the options, try to see if the language is set Ok (e.g. set to all)
If you find Phoca extensions useful, please support the project
jennyjeffreys
Phoca Newbie
Phoca Newbie
Posts: 7
Joined: 18 Apr 2010, 20:56

Re: Migration to Joomla 2.5

Post by jennyjeffreys »

I am having the same problem: You are not authorized to do this action

However, when I ran the following queries:

UPDATE `jos_phocaguestbook_books` SET `language` = '*';
UPDATE `jos_phocaguestbook_items` SET `language` = '*';

I got the error message:

Error

SQL query:

UPDATE `jos_phocaguestbook_books` SET `language` = '*';

MySQL said: Documentation
#1054 - Unknown column 'language' in 'field list'

and when I opened the .sql tables that I had exported there does not appear to be any language field.

I checked the fields in my Joomla 1.5 version of Phocasguestbook (which was upgraded to the latest version 1.5.3 before exporting the data) and the language field does not appear to exist).

In the Joomla 2.5 version, I checked the language setting for each of the guestbook entries and they are all set to "undefined". Is there any other way of resetting these to all - if this is the answer to the problem?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49138
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Migration to Joomla 2.5

Post by Jan »

Hi, the language columns are created while installing version which is working under 2.5

https://www.phoca.cz/documents/50-phoca/ ... -joomla-25

Jan
If you find Phoca extensions useful, please support the project
User avatar
cicalone
Phoca Member
Phoca Member
Posts: 35
Joined: 27 Feb 2008, 07:53
Location: Italy

Re: Migration to Joomla 2.5

Post by cicalone »

Following Jan's instructions I solved the problem.
Thanks!!!
pepino69
Phoca Member
Phoca Member
Posts: 28
Joined: 04 Mar 2012, 21:39
Location: Czech republic
Contact:

Re: [SOLVED] Migration to Joomla 2.5

Post by pepino69 »

I now have the same problem, how did you solve it exactly?
Post Reply