1. no direct mails -> mail to the list!
2. maybe you should make yourself familiar with php, mysql and SQL first!
3.
gaillac harry wrote:
Here is my missed_calls.php
Where is the SQL query file ???
$q="select username, domain from ".$config->table_aliases. " where'sip:".$auth->auth["uname"]."@".$config->default_domain."'=contact";
this is an SQL query
oh, here is antohter one
$q="delete from ".$config->table_missed_calls. " where username='".$row."' and domain='".$dom."' ". " and time<'".gmdate("Y-m-d H:i:s", $page_loaded_timestamp)."'"; $res=mySQL_query($q); if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; }
and again a query!
*/ $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC";
That's probably not very useful for you (as it looks like you have no glue what you are talking about - sorry), but I will give you another hint from your previous mail:
I've still a problem with missed_calls.php from serweb "error in SQL query, line: 77 No missed calls".
--> check line 77 and you will find a query just before it!
klaus
This may be a little to bad...
but www.google.com is a HELL of a good place to find info. I think Everyboy here started out on that spot.. Or what do you say Klaus? + README files are there to be read!
- Atle
* Klaus Darilion klaus.mailinglists@pernau.at [040427 12:45]:
no direct mails -> mail to the list!
maybe you should make yourself familiar with php, mysql and SQL first!
gaillac harry wrote:
Here is my missed_calls.php
Where is the SQL query file ???
$q="select username, domain from ".$config->table_aliases. " where'sip:".$auth->auth["uname"]."@".$config->default_domain."'=contact";
this is an SQL query
oh, here is antohter one
$q="delete from ".$config->table_missed_calls. " where username='".$row."' and domain='".$dom."' ". " and time<'".gmdate("Y-m-d H:i:s", $page_loaded_timestamp)."'"; $res=mySQL_query($q); if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; }and again a query!
*/ $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC";
That's probably not very useful for you (as it looks like you have no glue what you are talking about - sorry), but I will give you another hint from your previous mail:
I've still a problem with missed_calls.php from serweb "error in SQL query, line: 77 No missed calls".
--> check line 77 and you will find a query just before it!
klaus
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Thanks Atle
I use google everyday as many people.if you find my problem on google please send it me back .
Regards
Le mar 27/04/2004 à 13:39, Atle Samuelsen a écrit :
This may be a little to bad...
but www.google.com is a HELL of a good place to find info. I think Everyboy here started out on that spot.. Or what do you say Klaus?
- README files are there to be read!
- Atle
- Klaus Darilion klaus.mailinglists@pernau.at [040427 12:45]:
no direct mails -> mail to the list!
maybe you should make yourself familiar with php, mysql and SQL first!
gaillac harry wrote:
Here is my missed_calls.php
Where is the SQL query file ???
$q="select username, domain from ".$config->table_aliases. " where'sip:".$auth->auth["uname"]."@".$config->default_domain."'=contact";
this is an SQL query
oh, here is antohter one
$q="delete from ".$config->table_missed_calls. " where username='".$row."' and domain='".$dom."' ". " and time<'".gmdate("Y-m-d H:i:s", $page_loaded_timestamp)."'"; $res=mySQL_query($q); if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; }and again a query!
*/ $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC";
That's probably not very useful for you (as it looks like you have no glue what you are talking about - sorry), but I will give you another hint from your previous mail:
I've still a problem with missed_calls.php from serweb "error in SQL query, line: 77 No missed calls".
--> check line 77 and you will find a query just before it!
klaus
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Ok thanks !
I'm not a php/mysql developper I can't rewrite serweb, I try my best to correct configs files (config.php). it would be a good thing stables ser+serweb releases match.
Harry
Le mar 27/04/2004 à 12:44, Klaus Darilion a écrit :
no direct mails -> mail to the list!
maybe you should make yourself familiar with php, mysql and SQL first!
gaillac harry wrote:
Here is my missed_calls.php
Where is the SQL query file ???
$q="select username, domain from ".$config->table_aliases. " where'sip:".$auth->auth["uname"]."@".$config->default_domain."'=contact";
this is an SQL query
oh, here is antohter one
$q="delete from ".$config->table_missed_calls. " where username='".$row."' and domain='".$dom."' ". " and time<'".gmdate("Y-m-d H:i:s", $page_loaded_timestamp)."'"; $res=mySQL_query($q); if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; }and again a query!
*/ $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC";
That's probably not very useful for you (as it looks like you have no glue what you are talking about - sorry), but I will give you another hint from your previous mail:
I've still a problem with missed_calls.php from serweb "error in SQL query, line: 77 No missed calls".
--> check line 77 and you will find a query just before it!
klaus
I think the problem is, that there is no stable serweb.
klaus
gaillac harry wrote:
Ok thanks !
I'm not a php/mysql developper I can't rewrite serweb, I try my best to correct configs files (config.php). it would be a good thing stables ser+serweb releases match.
Harry
Le mar 27/04/2004 à 12:44, Klaus Darilion a écrit :
no direct mails -> mail to the list!
maybe you should make yourself familiar with php, mysql and SQL first!
gaillac harry wrote:
Here is my missed_calls.php
Where is the SQL query file ???
$q="select username, domain from ".$config->table_aliases. " where'sip:".$auth->auth["uname"]."@".$config->default_domain."'=contact";
this is an SQL query
oh, here is antohter one
$q="delete from ".$config->table_missed_calls. " where username='".$row."' and domain='".$dom."' ". " and time<'".gmdate("Y-m-d H:i:s", $page_loaded_timestamp)."'"; $res=mySQL_query($q); if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; }and again a query!
*/ $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC";
That's probably not very useful for you (as it looks like you have no glue what you are talking about - sorry), but I will give you another hint from your previous mail:
I've still a problem with missed_calls.php from serweb "error in SQL query, line: 77 No missed calls".
--> check line 77 and you will find a query just before it!
klaus
Do you think $q would be the problem with mysql-server-3.23.56-1.9
/* we have here a UNION statement -- that speeds up queries a lot as opposed to having an OR condition; it takes mysql 4.0.0 at least */ --------------------------------------------------------------------------- $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC"; ------------------------------------------------------------------------------ $mc_res=mySQL_query($q); if (!$mc_res) {$errors[]="error in SQL query, line: ".__LINE__; break;}
Harry
Le mar 27/04/2004 à 14:38, Klaus Darilion a écrit :
I think the problem is, that there is no stable serweb.
klaus
gaillac harry wrote:
Ok thanks !
I'm not a php/mysql developper I can't rewrite serweb, I try my best to correct configs files (config.php). it would be a good thing stables ser+serweb releases match.
Harry
Le mar 27/04/2004 à 12:44, Klaus Darilion a écrit :
no direct mails -> mail to the list!
maybe you should make yourself familiar with php, mysql and SQL first!
gaillac harry wrote:
Here is my missed_calls.php
Where is the SQL query file ???
$q="select username, domain from ".$config->table_aliases. " where'sip:".$auth->auth["uname"]."@".$config->default_domain."'=contact";
this is an SQL query
oh, here is antohter one
$q="delete from ".$config->table_missed_calls. " where username='".$row."' and domain='".$dom."' ". " and time<'".gmdate("Y-m-d H:i:s", $page_loaded_timestamp)."'"; $res=mySQL_query($q); if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; }and again a query!
*/ $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC";
That's probably not very useful for you (as it looks like you have no glue what you are talking about - sorry), but I will give you another hint from your previous mail:
I've still a problem with missed_calls.php from serweb "error in SQL query, line: 77 No missed calls".
--> check line 77 and you will find a query just before it!
klaus
yes, you need mysql 4 for UNIONS
klaus
gaillac harry wrote:
Do you think $q would be the problem with mysql-server-3.23.56-1.9
/* we have here a UNION statement -- that speeds up queries a lot as opposed to having an OR condition; it takes mysql 4.0.0 at least
*/
$q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC";
$mc_res=mySQL_query($q); if (!$mc_res) {$errors[]="error in SQL query, line: ".__LINE__; break;}
Harry
Le mar 27/04/2004 à 14:38, Klaus Darilion a écrit :
I think the problem is, that there is no stable serweb.
klaus
gaillac harry wrote:
Ok thanks !
I'm not a php/mysql developper I can't rewrite serweb, I try my best to correct configs files (config.php). it would be a good thing stables ser+serweb releases match.
Harry
Le mar 27/04/2004 à 12:44, Klaus Darilion a écrit :
no direct mails -> mail to the list!
maybe you should make yourself familiar with php, mysql and SQL first!
gaillac harry wrote:
Here is my missed_calls.php
Where is the SQL query file ???
$q="select username, domain from ".$config->table_aliases. " where'sip:".$auth->auth["uname"]."@".$config->default_domain."'=contact";
this is an SQL query
oh, here is antohter one
$q="delete from ".$config->table_missed_calls. " where username='".$row."' and domain='".$dom."' ". " and time<'".gmdate("Y-m-d H:i:s", $page_loaded_timestamp)."'"; $res=mySQL_query($q); if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; }and again a query!
*/ $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC";
That's probably not very useful for you (as it looks like you have no glue what you are talking about - sorry), but I will give you another hint from your previous mail:
I've still a problem with missed_calls.php from serweb "error in SQL query, line: 77 No missed calls".
--> check line 77 and you will find a query just before it!
klaus
I know this version works, with ser 0.8.12. ftp://ftp.berlios.de/pub/ser/latest/contrib/serweb_2004-01-04.tar.gz
- Atle
* Klaus Darilion klaus.mailinglists@pernau.at [040427 14:39]:
I think the problem is, that there is no stable serweb.
klaus
gaillac harry wrote:
Ok thanks !
I'm not a php/mysql developper I can't rewrite serweb, I try my best to correct configs files (config.php). it would be a good thing stables ser+serweb releases match.
Harry
Le mar 27/04/2004 ? 12:44, Klaus Darilion a ??crit :
no direct mails -> mail to the list!
maybe you should make yourself familiar with php, mysql and SQL first!
gaillac harry wrote:
Here is my missed_calls.php
Where is the SQL query file ???
$q="select username, domain from ".$config->table_aliases. " where'sip:".$auth->auth["uname"]."@".$config->default_domain."'=contact";
this is an SQL query
oh, here is antohter one
$q="delete from ".$config->table_missed_calls. " where username='".$row."' and domain='".$dom."' ". " and time<'".gmdate("Y-m-d H:i:s", $page_loaded_timestamp)."'"; $res=mySQL_query($q); if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; }and again a query!
*/ $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC";
That's probably not very useful for you (as it looks like you have no glue what you are talking about - sorry), but I will give you another hint from your previous mail:
I've still a problem with missed_calls.php from serweb "error in SQL query, line: 77 No missed calls".
--> check line 77 and you will find a query just before it!
klaus
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
I've got this version for ser-8.0.12 but i have a problem with missed_calls.php. I'm about to update mysql
Thanks Harry
Le mar 27/04/2004 à 15:15, Atle Samuelsen a écrit :
I know this version works, with ser 0.8.12. ftp://ftp.berlios.de/pub/ser/latest/contrib/serweb_2004-01-04.tar.gz
- Atle
- Klaus Darilion klaus.mailinglists@pernau.at [040427 14:39]:
I think the problem is, that there is no stable serweb.
klaus
gaillac harry wrote:
Ok thanks !
I'm not a php/mysql developper I can't rewrite serweb, I try my best to correct configs files (config.php). it would be a good thing stables ser+serweb releases match.
Harry
Le mar 27/04/2004 ? 12:44, Klaus Darilion a ??crit :
no direct mails -> mail to the list!
maybe you should make yourself familiar with php, mysql and SQL first!
gaillac harry wrote:
Here is my missed_calls.php
Where is the SQL query file ???
$q="select username, domain from ".$config->table_aliases. " where'sip:".$auth->auth["uname"]."@".$config->default_domain."'=contact";
this is an SQL query
oh, here is antohter one
$q="delete from ".$config->table_missed_calls. " where username='".$row."' and domain='".$dom."' ". " and time<'".gmdate("Y-m-d H:i:s", $page_loaded_timestamp)."'"; $res=mySQL_query($q); if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; }and again a query!
*/ $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1 ". "WHERE t1.username='".$auth->auth["uname"]."' and t1.domain='".$config->default_domain."' ) ". "UNION ". "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". "FROM missed_calls t1, aliases t2 ". "WHERE 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". "=t2.contact AND t2.username=t1.username AND t2.domain=t1.domain ) ". "ORDER BY time DESC";
That's probably not very useful for you (as it looks like you have no glue what you are talking about - sorry), but I will give you another hint from your previous mail:
I've still a problem with missed_calls.php from serweb "error in SQL query, line: 77 No missed calls".
--> check line 77 and you will find a query just before it!
klaus
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Atle Samuelsen -
gaillac harry -
Klaus Darilion