mySql BUG

am 11.06.2003 13:23:24 von Dyego Souza do Carmo

Hi,

Try to do the following:

*) Import the dump file I sent to you attached to this e-mail. There is a
table called l5 and some data in the dump file.

*) run the command:

select conjuge.l5_nome from l5 as conjuge, l5 as parte where parte.l5_parte
= 8 and parte.l5_seq = 0 and conjuge.l5_parte = parte.l5_parteconjuge order
by conjuge.l5_seq desc limit 1;

It shows the error 1105: Unknown error <-- here is the bug!!!

*) run the command:

select conjuge.l5_nome from l5 as conjuge, l5 as parte where parte.l5_parte
= 8 and parte.l5_seq = 0 and conjuge.l5_parte = parte.l5_parteconjuge group
by conjuge.l5_seq having max(conjuge.l5_seq);

It returns an empty set. It is what I would like had happend in the previous command.

My System is Linux Debian Box kernel 2.4.18...
with 768 of ram and MySQl 4.0.13 using InnoDB Tables !!!

I have a dump of table with the bug ! i cant send file to the list...
exists a FTP to put the file ?

sql,query,innodb,hellllp please

------------------------------------------------------------ -------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
------------------------------------------------------------ -------------
E S C R I B A I N F O R M A T I C A
------------------------------------------------------------ -------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- ICQ : 1647350
$ look into "my eyes" Phone : +55 041 296-2311
look: cannot open my eyes Fax : +55 041 296-6640
------------------------------------------------------------ -------------
Reply: dyego@escriba.com.br

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: mySql BUG

am 11.06.2003 19:16:16 von Sinisa Milivojevic

Dyego Souza do Carmo writes:
> Hi,
>
>
> Try to do the following:
>

[skip]

