Mailing List Receiver wrote:
Worked under version 4. Does not work under version 5.
$Qstr = "select distinct replace(reftraffic.refurl,'http://',''),\
count(*)\
from reftraffic,site\
left join links\
on
left(replace(reftraffic.refurl,'http://',''),locate('/',replace(reftraffic.refurl,'http://',''))-1)\
= links.url\
where links.url is null\
and reftraffic.web = site.siteurl\
and site.vend_addr = \"$Vendor\"\
group by replace(reftraffic.refurl,'http://','')";
DBD::mysql::st execute failed: Unknown column 'reftraffic.refurl' in 'on
clause' at /home/common/proj/bin/reftraffic.pl line 59.
Use "from reftraffic inner join site on ....." instead
of an implicit join. The precedence of joins has been corrected
in version 5.
This has been asked and answered about a hunderd times.
For more details, you may search the archives
mysql> describe reftraffic;
+--------+--------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+--------------+------+-----+---------------------+-------+
| web | varchar(40) | NO | | NULL | |
| datim | datetime | NO | | 0000-00-00 00:00:00 | |
| refurl | varchar(255) | NO | | NULL | |
| target | varchar(255) | YES | | NULL | |
+--------+--------------+------+-----+---------------------+-------+
mysql> describe links;
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| url | varchar(100) | NO | MUL | NULL | |
| linktype | varchar(16) | YES | | NULL | |
| rank | double(10,0) | YES | | NULL | |
| email | varchar(40) | YES | | NULL | |
| dateadd | date | YES | | NULL | |
| verified | enum('N','Y') | YES | | N | |
| vendor | varchar(8) | NO | | GWA | |
| deleted | enum('Y','N') | YES | | N | |
| info | text | YES | | NULL | |
| image | varchar(100) | YES | | NULL | |
| username | varchar(32) | YES | | NULL | |
| password | varchar(32) | YES | | NULL | |
| city | varchar(40) | YES | | NULL | |
| state | varchar(40) | YES | | NULL | |
| country | varchar(40) | YES | | NULL | |
| rowid | int(11) unsigned | NO | PRI | NULL | auto_increment |
+----------+------------------+------+-----+---------+----------------+
Server version 5.0.22
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
