Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
suresh vadlamudi
Need SQL script to updatelportal- Liferay6.1.10 GA1 EE to Liferay6.1.20 GA2
September 17, 2012 7:21 AM
Answer

suresh vadlamudi

Rank: Junior Member

Posts: 33

Join Date: September 7, 2010

Recent Posts

Hi ,

Could any one guide me where can i get the SQL script for updating the lportal tables of liferay6.1.10 GA1 to liferay6.1.20 -ee - GA2.
My intention is i want to point the liferay6.1.20 -ee - GA2 to my existing liferay6.1.10 GA1's lportal.So that i won't be loosing any of the existing data.

Regards
Suresh
Samuel Kong
RE: Need SQL script to updatelportal- Liferay6.1.10 GA1 EE to Liferay6.1.20
September 17, 2012 11:08 PM
Answer

Samuel Kong

LIFERAY STAFF

Rank: Liferay Legend

Posts: 1545

Join Date: March 10, 2008

Recent Posts

A SQL script would not be enough to upgrade your portal. You should use the portal's built in upgrade process to upgrade. You shouldn't lose any existing data. Please refer to the documentation for upgrade instructions.
Mika Koivisto
RE: Need SQL script to updatelportal- Liferay6.1.10 GA1 EE to Liferay6.1.20
September 18, 2012 12:27 PM
Answer

Mika Koivisto

LIFERAY STAFF

Rank: Liferay Legend

Posts: 1513

Join Date: August 7, 2006

Recent Posts

Always remember to create a backup before running upgrade.
Hitoshi Ozawa
RE: Need SQL script to updatelportal- Liferay6.1.10 GA1 EE to Liferay6.1.20
September 18, 2012 4:14 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Samuel's link is to the customer site. Non-EE users can refer to the following in the online User Guide:

http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/upgrading-lifer-6
suresh vadlamudi
RE: Need SQL script to updatelportal- Liferay6.1.10 GA1 EE to Liferay6.1.20
September 24, 2012 9:34 PM
Answer

suresh vadlamudi

Rank: Junior Member

Posts: 33

Join Date: September 7, 2010

Recent Posts

Hi Hitoshi,

I am not able to access "http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/upgrading-lifer-6" this link .It is showing "Asset Link Display is temporarily unavailable.".Could you please help me o this.

Regards
Suresh
suresh vadlamudi
RE: Need SQL script to updatelportal- Liferay6.1.10 GA1 EE to Liferay6.1.20
September 24, 2012 9:37 PM
Answer

suresh vadlamudi

Rank: Junior Member

Posts: 33

Join Date: September 7, 2010

Recent Posts

Hi Samuel,

When i hit the link you mentioned..i am finding this message..

The requested resource was not found.

http://www.liferay.com/group/customer/downloads/documentation

Could you please suggest any alternative way.

Regards
Suresh
suresh vadlamudi
RE: Need SQL script to updatelportal- Liferay6.1.10 GA1 EE to Liferay6.1.20
September 25, 2012 6:01 AM
Answer

suresh vadlamudi

Rank: Junior Member

Posts: 33

Join Date: September 7, 2010

Recent Posts

Hi All,

Here are the steps which i am following to upgrade from Liferay6.1.10 GA1 EE to Liferay 6.1.20

1.I have taken liferay latest and unziped and started the server (pointed to existing lportal which is of GA1)
2. Kept the license into deploy folder
3.And i added setup.wizard.enabled=false in portal-ext.properties file(to avoid theme probelm)
4.Now every thing is working fine ..site is up

But as per DB thr are some observations

As per the comparison which i did with the GA1 lportal and GA2 these are the tables which are got changed

1. AssetCategory(Index key added)
2. Blog Entry(Index key added)
3. DLFileVersion(Index key added)
4. Layout(Index key added)
5. MDRRuleGroupInstance(Index key added)
6. Region(Index key added)
7. Release_(Added New column called status)
8. SCProductVersion(Index key added)
9. User_(Index key added)

But when i do the above mentioned process for making liferay GA2 setup (by pointing to GA1 lportal) it is updating only Release_ table and it automatically updated the version and new column called status also added.But remaining tables it is not able to update the latest chanegs ...i mean index keys are not coming.

Could you please guide me how do i update the remaining tables?
Is thr any impact if the index keys are not updated?

Regards
Suresh