QA Tests for SmartSite 2.3.x patches

Test for SAK-588

SAK-588: Oracle performance tuning and tracking: convert LONG columns to CLOB

Access Level: (blue star) Any tester can run some steps; (star) admin access required for some steps
Test Description: The smartsite-test database server was recently updated to convert long text fields to a different format. This new format enhances performance by allowing Oracle to shrink space for reclamation and to allow the fields to be searched more easily.
The update affects the following tools: Announcements, Assignments, Chat Room, Discussion Forum, Email Archive, Resources, and Schedule.

Test Steps
To test this update, you simply need to verify that each of these tools still work and are unaffected by the database change. This may require adding tools to a site where you are an instructor or logging in using one of the sakaiinst or sakaistu accounts. You may need to ask a smartsite-test admin to create a new site for you as an Instructor to test adding new tools to a course.

Tool

User Acting As

Action

Expected Result

Technical Verification

Announcements

(star) Admin

Log in and create a new user. Log in as that user via the xlogin method (not through Kerberos.) Select Announcements in MyWorkspace. Verify that you can access the announcements screen without error.

Announcements is accessible to new users when their announcement channel is created.

ANNOUNCEMENT_CHANNEL XML field

Announcements

(blue star) Instructor

Log in as yourself or as sakaiinst account. Go to a course where you are an Instructor and create an announcement. View that announcement.

Announcement is successfully created.

ANNOUNCEMENT_MESSAGE XML field

Assignments

(blue star) Instructor

Log in as yourself or as sakaiinst account. Go to a course where you are an Instructor and create an assignment.

Assignment is successfully created.

ASSIGNMENT_ASSIGNMENT XML ASSIGNMENT_CONTENT XML

Assignments

(blue star) Student

Log in as yourself or as sakaistu account. Go to the course where you added the assignement and submit a text response.

Assignment is successfully submitted.

ASSIGNMENT_SUBMISSION XML

Chat Room

(blue star) Instructor

Log in as yourself or as sakaiinst account. Go to a course and add the Chat Room tool via Site Info - Edit Tools. Create a chat message.

Chat Room tool can be added successfully and chat message can be added successfully.

CHAT_CHANNEL XML CHAT_MESSAGE XML

Discussion

(blue star) Instructor

Log in as yourself or as sakaiinst account. Go to a course and add the Discussion tool via Site Info - Edit Tools. Create a Topic in the Discussion tool.

Discussion tool and a new topic can be added successfully.

DISCUSSION_CHANNEL XML DISCUSSION_MESSAGE XML

Email Archive

(blue star) Instructor

Log in as yourself or as sakaiinst account. Go to a course where you are an Instructor and add the Email Archive tool. Use the name of the course for an email address, e.g., "che2a001@smartsite-test.ucdavis.edu" for CHE 2A 001. Send an email to that address and verify that it is received in the email archive tool.

User able to successfully send an email to the course via the Email Archive tool.

MAILARCHIVE_CHANNEL XML MAILARCHIVE_MESSAGE XML

Resources

(star) Admin

Log in as the new user you created and verify that you can add a file or URL to Resources in My Workspace.

New user's Resources successfully added.

CONTENT_COLLETION XML

Resources

(blue star) Any User

Log in as any user and add a file or URL via Resources in My Workspace or a course or project site.

New file or URL successfully added to Resources.

CONTENT_RESOURCE XML

Resources

(blue star) Any User

Log in as any user and delete the file or URL you just created.

User able to successfully delete an item from Resources.

CONTENT_RESOURCE_DELETE XML

Schedule

(star) Admin

Log in as the newly-created user via the xlogin method (not through Kerberos.) Select Schedule in MyWorkspace. Verify that you can access the new user's calendar without error.

Calendar is accessible to new users when it is created.

CALENDAR_CALENDAR XML field

Schedule

(blue star) Instructor

Log in as yourself or as sakaiinst account. Go to a course where you are an Instructor and create an event in the Schedule calendar.

Calendar event is successfully created.

CALENDAR_EVENT XML

Report any error messages or onscreen errors, specifying the tool you were using when the error occurred. Each test step is a verification that the type conversion was successful for one or more tables in the database.

Test for SAK-598

SAK-598: Convert SmartSite production database to UTF-8 character encoding

