MySQL Error 1054??

[jervin]

I have a record that is listed on the SugarCRM home page (on my system) under My Calls. When I try to view or edit this file, I immediately get the following error:

Error filling in additional detail fields: Query Failed:SELECT name , assigned_user_id parent_name_owner from prospects where id = ''::MySQL error 1054: Unknown column 'name' in 'field list'

I know I've seen plenty of reports like this, and like most folks, I don't know what to do about it.

I am running a Trixbox system
SugarCRM 4.5.1h
CentOS 4.6
PHP 4.3.11

[johnt2005]

Take a look at this site and see if it may resolve your issue. http://dev.mysql.com/doc/refman/5.0/...ge-tables.html

[jervin]

Didn't seem to work so far, but thanks.

Logged on as Root
Entered the command: mysql_fix_privilege_tables --verbose --password=xxxxxxxx
got the following message:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Got a failure from command:
/user/bin/mysql --no-defaults --force --user=root --host=localhost --password=xxxxxxxx --database=mysql
Please check the above output and try again

[ptemplin7]

As you have Trix,

Have you loaded and used the myphpadmin? It will likely help you clear this error. Forgot wher I found it but you need to clear the root password and reset it. Also remember to flush privilege; to clear the table befoer exiting.

You may also want to go in with myphpadmin and delete that row. Remember to save the table and db first! (use mysqladmin of mysqldump)

Hope this helps, Paris

[barracuda]

Hi guys. Could you help me to fix this error:

Error filling in additional detail fields: Query Failed:SELECT name , assigned_user_id parent_name_owner from prospects where id = ''::MySQL error 1054: Unknown column 'name' in 'field list'


It appears when I want to see or edit My meetings or My Calls.

Thanks you very much in advance.

[kbrill]

Can you upload the diagnostic file from your system? It will let us look at your schema and vardefs.

[kuske]

Sounds like the good old 4.5-I forgot my database type-issue.
Check your config.php, does the dbconfig-section look like this:

'dbconfig' =>
array (
'db_host_name' => 'localhost',
'db_host_instance' => '',
'db_user_name' => 'sugarcrm',
'db_password' => 'topsecret',
'db_name' => 'sugar451x',
'db_type' => 'mysql', ),


In some cases sugar lost this db_type line. In the code the value 'mysql' is needed to calculate the name-field in your query.

[telania]

I just upgraded from 4.5.1 to 5.0b and got this error:

Query Failed:SELECT tracker.* from tracker WHERE user_id = '1' AND visible = 1 ORDER BY id DESC LIMIT 0,10::MySQL error 1054: Unknown column 'visible' in 'where clause'

Any idea how to fix?

Don

[kuske]

It looks as if your sql-update script did not finish correctly.

To fix you tracker problem you could run

ALTER TABLE `tracker` modify column user_id varchar(36)  NULL,
    add column `action` varchar(255)  NULL,
    modify column `module_name` varchar(255)  NULL,
    modify column `item_id` varchar(36)  NULL,
    add column `session_id` int(11)  NULL,
    add column `visible` bool  DEFAULT 0 NULL,
    ADD INDEX idx_tracker_iid(item_id),
    ADD INDEX idx_tracker_userid_vis_id(user_id,visible,id),
    ADD INDEX idx_tracker_userid_itemid_vis(user_id,item_id,visible);

UPDATE `tracker` set visible = '1';

in sqladmin, but I think you should test the whole 451_to500_mysql.sql out of the patch zip file.

[mamnmamn]

Sorry to butt in but I am getting this same error;

Error filling in additional detail fields: Query Failed:SELECT name , assigned_user_id parent_name_owner from prospects where id = ''::MySQL error 1054:

I have tried everthing in this thread but have not resolved the issue. It only happens on one user account and only when creating a meeting. He can edit meetijngs fine.

I am running
SugarCRM = SugarCE-Full-5.0.0b
MySQL = 5.0.38-Ubuntu_0ubuntu1.4-log
Ubuntu = 7.04
PHP = PHP Version 5.2.1
Kernel = 2.6.20-16-server #2 SMP Fri Feb 1 03:10:48 UTC 2008 i686

Hope you can help,

mamnmamn