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.
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
