incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maurice Howe" <maur...@stny.rr.com>
Subject RE: having major problem with a database, please help quickly!
Date Fri, 05 Oct 2012 21:39:25 GMT
You OOo/AOo guys & gals are really something.  A novice user like Shannon
reports that she's in catastrophe mode, and help jumps in from all
directions!  So I guess your geek-speak can be forgiven.

Glad to hear that you suggested TeamViewer, although it might not help this
time.  For the free "for private use" version, go to:
http://www.teamviewer.com/en/index.aspx 

Maurice D. Howe
General MacArthur Honor Guard Assn
616 Lacey Drive
Endwell, NY 13760
607-754-0469
Maurice@stny.rr.com
 


-----Original Message-----
From: john@terabyte-hosting.com [mailto:john@terabyte-hosting.com] 
Sent: Friday, October 05, 2012 5:01 PM
To: ooo-users@incubator.apache.org
Subject: Re: having major problem with a database, please help quickly!

Dan,
Sorry to report that I may have given you false hope here. The machine that
has OpenOffice on it, I mucked up the power port, in usual circumstances I
would just install it here on another machine. My issue there is my internet
is on portable WiFi, and I am redlining my allotted monthly usage. 

I will start working on this other machine here directly. And see if I can
get you an answer.



Sent from my Verizon Wireless 4G LTE Smartphone

----- Reply message -----
From: "Wellington Equine Associates (Shannon)" <shannonwequine@aol.com>
To: <ooo-users@incubator.apache.org>
Subject: having major problem with a database,  please help quickly!
Date: Fri, Oct 5, 2012 16:23
I'll try to answer as best I can.  I was in OpenOffice.org Base.  I
highlighted my mailing list and then selected edit from the drop down, which
took me into the table design and I made the changes from there.




So, here is where I become really computer illiterate, how do I find out the
application from incubator?  And how do I share the current SQL?  I'll
attach a copy of the file if that is helpful.  My head is getting completely
done in at this point.





John, thank you so much for your patience and willingness to help!






-----Original Message-----

From: john <john@terabyte-hosting.com>

To: ooo-users <ooo-users@incubator.apache.org>

Sent: Fri, Oct 5, 2012 4:09 pm

Subject: Re: having major problem with a database,  please help quickly!












Yes I suppose it does thank you. Ok now for the other part of the question;
what application are you running from incubator.

And when the database file was edited what did you use to edit it, I.e.
deleting the item_I'd on the table, Also can you dropbox or google share the
current SQL file. The current sql file in conjunction with looking at the
original script, I believe I can fix this.

Sent from my Verizon Wireless 4G LTE Smartphone

----- Reply message -----
From: "Wellington Equine Associates (Shannon)" <shannonwequine@aol.com>
To: <ooo-users@incubator.apache.org>
Subject: having major problem with a database,  please help quickly!
Date: Fri, Oct 5, 2012 15:47


Hi John.


I hope this helps.  

OS Name Microsoft Windows XP Professional Version 5.1.2600 Service Pack 3
Build 2600 OS Manufacturer Microsoft Corporation System Name DELL1 System
Manufacturer BIOSTAR Group System Model GF8100 M2+ TE System Type X86-based
PC Processor x86 Family 15 Model 127 Stepping 2 AuthenticAMD ~2700 Mhz BIOS
Version/Date American Megatrends Inc. 080015, 2/23/2009 SMBIOS Version 2.5
Windows Directory C:\WINDOWS System Directory C:\WINDOWS\system32 Boot
Device \Device\HarddiskVolume1 Locale United States Hardware Abstraction
Layer Version = "5.1.2600.5512 (xpsp.080413-2111)"
User Name DELL1\Admin
Time Zone Eastern Daylight Time
Total Physical Memory 2,048.00 MB
Available Physical Memory 920.45 MB
Total Virtual Memory 2.00 GB
Available Virtual Memory 1.96 GB
Page File Space 3.60 GB
Page File C:\pagefile.sys





-----Original Message-----
From: john <john@terabyte-hosting.com>
To: ooo-users <ooo-users@incubator.apache.org>
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
database 

platform that you are running on, mssql, mysql, or which. That's what I was
saying, is that I need to know the setup.



Sent from my Verizon Wireless 4G LTE Smartphone

----- Reply message -----
From: "Wellington Equine Associates (Shannon)" <shannonwequine@aol.com>
To: <ooo-users@incubator.apache.org>
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
just an 

old Windows XP.  We are a very small office, which is why I don't think
there is 

one.




-----Original Message-----
From: john <john@terabyte-hosting.com>
To: ooo-users <ooo-users@incubator.apache.org>
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 
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
its 
linux 

Sent from my Verizon Wireless 4G LTE Smartphone

----- Reply message -----
From: "Wellington Equine Associates (Shannon)" <shannonwequine@aol.com>
To: <ooo-users@incubator.apache.org>
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 
have a little more than basic computer knowledge, what and how do I "dump
the 
SQL"?


Thanks guys for trying to help.  Much appreciated!
Shannon




-----Original Message-----
From: john <john@terabyte-hosting.com>
To: ooo-users <ooo-users@incubator.apache.org>
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 an

empty column in the location where the column that got deleted, and just set
the 



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" <elderdanlewis@gmail.com>
To: <ooo-users@incubator.apache.org>
Cc: "Wellington Equine Associates (Shannon)" <shannonwequine@aol.com>
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 
because I don't "speak" computerese.  Yesterday I created a Table Mailing
List 
database.  All was well.  Today I needed to add some more people to the
list.  
That was fine.  Was also able to sort it to keep it alphabetized by last
name.  
My problem started when I wanted to change the ID field to automatic.  I
think 
that it accepted the change, but didn't change when I opened the table
again.  I 



went back into edit to change it back and somehow I deleted the ID field,
which 
to me was not that big of a deal, but it moved all of my information over a 
field i.e., my "first name" was now in the Title field and all of the Title 
information was gone.  So, I went in and renamed the fields to what they
were 
now showing.  When I went back to look at the table again, the information
had 
shifted again and this time the first names were missing.  Each change I
made in 



the field titles resulted in more missing information.  How do I get ALL of
my 
info back???  I don't want to have to start all over and I did not have the 
backup copy option selected.  I have in the meantime chosen it.  Please help

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 
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
reveal 



the tables (there is probably only the one table). Click the table. The
right 
side of the Data Source window contains a table with the field names for the

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 in 
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
selecting 



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
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2677 / Virus Database: 2591/5810 - Release Date: 10/04/12


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message