 |
|
 |
 |
Menu |
 |
|
 Home |
| |
|
 Discussions |
| |
|
 Tools |
| |
|
| Affiliates |
| |
|
 Content |
| |
|
 Info |
| | |
|
|
|
|
|
User Info |
|
 Membership:
 Latest: MichaelSnaRe
 New Today: 0
 New Yesterday: 0
 Overall: 9144
 People Online:
 Visitors: 101
 Members: 0
 Total: 101
|
|
|
|
|
|
Full disclosure |
|
|
|
 |
|
 |
 |
|
 |
IT Security and Insecurity Portal |
|
|
Error: Column 'profile_field_id' in from clause is ambiguous |
|
 Posted: Tue Jan 22, 2008 7:03 am |
 |
|
| f5only |
| Beginner |
 |
|
| Joined: Dec 31, 2007 |
| Posts: 4 |
|
|
|
 |
|
 |
|
Dear Sir,
Pls Help Me.
Error: Column 'profile_field_id' in from clause is ambiguous
in query: "SELECT `field`.*, `match_field_name`.`name` AS `matching`, `match_field`.`match_type` AS `matching_type` FROM `skadate_profile_field` AS `field` LEFT JOIN `skadate_link_profile_field_match` AS `match_field` ON `field`.`profile_field_id`=`match_field`.`match_profile_field_id` LEFT JOIN `skadate_profile_field` AS `match_field_name` USING ( `profile_field_id` )"
debug string: "" |
|
|
|
|
|
|
|
|
| Posted: Tue Jan 22, 2008 11:37 am |
|
|
| waraxe |
| Site admin |
 |
|
| Joined: May 11, 2004 |
| Posts: 2407 |
| Location: Estonia, Tartu |
|
|
|
|
|
|
Answer seems to reside here:
http://209.85.129.104/search?q=cache:q0f6VFsIftIJ:www.yagbu.net/index.php%3Fshowuser%3D2273+site:yagbu.net+skadate+ambiguous&hl=et&gl=ee&strip=1
| Code: |
First bug: SQL error below after installing.
QUOTE
Error: Column 'profile_field_id' in from clause is ambiguous
in query: "SELECT `field`.*, `match_field_name`.`name` AS `matching`, `match_field`.`match_type` AS `matching_type` FROM `5_profile_field` AS `field` LEFT JOIN `5_link_profile_field_match` AS `match_field` ON `field`.`profile_field_id`=`match_field`.`match_profile_field_id` LEFT JOIN `5_profile_field` AS `match_field_name` USING ( `profile_field_id` )"
debug string: ""
Open app/global.pr_fields.php and edit line 10. Change this:
CODE
LEFT JOIN `".TBL_PROF_FIELD."` AS `match_field_name` USING ( `profile_field_id` )";
to this:
CODE
LEFT JOIN `".TBL_PROF_FIELD."` AS `match_field_name` ON `match_field_name`.`profile_field_id`=`field`.`profile_field_id`";
|
Hopefully it helps  |
|
|
|
|
|
|
|
|
| Posted: Wed Feb 06, 2008 10:43 am |
|
|
| f5only |
| Beginner |
|
|
| Joined: Dec 31, 2007 |
| Posts: 4 |
|
|
|
|
|
|
|
Thanking you
My Problom Solved
But New Error
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in C:\Inetpub\vhosts\********.com\httpdocs\skadate\inc\class.language.php on line 244 |
|
|
|
|
www.waraxe.us Forum Index -> Php
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
All times are GMT
Page 1 of 1
|
|
|
|
Powered by phpBB © 2001-2008 phpBB Group
|
|
|
|
|
|
|
