I broke ilug

[Brad Spangler]

Well, we can try looking at it analytically. I'm a
Linux newbie and a non-programmer (for the most part)
- but I work in tech support and decipher previously
unknown error messages for a living.

Real programmers might laugh at my half-arsed
guesswork, and where I'm right I might be re-stating
the obvious, but here goes...

The script "sql_layer.php" has a statement on line
253.

That statement calls some sort of function named
"mysql_num_rows".

There is an argument (a piece of secondary data,
usually in the form of some sort of variable) linked
to that function.

The value that is currently in that variable refers to
a MySQL resource that is not valid - probably because
it is not present after deleting the table mentioned
earlier.

My guess is that something is pointing at something
that is no longer there. Again, I might be re-stating
the obvious. (shrug)

Can you FTP in and download the "sql_layer.php" file
and open it up with a text editor that has line
numbers? Might be a source of more clues...

--- Kurt Kessler <kessler2k at yahoo.com> wrote:
> Well, i cant log in with my account or creating
> another one... but there is this tidbit up at top...
> 
> Warning: mysql_num_rows(): supplied argument is not
> a
> valid MySQL result resource in
> /home/ilugorg/public_html/includes/sql_layer.php on
> line 253
> 
> dunno what significance it has, but im sure someone
> here will know.
> 
> Kurt
> 
> --- Eric Rossiter <rossiter at discoverynet.com> wrote:
> > Evening Lugnuts,
> > 
> > Help!!!  I was messing with a new theme at
> ilug.org,
> > and all of a sudden
> > I couldn't log into the administrator account
> > (admin.php). 
> > 
> > I've spent several hours gooling and trying
> > different things.  One of
> > the suggestions, was to delete the nuke_authors
> > table, which would force
> > a re-creation of the administrator account when
> > going to admin.php.
> > 
> > Well this is true, I'm prompted to create a super
> > user for the site, and
> > when I fill out all the info and try to submit I
> get
> > the following:
> > 
> > Warning: mysql_num_rows(): supplied argument is
> not
> > a valid MySQL result
> > resource in
> > /home/ilugorg/public_html/includes/sql_layer.php
> on
> > line 253
> >  
> > Any ideas, anyone... anywhere...
> > 
> > I'm lost at this point and ilug is less than
> > functional.
> > 
> > To re-create the whole process:
> > http://ilug.org/admin.php
> > 
> > If someone gets it to work, please let me know
> what
> > you set for admin
> > and pass.  =)
> > 
> > Thanks for your time,
> > E
> > 
> > 
> > 
> > 
> > 
> > 
> > KC Linux Users Group -- to unsubscribe send mail
> to
> > majordomo at kclug.org
> > Enter without the quotes in body of message
> 
> 
> =====
> 32 bit extensions and a graphical
> shell for a 16 bit patch to an 8 bit operating
> system
> originally coded for a 4 bit microprocessor, written
> by a 2 bit company that can't stand 1 bit of
> competition.
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> http://mailplus.yahoo.com
> 
> 
> majordomo at kclug.org
> Enter without the quotes in body of message

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com