FUDforum: FUDforum Suggestions » virtual hosts support

Home » FUDforum » FUDforum Suggestions » virtual hosts support

Show: Today's Messages :: Polls :: Message Navigator

Re: virtual hosts support [message #28066 is a reply to message #26585]

Mon, 10 October 2005 04:47

ruzam

Messages: 44
Registered: July 2005

Karma:

Member

Yeh! Finally found more time to look at this.

Ok, so I have a modified GLOBALS.php that includes a new var $SITES_DIR. I have a modified core.inc that checks for the new global, and includes a GLOBALS over-ride file from the $SITES_DIR using some magic on the $_SERVER['HTTP_HOST'] to determine a domain name. This is good. I have one domain setup this way and FUD appears to be working OK.

So now I'm trying to re-create the FUD tables in a new database for a second domain. In sql/ I've created the 'create_virtual_site.php' script attached. Things are still a bit hard coded for the moment, but basically, given a site name (domain) and a password (SQL database password), it:
(a) sets DBHOST_USER, DBHOST_PASSWORD and DBHOST_DBNAME according to the site name and password (this DB, User and pass were previousely setup in MYSQL)
(b) Generates a new GLOBALS file in the $SITES_DIR for the domain using a reference template
(c) Finally, connects to the database and runs through every .tbl and .sql file in the sql/ directory to create and default the tables.

So far so good, with a few caveats:
- Running the .tbl and .sql files using PHP seems to get tripped up on the query end ';'. Is this a PHP thing or did I just code this wrong? I ended up coding it ot split the queries, strip the ending ';' and feed the queries on at a time.
- UNIX_TIMESTAMP (in def_forum.sql) needs to be specified as 'UNIX_TIMESTAMP()'. Again, is this a PHP thing or is this file incorrect?

So I've got all the tables created and defaulted. But when I attempt to run this forum it duffs with a 'Fatal error: SQL Error has occurred'. The same config file for the new domain can be made to work with an existing FUD database, so I'm pretty sure the initial config setup is correct. The new domain DB is setup exactly the same as the working DB setup, except that this DB was created and loaded from my script, and not from the standard FUD init script.

I don't know what the SQL error is. The sql_errors log file contains dated entries of the failure, but the error message is just garbage. In fact it's the exact same garbage for every line . Looking at my error file for the working forum domain, they are garbage as well. Very frustrating...

How do I find the real error messages?
Why are the error files reporting garbage?
Are the .tbl and .sql files in the sql directory correct or have they been lapsing in the development?
What must be done to correctly build the required tables from scratch for a working forum?

Attachment: create_virtual_site.php
(Size: 3.30KB, Downloaded 1084 times)

Report message to a moderator

[Message index]

		virtual hosts support By: venus on Sat, 24 August 2002 12:10
		Re: virtual hosts support By: Ilia on Sat, 24 August 2002 16:07
		Re: virtual hosts support By: venus on Sat, 24 August 2002 18:03
		Re: virtual hosts support By: Ilia on Sat, 24 August 2002 18:42
		Re: virtual hosts support By: venus on Sun, 25 August 2002 11:00
		Re: virtual hosts support By: Ilia on Sun, 25 August 2002 16:01
		Re: virtual hosts support By: ruzam on Thu, 21 July 2005 22:51
		Re: virtual hosts support By: Ilia on Thu, 21 July 2005 22:58
		Re: virtual hosts support By: ruzam on Fri, 22 July 2005 01:25
		Re: virtual hosts support By: Ilia on Fri, 22 July 2005 02:00
		Re: virtual hosts support By: ruzam on Tue, 26 July 2005 20:06
		Re: virtual hosts support By: Ilia on Tue, 26 July 2005 20:16
		Re: virtual hosts support By: ruzam on Tue, 26 July 2005 20:41
		Re: virtual hosts support By: ruzam on Tue, 26 July 2005 21:14
		Re: virtual hosts support By: Ilia on Tue, 26 July 2005 21:44
		Re: virtual hosts support By: ruzam on Tue, 26 July 2005 22:10
		Re: virtual hosts support By: Ilia on Tue, 26 July 2005 22:18
		Re: virtual hosts support By: Ilia on Tue, 26 July 2005 22:35
		Re: virtual hosts support By: Anonymous on Wed, 27 July 2005 21:45
		Re: virtual hosts support By: ruzam on Wed, 27 July 2005 21:49
		Re: virtual hosts support By: Ilia on Wed, 27 July 2005 22:46
		Re: virtual hosts support By: ruzam on Mon, 10 October 2005 04:47
		Re: virtual hosts support By: Ilia on Mon, 10 October 2005 15:04
		Re: virtual hosts support By: ruzam on Mon, 10 October 2005 16:00
		Re: virtual hosts support By: ruzam on Mon, 10 October 2005 16:51
		Re: virtual hosts support By: Ilia on Tue, 11 October 2005 14:44
		Re: virtual hosts support By: ruzam on Tue, 11 October 2005 16:17
		Re: virtual hosts support By: ruzam on Tue, 11 October 2005 20:45
		Re: virtual hosts support By: Ilia on Tue, 11 October 2005 23:09
		Re: virtual hosts support By: Ilia on Tue, 11 October 2005 23:38
		Re: virtual hosts support By: ruzam on Wed, 12 October 2005 00:34
		Re: virtual hosts support By: Ilia on Wed, 12 October 2005 00:46
		Re: virtual hosts support By: ruzam on Wed, 12 October 2005 01:22
		Re: virtual hosts support By: ruzam on Wed, 12 October 2005 01:51
		Re: virtual hosts support By: ruzam on Wed, 12 October 2005 03:38
		Re: virtual hosts support By: Ilia on Wed, 12 October 2005 13:25
		Re: virtual hosts support By: ruzam on Wed, 12 October 2005 18:34
		Re: virtual hosts support By: Ilia on Wed, 12 October 2005 20:26
		Re: virtual hosts support By: ruzam on Wed, 12 October 2005 20:34
		Re: virtual hosts support By: Ilia on Wed, 12 October 2005 21:08
		Re: virtual hosts support By: ruzam on Thu, 13 October 2005 06:13
		Re: virtual hosts support By: Ilia on Thu, 13 October 2005 15:47
		Re: virtual hosts support By: ruzam on Tue, 11 October 2005 17:05
		Re: virtual hosts support By: Anonymous on Fri, 14 October 2005 07:15
		Re: virtual hosts support By: Ilia on Fri, 14 October 2005 13:57
		Re: virtual hosts support By: ruzam on Fri, 14 October 2005 16:10
		Re: virtual hosts support By: ruzam on Sat, 15 October 2005 04:06
		Re: virtual hosts support By: Ilia on Sat, 15 October 2005 17:34
		Re: virtual hosts support By: Ilia on Sat, 15 October 2005 18:39
		Re: virtual hosts support By: ruzam on Sun, 16 October 2005 15:56
		Re: virtual hosts support By: ruzam on Sun, 16 October 2005 16:23
		Re: virtual hosts support By: ruzam on Sun, 16 October 2005 16:29
		Re: virtual hosts support By: Ilia on Mon, 17 October 2005 14:39
		Re: virtual hosts support By: Ilia on Mon, 17 October 2005 14:43
		Re: virtual hosts support By: ruzam on Mon, 17 October 2005 17:02
		Re: virtual hosts support By: Ilia on Mon, 17 October 2005 20:03
		Re: virtual hosts support By: ruzam on Mon, 17 October 2005 23:18

Previous Topic:	dont show catagories if they are invisible
Next Topic:	default forum

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 21:54:40 GMT 2024

Total time taken to generate the page: 0.04599 seconds