Custom User Attribute MySql Error HELP!
Permalink
I am trying to create a site where a user can login and edit their profile page which includes questions about their family. I needed and attribute that is a lot like the address attribute but instead of addresses I need names and ages of children.
Using the address attribute as my starting point (copy and pasted then changed the name of the folder in my site's root models directory) and following the tutorial on custom attributes I made a new attribute that asks for firstname/lastname/age/conference.
The custom attribute successfully installs and displays wonderfully. But when I enter information and then hit save I get this error message:
mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from atChildAddress where avID = '34'' at line 1] in EXECUTE("select avID, firstname, lastname, age, conferance, from atChildAddress where avID = '34'")
where my custom attribute is child_address
The weird thing is that the attribute is successfully creating a table in the database (atChildAddress) and when I check the DB table it has the information in it from the test run. (e.g. 1 row with a all the columns filled in as per my test run).
Any Ideas? Attached is the controller.php I'm using.
Using the address attribute as my starting point (copy and pasted then changed the name of the folder in my site's root models directory) and following the tutorial on custom attributes I made a new attribute that asks for firstname/lastname/age/conference.
The custom attribute successfully installs and displays wonderfully. But when I enter information and then hit save I get this error message:
mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from atChildAddress where avID = '34'' at line 1] in EXECUTE("select avID, firstname, lastname, age, conferance, from atChildAddress where avID = '34'")
where my custom attribute is child_address
The weird thing is that the attribute is successfully creating a table in the database (atChildAddress) and when I check the DB table it has the information in it from the test run. (e.g. 1 row with a all the columns filled in as per my test run).
Any Ideas? Attached is the controller.php I'm using.
should be