| Author |
Topic |
|
tduggan
Starting Member
26 Posts |
 Posted - 2011-09-28 : 15:37:27
|
This is Tara (tkizer) but using another account. The tkizer account has 32,768 posts and can no longer even open up any topics due to an overflow. Haha!I've notified Bill, and he's going to look into it soon, perhaps tonight. Guess I'll have to focus on real work for now!  ~Tara Kizer (formerly Tara Duggan, hence this userid) |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-09-28 : 15:50:01
|
A-HA! Now my plan to catch up can begin!  Can you check if this error only occurs on the topic.asp page? I think I found the problem and it's a simple fix. Also check the email and spam nuke pages. |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2011-09-28 : 15:51:07
|
| LOL - That's impressive! Your post count blew out the datatype Be One with the OptimizerTG |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2011-09-28 : 16:04:57
|
| I think with your posting rate Bill should go right to BIGINT.Be One with the OptimizerTG |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-09-28 : 16:05:01
|
There's a forced conversion to CInt, meaning smallint. Change that to CLng and she's good to 4 billion posts.  |
|
|
|
tduggan
Starting Member
26 Posts |
Posted - 2011-09-28 : 16:06:06
|
| Rob, yes the email page is blowing up as well. Yes it was topic.asp where I noticed the problem. Not sure how to get to the spam nuke page without being able to open up a post, but I'm sure you are right that it is broken too.Thanks! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
tduggan
Starting Member
26 Posts |
Posted - 2011-09-28 : 16:55:30
|
| That link came up successfully.The site is extremely slow under my tkizer account but is very fast under this tduggan account. Not sure what would cause that, but thought it was interesting. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-09-28 : 17:21:24
|
| If I dug around in the code I'd probably find it, maybe to do with highlighting topics you've visited before.Another thing we should mention to graz at PASS summit is making code changes and other site-related stuff. |
|
|
|
tduggan
Starting Member
26 Posts |
Posted - 2011-09-28 : 17:38:12
|
| Oh, so you can't change the code? Alright, well I'll pester Bill if he doesn't get to it tonight. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-09-28 : 17:39:14
|
| Well, I can change it, but I'd rather not without his approval. That's basically what we should ask him at PASS. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-28 : 20:56:23
|
| LOL. TaraSmallInt.I was once hired to migrate a legacy system (from dbase) that failed because a customer ordered over 100 items. Yep, the quantity was stored in a 2 byte character field! What should've been our best sales day ever was our worst because the system crashed. (We hadn't completed the migration yet). Ouch.To make matters worse, I was out of town soliciting potential business partners. Had to excuse myself from a meeting to get on the phone with the CEO, my developers etc.Fun fun. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-09-28 : 21:08:22
|
LOL. Somebody warn visakh16 Or maybe he can just create visakh32 when he hit the 32K limit. 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-28 : 23:20:10
|
quote:
Originally posted by khtan
LOL. Somebody warn visakh16 Or maybe he can just create visakh32 when he hit the 32K limit.
KH[spoiler]Time is always against us[/spoiler]
I've taken a note of this So might come with visakh32 once I hit the limit ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-29 : 02:44:09
|
| Visakh: You knew about this all along for sure ... always wondered why you were "16" "TaraSmallInt"Tara31Bit surely ? Any I think the original design team should be blamed for not starting everyone's post counts at -32,767 |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-09-29 : 02:56:55
|
Kristen you have a solution there. Just subtract everybody post count by -32,767 ! problem solved 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-29 : 03:27:45
|
| Cracking idea ... I'm off to TEST it by trying to delete more posts that I have made ... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-29 : 03:30:07
|
| Or change Tara's existing account to tduggan, and her new one to tkizer, and then no one will be confused, eh?! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-29 : 03:32:18
|
| That gives me another idea: lock all accounts each month, and get everyone to create a new account. Problem solved. (well, might not work for Visakh ... he'll have to take a day or two off during each month )I could resign from my DEV job and get a job in Support ! |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-09-29 : 06:42:22
|
| Hasn't graz done some serious performance tuning on this forum already? These snitz-guys obviously weren't thinking too much about performance and scalability when they made this thing...- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-09-29 : 07:37:24
|
| Well, in their defense, they coded it for MySQL, which had blazing performance back in 1998. And explains why the dates are stored as strings, and the JOINs are, well, better not get into that. |
|
|
|
Next Page
|
tkizer - out of commission for now