Buy Now
Sign in

1064 you have an error in your sql syntax

Guusta , February 23 2014, 10:31
G
Guusta 13
February 23 2014, 10:31 #325203
I use in my form DB SAVE with CSV Export v@ [gh] and i get a message
1064 you have an error in your sql syntax .....
and there is no record exported to the csv file.

In earlier joomla versions this was not a problem.

Guusta Theewen
Attachments
chronoforms.pdf
(70.14 KiB)
304 Downloads/Views
GreyHead 64
February 23 2014, 14:17 #325226
Hi Guusta,

The action is working OK here - it looks as though there is something odd with the columns list which is showing up as ,,,, instead of *

What settings do you have on the Columns tab?

Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
G
Guusta 13
February 23 2014, 18:28 #325248
See attachment pplease.


guusta Theewen
Attachments
chrono.pdf
(47.38 KiB)
352 Downloads/Views
G
Guusta 13
February 25 2014, 18:32 #325462
Is there already a solution for this problem?


Guusta Theewen
G
Guusta 13
March 08 2014, 14:35 #326146
Hallo,

You did not give a reaction on my last reply. Mostly you are quick with an answer but this time not.
has this anything to do with joomla 3.2.2 Now joomla 3.2.3 is in use.
Please let me know what possible action i can do to fix this problem.

Regards Guusta
admin 28
March 08 2014, 16:31 #326158
Hi Guusta,

What do you have under the "Columns" tab ? it looks like there is a problem retrieving the table fields names.

Regards,
Max
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
G
Guusta 13
March 08 2014, 16:53 #326161
Please look at the attachment chrono.pdf i sent earlier.


Guusta
GreyHead 64
March 08 2014, 17:23 #326163
Hi Guusta,

I think that I have found the problem - there was a code change in Joomla! 3. If you are OK editing files please open and look fro this block of code around line 186:
        if ( $include ) {
$include = explode( ',', $include );
// check the columns and drop any that are 'excluded'
// or are not in the table columns list.
foreach ( $include as $k => $v ) {
$v = trim( $v );
if ( in_array( $v, $exclude ) || !in_array( $v, $fields_array ) ) {
unset( $include[$k
  • );
    continue;
    }
    $include[$k] = $db->nameQuote( trim( $v ) );
    }
    $include = implode( ', ', $include );
    $exclude = array();
    } elseif ( count( $exclude ) ) {
    $include = array();
    foreach ( $fields_array as $k => $v ) {
    if ( !in_array( $v, $exclude ) ) {
    $include
  • = $db->nameQuote( trim( $v ) );
    }
    }
    $include = implode( ', ', $include );
    } else {
    $include = '*';
    }
    }
    find the two places that nameQuote is used and replace them with quoteName That should be all that is needed.

    Bob
    ChronoForms technical support
    If you'd like to buy me a coffee or two, thank you very much
    P
    pcheng 41
    March 17 2014, 14:29 #326751
    Bob,

    which file is the one that I should change? I have the same issue with my registration form.

    Thanks,

    Pericles
    admin 28
    March 17 2014, 16:34 #326757
    the .php file under this path:
    /administrator/components/com_chronoforms/form_actions/csv_export_gh/

    Regards,
    Max
    Max
    If your main question got answered then please mark the answer using the button!
    Did you try the new ChronoForms7 ? if yes then please send us your comments!!
    GreyHead 64
    March 17 2014, 17:01 #326762
    Hi Pericles,

    The current version of my action has been updated to fix this.

    Bob
    ChronoForms technical support
    If you'd like to buy me a coffee or two, thank you very much