2016

It keeps the original formatting.

wr=ote:=20 This means that you haven't had any issues with your database. (No need to= mess with safe write) =C2=A0=C2=A0Watch that your error logs don't get too big, now that you've turned them o=n.=C2=A0Lots of stuff can change on a server in 10 years ;-) (Even if you don't tou=ch it)I'd start with Stuart's suggestion.=C2=A0D. Brooke MobileOn Mar 15, 2016, at 5:13 PM, Rich Kwas wrote:I don't seem to have any .db-tmp files anywhere .They would be in the same ="globals " folder as the main database right?I did not have error logging turned on.Just enabled that.Nothings changed in this site really for years and years. Same db, same adm=in area, same everything. Just every now and then this occurs.=20 On Tuesday, March 15, 2016 4:43 PM, Stuart Tremain = wrote:=20 Are you getting a lot of .db-tmp files being written for the db ?If you are then there could be a problem with either your code or some of t=he content, based on the fact that the site has been operational for many y=ears, I would open the .db file and check the content, also check your erro=r log.txtKind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 16 Mar 2016, at 08:09, Rich Kwas wrote:I already using [COMMITDATABASE db=3DFileName] in all the admin pages where= they edit these ads...Problem still pops up every now and then, like today again.Thoughts on the "Safe Write" setting?=20 On Tuesday, March 15, 2016 4:01 PM, Stuart Tremain = wrote:=20 From memory, there was a bug in =E2=80=9CAutomatically commit databases to= disk after modification=E2=80=9D, I wonder if this was associated with you=r problem ?You can always add=C2=A0[COMMITDATABASE db=3DFileName] after the modificati=on just to make sure.Kind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 16 Mar 2016, at 07:15, Rich Kwas wrote:Is it safe to disable ""Safe Write for Database" in Preferences???=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DSafe Write DB:Enabled by default. Sets the WebDNA engine to create a temporary file when =writing the contents of a database to disk. The temporary file contents are= then moved to the original database file after the entire database is comp=letely flushed to disk. This helps to eliminate corruption of the original =database file if there is an interruption during the database write process=..=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3DIf I disable this setting will all changes be written to the db on the HD i=mmediately, =C2=A0without that need for a temporary file?I've been having this issue "again" where a client says they make changes t=o ad listings stored in the database, but then all the changes are gone a f=ew moments later. Like they never were altered in the first place....This site has been for over 10 years and the admin area has not been change=d recently or much over that time span...There is no consistency to this issue.It happens (like today) but may not h=appen for days or weeks.I'm wondering if this "temporary file" and the original database on disk ar=e somehow under some circumstances getting out of sync.The db isn't that large, having 2,111 records,151 Fields and using 4,759K o=f ram.I'm wondering if disabling "Safe Write" might be an option to try and preve=nt this in the future.Very frustrating for the client.I can't seem to duplicate it myself,but I b=elieve them when they say it happens.I may have posted about =C2=A0this iss=ue in the past as well.I'm on Windows Server2008 using vers.6.2I have nearly 1gb of unused ram on =the server, plenty of hard drive space....I've attached a screen capture of my Preferences in case anything else can =be tinkered with.---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us ---------------------------------------------------------This message is= sent to you because you are subscribed tothe mailing list .To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reportin=g: support@webdna.us---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us ---------------------------------------------------------This message is= sent to you because you are subscribed tothe mailing list .To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reportin=g: support@webdna.us---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us ------=_Part_848698_49638161.1458096758088Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printable

Like usual, it happened 2x on 2 di=fferent ad listings I'm being told, and been stable ever since.

That's what makes it so frustrating. Can't seem to pin down =the why.

I'll keep my eye on those error logs..

On Tuesday, March 15, 2016 7:45 PM, Donovan Brooke <dbrooke@euca.=us> wrote:

This means that you haven't had any issues= with your database. (No need to mess with safe write)

Watch that your error logs don't get t=oo big, now that you've turned them on.

Lots of stuff can change on a server in 10 years ;-) (Even if= you don't touch it)

I'd start w=ith Stuart's suggestion.

D. Broo=ke Mobile

On Mar 15, 2016, at 5:13 PM, Rich Kwas &=lt;richkwa=sniewski@yahoo.com> wrote:

I don't seem to have any .db-tmp files anywhere .
They would be in the same= "globals " folder as the main database right?

I did not have error logging tu=rned on.
Just enabled that.

Nothings changed in this site really for years and= years. Same db, same admin area, same everything. Just every now and then =this occurs.

On Tuesday, March =15, 2016 4:43 PM, Stuart Tremain <webdna@idfk.com.au> wrote:

Are you getting a lot of .db-tm=p files being written for the db ?

If you ar=e then there could be a problem with either your code or some of the conten=t, based on the fact that the site has been operational for many years, I w=ould open the .db file and check the content, also check your error log.txt=

Kind regards

Stu=art Tremain
IDFK Web Developments
AUSTRALIA
webd=na@idfk.com.au

=

On 16 Mar 2016, at 08:09, R=ich Kwas <richkwasniewski@yahoo.com> wrote:
I already using [COMMITDATABASE db=3DFileNam=e] in all the admin pages where they edit these ads...

Problem still pops up every n=ow and then, like today again.

Thoughts on the "Safe Write" setting?

On Tuesday, March= 15, 2016 4:01 PM, Stuart Tremain <webdna@idfk.com.au> wrote:

From memory, there was a bug in =E2==80=9CAutomatically commit databases to disk after modification=E2=80=9D, I= wonder if this was associated with your problem ?

You can always add [COMMITDATABASE db=3DFileName] after the mod=ification just to make sure.

Kind regards

Stuart Tremain
<=div class=3D"yiv7544168511">IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au=

On =16 Mar 2016, at 07:15, Rich Kwas <richkwasniewski@yahoo.co=m> wrote:

Is it safe to disable ""S=afe Write for Database" in Preferences???

=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D
Safe Write DB:
En=abled by default. Sets the WebDNA engine to create a temporary file when wr=iting the contents of a database to disk. The temporary file contents are t=hen moved to the original database file after the entire database is comple=tely flushed to disk. This helps to eliminate corruption of the original da=tabase file if there is an interruption during the database write process.<=/span>
=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

If I disable this setting will all chang=es be written to the db on the HD immediately, without that need for =a temporary file?

I've been having this issue "aga=in" where a client says they make changes to ad listings stored in the data=base, but then all the changes are gone a few moments later. Like they neve=r were altered in the first place....

This site has been for over 10 years and the admin are=a has not been changed recently or much over that time span...

There is no consistency to this issue.
It happens= (like today) but may not happen for days or weeks.
=
I'm wond=ering if this "temporary file" and the original database on disk are someho=w under some circumstances getting out of sync.

The db isn't= that large, having 2,111 records,151 Fields and using 4,759K of ram.
=

I'm wondering if disabling "Safe Write" might be an option to try= and prevent this in the future.

Very frustrating for the =client.I can't seem to duplicate it myself,but I believe them when they say= it happens.I may have posted about this issue in the past as well.

I'm on Windows Server2008 using vers.6.2
I h=ave nearly 1gb of unused ram on the server, plenty of hard drive space....<=/div>

I've attached a screen capture of my Preferences in case anything e=lse can be tinkered with.

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to:=20archives: http://mail.=webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us<webdna.=jpg>

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to:=20archives: http://mail.=webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to:=20archives: http://mail.=webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to:=20archives: http://mail.webdna.us/list/talk@webd=na.usBug Reporting: support@web=dna.us