From ooo-users-return-2886-apmail-incubator-ooo-users-archive=incubator.apache.org@incubator.apache.org Fri Oct 5 19:48:04 2012 Return-Path: X-Original-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C5497D92B for ; Fri, 5 Oct 2012 19:48:04 +0000 (UTC) Received: (qmail 77258 invoked by uid 500); 5 Oct 2012 19:48:03 -0000 Delivered-To: apmail-incubator-ooo-users-archive@incubator.apache.org Received: (qmail 77200 invoked by uid 500); 5 Oct 2012 19:48:03 -0000 Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-users@incubator.apache.org Delivered-To: mailing list ooo-users@incubator.apache.org Received: (qmail 77139 invoked by uid 99); 5 Oct 2012 19:48:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Oct 2012 19:48:03 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of shannonwequine@aol.com designates 205.188.105.143 as permitted sender) Received: from [205.188.105.143] (HELO imr-da01.mx.aol.com) (205.188.105.143) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Oct 2012 19:47:54 +0000 Received: from mtaomg-ma06.r1000.mx.aol.com (mtaomg-ma06.r1000.mx.aol.com [172.29.41.13]) by imr-da01.mx.aol.com (8.14.1/8.14.1) with ESMTP id q95JlK0p003839 for ; Fri, 5 Oct 2012 15:47:20 -0400 Received: from core-dma003b.r1000.mail.aol.com (core-dma003.r1000.mail.aol.com [172.29.212.9]) by mtaomg-ma06.r1000.mx.aol.com (OMAG/Core Interface) with ESMTP id 60710E000085 for ; Fri, 5 Oct 2012 15:47:20 -0400 (EDT) References: <20121005191641.B12E9816020@nike.apache.org> To: ooo-users@incubator.apache.org Subject: Re: having major problem with a database, please help quickly! In-Reply-To: <20121005191641.B12E9816020@nike.apache.org> X-MB-Message-Source: WebUI MIME-Version: 1.0 From: "Wellington Equine Associates (Shannon)" X-MB-Message-Type: User Content-Type: multipart/alternative; boundary="--------MB_8CF71495DB8F3D1_1B94_E0AD_webmail-m144.sysops.aol.com" X-Mailer: AOL Webmail 37058-STANDARD Received: from 98.77.92.50 by webmail-m144.sysops.aol.com (149.174.9.9) with HTTP (WebMailUI); Fri, 05 Oct 2012 15:47:20 -0400 Message-Id: <8CF71495D9EC4A6-1B94-3A9A@webmail-m144.sysops.aol.com> X-Originating-IP: [98.77.92.50] Date: Fri, 5 Oct 2012 15:47:20 -0400 (EDT) x-aol-global-disposition: G DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mx.aol.com; s=20110426; t=1349466440; bh=3Nzx2yuETgmfebY/Qb4G9KOLJEB7ZM7TOD5fvmP5NY4=; h=From:To:Subject:Message-Id:Date:MIME-Version:Content-Type; b=I8fmHv+5n3tH5uS5JELaOs2n6CQo9VuTLOp4jI+xNW4/jY6b04+RPlnwreT/bPq+F 63QKW4t5jc+p013W74iokoWq2ICtGEmq9Mrx4ir/rrf/rLH7o9ekHjixeA+AWe0NKp 2Tg1PHZfbICCHep+qPN7sHth093mrqWr7h2d3A+g= X-AOL-SCOLL-SCORE: 0:2:529627488:93952408 X-AOL-SCOLL-URL_COUNT: 0 x-aol-sid: 3039ac1d290d506f3948585d ----------MB_8CF71495DB8F3D1_1B94_E0AD_webmail-m144.sysops.aol.com Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="us-ascii" Hi John. I hope this helps. =20 OS Name=09Microsoft Windows XP Professional Version=095.1.2600 Service Pack 3 Build 2600 OS Manufacturer=09Microsoft Corporation System Name=09DELL1 System Manufacturer=09BIOSTAR Group System Model=09GF8100 M2+ TE System Type=09X86-based PC Processor=09x86 Family 15 Model 127 Stepping 2 AuthenticAMD ~2700 Mhz BIOS Version/Date=09American Megatrends Inc. 080015, 2/23/2009 SMBIOS Version=092.5 Windows Directory=09C:\WINDOWS System Directory=09C:\WINDOWS\system32 Boot Device=09\Device\HarddiskVolume1 Locale=09United States Hardware Abstraction Layer=09Version =3D "5.1.2600.5512 (xpsp.080413-2111)" User Name=09DELL1\Admin Time Zone=09Eastern Daylight Time Total Physical Memory=092,048.00 MB Available Physical Memory=09920.45 MB Total Virtual Memory=092.00 GB Available Virtual Memory=091.96 GB Page File Space=093.60 GB Page File=09C:\pagefile.sys -----Original Message----- From: john To: ooo-users Sent: Fri, Oct 5, 2012 3:16 pm Subject: Re: having major problem with a database, please help quickly! Ok then hmmm, who installed, and is the winxp running wamp? What is the dat= abase=20 platform that you are running on, mssql, mysql, or which. That's what I was= =20 saying, is that I need to know the setup. Sent from my Verizon Wireless 4G LTE Smartphone ----- Reply message ----- From: "Wellington Equine Associates (Shannon)" To: Subject: having major problem with a database, please help quickly! Date: Fri, Oct 5, 2012 14:46 This may sound dumb, but I don't think there is a server setup. This is ju= st an=20 old Windows XP. We are a very small office, which is why I don't think the= re is=20 one. -----Original Message----- From: john To: ooo-users Sent: Fri, Oct 5, 2012 2:39 pm Subject: Re: having major problem with a database, please help quickly! Yeah I presumed you were using phpmyadmin or some other GUI to manage the= =20 database. If not then it would be done on command line. I guess you need to explain the server setup, because I am just guessing i= ts=20 linux=20 Sent from my Verizon Wireless 4G LTE Smartphone ----- Reply message ----- From: "Wellington Equine Associates (Shannon)" To: Subject: having major problem with a database, please help quickly! Date: Fri, Oct 5, 2012 14:24 Hi John. There is a recent backup now, but not from before the problem happened. As= I=20 have a little more than basic computer knowledge, what and how do I "dump t= he=20 SQL"? Thanks guys for trying to help. Much appreciated! Shannon -----Original Message----- From: john To: ooo-users Sent: Fri, Oct 5, 2012 2:18 pm Subject: Re: having major problem with a database, please help quickly! Stupid question here, ia there no recent backup of the database? Also, you can dump the SQL the way it is right now, then in an editor and a= n=20 empty column in the location where the column that got deleted, and just se= t the=20 field to null. Back to the database and drop the table, then import your modified SQL file Sent from my Verizon Wireless 4G LTE Smartphone ----- Reply message ----- From: "Dan Lewis" To: Cc: "Wellington Equine Associates (Shannon)" Subject: having major problem with a database, please help quickly! Date: Fri, Oct 5, 2012 13:44 On 10/05/2012 01:08 PM, Wellington Equine Associates (Shannon) wrote: > I think I maybe have a big "fubar" on my hands. And pardon my ignorance= =20 because I don't "speak" computerese. Yesterday I created a Table Mailing L= ist=20 database. All was well. Today I needed to add some more people to the lis= t. =20 That was fine. Was also able to sort it to keep it alphabetized by last na= me. =20 My problem started when I wanted to change the ID field to automatic. I th= ink=20 that it accepted the change, but didn't change when I opened the table agai= n. I=20 went back into edit to change it back and somehow I deleted the ID field, w= hich=20 to me was not that big of a deal, but it moved all of my information over a= =20 field i.e., my "first name" was now in the Title field and all of the Title= =20 information was gone. So, I went in and renamed the fields to what they we= re=20 now showing. When I went back to look at the table again, the information = had=20 shifted again and this time the first names were missing. Each change I ma= de in=20 the field titles resulted in more missing information. How do I get ALL of= my=20 info back??? I don't want to have to start all over and I did not have the= =20 backup copy option selected. I have in the meantime chosen it. Please hel= p=20 soon! Thank you! > Shannon Try this: With Writer open, use the F4 key to open the Data Source window. You should see a list of databases on the left side including Table= =20 Mailing List. If you see it, click the arrow to its left to reveal the queries and tables it contains. Click the arrow in front of Tables to r= eveal=20 the tables (there is probably only the one table). Click the table. The rig= ht=20 side of the Data Source window contains a table with the field names for th= e=20 column headings. In spite of what you wrote, all of the fields and their data is likely in this table. This is another possibility: What you did was to change the settings i= n=20 Mail Merge. If this is the case and you still have the table with the data, you probably should Begin mail merge from the beginning sele= cting=20 the fields needed and placing them where you need them. --Dan --------------------------------------------------------------------- To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org For additional commands, e-mail: ooo-users-help@incubator.apache.org =20 =20 =20 ----------MB_8CF71495DB8F3D1_1B94_E0AD_webmail-m144.sysops.aol.com--