Interesting problem.. it sounds like maybe the Symfony task is
escaping something?... this is a strange one..
On Sep 3, 3:53 pm, wasabhi <abhinav.kesw...@gmail.com> wrote:
> Hi there,
>
> I'm developing in Symfony 1.2.4, using Propel and MySQL as my
> database.
>
> I've written a task that:
>
> 1. grabs a set of CSV files from a reporting source
> 2. uploads the CSV files using MySQL's 'load data infile ... ' syntax
>
> It's step 2 above that is proving to be problematic.
>
> The problem is that I keep getting an error saying, "SQLSTATE[42000]:
> Syntax error or access violation: 1148 The used command is not allowed
> with this MySQL version"
>
> I write the query string to my debug log, cut n paste it into the CLI
> of MySQL and it executes perfectly.
>
> The code:
>
> $connection = Propel::getConnection();
>
> $taskLoad = "load data local infile '%s' into table task
> FIELDS
> terminated by ',' optionally enclosed by '\"' lines terminated by '\
> \n' IGNORE 1 LINES (task_id, ord_type_code, actn_type_code, order_no,
> customer_name, product_desc, status, task_name, @rfs_rev_date,
> @ms_rev_date, @ms_signoff_date, signoff_person, ack_by,
> jeop_type_code, product_group, priority, actn_opt, sales_manager,
> work_group, @crd, crd_days, access, monitor, serv_comp_ind, designer,
> deps_signed_off, sales_reference, site_code, street, suburb,
> post_code, state, @last_dep_signoff, cnd_project) SET rfs_rev_date =
> str_to_date(@rfs_rev_date, '%%Y-%%m-%%d'), ms_rev_date = str_to_date
> (@ms_rev_date, '%%Y-%%m-%%d'), ms_signoff_date = str_to_date
> (@ms_signoff_date, '%%Y-%%m-%%d'), crd = str_to_date(@crd, '%%Y-%%m-%
> %d'), last_dep_signoff = str_to_date(@last_dep_signoff, '%%Y-%%m-%
> %d')";
>
> //note the dates have %% (to escape the %) when we do a
> sprintf()
>
> $taskLoad = sprintf($taskLoad,$file);
>
> sfContext::getInstance()->getLogger()->debug("{importCSVfiles}
> running this: ".$taskLoad);
>
> try {
> $statement = $connection->prepare($taskLoad);
> $result = $statement->execute();
> }catch (Exception $e){
>
> sfContext::getInstance()->getLogger()->debug("{importCSVfiles}
> error ".$e->getMessage());
> }
>
> I've ensured that the user in question has been granted the global
> FILE permission in order to allow them to run 'load data infile ... '.
>
> As mentioned above, the query I write to the debug log works just fine
> when executed via the CLI.
>
> Any ideas where I could be going wrong?
>
> Thanks for your help...
> @wasabhi
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
