rackem
Well-Known Member
The "usekey" keyword in a URL seems to be broken. I use the calc element to dynamically create a URL to edit a specific record in form view. It was working fine for quite some time however now it is broken. Not sure when it happened.
Here is an example URL:
http://www.mypoolstats.com/index.ph...orm&formid=16&rowid=627|45&usekey=player|user
Here is the error I receive:
Unknown column 'mps_votes.playeruser' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `mps_votes`.`id` AS `mps_votes___id`, `mps_votes`.`id` AS `mps_votes___id_raw`, `mps_votes`.`date_time` AS `mps_votes___date_time`, `mps_votes`.`date_time` AS `mps_votes___date_time_raw`, `mps_votes`.`player` AS `mps_votes___player_raw`, CONCAT(mps_players.first_name, " ", mps_players.last_name) AS `mps_votes___player`, `mps_votes`.`vote` AS `mps_votes___vote`, `mps_votes`.`vote` AS `mps_votes___vote_raw`, `mps_votes`.`vote_diff` AS `mps_votes___vote_diff`, `mps_votes`.`vote_diff` AS `mps_votes___vote_diff_raw`, `mps_votes`.`user` AS `mps_votes___user_raw`, `btxz_users`.`name` AS `mps_votes___user`, `mps_votes`.`vote_date` AS `mps_votes___vote_date`, `mps_votes`.`vote_date` AS `mps_votes___vote_date_raw`, `mps_votes`.`pwr_vote` AS `mps_votes___pwr_vote`, `mps_votes`.`pwr_vote` AS `mps_votes___pwr_vote_raw`, `mps_votes`.`status` AS `mps_votes___status`, `mps_votes`.`status` AS `mps_votes___status_raw`, `mps_votes`.`id` AS slug , `mps_votes`.`id` AS `__pk_val` FROM `mps_votes` LEFT JOIN `mps_players` AS `mps_players` ON `mps_players`.`id` = `mps_votes`.`player` LEFT JOIN `btxz_users` AS `btxz_users` ON `btxz_users`.`id` = `mps_votes`.`user` WHERE ( `mps_votes`.`playeruser` = '62745') ORDER BY `mps_votes`.`vote_date` DESC
It seems that the " | " character is ignored?
Here is an example URL:
http://www.mypoolstats.com/index.ph...orm&formid=16&rowid=627|45&usekey=player|user
Here is the error I receive:
Unknown column 'mps_votes.playeruser' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `mps_votes`.`id` AS `mps_votes___id`, `mps_votes`.`id` AS `mps_votes___id_raw`, `mps_votes`.`date_time` AS `mps_votes___date_time`, `mps_votes`.`date_time` AS `mps_votes___date_time_raw`, `mps_votes`.`player` AS `mps_votes___player_raw`, CONCAT(mps_players.first_name, " ", mps_players.last_name) AS `mps_votes___player`, `mps_votes`.`vote` AS `mps_votes___vote`, `mps_votes`.`vote` AS `mps_votes___vote_raw`, `mps_votes`.`vote_diff` AS `mps_votes___vote_diff`, `mps_votes`.`vote_diff` AS `mps_votes___vote_diff_raw`, `mps_votes`.`user` AS `mps_votes___user_raw`, `btxz_users`.`name` AS `mps_votes___user`, `mps_votes`.`vote_date` AS `mps_votes___vote_date`, `mps_votes`.`vote_date` AS `mps_votes___vote_date_raw`, `mps_votes`.`pwr_vote` AS `mps_votes___pwr_vote`, `mps_votes`.`pwr_vote` AS `mps_votes___pwr_vote_raw`, `mps_votes`.`status` AS `mps_votes___status`, `mps_votes`.`status` AS `mps_votes___status_raw`, `mps_votes`.`id` AS slug , `mps_votes`.`id` AS `__pk_val` FROM `mps_votes` LEFT JOIN `mps_players` AS `mps_players` ON `mps_players`.`id` = `mps_votes`.`player` LEFT JOIN `btxz_users` AS `btxz_users` ON `btxz_users`.`id` = `mps_votes`.`user` WHERE ( `mps_votes`.`playeruser` = '62745') ORDER BY `mps_votes`.`vote_date` DESC
It seems that the " | " character is ignored?