meanster99
Well-known member
Hi All,
Dadabik v4.3
Firefox
Windows Vista
MySQL 5.1.56
Apache 2x
I have enabled the duplicate checking function and all works well on the email field I have set to check for duplicates, in one of my tables. When I try and enter a duplicate email address it warns me it could be a duplicate but gives me the option to add the record anyway. Perfect, all as should be.
However, in another table of mine I have set the telephone field (although its set to alphanumeric as I encourage a space being put between the area code and number) to check for duplicates and if I try and enter a duplicate I get the following message only, (with no option to add the record anyway):
Duplication is possible
[08] Error: during query execution.
Here is the full SQL statement and error:
Your SQL query (for debugging purpose): SELECT `artiste_contacts`.`ID`, `artiste_contacts`.`Stage_Name`, `artiste_contacts`.`Real_Name`, `artiste_contacts`.`Phone_Number`, `artiste_contacts`.`Email`, `artiste_contacts`.`Home_Town`, `artiste_contacts`.`Areas`, `artiste_contacts`.`Grade`, `artiste_contacts`.`Notes`, `artiste_contacts`.`Price`, `artiste_contacts`.`Gender`, `ethnicity_race__1`.`Ethnicity` AS `ethnicity_race__Ethnicity__1`, `performer_types__1`.`Performer_Type` AS `performer_types__Performer_Type__1` FROM `artiste_contacts` LEFT JOIN `ethnicity_race` AS `ethnicity_race__1` ON `artiste_contacts`.`Race` = `ethnicity_race__1`.`ID` LEFT JOIN `performer_types` AS `performer_types__1` ON `artiste_contacts`.`Performer_Type` = `performer_types__1`.`ID` where `ID` = '146'
[08] Error: during query execution.
SELECT `artiste_contacts`.`ID`, `artiste_contacts`.`Stage_Name`, `artiste_contacts`.`Real_Name`, `artiste_contacts`.`Phone_Number`, `artiste_contacts`.`Email`, `artiste_contacts`.`Home_Town`, `artiste_contacts`.`Areas`, `artiste_contacts`.`Grade`, `artiste_contacts`.`Notes`, `artiste_contacts`.`Price`, `artiste_contacts`.`Gender`, `ethnicity_race__1`.`Ethnicity` AS `ethnicity_race__Ethnicity__1`, `performer_types__1`.`Performer_Type` AS `performer_types__Performer_Type__1` FROM `artiste_contacts` LEFT JOIN `ethnicity_race` AS `ethnicity_race__1` ON `artiste_contacts`.`Race` = `ethnicity_race__1`.`ID` LEFT JOIN `performer_types` AS `performer_types__1` ON `artiste_contacts`.`Performer_Type` = `performer_types__1`.`ID` where `ID` = '146'
DBMS server said: Column 'ID' in where clause is ambiguous
Any ideas - obviously related to my auto-incremented ID field - but this has the same settings as in the table that the duplication check works, so I can't see what I've done wrong! Any ideas?
Dadabik v4.3
Firefox
Windows Vista
MySQL 5.1.56
Apache 2x
I have enabled the duplicate checking function and all works well on the email field I have set to check for duplicates, in one of my tables. When I try and enter a duplicate email address it warns me it could be a duplicate but gives me the option to add the record anyway. Perfect, all as should be.
However, in another table of mine I have set the telephone field (although its set to alphanumeric as I encourage a space being put between the area code and number) to check for duplicates and if I try and enter a duplicate I get the following message only, (with no option to add the record anyway):
Duplication is possible
[08] Error: during query execution.
Here is the full SQL statement and error:
Your SQL query (for debugging purpose): SELECT `artiste_contacts`.`ID`, `artiste_contacts`.`Stage_Name`, `artiste_contacts`.`Real_Name`, `artiste_contacts`.`Phone_Number`, `artiste_contacts`.`Email`, `artiste_contacts`.`Home_Town`, `artiste_contacts`.`Areas`, `artiste_contacts`.`Grade`, `artiste_contacts`.`Notes`, `artiste_contacts`.`Price`, `artiste_contacts`.`Gender`, `ethnicity_race__1`.`Ethnicity` AS `ethnicity_race__Ethnicity__1`, `performer_types__1`.`Performer_Type` AS `performer_types__Performer_Type__1` FROM `artiste_contacts` LEFT JOIN `ethnicity_race` AS `ethnicity_race__1` ON `artiste_contacts`.`Race` = `ethnicity_race__1`.`ID` LEFT JOIN `performer_types` AS `performer_types__1` ON `artiste_contacts`.`Performer_Type` = `performer_types__1`.`ID` where `ID` = '146'
[08] Error: during query execution.
SELECT `artiste_contacts`.`ID`, `artiste_contacts`.`Stage_Name`, `artiste_contacts`.`Real_Name`, `artiste_contacts`.`Phone_Number`, `artiste_contacts`.`Email`, `artiste_contacts`.`Home_Town`, `artiste_contacts`.`Areas`, `artiste_contacts`.`Grade`, `artiste_contacts`.`Notes`, `artiste_contacts`.`Price`, `artiste_contacts`.`Gender`, `ethnicity_race__1`.`Ethnicity` AS `ethnicity_race__Ethnicity__1`, `performer_types__1`.`Performer_Type` AS `performer_types__Performer_Type__1` FROM `artiste_contacts` LEFT JOIN `ethnicity_race` AS `ethnicity_race__1` ON `artiste_contacts`.`Race` = `ethnicity_race__1`.`ID` LEFT JOIN `performer_types` AS `performer_types__1` ON `artiste_contacts`.`Performer_Type` = `performer_types__1`.`ID` where `ID` = '146'
DBMS server said: Column 'ID' in where clause is ambiguous
Any ideas - obviously related to my auto-incremented ID field - but this has the same settings as in the table that the duplication check works, so I can't see what I've done wrong! Any ideas?