>
>
> ------------------------------------------------------------ -------------
> ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
> ------------------------------------------------------------ -------------
> E S C R I B A I N F O R M A T I C A
> ------------------------------------------------------------ -------------
> The only stupid question is the unasked one (somewhere in Linux's HowTo)
> Linux registred user : #230601
> -- ICQ : 1647350
> $ look into "my eyes" Phone : +55 041 296-2311
> look: cannot open my eyes Fax : +55 041 296-6640
> ------------------------------------------------------------ -------------
> Reply: dyego@escriba.com.br
>

Hi!

Your attachment was stripped off.

Please upload it to:

ftp://support.mysql.com:/pub/mysql/secret

and let us know it's filename.

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: mySql BUG

am 11.06.2003 19:16:16 von Sinisa Milivojevic

Re[2]: mySql BUG

am 11.06.2003 19:19:11 von Dyego Souza do Carmo

Sinisa:

Wednesday, June 11, 2003, 2:16:16 PM, você escreveu:

---------------[inicio]------------------

SM> Hi!

SM> Your attachment was stripped off.

SM> Please upload it to:

SM> ftp://support.mysql.com:/pub/mysql/secret

SM> and let us know it's filename.

The FileName is l5.zip

---------------[cortar]------------------

------------------------------------------------------------ -------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
------------------------------------------------------------ -------------
E S C R I B A I N F O R M A T I C A
------------------------------------------------------------ -------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- ICQ : 1647350
$ look into "my eyes" Phone : +55 041 296-2311
look: cannot open my eyes Fax : +55 041 296-6640
------------------------------------------------------------ -------------
Reply: dyego@escriba.com.br

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re[2]: mySql BUG

am 11.06.2003 19:19:11 von Dyego Souza do Carmo

Re: Re[2]: mySql BUG

am 11.06.2003 19:27:54 von Sinisa Milivojevic

Dyego Souza do Carmo writes:
> Sinisa:
>=20
> Wednesday, June 11, 2003, 2:16:16 PM, voc=EA escreveu:
>=20
> ---------------[inicio]------------------
>=20
>=20
>=20
> The FileName is l5.zip
>=20
>=20
> ---------------[cortar]------------------
>=20
>=20
>=20
> ------------------------------------------------------------ ---------=
----
> ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento =20
> ------------------------------------------------------------ ---------=
----
> E S C R I B A I N F O R M A T I C A
> ------------------------------------------------------------ ---------=
----
> The only stupid question is the unasked one (somewhere in Linux's How=
To)
> Linux registred user : #230601
> -- ICQ : 1647350 =
=20
> $ look into "my eyes" Phone : +55 041 296-2311 =
=20
> look: cannot open my eyes Fax : +55 041 296-6640 =
=20
> ------------------------------------------------------------ ---------=
----
> Reply: dyego@escriba.com.br
>=20
>=20

Thanks. We shall take a look at it.
=20

--=20

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=3Dm=
smi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinat=
or
<___/ www.mysql.com Larnaca, Cyprus

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql@m.gmane.org

Re: Re[2]: mySql BUG

am 11.06.2003 19:27:54 von Sinisa Milivojevic

Thousands of users? Newbie question

am 11.06.2003 19:35:46 von hosting

Hi Guys,

I intend my online database to be used by 100 or so companies each with up
to 100 employees. Each of these employees may add data as required. I
don't want to assign one password for an entire company, in case one
disgruntled ex-employee decides to post erroneous data.

So presumably I need to issue each employee a username and password, then
remove this when the employee leaves the company (or grant an admin for that
company permission to do it).

My questions are :

How is the username and password issue best handled when so many potential
users are involved?

Should a username and password be added to the web form used to add data?
or
Should I just use .htaccess to grant usernames and passwords so no
unauthorized user can access the submission form in the first place?

Which is less resource hungry?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Thousands of users? Newbie question

am 13.06.2003 00:32:50 von Curtis Maurand

I think that I would code it into my application. Essentially, I would
set up Agents on your end so that your customer service folks can set up
companies and administrative users for those companies. Then let the
companies handle their own users. Each company would have a database
password and a username/password combo to access their admin section of
the website.

Curtis

On Wed, 11 Jun 2003, 2Hosts.com wrote:

> Hi Guys,
>
> I intend my online database to be used by 100 or so companies each with up
> to 100 employees. Each of these employees may add data as required. I
> don't want to assign one password for an entire company, in case one
> disgruntled ex-employee decides to post erroneous data.
>
> So presumably I need to issue each employee a username and password, then
> remove this when the employee leaves the company (or grant an admin for that
> company permission to do it).
>
> My questions are :
>
> How is the username and password issue best handled when so many potential
> users are involved?
>
> Should a username and password be added to the web form used to add data?
> or
> Should I just use .htaccess to grant usernames and passwords so no
> unauthorized user can access the submission form in the first place?
>
> Which is less resource hungry?
>
>
>

--
--
Curtis Maurand
mailto:curtis@maurand.com
http://www.maurand.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

RE: Thousands of users? Newbie question

am 13.06.2003 06:07:34 von Daevid Vincent

Look into mod_auth_mysql -- this module rocks and I use it all the time.

> -----Original Message-----
> From: Curtis Maurand [mailto:curtis@maurand.com]
> Sent: Thursday, June 12, 2003 3:33 PM
> To: 2Hosts.com
> Cc: mysql@lists.mysql.com
> Subject: Re: Thousands of users? Newbie question
>
>
>
>
> I think that I would code it into my application.
> Essentially, I would
> set up Agents on your end so that your customer service folks
> can set up
> companies and administrative users for those companies. Then let the
> companies handle their own users. Each company would have a database
> password and a username/password combo to access their admin
> section of
> the website.
>
> Curtis
>
> On Wed, 11 Jun 2003, 2Hosts.com wrote:
>
> > Hi Guys,
> >
> > I intend my online database to be used by 100 or so
> companies each with up
> > to 100 employees. Each of these employees may add data as
> required. I
> > don't want to assign one password for an entire company, in case one
> > disgruntled ex-employee decides to post erroneous data.
> >
> > So presumably I need to issue each employee a username and
> password, then
> > remove this when the employee leaves the company (or grant
> an admin for that
> > company permission to do it).
> >
> > My questions are :
> >
> > How is the username and password issue best handled when so
> many potential
> > users are involved?
> >
> > Should a username and password be added to the web form
> used to add data?
> > or
> > Should I just use .htaccess to grant usernames and passwords so no
> > unauthorized user can access the submission form in the first place?
> >
> > Which is less resource hungry?
> >
> >
> >
>
> --
> --
> Curtis Maurand
> mailto:curtis@maurand.com
> http://www.maurand.com
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?> unsub=daevid@daevid.com
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org