search

SparkDevNetwork / Rock

An open source CMS, Relationship Management System (RMS) and Church Management System (ChMS) all rolled into one.
http://www.rockrms.com
572 stars 347 forks source link

Front Page properties #495

Closed kellynjan closed 10 years ago

kellynjan commented 10 years ago

It seems I messed up the front page (external) and can't get it back.

I was looking in the page properties and switched the layout to different options and set it to the error setting (who knows why) and now the tool bar in the lower right corner doesn't come up to change it back.

Any ideas how I can fix this?

Thank you!

Kelly home rock rms

azturner commented 10 years ago

You'll have to fix this manually by running a SQL command. From the Admin Tools > Power Tools page, select the 'SQL Command' option. Enter the following SQL Text.

UPDATE [Page]
SET [LayoutId] = ( SELECT TOP 1 [Id] FROM [Layout] WHERE [Guid] = '093acc5f-f7b6-4eb1-b9b7-9f3f5fb85f13' )
WHERE [Id] = 1

Note: This will only fix the external home page (page id 1). Make sure that is indeed the page you mis-configured before running this sql!!!

Set the 'Selection Query' to 'No' and then click 'Run'... image

After running the query, you'll need to clear the cache. From any page that works, click the 'Rock Information' icon in the admin bar, and then select 'Clear Cache'...

image

Your page should now work...

kellynjan commented 10 years ago

thank you so much. worked perfect!

Kelly Backstrom Lead Pastor

River Rock Church www.river-rock.org

On Sun, Aug 3, 2014 at 8:44 PM, David Turner notifications@github.com wrote:

You'll have to fix this manually by running a SQL command. From the Admin Tools > Power Tools page, select the 'SQL Command' option. Enter the following SQL Text.

UPDATE [Page] SET [LayoutId] = ( SELECT TOP 1 [Id] FROM [Layout] WHERE [Guid] = '093acc5f-f7b6-4eb1-b9b7-9f3f5fb85f13' ) WHERE [Id] = 1

Note: This will only fix the external home page (page id 1). Make sure that is indeed the page you mis-configured before running this sql!!!

Set the 'Selection Query' to 'No' and then click 'Run'... [image: image] https://cloud.githubusercontent.com/assets/548180/3792949/f5ecbd18-1b87-11e4-8d72-69deffad0baf.png

After running the query, you'll need to clear the cache. From any page that works, click the 'Rock Information' icon in the admin bar, and then select 'Clear Cache'...

[image: image] https://cloud.githubusercontent.com/assets/548180/3792976/d47c503e-1b88-11e4-82c9-cc288ae1e31b.png

Your page should now work...

— Reply to this email directly or view it on GitHub https://github.com/SparkDevNetwork/Rock/issues/495#issuecomment-51015164 .