Lists all of the journal entries for the day.

Fri, 2 Jan 2004

12:25 AM - Hmm.. DONT USE EDIT COMMENTS

I have a big problem with edit comments. The subject is deleted and the body isn't saved. Then when you try to view the comments they are not there. (still in mysql)

Its very odd. I wish i could figure it out.

location: Home

()

1:41 AM - SHIT

I just fucked up all the comments. The subject's are now 0. I have a text file with the original subjects at least (i always do a select on a table before updating and copied it from my console when i fucked up)

I'll have to fix them tomorrow. I'm to tired at this point.

Something is wrong with MYSQL though. The character set fields aren't set anymore. I'm starting to wonder if the new code is using UTF8 and JSP defaults to iso whatever.. sending 2 byte characters to a database expecting 1 byte could be VERY bad.

what i don't get is why the subjects fucked up since i was using the msyql command line client AND not java stuff.

()

3:59 AM - what was i thinking..

last time i compiled the kernel for freebsd i installed a generic kernel. AHHHGG. everything is so screwed up right now.

I decided to clean out the bs that was installed via ports tonight on the server and get a new kernel.

Lets hope this fixes the stability problems. Then its only a matter of figuring out whats wrong with mysql.

(an add drop of the table ain't out of the question at this point)

()

5:40 PM - JJ update

I have edit comments working! There might be a few bugs with special characters and the XML/XSL setup yet but at least its possible to alter comments.

I also created a new index on entry security. The change improved the query plan to view journal entries quite a bit. In the case of my username, it cut the number of records in one part of the query from 248 to 164.

I'll have to play with mysql optimization techniques when i get more time. Its obviously worth it!

location: Home

()