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

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

Reply via email to