Results 1 to 7 of 7

Thread: Newbie questions about phpBB and MySQL

  1. #1
    HEXUS.social member Allen's Avatar
    Join Date
    Nov 2003
    Location
    Brighton
    Posts
    8,536
    Thanks
    363
    Thanked
    262 times in 168 posts
    • Allen's system
      • Motherboard:
      • ASUS Maximus VIII Gene
      • CPU:
      • Intel Core i5 6600K
      • Memory:
      • 2 x 8GB Kingston HyperX Predator DDR4-3000
      • Storage:
      • 256GB Samsung 950 PRO NVMe M.2 (OS) + 2 x 512GB Samsung 960 EVO in RAID 0 (Games)
      • Graphics card(s):
      • ASUS ROG Strix GeForce GTX 1080 Ti OC
      • PSU:
      • XFX P1-650X-NLG9 XXX 650W Modular
      • Case:
      • Fractal Design Node 804
      • Operating System:
      • Windows 10 Home 64-bit
      • Monitor(s):
      • 27" BenQ XL2730Z + 23" Dell U2311H
      • Internet:
      • Virgin Media 200Mbps

    Red face Newbie questions about phpBB and MySQL

    Don't shoot me please, as my knowledge is not brilliant and my terminology may not be correct either.

    Right, having a mess about with phpBB and MySQL on my computer. I'm running Windows 2000 and have set up IIS so I can use http://localhost/. php pages run ok (the php test page and the front pages to phpBB work fine) and after a lot of fiddling about I think I got phpBB to install correctly following this guide. The MySQL was setup differently and I had to RTFM for ages to find out how to create a db, but I think it's running ok.

    Now, I can see the front page of the basic phpBB forum, and I can login successfully as the Administrator like I set up, but when I try and actually do something (like look at the basic intro post or go into the control panel) it doesn't load the page. I've left it for like 10 mins and nothing happens. Click back and it goes back, but you can't do anything else. It's like it locks the site.

    Anyone have any ideas what I could have done wrong please? Also, need to know of a free host for me to test it online. Don't care about adverts for the time being. Cheers.

    :edit: Believe it or not, Lycos' Tripod service has free php and MySQL services.
    Last edited by Allen; 23-04-2004 at 08:59 AM.

  2. #2
    Furry Shorty's Avatar
    Join Date
    Jul 2003
    Location
    Manchester, UK
    Posts
    1,237
    Thanks
    1
    Thanked
    2 times in 2 posts
    IIS + PHP = trouble. I know many use it and have no problems but.. yuck mate. Really yuck.

    When you say it stalls?? Does it ever load at all?

    Do me a favour.. open notepad and put this in it:
    PHP Code:
    <?php

    phpinfo
    ();

    ?>
    Save it as "info.php" and then access it on your server (http://localhost/info.php). Then PM me a link (if you want it kept private) where I can access it (or copy the output and get it to me via email/PM).. and Il take a look at your PHP setup

    Ps.. Tripod do offer MySQL & PHP but I warn you.. it's dogslow
    "In a world without walls and fences, who needs Windows and Gates?"

  3. #3
    bored out of my tiny mind malfunction's Avatar
    Join Date
    Jul 2003
    Location
    Lurking
    Posts
    3,923
    Thanks
    191
    Thanked
    187 times in 163 posts
    • malfunction's system
      • Motherboard:
      • Gigabyte G1.Sniper (with daft heatsinks and annoying Killer NIC)
      • CPU:
      • Xeon X5670 (6 core LGA 1366) @ 4.4GHz
      • Memory:
      • 48GB DDR3 1600 (6 * 8GB)
      • Storage:
      • 1TB 840 Evo + 1TB 850 Evo
      • Graphics card(s):
      • 290X
      • PSU:
      • Antec True Power New 750W
      • Case:
      • Cooltek W2
      • Operating System:
      • Windows 10
      • Monitor(s):
      • Dell U2715H
    Quote Originally Posted by Shorty
    IIS + PHP = trouble. I know many use it and have no problems but.. yuck mate. Really yuck.
    Arse! Just typed out a long message and lost it due to bloody back button on my keyboard...

    Anyway. Shorter version:

    Shorty: Care to qualify that statment? I've just installed PHP on IIS 6 in the office for our other developer (I've stuck to ASP so far) and was wondering if there's anything I should look out for.

    Al: Sorry for the hijack. FWIW I think that MySQL is very good but like many things originating in the linux world you don't get to know everything you need to know without actually trying it out... Setting up replication in the office was fun... Not.

  4. #4
    Furry Shorty's Avatar
    Join Date
    Jul 2003
    Location
    Manchester, UK
    Posts
    1,237
    Thanks
    1
    Thanked
    2 times in 2 posts
    It was more a generalised statement as Im not a big fan of IIS in general.

    I prefer the tight integration and portability of AMP (on either Linux/BSD or Windows) but that is just my personal preference

    The main things to look for in ANY PHP installation is the obvious configurations you will find in your php.ini file.

    register_globals = Off

    Globals are bad. Any google search for that term will go into the indepth reasons why that flag should be like that (think variable scope).

    allow_call_time_pass_reference = Off

    Only really relevant to OOP level PHP programming as it causes hell with procedural functions (and lazy programmers!).

    magic_quotes_gpc = Off

    With this flag set On, all GET, POST and COOKIE vars are automatically escaped ("). Again, lazy programming to rely on it and causes all hell of issues down the line.

    http://www.pinkgoblin.com/quotesarticle.php is a good reference of several PHP flags to watch for
    "In a world without walls and fences, who needs Windows and Gates?"

  5. #5
    HEXUS.social member Allen's Avatar
    Join Date
    Nov 2003
    Location
    Brighton
    Posts
    8,536
    Thanks
    363
    Thanked
    262 times in 168 posts
    • Allen's system
      • Motherboard:
      • ASUS Maximus VIII Gene
      • CPU:
      • Intel Core i5 6600K
      • Memory:
      • 2 x 8GB Kingston HyperX Predator DDR4-3000
      • Storage:
      • 256GB Samsung 950 PRO NVMe M.2 (OS) + 2 x 512GB Samsung 960 EVO in RAID 0 (Games)
      • Graphics card(s):
      • ASUS ROG Strix GeForce GTX 1080 Ti OC
      • PSU:
      • XFX P1-650X-NLG9 XXX 650W Modular
      • Case:
      • Fractal Design Node 804
      • Operating System:
      • Windows 10 Home 64-bit
      • Monitor(s):
      • 27" BenQ XL2730Z + 23" Dell U2311H
      • Internet:
      • Virgin Media 200Mbps
    Quote Originally Posted by Shorty
    IIS + PHP = trouble. I know many use it and have no problems but.. yuck mate. Really yuck.

    When you say it stalls?? Does it ever load at all?

    Do me a favour.. open notepad and put this in it:
    PHP Code:
    <?php

    phpinfo
    ();

    ?>
    Save it as "info.php" and then access it on your server (http://localhost/info.php). Then PM me a link (if you want it kept private) where I can access it (or copy the output and get it to me via email/PM).. and Il take a look at your PHP setup

    Ps.. Tripod do offer MySQL & PHP but I warn you.. it's dogslow
    I'll email the output to ya, it's friggin huge!!

    And I got it running ok on Tripod, don't care about speed either as it's only for testing right now. Adverts mucked it up to start off with, but now the only advert I get is on the right hand side of the screen.

    If I ever make a real one and it goes public, I'll pay for a non-advert/fast service. I must say though, phpBB is very easy to use once set up!

  6. #6
    HEXUS.social member Allen's Avatar
    Join Date
    Nov 2003
    Location
    Brighton
    Posts
    8,536
    Thanks
    363
    Thanked
    262 times in 168 posts
    • Allen's system
      • Motherboard:
      • ASUS Maximus VIII Gene
      • CPU:
      • Intel Core i5 6600K
      • Memory:
      • 2 x 8GB Kingston HyperX Predator DDR4-3000
      • Storage:
      • 256GB Samsung 950 PRO NVMe M.2 (OS) + 2 x 512GB Samsung 960 EVO in RAID 0 (Games)
      • Graphics card(s):
      • ASUS ROG Strix GeForce GTX 1080 Ti OC
      • PSU:
      • XFX P1-650X-NLG9 XXX 650W Modular
      • Case:
      • Fractal Design Node 804
      • Operating System:
      • Windows 10 Home 64-bit
      • Monitor(s):
      • 27" BenQ XL2730Z + 23" Dell U2311H
      • Internet:
      • Virgin Media 200Mbps
    Quote Originally Posted by malfunction
    Al: Sorry for the hijack. FWIW I think that MySQL is very good but like many things originating in the linux world you don't get to know everything you need to know without actually trying it out... Setting up replication in the office was fun... Not.
    Took me long enough to figure out how to create a new database! I won't be doing anything in depth with this, as I'm not a programmer at all.....

  7. #7
    Sublime HEXUS.net
    Join Date
    Jul 2003
    Location
    The Void.. Floating
    Posts
    11,819
    Thanks
    213
    Thanked
    233 times in 160 posts
    • Stoo's system
      • Motherboard:
      • Mac Pro
      • CPU:
      • 2*Xeon 5450 @ 2.8GHz, 12MB Cache
      • Memory:
      • 32GB 1600MHz FBDIMM
      • Storage:
      • ~ 2.5TB + 4TB external array
      • Graphics card(s):
      • ATI Radeon HD 4870
      • Case:
      • Mac Pro
      • Operating System:
      • OS X 10.7
      • Monitor(s):
      • 24" Samsung 244T Black
      • Internet:
      • Zen Max Pro
    phpmyadmin rocks
    (\__/)
    (='.'=)
    (")_(")

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •