-
I wanted to thank you for the effort. I did get these commands to work, but I have some text field problems which still makes this a problem (I used double quotes both in the title and in a plot and comments section). I worked on it for awhile but I am sadly frustrated because I would still have to piece the data together.
mysql -uroot -p<password> <database name> -B -e...
2009-10-01 16:00:47 UTC in Open Media Collectors Database
-
I wish I were good at MySql, but no such luck.
I can dump the raw data in CSV using phpMyAdmin but it would be a lot of work to go from there as you said.
I am looking at using an XSLT filter on the XML output and have Open Office import it into Calc which would get me to a CSV eventually. The problem is the XML output is complex and it might also be beyond my reach.
I would really...
2009-09-30 14:57:42 UTC in Open Media Collectors Database
-
Has anyone figured out how to convert their databases to csv? The XML output carries all the information, but the csv really doesn't dump much at all. I can not figure out how to convert the 3000+ entries from the xml to csv without being charged a lot of money on a software product. Most of the programs I am looking at require csv for import.
Thanks.
2009-09-29 18:16:08 UTC in Open Media Collectors Database
-
I had to recompile PHP 5.3 with mysqli for another program and Opendb could no longer open the database. I am looking for another program, but I need to have this one working for awhile longer, so I checked around. Opendb has a template to check for mysqli support but the functions file:
opendb/functions/database/mysqli.inc.php
makes calls to functions that do not exist. To make Opendb...
2009-09-29 01:19:30 UTC in Open Media Collectors Database
-
Actually it was the actual gedcom text file that produced the error.
I don't backup using zip files.
2009-09-15 14:09:40 UTC in PhpGedView
-
Thanks for all the tips. I really was getting a blank page (as in the page source was blank without any errors).
It turned out my major problem was that PDO was not enabled for MySQL in PHP 5.3. I didn't see any changes in the requirements on the INSTALL doc, and I was sloppy because I thought a ".1" change difference was only going to be a bug fix. I read the release notes and I...
2009-09-13 14:25:31 UTC in PhpGedView
-
I had upgraded to php 5.3 which caused 4.2.1 to spew error messages, so I tried to upgrade to 4.2.2. After I upgraded (all the permissions are correct) all I get is an empty page without any errors in my apache log. I was hoping someone can give me hints on where to look next.
linux box: apache 2.2.13, php 5.3, mysql 5.0.83
index and media directories are in non-standard locations but are...
2009-09-12 02:58:17 UTC in PhpGedView
-
Okay I will wait for an update, but my problem with error #1 is that in my php.ini session.gc_maxlifetime is set to 1440. Is there a way I can tell where the program is getting this value?
Thank you.
2009-07-01 14:27:02 UTC in phpMyAdmin
-
I had previously installed phpMyAdmin 3.1.5 which worked fine, and still works correctly.
I tried installing phpMyAdmin 3.2.0.1, but I get some strange errors and functionality problems.
Is there something I need to configure. Thank you.
Environment:
MySql Server: Localhost via UNIX socket; Server version: 5.0.83
Apache/Php: Http 2.2.11; Php 5.3
First Error Message: [the...
2009-06-30 16:01:08 UTC in phpMyAdmin
-
I had a problem with compiling 0.47 which I was able to fix, but I wanted to tell others in case someone else had the problem. I am not a coder, so I don't know if there is a better fix.
I have an older SUSE 10.1 system which had netpbm installed. At this point, the netpbm was too old and I installed a newer version in a different directory. I could not remove the old version because the...
2009-04-08 11:26:15 UTC in Optical Character Recognition (GOCR)
