Login Form

#574 – Questions not hiding

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.
Saturday, 28 March 2015 03:33 AEDT
ronaldotto
Joomla! version: 3.4
BF survey version 2.05

On https://www.valleiwonen.nl/onderzoek-onderhoud?template=protostar the answer to the question " Heeft Vallei Wonen achterstallig onderhoud in haar bezit, denk aan: schilderwerk, gotenschoonmaak, voegwerk enz. *"
Should show or hide " Waarom bent u het daarmee eens?"

Instead it gives a TypeError: document.id(...) is null
https://827a4e.cdn.tuxis.nl/media/com_bfsurvey/js/31result.js
Line 3

Any idea?
Saturday, 28 March 2015 08:55 AEDT 5'
Tim
Everything Bundle, BF Quiz Plus 3 Years, BF Survey 12 Months
It appears that you have spaces in your db field names. The first error I can see is for the field "eens met achterstallig onderhoud". Try removing the spaces, and press the fix database button, and see if this solves your issue. Note you can use underscore _ character.

regards

Tim
Follow us on twitter http://twitter.com/tamlynsoftware
Tuesday, 31 March 2015 03:16 AEDT
ronaldotto
Hi,

I see that the customer did not remove alle spaces but used the form anyway.

That worked, the results are stored an viewable but in statistics i get:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'kleurkeuze = 'Oneens'' at line 3 SQL=SELECT * FROM `ltg8s_bfsurvey_31results` WHERE Inspraak in kleurkeuze = 'Oneens'

Can i rename the db fields or will i lose the results
Tuesday, 31 March 2015 15:47 AEDT 10'
Tim
Everything Bundle, BF Quiz Plus 3 Years, BF Survey 12 Months
Yes you can rename the db fields without loosing data. You would need to update the field name in the question, as well as updating the mysql field in the answer table.

Maybe SQL commands in phpMyAdmin something like this would fix:

UPDATE `ltg8s_bfsurvey_questions` SET `field_name`='Inspraak_in_kleurkeuze' WHERE `field_name`='Inspraak in kleurkeuze';

ALTER TABLE `ltg8s_bfsurvey_31results` CHANGE 'Inspraak in kleurkeuze' 'Inspraak_in_kleurkeuze' text;


regards

Tim
Follow us on twitter http://twitter.com/tamlynsoftware
Wednesday, 06 May 2015 14:25 AEST
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
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