Table Column is called fields_thief, not fields

Christian Zange - January 1, 2008 - 23:58
Project:Field Thief
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:active
Description

Within the code, the column with the copyrules is called fields, while within the database it is called field_thiefs.

#1

Hanno - April 17, 2008 - 20:05

changing the database name into 'fields' returned a SQL error as 'fields' might be a reserved SQL variable. I also changed the fieldtype to TEXT because mysql didn't like 1024 as a VARCHAR length.

In the module I changed lines 241 and 243
db_query("INSERT INTO {copy_rule} (to_type, src_arg, fields_thief) VALUES ('%s', %d, '%s')", $form_values['to_type'], $form_values['src_arg'], $form_values['fields']);
} else {
db_query("update {copy_rule} set src_arg = %d,fields_thief = '%s' where to_type = '%s'", $form_values['src_arg'], $form_values['fields'], $form_values['to_type']);

as well as 151
'#default_value' => $edit['fields_thief'],
and 261
$list = explode("\n", $copy_rule->fields_thief);

 
 

Drupal is a registered trademark of Dries Buytaert.