RE: [pmm-cms-developers] Re: Break status

[Bill H. <bi...@nc...>]

> > > I have been looking at the code and attempting to 
> > > get it to work on my machine and there are a number of programming

> > > issues (not including the mysql database) that would render it
useless on any 
> > > machine other than NCNPR's - this has mainly to do with 
> > > include path names and directories.

Recommendation: the config.php file in th 'newsdb' directory has a few
define functions and such set up that I was never able to fully
implement.

There is an install directory variable set at line 3 of that file:

	$install_directory = '/pmm-cms/NewsCMS';

Then at line 23 the global constants that use that variable are set:

	define('INSTALL_DIR',
$_SERVER['DOCUMENT_ROOT'].$install_directory);
	define('WEB_DIR',
'http://'.$_SERVER['HTTP_HOST'].$install_directory);
	define('PI_STATION_ID', $pi_station_identification);

You might want to do a global search and replace for the path you're
trying to replace. Replace it with the globally defined path from that
config file. Usage of the constants would be similar to the way it's
done in the functions.php file in that same directory at line 47:

	include INSTALL_DIR."/newsdb/dbvars.php";

I thought I had converted all of those server-specific directories, but
perhaps not.

I have no good answer for the database question, except that we never
expected it to be this big, so the DB is not very relational in nature.
I think I only used one linking table, and the rest is totally
un-normalized. Sorry! That's why you guys get the big bucks, right?

Hope that helps.

Later,
Bill