Gossamer Forum
Home : Products : Links 2.0 : Discussions :

links.db is removing and changing lines of sites from the db

Quote Reply
links.db is removing and changing lines of sites from the db
I have been cleaning my database as it had many dead sites. I DO back up constantly! There is something very strange going on tho! Sometimes when I check the links.db file I see lines that have been either shortened or wind up on 2 lines instead of 1 line. I also notice that sometimes the file size goes down significantly, then I do a look see and find that 1/8th the database has poofed into thin air.
What causes this, and is there a fix for it?
This is an example of 1 of the lines that goes missing. It's the one with the ://
16690|SITENAME|http://www.COM|21-Oct-2005|CAT|DESCRIPTION|NAME|webmaster@URL.com|25|No
://http://www.COM|20-Oct-2005|CAT|DESCRIPTION|NAME|webmaster@URL.com|25|No|No|0|0|Yes||WOTD
16700|SITENAME|http://www.COM|21-Oct-2005|CAT|DESCRIPTION|NAME|webmaster@URL.com|50|WOTD

This one is a 2 liner. The errored line starts with the || -
13342|SITENAME|http://www.COM|6-Apr-2005|CAT|DESCRIPTION||||No|No|||||
||stoned|||||||No|No|||||

The next kind of error is the one that eats chunks of the database -
site # 5100 will be in tact, then there will be a space on the next line.

Then the next site listed in site #5501.
There are aprox 401 entries missing in cyberspace :( (this is just an example of the sites that go missing)

There has got to be a fix for this (I'm hoping) somewhere! Please??!!

Thank you to whomever can fix this bugger!

Quote Reply
Re: [MistressR] links.db is removing and changing lines of sites from the db In reply to
So you have over 16,000 links?

Links2 seems to have that problem when the number of links gets over a few thousand, though some folks seem to not have any trouble with more...

The standard reply is to upgrade to Links SQL, requiring a substantial investment in time and money.

Sorry... Unsure


Leonard
aka PerlFlunkie
Quote Reply
Re: [PerlFlunkie] links.db is removing and changing lines of sites from the db In reply to
Hiya,

No, actually I have only 8679 live sites. Many have been deleted or not accepted. I just ran a sucessfull build, and the links db file size went from 1778KB to 1769KB. Is that drop in size from formatting to the links2.0? The number of sites is exactly the same! Whew! LOL!

Someone told me that there was something that is suppose to happen to the files when they are being used.. called "lock". He said they are suppose to unlock when they are being used, and lock when you are finished. Is there some sort of code that makes that happen if that is a truism?