Forums

hi,
I get the message

Error while creating table :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 ') ENGINE = MYISAM' at line 1 SQL=CREATE TABLE `jos_chronoforms_cardetails2` () ENGINE = MYISAM ;

i seem to get this same error no matter what cf form I try to do.
I am using the supplied 'create table' and setting every field to store by a click a the top of the column.
--
Dave

Hi Dave,

This can happen with old versions of MySQL. Try changing the "MYSQL Statement ? ENGINE or TYPE" setting on the Form General Tab.

Bob

Hi Dave & Bob,
To me, it looks like you are trying to create an empty table, causing mysql to bark. The error might be slightly misleading, but it's actyally trying to say that it did not expext a ')' at that point in the command line (but rather a column definition).

This would suggest there is something breaking the table wizard :/

/Fredrik

Hi,

All the table fields/rows should be "green" in order to be active and get saved, I guess maybe you set them all to red and this is why the table creation statement is empty!

Regards,
Max

Hi all,

Oh yes, I hadn't noticed that this tab has changed in the latest release.

Max - we've had several problems with this now and with the new Plugin tab which is the same. It seems as though some users (like me) look at the tick and cross icons at the right of the coloured bars. These are the reverse of the Joomla convention which is that 'cross' = disabled and 'tick' = enabled.

I understand that you are flagging the 'action' of the icons here but switching them over for the next release might prevent more of these problems (two this morning).

Bob

hanks everyone.
I am colour-blind so red/green does not help But I did set all the rows to a tick...was that wrong ?
--
Dave

You know some 8 to 10% of us poor blokes have defective colour vision, the majority of which is red/green.
As an electrical engineer, the number of big bangs I produced helped towards changing the wiring code from red= live green=earth to brown and blue. (the French have not entirely cottoned on yet!).

When I come across a web-site that uses colour to convey information I always email them and say STOP. It is discrimination against us handicapped people. Use colour to make things attractive and to draw attention but NEVER to convey information.

Several sites now have a mouse-over giving the colour of a button so that with mouse over a red button the word 'red' is displayed.
I only wish I could persuade the electronic goods industry to use two leds instead of one which changes from red to green !
--
Dave

OK I have now got it working. It needs all crosses. I am a bit grumpy this morning !
I should say that the database facilities that this bit introduces are excellent, a good extension.
The problem arises frequently with the ability to change the label of a button. Is the label an instruction or an indicator?
In the old days we always had two buttons one labelled ON and another labelled OFF and a separate indicator lamp to show what the state was.
It is because of the computer ability to change labels on buttons that this confusion arises. I say it is greedy to try and make one button act as both the toggle switch and indicator of state. My tomtom navigator does this and it is dangerous.
But keep up the good work I think the chronoform system is excellent.

--
Dave

Hi Dave,

I can see the colours (only a mildly anomalous trichromat) but they looks pretty garish IMHO and don't immediately help.

Bob