deRusett

This is using  Apache 2.0.5x,  php5.1.xx, anyone got a debian/ubuntu  Apache2.2/php5.2 install running? I get the Apache 2.2 like so $wget -c http://apache.sunsite.ualberta.ca/httpd/httpd-2.2.3.tar.gz sudo apt-get install build-essential $tar -xvf httpd-2.2.3.tar.gz $cd httpd-2.2.3 ./configure make sudo make install but I can't seem to get php5.2 to install with it,  I get errors when I try to configure and if I use apt-get install I notice that all of the apache related stuff is for 2.0.5x  and from what I read at apache.org  2.2 has changed the way apache does things over 2.0

you need to build the Database in mysql before the install go into whatever mysql thing you have, and create a Database called what ever you want your postnuke database to be, then install postnuke IF you are limited to just one Database, you will have to select the name of your current DB as the DB name in postnuke, I suggest naming all Postnuke tables with a Prefix of nuke,

LoadModule php4_module C:/php/sapi/php4apache2.dll AddType application/x-httpd-php .php you need to add this not just LoadModule php4_module C:/php/sapi/php4apache2.dll

First you need to have SP1 for Windows XP installed. Next I would suggest using Apache2 for windows XP instead of Apache 1.3.X if you move to Apache 2 come back to this thread asking for help and I\'ll walk you through the installation

try installing Apache 2 instead of 1.3.X

NULL does not equal zero, NULL is more can be igored, or Ignore this

Well it would seem that `something` int(11) NOT NULL default \'\', is not permitted, and one must use `something` int(11) NOT NULL default \'0\', everyone I have asked seems to think I will generate an error if I leave it as `something` int(11) NOT NULL default \'\', crappy!

Nice thread link, on that note, MySQL will easily handed 1500 a DAY transactions, 1500 a month is hardly big, My Uncle who is a Computer Engineer in England is the only person I know who does tasks greater then MySQL can handle, He uses Orical, since the company he works for handles 10-25 Million transactions a day, My former university ran completly on MySQL, during registration thats 5000+ students online signing up for 5-10 courses, which is intencive insert / drop / update queries, rarely did we experience slow downs from the DB, just poor ASP programming HA!.

WHY would you not have SP1 installed when you are running XP!! that is STUPID I could clear your hard drive from this forum if you are running an XP box unpatched with SP1, very dangerous times

I was just building a DB for a project I am doing when it occered to me, I have never done `something` int(11) NOT NULL default \'\', always `something` int(11) NOT NULL default \'0\', what does mySQL do if I do `something` int(11) NOT NULL default \'\', the reason I ask is some of the formula I will be using, will talk to the something cell, will not work correctly if there is a 0 in that cell, BUT the default can not be a 1, I need it to ignore the cell if there is nothing in it. I\'m about 3 or 4 tables away from even droping this file into mySQL to make DB\'s and figured it wouldn\'t hurt to throw this question out to the world and see what comes back

use apache2 I use it on win XP boxes and it installs and runs flawlessly

you have mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD) should it not say mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD); or did you just omit that in the forum

what programs have you installed sicne then? possibly a new firewall?

do both servers have phpMYADMIN??

To get a Domain name ( going to a name rather then an IP ) go to a Domain anme register, I use http://www.vimar.ca/ As for a server What system specs are you running? RedHat is probably your best bet for linux, it will have Apache already installed, and PHP, mySQL are both easy to install from there respective sites www.php.net and www.mysql.com For webmail I suggest squirrel mail, it is a great program, I use it for my mailserver on my site. as for perl I suggest http://www.activestate.com/Products/Downlo...x?id=ActivePerl Activestate Perl. any other questions just post back

if you can get access to the drive you could just have the DIR coppied and e-mailed to you, then e-mail it to the new host otherwise you are doing it the way they are telling you in the manual

[MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1 ; Default port number for mysql_connect(). If unset, mysql_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysql.default_port = ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysql.default_socket = ; Default host for mysql_connect() (doesn\'t apply in safe mode). mysql.default_host = ; Default user for mysql_connect() (doesn\'t apply in safe mode). mysql.default_user = ; Default password for mysql_connect() (doesn\'t apply in safe mode). ; Note that this is generally a *bad* idea to store passwords in this file. ; *Any* user with PHP access can run \'echo get_cfg_var(\"mysql.default_password\") ; and reveal this password! And of course, any users with read access to this ; file will be able to reveal the password as well. mysql.default_password = ; Maximum time (in secondes) for connect timeout. -1 means no limimt mysql.connect_timeout = 60 ; Trace mode. When trace_mode is active (=On), warnings for table/index scans and ; SQL-Erros will be displayed. mysql.trace_mode = Off [mSQL] ; Allow or prevent persistent links. msql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. msql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. msql.max_links = -1 make sure this is in your PHP.ini file and make sure it is uncommented

you need to install apache as a service its called apache monitor

bumping as a test

as said above the glitch was telling me \"failed send email\" and did not tell me it had posted this forum seems to have an probelm I posted on Nov 24 and it still says Nov 14 as the last post

some glitch caused me to multi post sorry

<?php mysql_pconnect("*****","*****","*******"); mysql_select_db("Clan"); $Tstrength = mysql_query("SELECT m.clan, SUM(m.strength) FROM members m, clan c WHERE c.id = 1 AND m.clan = 1 Group By m.strength"); while ($row = mysql_fetch_array($Tstrength)) { print" Strength: $row[1]"; } ?> this code works great if c.id and m.clan are numbers, but I need them to be a variable I tried WHERE c.id =$clan[id] AND m.clan =$clan[id] but I get any ideas? what I need is to beable to see the users clan[id]\'s to determin the strength of said clan the site uses sessions, if some one is truely interested in troubleshooting with me beyond forum posts I\'ll show the enite source code to you give you a better understanding of what I\'m trying to do

Thanks works, though I only need echo $row[1] echo $row[0] makes it out put a number that I can\'t figure out were it came from, I must say you guys opened a can of worms being so fast and friendly, now you are stuck with me

thanks, in PHPmyAdmin it out puts what I want to see SELECT m.clan, SUM(m.strength) FROM members m, clan c WHERE c.id = "1" AND m.clan = "1" Group By m.strength I made a php page in hopes to output m.strength but it didn\'t do it <?php mysql_pconnect("*****","*****","*******"); mysql_select_db("Clan"); $Tstrength = mysql_query("SELECT m.clan, SUM(m.strength) FROM members m, clan c WHERE c.id = "1" AND m.clan = "1" Group By m.strength"); print "$Tstrength"; ?> this does not out put a number it outputs Resource id #3 which really confuses me since no members have an ID of 3,

I get this error when using your query #1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause this is the exact query I used SELECT m.clan, SUM(m.strength) FROM members m, clan c WHERE c.id = "1" AND m.clan = "1" when the I get this working for c.id = 1 and m.clan = 1 then both of the 1\'s become variables, since there are multiple clans and multiple members