CMS MADE SIMPLE FORGE

CMS Forge

 
Back Back to List

[#2987] SQL Index Problem

avatar
Created By: Peter Carroll (pcarroll)
Date Submitted: Wed Feb 04 17:31:38 -0500 2009

Assigned To:
Version: Production
CMSMS Version: None
Severity: Minor
Resolution: None
State: Open
Summary:
SQL Index Problem
Detailed Description:
Everything is working great but I found an oversight in the SQL. When I use my
favorite tool to sync databases, I get the following error on every table.

WARNING: table `cms_module_news_fieldvals` does not have a Primary Key or a
Unique Key with columns defined NOT NULL. Data Sync will operate in a special
mode. Refer to documentation for details.

I would have thought this was basic SQL housekeeping. You really should update
your tables to avoid any potential problems...

Otherwise, it's an excellent product. Thanks.


History

Comments
avatar 
Date: 2009-02-17 14:39
Posted By: Ronny Krijt (ronnyk)

Thanks for reporting. This point is being looked at....
Updates

Updated: 2009-02-04 17:33
description: Everything is working great but I found an oversight in the SQL. When I use my favorite too to sync databases, I get the following error on every table. WARNING: table `cms_module_news_fieldvals` does not have a Primary Key or a Unique Key with columns => Everything is working great but I found an oversight in the SQL. When I use my favorite tool to sync databases, I get the following error on every table. WARNING: table `cms_module_news_fieldvals` does not have a Primary Key or a Unique Key with column

Updated: 2009-02-04 17:32
version_id: -1 => 27707
resolution_id: => 5
severity_id: 12 => 3