phpodpworld-users — Discussions related to usage (and development) of phpODPWorld

Re: [phpodpworld-users] Installation of pre3.0

[Hans F. N. <Han...@hi...>]

* 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

[phpodpworld-users] Installation of pre3.0

[faidon p. <fai...@gm...>]

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?

Re: [phpodpworld-users] Suggestion on tools/extract.pl

[Hans F. N. <Han...@hi...>]

* 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

Re: [phpodpworld-users] Suggestion on tools/extract.pl

[Howard L. <hl...@gm...>]

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

Re: [phpodpworld-users] Suggestion on tools/extract.pl

[Hans F. N. <Han...@hi...>]

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 ;-)

Re: [phpodpworld-users] Suggestion on tools/extract.pl

[Howard L. <hl...@gm...>]

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

Re: [phpodpworld-users] Suggestion on tools/extract.pl

[Howard L. <hl...@gm...>]

#!/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;

Re: [phpodpworld-users] Suggestion on tools/extract.pl

[Hans F. N. <Han...@hi...>]

* 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 ;-)

[phpodpworld-users] Suggestion on tools/extract.pl

[Howard L. <hl...@gm...>]

#!/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;

Re: [phpodpworld-users] help with installation

[Hans F. N. <Han...@hi...>]

* 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

Re: [phpodpworld-users] help with installation

[Hans F. N. <Han...@hi...>]

* 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

[phpodpworld-users] help with installation

[Javad B. <m2b...@ya...>]

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



      

Re: [phpodpworld-users] Erro when i change host address

[Hans F. N. <Han...@hi...>]

* 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

[phpodpworld-users] Erro when i change host address

[Lonh S. <sam...@gm...>]

 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

Re: [phpodpworld-users] I can open only the first page

[Lonh S. <sam...@gm...>]

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
>

Re: [phpodpworld-users] I can open only the first page

[Hans F. N. <Han...@hi...>]

* 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 

[phpodpworld-users] I can open onlt the first page

[Lonh S. <sam...@gm...>]

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.

Re: [phpodpworld-users] Phpodpworld.pl temp file not found

[Hans F. N. <Han...@hi...>]

* 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

Re: [phpodpworld-users] Phpodpworld.pl temp file not found

[Nicholas J. <joh...@ne...>]

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

Re: [phpodpworld-users] Phpodpworld.pl temp file not found

[Nicholas J. <joh...@ne...>]

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

Re: [phpodpworld-users] Phpodpworld.pl temp file not found

[Hans F. N. <Han...@hi...>]

* 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

Re: [phpodpworld-users] Phpodpworld.pl temp file not found

[Howard L. <hl...@gm...>]

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?

Re: [phpodpworld-users] Phpodpworld.pl temp file not found

[Nicholas J. <joh...@ne...>]

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

Re: [phpodpworld-users] Phpodpworld.pl temp file not found

[Howard L. <hl...@gm...>]

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

[phpodpworld-users] Phpodpworld.pl temp file not found

[Nicholas J. <joh...@ne...>]

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