Once we have the code working for PostgreSQL, I think we should go on to implementing triggers for post number incrementing, et al.
But I still have to fix the filter first anyway,
Mal: You know, you ain't quite right. River: It's the popular theory.
'Objects In Space'
Buffistas Building a Better Board
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
§ ita § - Jun 08, 2004 11:50:38 am PDT #7916 of 10000
Well not canonically, no, but this is transformative fiction.
DXMachina - Jun 08, 2004 11:50:40 am PDT #7917 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
The new back end.
tommyrot - Jun 08, 2004 11:55:27 am PDT #7918 of 10000
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
I wonder if things were coded assuming Count(0) =0?
DX, I think my explanation still applies. I think the code will always set the post_number one too high, but after this happens once then future posts will follow in correct sequence.
msbelle, the sign-in problem was fixed (assuming there was only one sign-in problem). Last night my internet access died, so I didn't do any fixing beyond that. So there are still some known issues for me to fix.
I don't know offhand if all possible functionality has been tested yet.
edit for spelling....
tommyrot - Jun 08, 2004 4:11:26 pm PDT #7919 of 10000
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
No one post in the test board, please. I'm changing code so....
tommyrot - Jun 08, 2004 5:26:32 pm PDT #7920 of 10000
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
OK, I fixed a bunch of stuff. I'm going to exercise for a bit.
Can somebody(s) go to BBaBB on the test system, see what I did, and remind me what else needs to be done?
DCJensen - Jun 09, 2004 3:57:19 pm PDT #7921 of 10000
All is well that ends in pizza.
I'd like to help out, but I never got the confirmation email.
DXMachina - Jun 09, 2004 4:10:43 pm PDT #7922 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
Daniel, I just sent it again, and activated the account. Let me know if you don't get it.
tommyrot - Jun 09, 2004 4:16:35 pm PDT #7923 of 10000
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Maybe Daniel originally registered back when the confirmation email didn't have a "from" address? (which caused some spam filters to reject it)
Huh--I just noticed that nothing is in the user_timestamp field. Is this being used? Maybe the MySQL version this field defaults to Now()?
§ ita § - Jun 09, 2004 4:38:16 pm PDT #7924 of 10000
Well not canonically, no, but this is transformative fiction.
You can check out the table structures using the MySQL command line utility, tommyrot -- there are definitely defaults and restrictions therein.
tommyrot - Jun 09, 2004 4:44:22 pm PDT #7925 of 10000
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Yeah, but I'm being lazy....
OK, at some point I'll have to check all the MySQL tables for defaults, as I think I missed another default for the bookmarks table.