| Index
» Projects
» phpMyEdit
» Forum
» found bug #94, still problem with underscores in names |
 |
peg_rtm
Joined: 14 Apr 2006
Posts: 6
Posted: 2006-04-14 02:57
Back to top
Reply with quote
|
First, let me say I was very, very excited to find PhpMyEdit. It is an amazing tool! But...
Regrettably, most of the databases I am trying to use have underscores in table and field names. I found bugs #94 and 146 which attempt to explain how to fix this. I tried adding backticks like `'x_news_pics'` around table and field names in various ways. Nothing I have found will allow me to make changes to my tables :( This seems a very serious bug, as it appears to make PhpMyEdit useless for editing! As I read MySQL docs, underscore is a legal character, and it should be supported.
Could someone please explain EXACTLY where and how I must make these changes to the following lines of my file which have table or field names?
$opts['tb'] = 'x_news_pics';
$opts['key'] = 'id_pic';
$opts['sort_field'] = array('id_pic');
$opts['fdd'][id_pic]
...etc...
$opts['fdd']['pic_x']
$opts['fdd']['pic_y']
$opts['fdd']['credit']
and what about the one field which pulls data from another table, as below:
$opts['fdd'][id_story] = array(
'name' => 'Story',
'values' => array(
'table' => 'x_news',
'column' => 'id_story',
'description'=> array(
'columns' => array(
'0' => 'date',
'1' => 'title'
),
'divs' => array(
'0' => ': '
),
),
'orderby'=>'date'
)
);
I hope someone can enlighten me to fix this. If so, I will send what money I can to support the project, because it will be just what I need if it will just edit my data!
Thank you
|
peg_rtm
Joined: 14 Apr 2006
Posts: 6
Posted: 2006-04-14 15:46
Back to top
Reply with quote
|
I stumbled upon the solution myself. I had a field named "order" which conflicts with MySQL keyword. When I backtick just that field and the table name, all is ok.
I still wonder why it did not work when I backtick'ed ALL fieldnames and the table name...?
|
peg_rtm
Joined: 14 Apr 2006
Posts: 6
Posted: 2006-04-14 16:46
Back to top
Reply with quote
|
Nope, again I am mistaken. Although what I did fixed things so that I can CHANGE a record, now I cannot ADD a new record.
This is very frustrating. I am beginning to believe perhaps this tool will not do what I want after all. What a shame after such a hopeful start :(
IMHO, if MySQL permits an underscore character in table and field names, then I have to say I think PhpMyEdit must support it seemlessly.
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
