Snitz Forums 2000 - "Exception occurred" error when updating counts

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: Database: MySql

"Exception occurred" error when updating counts

New Topic

Topic Locked

Printer Friendly

Author

Topic

Page: of 3

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 January 2008 : 12:54:46

I would strongly suggest the change to double. Most users won't be able to handle these errors on their own, if their MySQL install is not up to date.

Snitz 3.4 Readme | Like the support? Support Snitz too

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 07 January 2008 : 13:23:26

Sure thing. I am noticing that MySQL document shows SUM() returns NULL for no matching rows, and we are testing for:

if expression <> "" then

instead of:

if IsNull(expression) then

or:

if expression <> Null then

More testing would be needed it seems. Or we fix the errors as they are reported.

Support Snitz Forums

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 January 2008 : 13:31:12

I don't know why they just don't return 0.

Snitz 3.4 Readme | Like the support? Support Snitz too

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 07 January 2008 : 13:36:44

quote:
Originally posted by ruirib

I don't know why they just don't return 0.

Give developers something to worry about, I guess.

Support Snitz Forums

AnonJr
Moderator

United States
5768 Posts

Posted - 07 January 2008 : 14:14:54

quote:
Originally posted by ruirib

I don't know why they just don't return 0.

Because that would make sense? I could think of other semi-rational reasons... but those might start some heated arguments.

Page: of 3

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.09 seconds.