Oracle install errors
Oracle install errors
Posted:09 Jul 2009 (00:50 UTC)When installing just the required packages under Oracle 10g I get the below errors:
Failed to create index content_content_hits_idx on liberty_content_hits:
CREATE INDEX content_content_hits_idx ON liberty_content_hits (content_id)
Failed to create index themes_layouts_module_idx on themes_layouts:
CREATE INDEX themes_layouts_module_idx ON themes_layouts (module_id)
I had a look at the tables and the indexs were automatically created - I'm guessing when the primary key was defined in the CREATE TABLE statement these were created. I'm using the CVS version which I got this morning.
Failed to create index content_content_hits_idx on liberty_content_hits:
CREATE INDEX content_content_hits_idx ON liberty_content_hits (content_id)
Failed to create index themes_layouts_module_idx on themes_layouts:
CREATE INDEX themes_layouts_module_idx ON themes_layouts (module_id)
I had a look at the tables and the indexs were automatically created - I'm guessing when the primary key was defined in the CREATE TABLE statement these were created. I'm using the CVS version which I got this morning.
Re: Oracle install errors
Posted:11 Jul 2009 (06:00 UTC)Daniel - I'd simply delete those lines in the scheme_inc.php ( liberty and themes ). I'm not sure why only those are being flagged, I think I have a couple more duplicated in Firebird, but you are right that once something is set as PRIMARY then in most real databases, an index will also be created. I think these duplicates should simply be removed.
Page 1 of 1 1