TOPIC: [SOLVED] Unknown column SQL error when registering group

[SOLVED] Unknown column SQL error when registering group 14 years 11 months ago #5851

divalsafety
Topic Author
Offline
Senior Boarder
Posts: 45
Thank you received: 0

I am getting this message when registering a group at the final screen. The registrations are submitted but this error repeats for the amount of group members who register.

Unknown column 'city' in 'field list' SQL=INSERT INTO jos_dtregister_group_member(`firstname`,`lastname`,`organization`,`address`,`city`,`state`,`zip`,`country`,`email`,`phone`,`PO_NUM`,`CC_NUM`,`CC_DATE`,`groupUserId`) VALUES ('Guest','','','','','','','','','','','','','16')

Single registrations work fine. As you can see I am not using a custom 'city' field as some have suggested may be the problem in other support topics.

Please Log in or Create an account to join the conversation.

Last Edit: by divalsafety.

[SOLVED] Unknown column SQL error when registering group 14 years 10 months ago #5878

divalsafety Topic Author Offline Senior Boarder Posts: 45 Thank you received: 0	I managed to resolve this issue by manually adding the missing fields into the jos_dtregister_group_member table through our cpanel. Strange but I had to add 'city', 'phone' and 'email'. All is well now. Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.
	Please Log in or Create an account to join the conversation.

[SOLVED] Unknown column SQL error when registering group 14 years 10 months ago #5881

dthadmin Offline Administrator Posts: 5470 Thank you received: 3	Don't know why those fields would not have been there. I've never heard of them not being added on an install. Glad you found it though. Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.
	Please Log in or Create an account to join the conversation.

DT Register

General Discussion - Joomla 1.5

[SOLVED] Unknown column SQL error when registering group