double entries in database: WSN Support

Version:

double entries in database

wizardofchips
Member

Usergroup: Customer
Joined: Oct 15, 2004
Total Topics: 10
Total Posts: 23

Posted 11/03/04 - 11:39 AM:	#1
Was in phpmyadmin and noticed that all my links in the database are duplicated. Everytime i make a new link instead of putting one new entry into wsnlinks_links it puts two of the same thing. Is this normal? My database is twice as big as it needs to be .

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6175

Posted 11/04/04 - 12:28 AM:	#2
It's not normal unless you're making an alias of every link. If it's not showing it twice in your directory then thre must be something different about the two copies, and you'll need to find what fields these are that are differnt.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

wizardofchips
Member

Usergroup: Customer
Joined: Oct 15, 2004
Total Topics: 10
Total Posts: 23

Posted 11/04/04 - 10:34 AM:	#3
It doesnt show twice in the links list and theres nothing different about them except the ID in the database

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6175

Posted 11/04/04 - 09:16 PM:	#4
If there were nothing different then it would have to show twice, it would be impossible for them to not show twice.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

wizardofchips
Member

Usergroup: Customer
Joined: Oct 15, 2004
Total Topics: 10
Total Posts: 23

Posted 11/09/04 - 10:49 PM:	#5
You mentioned aliasing earlier in a post. Looking at two database entries for eacb link now I do see a field named alias. In phpmyadmin Ill try to explaing what I see best I can. Say I add a link and it goes into my database as LINKID "38" and if I look a bit further down that row I see that the LINKALIAS "0". BUT somehow there has been added a new row with LINKID "39" and and LINKALIAS "38" and everything except id and alias are identical to row 38 Did I explain that so it could be understood? Hope so. This is happening to every link I add. How can I stop this? If I delete either one of them the link doesnt show up in my directory.

wizardofchips
Member

Usergroup: Customer
Joined: Oct 15, 2004
Total Topics: 10
Total Posts: 23

Posted 11/11/04 - 05:23 AM:	#6
I figured it out thanks anyways

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6175

Posted 11/11/04 - 01:28 PM:	#7
You must have been aliasing every link for some reason.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.