Access Level: (blue star) Any tester can run this test
Test Description: The SmartSite production server is pending an upgrade to recognize UTF-8 characters; http://smartsite-test.ucdavis.edu is already upgraded. The initial test will verify that you are able to test the failure to display special characters on the production server. After the upgrade, you will verify that the production server now displays these characters correctly.

Test Steps: Test As Any User with ability to enter data online, for example, in Chat or Message Center or Tests & Quizzes

  1. Log into Smartsite-test.ucdavis.edu in one window and smartsite.ucdavis.edu in another window or tab.
  2. Select a tool in a course or project site that you have in common in both systems. The following steps will use Discussion Forum as an example
  3. Open another window or tab to the following UTF-8 Sampler website: http://www.columbia.edu/kermit/utf8.html
  4. Create a message (or enter data in another tool) by copying and pasting foreign language text from the sampler page. For example, copy the Greek phrase for "I can eat glass" into both browsers.
  5. Keep a list of the phrase and languages you used and continue this process until you've identified 3-5 languages which are displayed correctly on test and fail on the production server, smartsite.ucdavis.edu. Failure to interpret and display properly will be indicated by upside-down "?" or by a box character.
  6. Keep this list so that you can repeat this test after the production server is upgraded. Your repeat test will be verification that the production server upgrade is successful.

Test for SAK-305

SAK-305

Test steps: Compare these fixes on Smartsite-test with issues on Smartsite and confirm that no new issues are introduced in the UI.

Smartsite skin updates from Simon to correct the following issues:

  1. Fixed issue with grey background on content not extending to bottom of page in IE7 and IE6.
  2. Fixed: footer in IE7 not positioned at bottom of page
  3. Added min-width rule to stop header images wrapping in very narrow browser widths
  4. Fixed long site names forcing site select box edge off screen
  5. Fixed remaining scrollbar problems on some portletBody items, fixed selectNav dropping down below nav bar in IE browsers

Note: Fix for toolMenuWrap flowing past footer in IE6 still pending

Test for SAK-414

SAK-414

Working on SAK-8234 and SAK-7413 - rest of the test is good to go!

Patch to fix multiple Collab issues as listed in the Jira, including:

Verify UI Fixes

Test for SAK-7618, SAK-7423, SAK-7667

Log in as any user type in either a course or project site to perform these UI fix tests. Read the problem and view the thumbnail to see the issue being addressed.

Verify each UI issue is fixed in all of the following OS/browser combinations:

  • Windows XP SP2, Windows 2000 SP4 - Internet Explorer 6, Firefox 1.5.0.8
  • Mac OS X 10.4.8, Mac OS X 10.3.9 - Safari 2.0.4, Safari 1.2, Firefox 1.5.0.8
  • Additional test environment: VISTA - IE7

Steps

Problem

Thumbnail

Action

Expected Result

1

SAK-7618: If viewing an Edit screen in Smartsite.ucdavis.edu (pre-fix) in IE6, the UI tools are out of position. Critical to test for: IE6

Log into a course or project wiki and select Edit for any page. Verify the layout of edit features is compact, but not overlapping, and that features are visible and accessible.

Edit features are not overlapping and are visible and accessible to the user.

2

SAK-7423, SAK-7667: Hide help toolbar reduces screen visibility. Critical to test for: IE6, IE7, Firefox

From the Edit screen, select the hide the help sidebar "(-)" feature on the upper right hand side of the screen.

The edit area expands horizontally to fill the area the Help sidebar previously filled. There is no loss of height during the frame resizing.

Verify Functional Fixes

Test for SAK-7615, SAK-7457, SAK-5863
Log in to either a course or project site to perform these functional fix tests.
as any user type

Problem - SAK-7615: Removing all content from a Wiki page results in unrecoverable page loss.

Steps

Action

Expected Result

1

Select Wiki from your course menu and then select the Edit button. Type the name of a new page in square brackets, i.e., [new page]; select Save button.

"new page" will be shown as a hyperlink with a question mark after it on the Home page.

2

Select the new page and then select Edit button or link and delete all the default text in the text area box. Make sure the textarea is empty and Save. Select the new page.

An empty page may be saved without any errors and the page is still accessible without any errors.

Problem - SAK-7457: Cannot use special characters ~, ?, or & in links.

Steps

Action

Expected Result

1

