Gossamer Forum
Home : Products : DBMan : Discussions :

DBConcatenate

Quote Reply
DBConcatenate
Hi,



I have been using this script for awhile now, to gather record stats on my database. Recently my ISP changed our script paths, however, and since I have not been able to get it to work.

Below is the .cfg ...

#

# The column name for the database key. Can be any column, but it must be unique!

# You can't have two records with the same key value!

$db_key = 'ID';

# Database delimeter.

$db_delim = '|';

# Use file locking (1 = Yes, 0 = No). Should be used, but won't work on Win95.

$db_use_flock = 1;

# variables for databases

$db_script_path = "/x/x/x/x/x/x/x/x";

$db_path = "/x/x/x/x/x/x/x/x";

$combine_db = "/x/x/x/x/x/x/x/x/combine.db";

$URL_db = "/x/x/x/x/x/x/x/x/clicky2.log";

$counter_dir = "/x/x/x/x/x/x/x/x/temp2";

$form_db = "/x/x/x/x/x/x/x/x/formresults.bout";



# add your DBMan databases here using a push command for each

# push(@dbman_db ,$db_path . "/data2.db");push(@dbman_db ,$db_path . "/data3.db");

push(@dbman_db ,"/x/x/x/x/x/x/x/x/accommodation.db");


Now I guarantee that the paths are all correct, but when running the script via telnet, I get "No such file or directory at ./combineaccom.pl line 41.

Below is a snippet of the .pl script ....

require "combineaccom.cfg";

use Fcntl;

use File::Find;

# Build new record

open (COMBINE,">$combine_db") || die $!; <<------------- This is line 41

foreach $db (@dbman_db) {

Again, it is definately not the paths as I have checked them a million times.



Can anyone help?

Quote Reply
Re: [Palemo] DBConcatenate In reply to
Your ISP only changed your script paths? They didn't move to you to a new server or anything like that?

You say you're sure the paths are right, but how did you come across the path name. In telnet, navigate to the directory that combine.db is in, and type: pwd what path does it return? Is this the same that you have in your config file?
Quote Reply
Re: [Palemo] DBConcatenate In reply to
In my experience when I've had my files moved it messed up all my permissions also. Please recheck all your file permissions and see if that helps.

I've had to just re-upload all my files myself to get things working properly again.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/