- Development - lists.drupal.org

The used command is not allowed with this mysql version query
by Amit Vyas 29 Nov '11

29 Nov '11

Hello Druplers, Have been in this problem from last 3 days and did a lot of google but didn't able to find any solution which work for me. Here is the problem: I have to go live and I have two servers on Joyent. one is for database and another is for durpal installation with files. 1. I'll get one file in the drupal's files directory, based on that file I have to update my tables. 2. I have written a module which will get that file and using LOAD DATA LOCAL INFILE, it will load all the data from csv file to a temp table. 3. And this will be done when cron will run. It will execute the code and move the file to some other folder and load all the data and update the database(which is on other server). 4. Now the problem occurs, 5. When I run the cron, its giving me the error " user warning: The used command is not allowed with this MySQL version query: LOAD DATA LOCAL INFILE '/file/path/file.csv' IGNORE INTO table temp_table FIELDS TERMINATED BY ',' IGNORE 1 LINES " We have tried these solutions: 1. We have added "LOCAL INFILE=1" in my.cnf in "client" and "mysql" on both server [Which didn't work]: here is what we have done in my.cnf - [client] port = 3306 socket = /tmp/mysql.sock local-infile =1 - [mysqld] port = 3306 bind-address = 127.0.0.1 #bind-address = 10.12.24.151 socket = /tmp/mysql.sock skip-external-locking #skip-bdb local-infile = 1 2. When we connect from fileserver to database server with command line and execute the same sql query then it is working fine BUT not with drupal module. We are now just frustrated with this error because we are solving this from last 3 days and management is on us :) Can anyone has experience with this type of problem before? Thanks! -- Cheers, Amit Vyas ____________________________________________________________________________ ____ Email : vyasamit2007(a)gmail.com Skype : vyasamit2004 Mobile : +91 993-040-1490 Phone : +91-022 428-884-07

2 3

Re: [development] Right to left languages
by Yani 25 Nov '11

25 Nov '11

http://www.thebestplans.org/node/180?language=ar I’m using rtl in the tags. Co-ment is an iframe, I’m not a fan of inline styles but hey you do what you have to do and it works. I’ve got nothing bad to say about the developers. Gérald (co-ment) busted his guts for us as we are the first to use this in Drupal 7. A really useful module. 4 ½ / 5 stars. Yani From: Sean Robertson [mailto:seanr@webolutionary.com] Sent: Saturday, 26 November 2011 2:48 AM To: development(a)drupal.org; Yani Subject: Re: [development] Right to left languages It's working fine on Chrome 15.0.874.121 on Mac OSX Lion. Text highlighting is working as expected (LTR everywhere except for the hebrew text which is RTL). The only thing I see is that the Hebrew text is still defaulting to align:left; you'll want to change that for the #textcontainer div on Hebrew pages. -- Sean Robertson Web Designer/Developer http://webolutionary.com 757-201-4750 On Friday, November 25, 2011 at 11:24 AM, Yani wrote: Don't say too much Fred or I'll put you name on the volunteer list. ;) Yani -----Original Message----- From: development-bounces(a)drupal.org [mailto:development-bounces@drupal.org] On Behalf Of Fred Jones Sent: Tuesday, 22 November 2011 11:00 PM To: development(a)drupal.org Subject: Re: [development] Right to left languages http://www.thebestplans.org/node/174?language=he Really? Not in Chrome or Firefox here. In Chromium and Firefox on my Hebrew-enabled (but English is the master language) Linux machine the text starting with "המדינות האחיות הן ישראל" comes out correctly--I can read it just fine. Fred, who knows how to read Hebrew :)

1 0

Can I define fields that do not get stored in a separate table?
by Mukesh Agarwal 25 Nov '11

25 Nov '11

