Monday, July 20, 2009

Problem to-be solved: Phase I + II

Tasks still need to be solved for Phase I & II:
  1. Review page still have problem to redirect back to 'home' for viewing reviews
  2. Add "Review for Game title" to review page.
  3. solved Average rating of each game.
  4. solved Change table to add fields suitable to site's content.
  5. solved Add & display submit date, user
Task 4 & 5:
I has quiet some trouble making changes to add fields I want into the database, since they don't seems to take effect at all. I realize that after the table is created, no change will take effect. Therefore, I must go into mySQL database and delete the table from there using command: drop table [tablename]

I made changes to the metadata table:
  1. changing the name of some columns -so they fit the content they contain
  2. added 2 new columns: a) datestamp & b) userid - for tracking who added each entry and when
This caused massive change file metadata.java and metadataServlet.java, and I wasn't able to test it until almost all changes are done, since they are interconnected. They is making debugging difficult. The problem is found - a small syntax error.

No comments:

Powered By Blogger