NYCPHP Meetup

[Chris French]

No idea why it is happening, but  it has to do with #__redirect_links  if you not making heavy use of that  you should be totally fine forcing the import. 

Here is a reference to it 

http://phpcrossref.com/joomla/installation/sql/sqlazure/joomla.sql.html

 SET QUOTED_IDENTIFIER ON;
1208  
1209  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[#__redirect_links]') AND type in (N'U'))
1210  BEGIN
1211  CREATE TABLE [#__redirect_links](
1212      [id] [bigint] IDENTITY(1,1) NOT NULL,
1213      [old_url] [nvarchar](255) NOT NULL,
1214      [new_url] [nvarchar](255) NOT NULL,
1215      [referer] [nvarchar](150) NOT NULL,
1216      [comment] [nvarchar](255) NOT NULL,
1217      [hits] [bigint] NOT NULL,
1218      [published] [smallint] NOT NULL,
1219      [created_date] [datetime] NOT NULL,
1220      [modified_date] [datetime] NOT NULL,
1221   CONSTRAINT [PK_#__redirect_links_id] PRIMARY KEY CLUSTERED
1222  (
1223      [id] ASC
1224  )WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF),
1225   CONSTRAINT [#__redirect_links$idx_link_old] UNIQUE NONCLUSTERED
1226  (
1227      [old_url] ASC
1228  )WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
1229  )
1230  END;
1231  
1232  IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[#__redirect_links]') AND name = N'idx_link_modifed')
1233  CREATE NONCLUSTERED INDEX [idx_link_modifed] ON [#__redirect_links]
1234  (
1235      [modified_date] ASC
1236  )WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF);
1237  

On Jul 21, 2012, at 7:26 PM, David Roth wrote:

> Thanks, Chris for the reply.
> 
> I've never had to use those options on MySQL before. I will give it a try. Any idea what this error message is all about? Thanks!
> 
> David Roth
> 
> On Sat, Jul 21, 2012 at 9:52 PM, Chris French <contact at chrisfrench.me> wrote:
> That is weird,
> 
> if you are using the command line   just ad -f or --force to your import and it should continue passed it and  your install will probably be fine.
> 
> 
> 
> 
> On Jul 21, 2012, at 6:44 PM, David Roth wrote:
> 
> > I did a MySQL dump of a Joomla 2.5.6 website to publish it in another directory. When I went to load the MySQL database from the edited *.sql file for the new installation I got this error message from the mysql command:
> >
> > ERROR 1062 (23000) at line 3472: Duplicate entry ... for key 'idx_link_old'
> >
> > I never saw this before. Any suggestions what to do about it? Thanks for any insight!
> >
> > David Roth
> >
> >
> > _______________________________________________
> > New York PHP SIG: Joomla! Mailing List
> > http://lists.nyphp.org/mailman/listinfo/joomla
> >
> > NYPHPCon 2006 Presentations Online
> > http://www.nyphpcon.com
> >
> > Show Your Participation in New York PHP
> > http://www.nyphp.org/show_participation.php
> 
> _______________________________________________
> New York PHP SIG: Joomla! Mailing List
> http://lists.nyphp.org/mailman/listinfo/joomla
> 
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
> 
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
> 
> _______________________________________________
> New York PHP SIG: Joomla! Mailing List
> http://lists.nyphp.org/mailman/listinfo/joomla
> 
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
> 
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/joomla/attachments/20120721/aec1356a/attachment.html>