Sharepoint Designer 'Error reading file' on opening default.apsx file

Opened default.aspx to edit it and got 'error reading file', could only open in text mode or notepad.
Did some reseach on google and found this ..

http://msdevelopers.blogspot.com/2007/04/error-reading-file-with-sharepoint.html.

I look in the file and was a massive blank area between the two sections of code, 70,000 lines.
Solution I found was to cut the bottom bit of code and paste so all the code is together, just highlight and cut the combined code and past it into a newly created aspx file. Rename old file and name new file default.apsx.

Also did this
BACKUP LOG SharePoint_Config WITH TRUNCATE_ONLY
USE SharePoint_ConfigGODBCC SHRINKFILE (SharePoint_Config_Log, EMPTYFILE)GO

afterwards as might have been contributing to the problem.

Customising the Announcments Web

A pain with the standard announcments web part is that you cannot just click on the title and go straight to the attachement or web page that you need.

Solution

Create a new column called 'Link' , make this a hyperlink
This has two columns to edit for each item , the address itself either http: , ftp etc and the text description. You can leave the text description blank.
If you are using an attachement , upload it then in edit view right click the mouse and copy shortcut and paste the path in the hyperlink column for Link.
If you are linking to an internal or external web page just paste the link.

Amend the title field
Click on the title field in the announcments web part, edit hyperlink and replace in the address
mailto:%7BURL_Display?ID={@ID} with this {substring-before(@WebPageLink, ', ')} - leave the text description of the hyperlink as @Title.

You will now find you can click on title and it will take you straight to eithe the attachement or web page AND you can still click down and view or edit item !

*** Note you cannot store a relative URL in a list item column , has to be fully qualified **** a pain if you move servers since you will need to edit all the links in the announcments list ****

WSS Alter thumbnail size in picture gallery with Sharepoint Manager 2007 and Change background Color of thumbnail and border

The default size for thumbnails picture libraries is contained in
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES\PictureLibrary\PicLib\schema.xlm.

Find ThumbnailSize="160" WebImageWidth="480" WebImageHeight="640
and change it here. This will be used for any NEW picture library you have created.

For an exisiting picture library you have already created download Sharepoint 2007 Manager, a good tool for looking at the inards of Sharepoint WSS or MOSS 2007.

Open it up aqnd go to your site collection, lists and find say Marketing Picture Library (or whatever you called your library). There is a thumbnail property of 120 , I set it to 80.
You can change WebImageHeight and WebImageWidth for resizing the WebPreview if you want.

Go file Save Change to Sharepoint

Refresh your picture library and it is now resized!

Change Background Color of the thumbnail
The dark grey is a bit too much , you can change it via CSS (a whole other story)
*** Note CSS for the site should have its own custom css file as upgrades can wreck changes ****
There are two items that need tweaking:

img.thumbnail
Color behind thumbnail in the Picture Preview area of the left navigation area in a picture library.
.
.ms-imglibthumbnail
Background for thumbnails in Thumbnails view. Border color should be the same as for img.thumbnail style above. Ensure has border that is solid, 1px and #E7E3E7

Edit these in core.css in
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033\STYLES

img.thumbnail{border:solid #E7E3E7 3px;}tr.ms-imglibselectedrow,tr.ms-highlight{background-color:#f2f2f2;}
.ms-imglibthumbnail{background-color:#F7F7F7;border:solid #E7E3E7 1px;}