Hi,

Ok for sub-select. I thinks that sub select is nt compatible with all 
version of mysql.
Correction in next commit for notification by mail.

For by annotation in my description, next development will be done. But next 
time, I would not make these annotations.

Bye,

Ruben


----- Original Message ----- 
From: "Pierrick LE GALL" <[EMAIL PROTECTED]>
To: "Ruben" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, March 09, 2006 10:05 PM
Subject: Re: [Phpwebgallery-cvs] r1070 - in /trunk: ./ admin/ admin/include/ 
include/ install/ install/db/ language/en_UK.iso-8859-1/ 
language/fr_FR.iso-8859-1/


Hi Ruben,

Ruben <[EMAIL PROTECTED]> writes:

> Author: rub
> Date: Thu Mar  9 00:14:53 2006
> New Revision: 1070
>
> URL: http://svn.gna.org/viewcvs/phpwebgallery?rev=1070&view=rev
> Log:
> Step 1 improvement issue 0000301:
>   o Change status of table #_user_infos
>   o Don't send password to webmaster, guest, generic

select
  id user_id, username, mail_address
from
  phpwebgallery_users
where
  mail_address is not null and
  id not in (select user_id from phpwebgallery_user_mail_notification)
order by
  id;
[mysql error 1064] You have an error in your SQL syntax.  Check the manual 
that corresponds to your MySQL server version for the right syntax to use 
near 'select user_id from phpwebgallery_user_mail_notification)
order

Please, do not use "sub selects".

> Next Step:
>   o Functions Check of status
>   o Restricted Access for user generic

Did you made these modification in your commit? If not, please do not
tell about next steps (in case you wouldn't do them).

Bye

-- 
Pierrick LE GALL



---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 0610-1, 08/03/2006
Tested on: 09/03/2006 22:32:49
avast! is copyright (c) 2000-2003 ALWIL Software.
http://www.avast.com




_______________________________________________
Phpwebgallery-cvs mailing list
Phpwebgallery-cvs@gna.org
https://mail.gna.org/listinfo/phpwebgallery-cvs

Reply via email to