phpodpworld-users Mailing List for phpODPWorld
Status: Beta
Brought to you by:
hansfn
You can subscribe to this list here.
2006 |
Jan
|
Feb
|
Mar
|
Apr
(14) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2007 |
Jan
|
Feb
|
Mar
(5) |
Apr
(2) |
May
|
Jun
(1) |
Jul
(14) |
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
|
2008 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(4) |
Dec
|
2009 |
Jan
(1) |
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2010 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(5) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2011 |
Jan
|
Feb
(1) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2012 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Hans F. N. <Han...@hi...> - 2011-03-01 10:02:59
|
* faidon passias <fai...@gm...> [2011-02-28]: > Hi there, i get two errors i can see of > > 1) [error] [client 127.0.0.1] PHP Notice: Undefined variable: sort_order in /var/www/Dmoz/index.php on line 178 This is a notice, not an error. And it has been fixed long time ago in SVN. I just haven't had time to make a new release. (Feeling guily about that.) > 2)i get << > Unexpected error > Couldn't set locale (to en_US). > >> when i try opening index.php. Any ideas? The locale isn't enabled/available on your server. You can list available locales with the command "locale -a". Hans |
From: faidon p. <fai...@gm...> - 2011-02-28 10:44:21
|
Hi there, i get two errors i can see of 1) [error] [client 127.0.0.1] PHP Notice: Undefined variable: sort_order in /var/www/Dmoz/index.php on line 178 from apache error logs.. [ line 178 is << if (!is_utf8($sort_order)) >> ] shouldn't sort order be set on the config.inc.php? I am will include it anyway, <?php $config = array(); $config["categories"] = array( "Category1", "Category2", ); $config["sitetitle"] = ""; $config["sitepath"] = "/Dmoz/"; $config["meta_description"] = ""; $config["about"] = 'Run by <a href="http://phpodpworld.sourceforge.net/ ">phpODPWorld</a>.'; $config["webmaster"] = ''; $config["maintenance"] = false; $config["reset_key"] = "xyz"; $config["show_xml"] = true; $config["show_type"] = true; $config["mediadate"] = "list"; $config["locale_name"] = "en_US"; $config["sort_order"] = "aábcçčdđeéèfghijklmnñŋoóòôpqrsštŧuüvwxyzžæäøöå"; $config["sort_ignore_start"] = ""; $config["use_rewrite"] = false; $config["use_smarty"] = false; $config["use_logging"] = false; $config["dbtype"] = "mysql"; // mysql, pgsql, ... .....couple of more database pass/name not necessary in my belief. 2)i get << Unexpected error *Couldn't set locale (to en_US). * >> when i try opening index.php. Any ideas? |
From: Hans F. N. <Han...@hi...> - 2010-06-23 07:57:50
|
* Howard Lee <hl...@gm...> [2010-06-20]: > Hi Hans, > > I appreciate the response. The RDF source files are quite large, so it > should save time by reducing the need to re-read them. I have a need to > extract multiple DMOZ categories, the script I posted was faster for me. I'm > sorry that it is slower in your case. After all, I'm not a full time > programmer, so it may not be up to standard. Oh, your Perl programming skills are probably as good (or better) than mine. Anyway, what made your code slower was that you dropped the usage of the DMOZ parser. (OK, I didn't test a lot but it seemed so.) The addition of support for extraction of multiple categories in one run is a nice feature that I'll probably add. Hans |
From: Howard L. <hl...@gm...> - 2010-06-20 15:34:44
|
Hi Hans, I appreciate the response. The RDF source files are quite large, so it should save time by reducing the need to re-read them. I have a need to extract multiple DMOZ categories, the script I posted was faster for me. I'm sorry that it is slower in your case. After all, I'm not a full time programmer, so it may not be up to standard. I'll take a look at the SVN repository, and see if I can contribute to it. Regards, Howard |
From: Hans F. N. <Han...@hi...> - 2010-06-14 11:33:02
|
Thx, Howard for contributing again. Some quick comments: 0) phpODPWorld is not dead ;-) I plan a new release this summer. 1) Your script is slower than using DMOZ-ParseRDF (which now is an integral part of phpODPWorld) so I'll probably not use it. 2) Extracting multiple categories in one RDF file could be useful, but not very. If many users request it, I'll add it. Personally I need (and prefer) seperate RDF files. 3) If you need to re-run the extraction, it's better to unzip the file once in stead of having the script doing the unzipping every single time it runs. This came out very negative, I guess. Sorry about, but I hope you don't mind that much (as long as phpODPWorld still serves your needs). Next time you want to contribute, please base it on the currect code in the SVN repository - see http://sourceforge.net/projects/phpodpworld/develop or directly at http://phpodpworld.svn.sourceforge.net/viewvc/phpodpworld/trunk/phpodpworld/tools/ Regards, Hans PS! phpODPWorld 3.0 is still not released ;-) * Howard Lee <hl...@gm...> [2010-06-13]: > It's been a long while since I wrote to the mailing list. > I have rewritten portion of tools/extract.pl, which has been attached. It is > based on the version 3.0 of phpODPWorld. The following features have been > added, hope someone may find it useful. > 1. The source RDF file can be in text or gzipped format > 2. Multiple categories can be entered for extraction in a single command > line > 3. The script does not require DMOZ-ParseRDF-0.14 to be installed > Regards, > Howard > > On Sat, Apr 4, 2009 at 6:46 AM, Hans F. Nordhaug <Han...@hi...> wrote: > > > I did reply immediately to Howard that I found this script very > > interesting. However, I didn't find time to test it before now ... > > Unfortunately, it doesn't work as intended: > > > > ./extract.pl structure.rdf.u8 World > > > > produces a file World-structure.rdf.u8 that contains more > > categories outside World than inside: > > > > # grep 'Topic r:id' World-structure.rdf.u8 | grep -v 'r:id="Top/World' | wc -l > > 405753 > > # grep 'Topic r:id' World-structure.rdf.u8 | grep 'r:id="Top/World' | wc -l > > 229470 > > > > This also causes it to run slower than the current solution. I don't > > have time to debug the script so unless Howard produces a bug fixed > > version nothing will change. (On my old computer extracting World take > > one minute and 15 seconds - more than quick enough for me.) > > > > Regards, > > Hans - who is working on a new release. > > > > PS! Please add "use warnings;" to the script ;-) |
From: Howard L. <hl...@gm...> - 2010-06-13 11:16:54
|
I'm not sure why the script was posted without the message. Anyway, here it is again. It's been a long while since I wrote to the mailing list. I have rewritten portion of tools/extract.pl, which has been attached. It is based on the version 3.0 of phpODPWorld. The following features have been added, hope someone may find it useful. 1. The source RDF file can be in text or gzipped format 2. Multiple categories can be entered for extraction in a single command line 3. The script does not require DMOZ-ParseRDF-0.14 to be installed Regards, Howard |
From: Howard L. <hl...@gm...> - 2010-06-13 11:08:26
|
#!/usr/bin/perl # # This file is part of phpODPWorld and released under GNU GPL. # # $Id: extract.pl,v 1.3 2006/03/24 21:49:59 hansfn Exp $ # use strict; use warnings; if ($#ARGV < 1) { print "Usage: extract.pl rdffile category [...]\n\n"; print "rdffile Specifies the RDF file for parsing\n"; print " (can be text format or compressed by gzip)\n"; print "category Specifies the category to extract\n"; print " (separate multiple categories with space)\n\n"; print "e.g. extract.pl structure.rdf.u8.gz World/Norsk Regional/Europe/Norway\n"; exit; } my $rdffile = $ARGV[0]; if (! -e $rdffile ) { die("RDF file ($rdffile) doesn't exist\n"); } # Determine type of RDF file (based on filename) - "structure" or "content" my $type; if ($rdffile =~ /structure/i) { $type = "structure"; } elsif ($rdffile =~ /content/i) { $type = "content"; } else { $type = "unknown"; } # Creating an array for the categories my $i = 0; my @categories = (); while ( $ARGV[$i+1] ) { push (@categories, "$ARGV[$i+1]"); $i++; } my $catsize = $i; my @catfh = (); my @catmatch = (); # Open files for each category for ($i = 0; $i < $catsize; $i++) { $catmatch[$i] = 0; my $safecategory = $categories[$i]; $safecategory =~ s#/#_#g; my $outfile = "$safecategory-$type.rdf.u8"; open ($catfh[$i], ">$outfile") or die "Can't open RDF file ($outfile) for writing: $!"; print {$catfh[$i]} '<?xml version="1.0" encoding="UTF-8" ?> <RDF xmlns:r="http://www.w3.org/TR/RDF/" xmlns:d="http://purl.org/dc/elements/1.0/" xmlns="http://dmoz.org/rdf"> '; } # The main parsing starts here my $line; my $catread; $rdffile =~ s/(.*\.gz)$/gzip -dc $1|/; open(RDFFILE, $rdffile) or die "Can't open RDF file ($rdffile) for reading: $!"; while(<RDFFILE>) { $line = $_; # Check for Topic lines and compare if ($line =~ m/<Topic r:id="/) { $catread = $line; $catread =~ s/^\s+<Topic r:id="(.*)">/$1/; # print "Current category: $catread\n"; for ($i = 0; $i < $catsize; $i++) { $catmatch[$i] = ($catread =~ m#^Top/$categories[$i]#) ? 1 : 0; } } # Write line to file if matched for ($i = 0; $i < $catsize; $i++) { print {$catfh[$i]} $line if ($catmatch[$i] == 1); } } close(RDFFILE); # Close files for each category for ($i = 0; $i < $catsize; $i++) { print {$catfh[$i]} '</RDF>'; close ($catfh[$i]); } exit; |
From: Hans F. N. <Han...@hi...> - 2009-04-03 23:17:10
|
* Howard Lee <hl...@gm...> [2009-01-18]: > Dear all, > > I find it quite time consuming when extracting multiple categories from > tools/extract.pl, because the full RDF files will need to be parsed from the > beginning. > > I have modified the extract.pl so that it can handle multiple categories > from the same command line. It also does not depend on DMOZ-ParseRDF-0.14 > now. The script has been attached, and hope somebody may find it useful. I did reply immediately to Howard that I found this script very interesting. However, I didn't find time to test it before now ... Unfortunately, it doesn't work as intended: ./extract.pl structure.rdf.u8 World produces a file World-structure.rdf.u8 that contains more categories outside World than inside: # grep 'Topic r:id' World-structure.rdf.u8 | grep -v 'r:id="Top/World' | wc -l 405753 # grep 'Topic r:id' World-structure.rdf.u8 | grep 'r:id="Top/World' | wc -l 229470 This also causes it to run slower than the current solution. I don't have time to debug the script so unless Howard produces a bug fixed version nothing will change. (On my old computer extracting World take one minute and 15 seconds - more than quick enough for me.) Regards, Hans - who is working on a new release. PS! Please add "use warnings;" to the script ;-) |
From: Howard L. <hl...@gm...> - 2009-01-18 13:16:25
|
#!/usr/bin/perl # # This file is part of phpODPWorld and released under GNU GPL. # # $Id: extract.pl,v 1.3 2006/03/24 21:49:59 hansfn Exp $ # use strict; if ($#ARGV < 1){ print "Usage: extract.pl rdffile category...\n"; print "(The RDF file should already be uncompressed\n"; print "and the category name must NOT end with a slash.)\n"; exit; } my $rdffile = $ARGV[0]; if (! -e $rdffile ) { die("RDF file ($rdffile) doesn't exist\n"); } # Determine type of RDF file (based on filename) - "structure" or "content" my $type; if ($rdffile =~ /structure/i) { $type = "structure"; } elsif ($rdffile =~ /content/i) { $type = "content"; } else { $type = "unknown"; } # Creating an array for the categories and sort it my @array = (); my $category; my $ptr = 1; while ( $ARGV[$ptr] ) { $category = "Top/$ARGV[$ptr]"; push (@array, $category); $ptr++; } @array = sort { $a cmp $b }(@array); # The main parsing starts here my $line; my $tmpcat; my $cat = shift(@array); my $match = 0; my $key_cat; open(RDFFILE, $rdffile) or die "Can't open RDF file ($rdffile) for reading: $!"; while(<RDFFILE>) { $line = $_; if ($line =~ m/<Topic r:id="/) { $tmpcat = $line; chomp $tmpcat; $tmpcat =~ s/<Topic r:id="(.*)">/$1/; #print "$tmpcat, $cat\n"; while (substr($tmpcat, 0, (length($cat)-1)) gt $cat) { #print "Switching ($tmpcat) ($cat)\n"; $match = 0; $cat = shift(@array); } if ($tmpcat =~ m/$cat/) { if ($match == 0) { print "Parsing category: $cat\n"; $match = 1; print OUTFILE '</RDF>'; close(OUTFILE); # Removing slashes from category since it will be used in the filename $key_cat = $cat; $key_cat =~ s#Top/##; $key_cat =~ s#/#_#g; my $outfile = "$key_cat-$type.rdf.u8"; open(OUTFILE, ">$outfile") or die "Can't open extracted RDF file ($outfile) for writing: $!"; print OUTFILE '<?xml version="1.0" encoding="UTF-8" ?> <RDF xmlns:r="http://www.w3.org/TR/RDF/" xmlns:d="http://purl.org/dc/elements/1.0/" xmlns="http://dmoz.org/rdf"> '; } $match = 1; } } if ($match == 1) { # Write line to file print OUTFILE $line; } else { # Skip this line } } close(RDFFILE); print OUTFILE '</RDF>'; close(OUTFILE); exit; |
From: Hans F. N. <Han...@hi...> - 2008-11-11 21:14:17
|
* Javad Babaee <m2b...@ya...> [2008-11-11]: > Hello > Many thanks for your reply to my question > I looked through the codes again and got a better understanding of phpodpworld Don't do it - the code is ugly and might hurt your eyes ;-) > i looked out the worked example tools/update-rdf.sh and think that > should be modified like the attached file: (as categorized content > is not available anymore) Nope. The "categorized content" might reappear - just set "complete_rdf" to true (which is the default I guess). I plan to distribute the "categorized content" at http://phpodpworld.sourceforge.net/ since the old site is gone. Maybe this weekend. (Remind me if nothing happens.) > another question is about the Perl module DMOZ-ParseRDF-0.14. > should i only upload the files to the same dirctory as dmoz files > are in and no modification is needed? No modifications needed, but the files should really be install in the same dirctory as dmoz files. > by the way, doesn't an unbalance " exist in ParseRDF.pm on line 149? Nope. > about installing this module, readme file only says: > INSTALLATION > > perl Makefile.PL > make > make test > make install > > and I didn't understand what they mean. It means that you have shell access to the server and can run these lines from the shell (to install the files). However, they require that you are root. Maybe read <http://www.cs.ucsc.edu/~you/notes/perl-module-install.html> I think in the case of this module, you don't have to run make and so. Just extract the files, and move ParseRDF.pm to $PERL5LIB/DMOZ/ParseRDF.pm The next version will probably just include ParseRDF.pm verbatim since the module isn't maintained any more - will make the install a lot easier... > finally, what is my reset_key and how should i get it? The docs clearly state: Open "http://yourserver/?reset=key" (where the key is set in "config.inc.php"). It's just a key so you can protect the reset mecanism. (You can reset the database (count) using the browser - without running SQL queries.) > Thank you in advance for your assistance Your welcome. Hans |
From: Hans F. N. <Han...@hi...> - 2008-11-07 02:03:08
|
* Javad Babaee <m2b...@ya...> [2008-11-04]: > Hi > I was trying to install phpODPworld and faced a few problems. any > help would be extremely appreciated First I must apologize for the sorry state of phpODPworld (when it comes to ease of installation) - I have just been busy with other projects (and paid work) the last two years. In addition phpODPworld has done the job for my sites. > in step 5, downloading content+structure is 300+70MB. of very large size. > also subpart of the RDFs from rodan.ncc.com (http://rodan.ncc.com/rdf/cats/) sends a 404 not found error > so what is the solution? is there a way to download the files directly to our webserver? > is there any other link we can choose some of the RDFs? It seems that the smaller RDFs for parts of DMOZ no longer are available at http://rodan.ncc.com/ (or some where else) - I'll update the documentation. You just have to grab the full complete ones. > in step 6, it is stated that we need the Perl module > DMOZ-ParseRDF-0.14 installed. i downloaded it but there is no > instruction for installation. where can i get help? the author > website is off too Doesn't http://backpan.perl.org/authors/id/P/PA/PAUL/DMOZ-ParseRDF-0.14.readme work? (This is after you have unpacked the tar.gz file) Hans |
From: Javad B. <m2b...@ya...> - 2008-11-04 06:01:41
|
Hi I was trying to install phpODPworld and faced a few problems. any help would be extremely appreciated in step 5, downloading content+structure is 300+70MB. of very large size. also subpart of the RDFs from rodan.ncc.com (http://rodan.ncc.com/rdf/cats/) sends a 404 not found error so what is the solution? is there a way to download the files directly to our webserver? is there any other link we can choose some of the RDFs? in step 6, it is stated that we need the Perl module DMOZ-ParseRDF-0.14 installed. i downloaded it but there is no instruction for installation. where can i get help? the author website is off too thank you in advance for your assistance |
From: Hans F. N. <Han...@hi...> - 2007-08-29 09:17:47
|
* Lonh Samdy <sam...@gm...> [2007-08-29]: > I used phpodpworld-3.0 pre1 to make web directory from ODP. > > Af first i use localhost(127.0.0.1) to connect to MySQL database. It works > pretty well. > > After that, i change connection to other ip address like (192.168.2.100). > then error occures. it diplays only the first page when click on the link it > did not display the page but it diplay the directory structure of > phpodpworld. You have tested using the command line MySQL clieant that you can actually connect to that other host? Hans |
From: Lonh S. <sam...@gm...> - 2007-08-29 07:49:52
|
I used phpodpworld-3.0 pre1 to make web directory from ODP. Af first i use localhost(127.0.0.1) to connect to MySQL database. It works pretty well. After that, i change connection to other ip address like (192.168.2.100). then error occures. it diplays only the first page when click on the link it did not display the page but it diplay the directory structure of phpodpworld. /Samdy |
From: Lonh S. <sam...@gm...> - 2007-07-31 10:26:55
|
Thanks alot. it works pretty well now. Samdy On 7/31/07, Hans F. Nordhaug <Han...@hi...> wrote: > > * Lonh Samdy <sam...@gm...> [2007-07-31]: > > Hi developer, > > > > i have some problem regarding using your phpodpworld3.0 software which i > use > > to create web directory base on ODP DMOZ Project. > > i do as you instruct on the website but after i complete i could open > only > > the first page. when i try click on the link on each sub category it > respose > > error page like the following: > > > > The requested URL /phpodpworld/Kids_and_Teens/Entertainment was not > found on > > this server. > > > > and i check my directory but i could not see any folders like > > Kids_and_Teens. > > > > What is the problems? can you help me solve it. > > In config.inc.php you have enabled rewrite, but you haven't added a > .htaccess file. From the config file: > > // Use (Apache) rewrite rules to get prettier URLs to categories - must be > // accompanied by a suitable .htaccess-file. (true/false) > $config["use_rewrite"] = false; > > You have set this one to "true". Set it back to "false" or do as you > are told - there are two example .htaccess files. > > Hans > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > phpodpworld-users mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpodpworld-users > |
From: Hans F. N. <Han...@hi...> - 2007-07-31 07:35:27
|
* Lonh Samdy <sam...@gm...> [2007-07-31]: > Hi developer, > > i have some problem regarding using your phpodpworld3.0 software which i use > to create web directory base on ODP DMOZ Project. > i do as you instruct on the website but after i complete i could open only > the first page. when i try click on the link on each sub category it respose > error page like the following: > > The requested URL /phpodpworld/Kids_and_Teens/Entertainment was not found on > this server. > > and i check my directory but i could not see any folders like > Kids_and_Teens. > > What is the problems? can you help me solve it. In config.inc.php you have enabled rewrite, but you haven't added a .htaccess file. From the config file: // Use (Apache) rewrite rules to get prettier URLs to categories - must be // accompanied by a suitable .htaccess-file. (true/false) $config["use_rewrite"] = false; You have set this one to "true". Set it back to "false" or do as you are told - there are two example .htaccess files. Hans |
From: Lonh S. <sam...@gm...> - 2007-07-31 06:05:26
|
Hi developer, i have some problem regarding using your phpodpworld3.0 software which i use to create web directory base on ODP DMOZ Project. i do as you instruct on the website but after i complete i could open only the first page. when i try click on the link on each sub category it respose error page like the following: The requested URL /phpodpworld/Kids_and_Teens/Entertainment was not found on this server. and i check my directory but i could not see any folders like Kids_and_Teens. What is the problems? can you help me solve it. Thanks. |
From: Hans F. N. <Han...@hi...> - 2007-07-09 11:52:25
|
* Nicholas Johnston <joh...@ne...> [2007-07-09]: > Oops, I hit a shortcut key... > > Thank you both for your diagnosis. > > Briefly using display_errors, it became apparent that I was missing > something. This was infact Pear DB, thanks to my lack of familiarity with > PHP. OK, glad you found the problem. (It is listed in the dependencies section - http://phpodpworld.sourceforge.net/#depend - but that might not make much sense to everyone.) > I am now on to hopefully my last issue - when viewing the index page, I am > greeted with: > > The category "" was not found. The closest matches are: > > In this case I'm trying to display all categories, in a similar way to DMOZ > does. Currently in the config.inc.php categories array, I've just got > "Top", but testing this and replacing this with "Business" for example, > creates the same effect. > > The category "Business" was not found. The closest matches are: > > Any help again would be greatly appriciated. Did you try "Top/Business"? (Just "Business" doesn't exist.) I'm guessing that the import of the RDF into your db failed or is incomplete. (What version are you using by the way - 3.0 pre1 or the latest from SVN?) You should check the db using a mysql client. (If that doesn't make any sense you could try to import a sub-sub-category and in the db perl scripts change my $single_insert = 1; to my $single_insert = 0; This will be slower, not loading the data from (temp) files, but it should work without errors. If it works, you know that you did a mistake when you tried to fix the problems you had.) In general, never work with the complete RDF/all categories, until you have it working for a small sub-sub-category. Hans |
From: Nicholas J. <joh...@ne...> - 2007-07-09 11:26:29
|
Oops, I hit a shortcut key... Thank you both for your diagnosis. Briefly using display_errors, it became apparent that I was missing something. This was infact Pear DB, thanks to my lack of familiarity with PHP. I am now on to hopefully my last issue - when viewing the index page, I am greeted with: The category "" was not found. The closest matches are: In this case I'm trying to display all categories, in a similar way to DMOZ does. Currently in the config.inc.php categories array, I've just got "Top", but testing this and replacing this with "Business" for example, creates the same effect. The category "Business" was not found. The closest matches are: Any help again would be greatly appriciated. Kind regards, Nick Johnston -----Original Message----- From: php...@li... [mailto:php...@li...] On Behalf Of Nicholas Johnston Sent: 09 July 2007 12:20 To: php...@li... Subject: Re: [phpodpworld-users] Phpodpworld.pl temp file not found Thank you both for your diagnosis. Briefly using display_errors, it became apparent that I was missing something. This was infact Pear DB, thanks to my lack of familiarity with PHP. I am now on to hopefully my last issue - when viewing the index page, I am greeted with: -----Original Message----- From: php...@li... [mailto:php...@li...] On Behalf Of Hans F. Nordhaug Sent: 09 July 2007 11:43 To: php...@li... Subject: Re: [phpodpworld-users] Phpodpworld.pl temp file not found * Howard Lee <hl...@gm...> [2007-07-08]: > On 7/6/07, Nicholas Johnston <joh...@ne...> wrote: > > I now have an issue where, after counting the categories, the > > index.php page does not display anything - just a white page. The > > maintinence page displays fine. Any known or obvious issues there? > > Not that I know of. I can only think of the difference between the > maintainance page and the actual page is the database connection. Have > you checked that PHP can connect the MySQL successfully? (Sorry for the late reply - spent some time off-line.) That sounds like good advice, Howard. The MySQL extension for PHP must be enabled/installed - check your phpinfo. Nicholas, have you checked the webserver error logs (where PHP normally logs it's error messages)? You could also turn on logging ("use_logging") in the phpODPWorld config, but I guess this problem happens at the PHP system level (missing MySQL extension). Regards Hans ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ phpodpworld-users mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpodpworld-users ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ phpodpworld-users mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpodpworld-users |
From: Nicholas J. <joh...@ne...> - 2007-07-09 11:20:20
|
Thank you both for your diagnosis. Briefly using display_errors, it became apparent that I was missing something. This was infact Pear DB, thanks to my lack of familiarity with PHP. I am now on to hopefully my last issue - when viewing the index page, I am greeted with: -----Original Message----- From: php...@li... [mailto:php...@li...] On Behalf Of Hans F. Nordhaug Sent: 09 July 2007 11:43 To: php...@li... Subject: Re: [phpodpworld-users] Phpodpworld.pl temp file not found * Howard Lee <hl...@gm...> [2007-07-08]: > On 7/6/07, Nicholas Johnston <joh...@ne...> wrote: > > I now have an issue where, after counting the categories, the > > index.php page does not display anything - just a white page. The > > maintinence page displays fine. Any known or obvious issues there? > > Not that I know of. I can only think of the difference between the > maintainance page and the actual page is the database connection. Have > you checked that PHP can connect the MySQL successfully? (Sorry for the late reply - spent some time off-line.) That sounds like good advice, Howard. The MySQL extension for PHP must be enabled/installed - check your phpinfo. Nicholas, have you checked the webserver error logs (where PHP normally logs it's error messages)? You could also turn on logging ("use_logging") in the phpODPWorld config, but I guess this problem happens at the PHP system level (missing MySQL extension). Regards Hans ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ phpodpworld-users mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpodpworld-users |
From: Hans F. N. <Han...@hi...> - 2007-07-09 10:42:55
|
* Howard Lee <hl...@gm...> [2007-07-08]: > On 7/6/07, Nicholas Johnston <joh...@ne...> wrote: > > I now have an issue where, after counting the categories, the index.php page > > does not display anything - just a white page. The maintinence page > > displays fine. Any known or obvious issues there? > > Not that I know of. I can only think of the difference between the > maintainance page and the actual page is the database connection. Have > you checked that PHP can connect the MySQL successfully? (Sorry for the late reply - spent some time off-line.) That sounds like good advice, Howard. The MySQL extension for PHP must be enabled/installed - check your phpinfo. Nicholas, have you checked the webserver error logs (where PHP normally logs it's error messages)? You could also turn on logging ("use_logging") in the phpODPWorld config, but I guess this problem happens at the PHP system level (missing MySQL extension). Regards Hans |
From: Howard L. <hl...@gm...> - 2007-07-08 07:30:59
|
On 7/6/07, Nicholas Johnston <joh...@ne...> wrote: > I now have an issue where, after counting the categories, the index.php page > does not display anything - just a white page. The maintinence page > displays fine. Any known or obvious issues there? Not that I know of. I can only think of the difference between the maintainance page and the actual page is the database connection. Have you checked that PHP can connect the MySQL successfully? |
From: Nicholas J. <joh...@ne...> - 2007-07-05 19:34:29
|
Thanks Howard, I've added those lines and will attempt it again overnight. For the time being I imported the temp files into mysql directly. I now have an issue where, after counting the categories, the index.php page does not display anything - just a white page. The maintinence page displays fine. Any known or obvious issues there? Nick -----Original Message----- From: Howard Lee [mailto:hl...@gm...] Sent: 05 July 2007 06:52 To: Nicholas Johnston Cc: php...@li... Subject: Re: [phpodpworld-users] Phpodpworld.pl temp file not found On 7/4/07, Nicholas Johnston <joh...@ne...> wrote: > Hello all, > > Using phpodpworld.pl to import structure or content in the database, > all records are successfully loaded, but then followed by the error below: > > DBD::mysql::db do failed: File 'C:WINDOWSTEMP1NfxkiP8CnW' not found > (Errcode: 2) at C:\\mypath\phpodpworld.pl line 576. > > The temp file is created successfully in the correct directory, but > then cannot be found successfully. I can only think that the path > shown, C:WINDOWSTEMP1NfxkiP8CnW, is not successful because it doesn't > contain the slashes required... I use it on Linux and MySQL and this problem does not occur. Apparently MySQL requires double backslashes for paths in LOAD DATA statement on Windows. For testing purpose, I would suggest to change the below statements and see if it works or not. There might be a better way to do it though. From: $dbh->do("LOAD DATA LOCAL INFILE '$tempname' INTO TABLE xurls FIELDS OPTIONALLY ENCLOSED BY \"'\""); To: my $tempname_mysql = $tempname; $tempname_mysql =~ s/\\/\\\\/g; $dbh->do("LOAD DATA LOCAL INFILE '$tempname_mysql' INTO TABLE xurls FIELDS OPTIONALLY ENCLOSED BY \"'\""); From: $dbh->do("LOAD DATA LOCAL INFILE '$temp_res' INTO TABLE resources FIELDS OPTIONALLY ENCLOSED BY \"'\""); $dbh->do("LOAD DATA LOCAL INFILE '$temp_str' INTO TABLE structure FIELDS OPTIONALLY ENCLOSED BY \"'\""); To: my $temp_res_mysql = $temp_res; my $temp_str_mysql = $temp_str; $temp_res_mysql =~ s/\\/\\\\/g; $temp_str_mysql =~ s/\\/\\\\/g; $dbh->do("LOAD DATA LOCAL INFILE '$temp_res_mysql' INTO TABLE resources FIELDS OPTIONALLY ENCLOSED BY \"'\""); $dbh->do("LOAD DATA LOCAL INFILE '$temp_str_mysql' INTO TABLE structure FIELDS OPTIONALLY ENCLOSED BY \"'\""); Howard |
From: Howard L. <hl...@gm...> - 2007-07-05 05:52:17
|
On 7/4/07, Nicholas Johnston <joh...@ne...> wrote: > Hello all, > > Using phpodpworld.pl to import structure or content in the database, all > records are successfully loaded, but then followed by the error below: > > DBD::mysql::db do failed: File 'C:WINDOWSTEMP1NfxkiP8CnW' not found > (Errcode: 2) at C:\\mypath\phpodpworld.pl line 576. > > The temp file is created successfully in the correct directory, but then > cannot be found successfully. I can only think that the path shown, > C:WINDOWSTEMP1NfxkiP8CnW, is not successful because it doesn't contain the > slashes required... I use it on Linux and MySQL and this problem does not occur. Apparently MySQL requires double backslashes for paths in LOAD DATA statement on Windows. For testing purpose, I would suggest to change the below statements and see if it works or not. There might be a better way to do it though. From: $dbh->do("LOAD DATA LOCAL INFILE '$tempname' INTO TABLE xurls FIELDS OPTIONALLY ENCLOSED BY \"'\""); To: my $tempname_mysql = $tempname; $tempname_mysql =~ s/\\/\\\\/g; $dbh->do("LOAD DATA LOCAL INFILE '$tempname_mysql' INTO TABLE xurls FIELDS OPTIONALLY ENCLOSED BY \"'\""); From: $dbh->do("LOAD DATA LOCAL INFILE '$temp_res' INTO TABLE resources FIELDS OPTIONALLY ENCLOSED BY \"'\""); $dbh->do("LOAD DATA LOCAL INFILE '$temp_str' INTO TABLE structure FIELDS OPTIONALLY ENCLOSED BY \"'\""); To: my $temp_res_mysql = $temp_res; my $temp_str_mysql = $temp_str; $temp_res_mysql =~ s/\\/\\\\/g; $temp_str_mysql =~ s/\\/\\\\/g; $dbh->do("LOAD DATA LOCAL INFILE '$temp_res_mysql' INTO TABLE resources FIELDS OPTIONALLY ENCLOSED BY \"'\""); $dbh->do("LOAD DATA LOCAL INFILE '$temp_str_mysql' INTO TABLE structure FIELDS OPTIONALLY ENCLOSED BY \"'\""); Howard |
From: Nicholas J. <joh...@ne...> - 2007-07-04 15:30:22
|
Hello all, Using phpodpworld.pl to import structure or content in the database, all records are successfully loaded, but then followed by the error below: DBD::mysql::db do failed: File 'C:WINDOWSTEMP1NfxkiP8CnW' not found (Errcode: 2) at C:\\mypath\phpodpworld.pl line 576. The temp file is created successfully in the correct directory, but then cannot be found successfully. I can only think that the path shown, C:WINDOWSTEMP1NfxkiP8CnW, is not successful because it doesn't contain the slashes required... Any help would be greatly appreciated, Nick Johnston |