Login Form

#428 – error 1064

Posted in ‘BF Quiz’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Tuesday, 14 October 2014 02:16 AEDT
sashido
Joomla! version: (3.3.5)

Hi Tim,

I have just asked for your support on the cirillic characters.

Now that I've got this right I'm getting a new problem.


1. I have a multipage quiz

2. questions at the moment:
a). the radio-button options in russian
b). the text field where the entry should be in russian.

4. I go through the quiz pages without any problem
5. when I submit quizz I get this

1064 - 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 '-translation-cinema = 'Кинотеатр' WHERE id = 17' at line 2 SQL=UPDATE `jos_bfquizplus_32` SET w-translation-cinema = 'Кинотеатр' WHERE id = 17

Best regards,
Aleksandra
 
Tuesday, 14 October 2014 03:56 AEDT
sashido
I have tried to change the name of the db field. But that doesn't work. I get then the error

1054 - Unknown column 'cinemameaning' in 'field list' SQL=UPDATE `jos_bfquizplus_33` SET cinemameaning = 'Кинотеатр' WHERE id = 7

I have also tried to delete the whole category and starting again. But I run into the same problem.
 
Tuesday, 14 October 2014 16:40 AEDT 5'
Tim
BF Quiz Plus 3 Years, BF Survey 12 Months
Hi Aleksandra,
I think you are on the right track in renaming the field. Try pressing the fix database in the back end question view, and see if this solves the problem.

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