[thesite] LONG to CLOB

[Dean Mah]

I've migrated the LONG 'body' field in the CONTENT table to a CLOB
last night.  I sumbitted a test article which seemed to work without
problem.  The article was inserted into the database without having to
change the CF code.

A few things happened during the conversion:

1) When doing an export, I ran into a problem with shared pool memory.
   I bounced the database and that resolved the problem.  This is only
   a temporary solution.  The memory on the test Oracle database needs
   to be tuned a little better.

2) When I first switched to the new table, teo started throwing
   errors. This was related to a faulty SQL query.  The 'datemod'
   field was being compared to an empty string.  The
   session.user.lastlogin variable was not being set.  I restarted the
   CF server and that seemed to fix it.

3) The content table has three fields that have a NOT NULL constraint
   on them: 'rating', 'ratings', and 'replies'.  The teo code did not
   supply default values for these fields and so the article
   submission failed.  I removed these constraints and then submission
   worked.  I don't know how the original table was created so I might
   have missed something when duplicating it.

I'll be out of town for the next couple of days and am not sure if I
will be able to check e-mail but everything should be working.  If it
does cause problems, the original table can be put back into place.
It's been renamed CONTENT_ORIG.

Dean