Login Form

#78 – 1060 Duplicate column name 'name' SQL=ALTER TABLE `ocrqo_bfsurveyplus_13` ADD `name` TEXT ;

Posted in ‘BF Survey’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Friday, 03 January 2014 06:20 AEDT
rpoock
Joomla! version: 3.2.1

Keep getting an error when I click on Components > BF Survey Plus > Questions that states:

1060 Duplicate column name 'name' SQL=ALTER TABLE `ocrqo_bfsurveyplus_13` ADD `name` TEXT ;

About 90% sure it's because I made a question for the "name" field and it's doubled up with an existing field in a table. Any idea how to fix this?
Friday, 03 January 2014 07:39 AEDT 5'
Tim
Everything Bundle, BF Quiz Plus 3 Years, BF Survey 12 Months
Hi Ryan,
Yes this would definitely be due to you using "name" as the db field name of one of your questions. By default, every answer table has a Name, Email and Company field. The script that builds the table is case sensitive, so "name" looks different to "Name", but MySQL is not and you can't have two fields with the same name but different case. I think to fix this you will need to edit your question table ocrqo_bfsurvey_plus using phpMyAdmin, and change the field_name for that question. Let me know how you go.

regards

Tim
Follow us on twitter http://twitter.com/tamlynsoftware
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.
Go to top