I have errors when I try to view details contact
I Try to run the function "Repair database" to investigate problem
I have this warning:
==============
Repair Database:execute Print Help
Warning: mysql_query() [http://www.mysql.com/doc]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in c:\Inetpub\wwwroot\crm\include\database\MysqlManag er.php on line 142
/* Table : files */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - id - ROW [Field] => 'id' [Type] => 'varchar(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
/* VARDEF - id - ROW[Field] => 'id' [Type] => 'char(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
alter table files modify column id char(36) NOT NULL
/*MISMATCH WITH DATABASE - assigned_user_id - ROW [Field] => 'assigned_user_id' [Type] => 'varchar(36)' [Null] => 'YES' [Key] => 'MUL' [Default] => '' [Extra] => '' */
/* VARDEF - assigned_user_id - ROW[Field] => 'assigned_user_id' [Type] => 'char(36)' [Null] => 'YES' [Key] => '' [Default] => '' [Extra] => '' */
alter table files modify column assigned_user_id char(36)
/*INDEXES/*
/* Table : acl_roles_actions */
/*COLUMNS/*
/*INDEXES/*
/*MISSING INDEX IN DATABASE - idx_aclactions_roles -index ROW/*
ALTER TABLE acl_roles_actions ADD
===========
I am using mysql5 and IIS and it seems I have to modify something in the sintax of parameter $sql in function mysql_query() but I do not know where.
I am in very difficult. I hope can use Sugarcrm But whit this problem is not possible.
Many thanks to who can help me
mario cibola


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks