Pictures Install Error

Pro-com / 1 decade ago (27 November 2005 12:23)

When i try to install php news manager it install's but there is one problem , i receive this problem:

news_pics...Duplicate column name 'id'

i have no idea what this means and i have tried this on so many diffrent servers and it comes up with the same problem can somebody please help?



Post replies:


1 decade ago (27.11.2005 12:03)
Reply by: TAXIFUNK
Try message to Polaris or polaris
1 decade ago (27.11.2005 12:18)
Reply by:
Great help and explanation,TAXIFUNK Cool
1 decade ago (27.11.2005 04:21)
Reply by: polaris
Hi,

Well, there is bug in install.php file.

Open install.php and on line 225 you will see something like this:
----------------------------------------------------------------------------------
mysql_query("CREATE TABLE $db_news_pics (id int(11) NOT NULL auto_increment,author tinytext NOT NULL,name tinytext NOT NULL,picture tinytext NOT NULL,description tinytext NOT NULL,datum date NOT NULL default ´0000-00-00´,PRIMARY KEY (id,id,id)) TYPE=MyISAM;");
----------------------------------------------------------------------------------

Whatch for this part = PRIMARY KEY (id,id,id)),
it should be = PRIMARY KEY (id))

(just one ID)

Save and exit and try to install again. (but delete all tables from mysql that News Manager created).

Regards.
1 decade ago (15.08.2010 09:22)
Reply by:
welcome to ::[ [ == [LINK] ==]
(b..r..a..n..d.)s.h.o.e.s.(34u.s.d),,

==J. a .m .e )) shoes

< j o r d a n> (1-24) shoes

< j o r d a n> 2010 shoes

c.l.o.t.h.i.n.g,,j.e.a.n,,h.a.n.d.b.a.g(35u.s.d),,

==c .o. a .c .h )) handbag

(f.r.e.e)s.h.i.p.p.i.n.g

[ [ == [LINK] == ]