Error when adding other fields
ineffable - June 28, 2007 - 03:02
| Project: | Profile Enforcer |
| Version: | 5.x-1.1 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
Everything is fine if I leave "Other Fields" empty, but once I add something, e.g. "profile_lastname|user/%uid/edit", I get this error:
SQL ERROR: $statement
--------------------------------------------------------------------------------
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 profile_lastname WHERE uid = 3' at line 1
#1
The code appears to indicate that the "other fields" entry is for fields which are in other tables than profile_values. It separates each entry into 3 parts, not the 2 as expected. First part is the name of the table, second is the name of the field in the table, third part is the expected URL.
Try something like
table.field|URL
#2
I had the same proplem.
Now I have a nother.
When I conficurate the Profile Enforcer to require info of membership by placing this to the "Other Fields:"
profile_values.profile_member|http://www.parkour.fi/drupal/?q=user
And enable the profile Enforcer block, I get this error message every where on the website.
SQL ERROR: $statementUnknown column 'profile_member' in 'field list'
The profile_member exist in the table by that name.
What am I missing?
#3
The same proplem occur when I place this line to the
profile_fields.profile_member|http://www.parkour.fi/drupal/?q=user
-->
SQL ERROR: $statementUnknown column 'profile_member' in 'field list'
#4
I can confirm this bug. The "other fields" option is very misleading. It seems to say that fields you list here are required, but it's actually other custom tables and values that you list are required. How can I make regular profile fields created w/the profile module mandatory? For example, a user I created has 5 empty profile fields but is still allowed access, and the debugger says his profile is complete. Any ideas?
#5
Any news on this issue?
#6
I haven't had time to address it yet. I think it's an easy fix though....just need to find time to do it. :(
#7
The same problem here!
any one planning to fix this issue!?
#8
I am the only one working on it right now and it's lower in my priority list than I'd prefer.
Subscribe to this post and you'll get a notice when I post a fix.
#9
subscribing