I'm using hook_field_info to define my new fields. I need to use this field within a couple of entities and I dont need to have these fields in separate tables. However when I try to define the schema of a field using hook_field_schema I see that I need to mention the columns which means the table for the field will be created when I create an instance of the field with some entity. Is there a way out of this? Can I have my field data in the same table as that of my entity (which is not a node but a custom entity)? -- Cheers, Mukesh Agarwal ________________________________ Innoraft Solutions <http://www.innoraft.com> || +91 8017220799

4 7

Using specific input format for textarea
by Pooya 19 Nov '11

19 Nov '11

Anyone know how to use a specific input format for a textarea in form api? There's no property for this option. // This is my form element: $form['easyco_custom']['easyco_custom_query'] = array( '#type' => 'textarea', '#title' => t(My Query'), '#size' => 1000, '#maxlength' => 1000, '#prefix' => '', '#suffix' => '', ); I've created a new input_format using admin/settings/filters and I need to use it here. It's a SQL syntax highlighter(it's not about executing this sql, so no injection) Thanks in advanced

2 1

Js event after image uploaded
by Idan Arbel 12 Nov '11

12 Nov '11

Hello, I have an image field form, and I want to run some js code after the image is uploaded and the preview is created. I can't seem to figure out what jquery event to use. I'd appreciate any help. Thanks Idan

3 3

Hidden required select field with default value
by Idan Arbel 11 Nov '11

11 Nov '11

Hello, I'm trying to modify a form where I'm hiding a select field. This field is usually required. When setting the #type = hidden The field is hidden, but when trying to submit the form I get an error about the fields being required. Looking at the $form dump, I see that the select field has a default value. (a term id). I tried changing the Required to false when hiding but then the field looses its value. Is there some other property I need to set? Thanks Idan

5 6

Serialized Data
by Lynn 11 Nov '11

11 Nov '11

Hello, I'm trying to create an Ubercart module to show products with their attribute option name. Could anyone guide me (or provide a link) how to get the '29', via PHP or function, from this serialized data: a:1:{i:3;s:2:"29";} If there are two product attributes, I would need to extract the 155 and 154 from this: a:2:{i:3;s:3:"155";i:17;s:3:"154";} Thanks, Lynn

3 2

Rules Data Selection Token works, but doesn't in direct input
by Idan Arbel 10 Nov '11

10 Nov '11

Hello, I'm using rules to send a mail. I've found the data I want to use in the body and TO emails, using the Data Selectors. But when I try to use with the input box set the Direct Input (for multi line in the message Body) the tokens don't seem to work. This is my token: design:field-image1:file:url if the field is set to Data selection, it works and I get the value via email. If the field is set to direct input I get the token text in the email. Tried: design:field-image1:file:url and [design:field-image1:file:url] Am I doing something wrong? The help text implies that they should be interchangeable: The data selector helps you drill down into the data available to Rules. To make entity fields appear in the data selector, you may have to use the condition 'entity has field' (or 'content is of type'). More useful tips about data selection is available in <http://drupal.org/node/1300042> the online documentation. Thanks Idan

1 0

Field Approval on D7
by Idan Arbel 09 Nov '11

09 Nov '11

Hello, I'm looking for a way to have an approval process on a field, specifically on an multi image field. Users can upload images on a multi image field and I want to manually go over each image before I approve it for publishing. The catch is that if someone updates an existing field and only changes one image, I don't want to unpublish the entire profile but either leave it as it was or just hide the unapproved field. Thanks Idan

2 2

Quiz Module - individual record for Multichoice answers
by Sergio Rodolfo Gattas 29 Oct '11

29 Oct '11

Hi, I need to know in which table of the database results are saved for each user to multiple choice questions. I review the model and only get to see that the table is saved quiz_multichoice_user_answers a record (id, result_id, question_nid, question_vid) is linked with quiz_multichoice_user_answer_multi the table (id = user_answer_id), and in the latter table is an additional column (answer_id) which I think will refer to the detail but I can not find that table. >From already thank you for any help, regards, Sergio

2 1