Re: [Subtext-devs] R: NullRefException on gallery page

[Phil H. <ha...@gm...>]

Ah! Did you update your database with the latest SPs? I forgot to send =
out
an email saying I updated the schema. Sorry!

=20

From: sub...@li...
[mailto:sub...@li...] On Behalf Of Simone
Chiaretta
Sent: Monday, March 26, 2007 6:25 AM
To: sub...@li...
Subject: [Subtext-devs] R: NullRefException on gallery page

=20

Yes, changed on 2327 by Phil which refactored something in that part of =
the
code.... he merged the getcategorybyid and getcategorybyname in just one =
SP
with "optional" parametes.

=20

so, I'm going to uncomment my fix :)

=20

Simo

=20

-------------------------
Simone Chiaretta
www.codeclimber.net.nz <http://www.codeclimber.net.nz/>=20
Any sufficiently advanced technology is indistinguishable from magic

"Life is short, play hard"

-----Messaggio originale-----
Da: sub...@li...
[mailto:sub...@li...] Per conto di Steve
Harman
Inviato: marted=EC 27 marzo 2007 1.08
A: sub...@li...
Oggetto: Re: [Subtext-devs] NullRefException on gallery page

I have the galleries enabled on my site and the seem to be working =
(running
v1.9.4.78). Can you check SVN and see if one of those SPs has changed
recently?

On 3/26/07, Simone Chiaretta <sim...@pi...> wrote:=20

Hi guys,

is anybody having the same problem I've?

Everytime I access a gallery category I get a null reference =
exception...
(on my local dev machine, but don't know online since I don't use the
gallery online)

basically what is happening is that the subtext_GetImageCategory sp =
should
return 2 datareaders

the first should contain the name and descr of the category

the second the list of images in the category

=20

but the first was always empty even if the data were in the database:

=20

the SP calls inside that:

EXEC [dbo].[subtext_GetCategory] @CategoryID, @IsActive, @BlogId

=20

but that SP doesn't have only 3 params, but have 5 params in the =
following
order:

=20

@CategoryName nvarchar(150) =3D NULL

, @CategoryID int =3D NULL

, @IsActive bit=20

, @BlogId int =3D NULL=20

, @CategoryType tinyint =3D NULL=20

 =20

what was happening is that probably the params inside exec statement =
above
were interpreted as CategoryName,CategoryID, IsActive, or at least is =
what I
guess since that sp always returned an empty reader.

=20

I fixed the problem on my machine changing=20

EXEC [dbo].[subtext_GetCategory] @CategoryID, @IsActive, @BlogId

=20

to=20

=20

EXEC [dbo].[subtext_GetCategory] @CategoryID=3D@CategoryID,
@IsActive=3D@IsActive, @BlogId=3D@BlogId

=20

Now it works on my machine, but since nobody ever reported such a =
problem
before I'm wondering if it's something wrong with my SQL server or other
thing

=20

Any Idea?

Simo

=20

-------------------------
Simone Chiaretta
www.codeclimber.net.nz <http://www.codeclimber.net.nz/>=20
Any sufficiently advanced technology is indistinguishable from magic

"Life is short, play hard"

=20


-------------------------------------------------------------------------=

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share =
your

opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=3Djoin.php
<http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV>
&p=3Dsourceforge&CID=3DDEVDEV
_______________________________________________
Subtext-devs mailing list
Sub...@li...
https://lists.sourceforge.net/lists/listinfo/subtext-devs
<https://lists.sourceforge.net/lists/listinfo/subtext-devs>=20




--=20
//----  90% of being smart is knowing what you're dumb at  ----//
http://stevenharman.net/=20