Select Edit on any wiki page and add a link which has any of the special characters ~, ?, or &, for example, {link:Google|http://www.google.com/firefox?client=firefox-a&rls=org.mozilla:en-US:official}. Verify that the link works and is rendered correctly and does NOT add "#38" anywhere in the url string.

Link with any of these special characters still renders correctly.

Problem - SAK-5863: Macro reference outputs the word "null" instead of no text if description and short description are empty in Site Info.

Steps

Action

Expected Result

1

Log in as an Instructor and access Site Info, and then Edit Site Information. Delete text or confirm that there is no text under the Description and Short Description text areas.

Description and Short Description are empty fields.

2

Go to any page and select Edit. Enter the following information in the edit area and then Save:
title - {worksiteinfo:title}
description - {worksiteinfo:description}
shortdescription - {worksiteinfo:shortdescription}

The title should appear after "title - ", but no text should appear after "description - " or "shortdescription - "
The text "null" should not appear.

Verify Public View Fixes

Tests for SAK-8226 and 8224
Log in to either a course or project site as any user type to perform this test.

Problem - SAK-8226: Breadcrumbs do not appear in public view

Steps

Action

Expected Result

1

As any user type, create a new page from the Home page and add some text into it , then Save the page.

New page is created.

2

Select Info and locate Feeds?, and click on the Public View link (below Printer Friendly).

A new window should pop up with the content of the page on a different background.

3

Go back to the Info page and enable Public Read permission for this page by checking the first Public? checkbox and pressing the Save button (beneath Public?)

No visible change.

4

Repeat steps 2 and 3 for the Home page. Copy and save the new window Home page URL somewhere before closing the window. Close the browser and exit all windows.

Warning: This test is not run properly if you have other windows open!

5

Open a new Browser session and paste the saved Home page URL back into the browser.

You should see the content without being asked to log in.

6

Click on the new page link and verify that a breadcrumb appears at the top of the page.

Breadcrumb from the Home page allows you to easily return to the Home page and vice-versa at this point.

Problem - SAK-8224: View_right option does not appear on every page

Steps

Action

Expected Result

1

As any user type, create a new page named "view_right" on the Home page, e.g., select Edit from Home and type [view_right], and then Save the page. Select Edit on the new page and add some text.

A view_right page is created.

2

View each page in the wiki and verify that the new text appears to the right-hand side.

New view_right text visible on every page.

3

Go to Info for the view_right page and enable Public Read permission for this page by checking the first Public? checkbox and pressing the Save button (beneath Public?.) Ensure that Home and at least a couple other wiki pages are also enabled.

No visible change.

4

Copy and save the Home page Public View link URL somewhere before closing the window. Close the browser and exit all windows.

Warning: This test is not run properly if you have other windows open!

5

Open a new Browser session and paste the saved Home page URL back into the browser. Select and view every link from the home page.

You should see the content from the view_right page displayed to the right of every page.

Verify Permissions/Editing Collision Fixes

Tests for SAK-7530, SAK-8234, and SAK-7413
Log in to either a course or project site as any user type to perform this test.


Problem - SAK-7530: Permission reference to term "Update" confusing for users; replace with Edit

Collab fix to make the permissions reference consistent with the wiki function links. Prior to this fix, when the user selects Info, the first line in the permissions table reads: Page Permissions by role? Create? Read? Update? Admin? Super Admin?

Test: Verify that the first line in the permissions table now reads: Page Permissions by role? Create? Read? Edit? Admin? Super Admin?


Problem - SAK-8234: default_template permissions should equal Home page permissions

No test as of 3/12/07. Communicating with wiki collab team to verify UI and functionality here. L.Wilson
3/13/07 Fix did not get patched to v2.3 yet. This will be a separate Jira in the future.


Problem - SAK-7413: Browser refresh during rWiki edit session sends user back to Home page
This change request rose out of the situation where multiple users are editing in a wiki and the individual wants to refresh the page to see changes made. This refresh is also done by selecting the View link, but this test deals specifically with browser refresh.

Steps

Action

Expected Result

1

Log in to one browser as a user in the course or project site with a wiki. Go to any page other than Home and select Edit. Make text changes, but do not save yet.

Other users see no change in the wiki page yet.

2

Log in to another browser as a different user to the same site OR have another tester log into the same site. The other user will also choose Edit to make changes, and then Save the page.

Second user's changes are saved first.

3

First user may now save changes, but will need to modify those changes to work with second user's edits.

User can now see both second user's edits and his/her own changes.

4

Second user refreshes his/her browser.

The browser updates the current page so that the second user sees all changes - and does NOT get sent back to the Home page.


Verify Sensitive Information Fix

Test for SAK-8182:Wiki displays user login/Kerberos id which is exposing sensitive information

Log in to either a course or project site as any user type to perform this test.

Steps

Action

Expected Result

1

View the Home page and other pages in any Wiki as any user type and verify that only user names (first and last name) are displayed and Kerberos login is no longer displayed in last modified information.

Only user first and last names, but not Kerberos id are displayed in last modified.

Verify Performance Fix

Regression test required - no test plan at this time

Verify Gateway usage Fix

Regression test required - no test plan

Test for SAK-418

SAK-418

Patch to fix Collab issues -
SAK-8386: "The link and image buttons in the edit screen of the wiki tool do not work - in IE7 and Firefox, these buttons appear to refresh the page when clicked but have no effect over the text"
SAK-8329: "Click on the Resource Embed button in the RWiki - currently nothing at all happens."

Programmer/QA Note: this error was not reproduceable on SmartSite when tested on 3/6/07 and 3/7/07. May be based on code changes in preparation for 2.4 according to the original Jira.

Test Preparation:

  • Make sure you have Instructor and Student access to a course and/or project site with the Wiki tool available
  • Make sure that Resources is available on the same site with some graphic material, documents (.ppt, .doc, .xls, or .pdf) and some external URLs.

Test Steps:

Steps

User Acting As

Action

Expected Result

1

Instructor

Select Wiki from your course menu and then select the Edit button. Type the name of a new page in square brackets, i.e., [new page]; select Save button.

"new page" will be shown as a hyperlink with a question mark after it on the Home page.

2

Instructor

Select the new page and then select Edit button or link. You may edit or delete the text in the text area box. Select the Link icon (second from right of page editing tools.)

Selecting link will send the user to Resources.

3

Instructor

Use the select option under the Actions column in Resources to select a graphic, document or external url or click 'add new' to upload a new file from your computer. Select Continue at the bottom of the Resources page.

Coded link is added to the wiki page after a resource is selected and the user is returned to the wiki page.

4

Instructor

Select Save on the wiki edit page. Test the url to verify that it works.

A new link is displayed on the page. A graphic, html file or html selected from the url link may be displayed in the wiki frame; a link to a Word, Excel, PDF, PowerPoint or other document type is available as a downloadable file.

5

Instructor

Select the new page and then select Edit button or link. Select the Image icon (last one on the right of page editing tools.)

Selecting link will send the user to Resources.

6

Instructor

Use the select option under the Actions column in Resources to select a graphic file or or click 'add new' to upload a new image from your computer. Select Continue at the bottom of the Resources page.

The selected graphic is displayed in the wiki and is not a link.

7

Student

Log in as a Student in the course and repeat steps 1-6.

Results should be the same. May need to use 'add new' Resource function if student user has no files avaiilable.

8

project maintain user

Log in to a project site where you have a maintain role and repeat steps 1-6.

Results should be the same. May need to use 'add new' Resource function if project maintain user has no files avaiilable.

9

project access user

Log in to a project site where you have an access role and repeat steps 1-6.

Results should be the same. May need to use 'add new' Resource function if project access user has no files avaiilable.

Test for SAK-413

SAK-413

Patch to fix Collab issue -
SAK-8331: Clicking on RSS link in Firefox gives the following error: The server encountered an internal error () that prevented it from fulfilling this request.

Programmer/QA Note: this error was not reproduceable on SmartSite when tested on 3/6/07 and 3/7/07. May be based on code changes in preparation for 2.4 according to the original Jira.

Test Preparation:

  • Make sure you have Instructor and Student access to a course and/or project site with the Wiki tool available

Test Steps:

  • As an Instructor, access Wiki in your course and select the RSS icon in the upper right hand corner from various pages of the wiki.
  • Verify that no error messages appear. If an error message occurs, document in the Jira what you were doing/accessing when the error occurred and post a screen shot of the error.
  • Repeat these steps as a Student in the course site.
  • Repeat these steps as a project site member with maintain permission.
  • Repeat these steps as a project site member with access permission.