Login Form

#18 – Error 1166: Incorrect column name '' SQL=ALTER TABLE `ojp80_bfsurveyplus_8` ADD `` 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.
Wednesday, 23 October 2013 18:05 AEDT
markyg123
Joomla! version: 3.1.5

Upon attempting to move one of the questions so the sequence was varied, I now get:
An error has occurred.
Error 1166: Incorrect column name '' SQL=ALTER TABLE `ojp80_bfsurveyplus_8` ADD `` TEXT ;

(The survey in question is a modification of the original Feedback form)

I can enter into all BFsurvey sub-menus except Questions where the above error is presented and the only choice is "Return to Control Panel".

I've also carried out Auto Database Cleanup with no change.

Thaks

Mark
Wednesday, 23 October 2013 18:24 AEDT 5'
Tim
Everything Bundle, BF Quiz Plus 3 Years, BF Survey 12 Months
I would expect this error when you have one question with a blank db field name. Can you check that all your questions have a db field name set. Let me know if you still have a problem.

regards

Tim
Follow us on twitter http://twitter.com/tamlynsoftware
Wednesday, 23 October 2013 20:35 AEDT
markyg123
Hi Tim

In the past I've had a warning that I've not had a db field name... when I've copied an existing Q and overlooked this, for example, as it's blanked out upon copy.

However this error happened after the Q was created...I was just moving its order sequence.

I can't check if a Q is missing a db field name as I can no longer get to see any Q's due to the error message - as soon as I try the Questions menu it returns the error.

I guess I can edit the SQL table directly?

cheerrs

Mark

Wednesday, 23 October 2013 23:15 AEDT 10'
Tim
Everything Bundle, BF Quiz Plus 3 Years, BF Survey 12 Months
Moving a question shouldn't have caused this problem, but one possible scenario is that by moving the question you have changed which questions display on that page, and potentially there was already one question in the database without a db field name which is now appearing on that same page due to the ordering change. The error message shouldn't stop you from looking at the question view, I'll need to investigate that further. Looking at the code, I suspect this is due to line 57-60 of /administrator/components/com_bfsurvey_plus/views/question/view.html.php, which possibly shouldn't raise a 500 error.

		// Check for errors.
		if (count($errors = $this->get('Errors'))) {
			JError::raiseError(500, implode("\n", $errors));
			return false;
		}


Are you able to send me an export from phpMyAdmin of your question table ojp80_bfsurvey_plus and your answer table ojp80_bfsurveyplus_8 so I can try to reproduce this problem on my test site and find the cause. Feel free to make this support ticket private if you attach files.
Follow us on twitter http://twitter.com/tamlynsoftware
Friday, 25 October 2013 10:31 AEDT 30'
Tim
Everything Bundle, BF Quiz Plus 3 Years, BF Survey 12 Months
Thanks for sending the database export. I can see that you have one question (id=18, question="Copy of Reflecting on your original choice") that currently has no DB Field Name, which is causing this error. It seems that Joomla 3 doesn't handle these errors as nicely as 2.5, so if you make the following change you should be able to access the question view again.

Edit the file /administrator/components/com_bfsurvey_plus/controller.php

Line 914, add the following where clause to the query
$query->where('field_name <> \'\'');

I'll be including this fix in the next version release. Let me know if you still have a problem.

regards

Tim
Follow us on twitter http://twitter.com/tamlynsoftware
Friday, 25 October 2013 22:30 AEDT
markyg123
.
Saturday, 26 October 2013 00:22 AEDT 10'
Tim
Everything Bundle, BF Quiz Plus 3 Years, BF Survey 12 Months
I've just emailed you the file now.
Follow us on twitter http://twitter.com/tamlynsoftware
Saturday, 26 October 2013 08:20 AEDT
markyg123
Thanks Tim

All good now.

Cheers

Mark
Saturday, 26 October 2013 11:40 AEDT
Tim
Everything Bundle, BF Quiz Plus 3 Years, BF Survey 12 Months
This fix is included in BF Survey Plus v1.1.11 that has now been released.
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