WEB PAGE:
http://www.localhelpwanted.net/illini/cgi-bin/Jobs/77021/95/728/1/0/c/aab/ ________________________________________________________________________________________________________________________
ERROR MESSAGE:
SELECT DISTINCT aax.*, logs.mode, category.base
from (
SELECT ads.id, ads.date_create, ads.date_end, ads.username, ads.status, ads.visibility, ads.priority, ads.template, ads.view, ads.reply, ads.save, ads.updated, ads.photo, ads.cat_a, ads.cat_b, ads.cat_c, ads.cat_a1, ads.cat_a2, ads.cat_a3, ads.cat_a4, ads.cat_a5, ads.contact_name, ads.contact_email, ads.homepage, ads.contact_phone, ads.contact_fax, ads.contact_address, ads.contact_city, ads.contact_state, ads.contact_province, ads.contact_country, ads.contact_zip, ads.contact_method, ads.starting_date, ads.size, ads.salary, ads.job_type, ads.education, ads.experience, ads.travel, ads.title, ads.description, ads.custom11, ads.custom12, ads.custom13, ads.custom14, ads.custom15, ads.custom16, ads.custom17, ads.custom18, ads.custom19, ads.custom20, ads.level, ads.function, ads.degree, ads.authorized, ads.security, ads.relocate, ads.ideal_job, ads.ideal_company, ads.recent_employer, ads.recent_job, ads.objective, ads.affiliations, ads.skills, ads.additional, ads.reference, ads.resume, ads.image1, ads.image2, ads.image3, ads.image4, ads.image5, ads.company, ads.company_type, ads.division, ads.department, ads.company_profile, ads.job_title, ads.job_location, ads.openings, ads.vacation, ads.job_code, ads.options, ads.shared_id, member.username, member.password, member.email, member.fname, member.lname, member.address, member.address2, member.city, member.state, member.province, member.country, member.zip, member.phone, member.fax, member.website, member.aim, member.yim, member.icq, member.msn, member.custom1, member.custom2, member.custom3, member.custom4, member.custom5, member.custom6, member.custom7, member.custom8, member.custom9, member.custom10
FROM ads
JOIN member ON ads.username=member.username
WHERE ads.status="active" AND (ads.cat_b IN ("95","95")) AND (ads.cat_b IN ("95","95")) AND (ads.cat_c IN (728, 95, 39248, 61389, 59553, 26383, 10796, 70782, 18064, 24403, 43858, 29992, 11638, 18247, 16842, 33741, 21327, 19494, 18299, 19496, 19902, 18346, 19420, 19290, 19370, 19949, 20006, 19986, 18324, 20984, 20784, 20196, 18289, 20638, 18326, 18565, 18251, 19362, 18768, 19133, 19105, 43396, 20842, 19441, 19970, 18295, 19577, 18119, 20025, 19324, 18281, 19358, 21000, 20296, 18961, 19103, 19059, 18802, 20840, 19015, 18775, 18182, 19438, 19261, 18766, 18257, 18746, 20294, 20540, 20010, 19995, 19718, 20001, 20004, 19541, 20055, 19991, 20857, 20796, 18396, 20170, 19827, 19202, 19239, 20592, 18132, 19659, 47187, 20932, 20368, 19011, 18265, 19492, 20372, 18985, 19443, 19569, 20758, 19383, 20142, 20928, 19411, 20220, 20437, 19093, 19424, 19539, 20348, 19206, 20555, 19549, 19661, 18249, 20016, 19997, 19953, 19413, 19551, 18235, 20319, 20934, 54532, 19557, 18271, 18248, 19372, 18085, 20792, 19999, 20311, 20549, 18320, 18150, 19555, 19981, 19274, 19966, 18476, 19488, 20002, 8019, 18095, 18974, 20254, 20262, 20577, 19665, 20988, 20868, 18976, 18930, 19890, 18224, 728))
ORDER BY sponsored DESC,id desc LIMIT 0, 50
) aax
LEFT JOIN logs ON aax.username=logs.username
JOIN category ON aax.cat_b=category.id
SQL Error: Duplicate column name "username"
________________________________________________________________________________________________________________________
STACK TRACE:
at /usr/share/perl/5.10/CGI/Carp.pm line 527
CGI::Carp::fatalsToBrowser("SELECT DISTINCT aax.*, logs.mode, category.base\x{a} from (\x{a}...") called at /usr/share/perl/5.10/CGI/Carp.pm line 448
CGI::Carp::die("SELECT DISTINCT aax.*, logs.mode, category.base\x{a} from (\x{a}...", "Duplicate column name \"username\"", "\x{a}") called at /home/lhw/public_html/illini/cgi-bin/scripts/new_database.pl line 1620
main::runSQL("\x{a} SELECT DISTINCT aax.*, logs.mode, category.base\x{a} ...") called at /home/lhw/public_html/illini/cgi-bin/scripts/display2.pl line 386
main::BuildCategoryAds called at /home/lhw/public_html/illini/cgi-bin/Jobs.cgi line 192
main::DisplayCategory called at /home/lhw/public_html/illini/cgi-bin/Jobs.cgi line 147
main::main called at /home/lhw/public_html/illini/cgi-bin/Jobs.cgi line 74
________________________________________________________________________________________________________________________
POSTED DATA:
action: browse
cat_a: 77021
cat_b: 95
cat_c: 728
cattype: c
database: job
daysnew: 10
lpp: 50
number: 0
order: sponsored DESC,id desc
parent: 1
password_cookie:
total: 3842
trace: aab
username:
________________________________________________________________________________________________________________________
ENVIRONMENT:
SCRIPT_NAME: /illini/cgi-bin/Jobs.cgi
SERVER_NAME: www.localhelpwanted.net
SERVER_ADMIN: [no address given]
HTTP_ACCEPT_ENCODING: gzip
HTTP_CONNECTION: close
HTTP_X_CC_ID: ccc02-02
REQUEST_METHOD: GET
HTTP_ACCEPT: text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
SCRIPT_FILENAME: /home/lhw/public_html/illini/cgi-bin/Jobs.cgi
REDIRECT_URL: /illini/cgi-bin/Jobs/77021/95/728/1/0/c/aab/
SERVER_SOFTWARE: Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny6 with Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g
HTTP_ACCEPT_CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
QUERY_STRING: cat_a=77021&cat_b=95&cat_c=728&parent=1&number=0&cattype=c&trace=aab
REMOTE_PORT: 53859
HTTP_USER_AGENT: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
SERVER_PORT: 80
SERVER_SIGNATURE: <address>Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny6 with Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g Server at www.localhelpwanted.net Port 80</address>
HTTP_PRAGMA: no-cache
REDIRECT_STATUS: 200
HTTP_CACHE_CONTROL: no-cache
REDIRECT_QUERY_STRING: cat_a=77021&cat_b=95&cat_c=728&parent=1&number=0&cattype=c&trace=aab
HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
HTTP_COOKIE: PHPSESSID=85911d2223898076b3e25bfdba30949c
REMOTE_ADDR: 38.107.191.89
SERVER_PROTOCOL: HTTP/1.1
PATH: /usr/local/bin:/usr/bin:/bin
REQUEST_URI: /illini/cgi-bin/Jobs/77021/95/728/1/0/c/aab/
GATEWAY_INTERFACE: CGI/1.1
SERVER_ADDR: 199.187.121.42
DOCUMENT_ROOT: /home/lhw/public_html
HTTP_HOST: www.localhelpwanted.net
________________________________________________________________________________________________________________________
This msg was automatically generated by [LHW::Oops.pl]