Closed (fixed)
Project:
Registration codes
Version:
6.x-2.2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
4 Aug 2010 at 14:36 UTC
Updated:
28 Aug 2010 at 20:10 UTC
problem:
- SQL in funktion regcode_load() fails with enables table prefixing. Error occurs at insertion time of voucher code on user profile.
- current implementation:
'SELECT term_data.tid, term_data.name
FROM {regcode_term}
JOIN {term_data} ON (regcode_term.tid = term_data.tid)
WHERE regcode_term.rid = %d'
- bugfix:
'SELECT term_data.tid, term_data.name
FROM {regcode_term} AS regcode_term
JOIN {term_data} AS term_data ON (regcode_term.tid = term_data.tid)
WHERE regcode_term.rid = %d'
Regards,
Thomas
Comments
Comment #1
aidanlis commentedThanks for the fix!
Comment #2
aidanlis commentedComment #3
juankvillegas commentedYou added the alias {regcode_term} AS regcode_term
But you didn't add the alias {term_data} AS term_data on line 359
I can confirm that adding the bold text the warning doesn't appears again.
Congratulations for this very usefull module.
Comment #4
aidanlis commentedThanks, it's in the dev version now!