Page 1 of 3 123 LastLast
Results 1 to 40 of 84

Thread: Site News, (Now PhpBB)

  1. #1

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464

    Site News, (Now PhpBB)

    Hello,
    I was just wondering what any of you people() do with your website and the news stuff. Like, when you put news on your site, do you do it manual or have some news script or something?? I am in search of a program that puts news on my website... (FREE)

    I've had this done before(lost it)... an ASP page that you can send info to (but if someone finds out the parameters, ouch you got a site full of ads probably)

    Thanks,
    alacritous
    Last edited by alacritous; Jul 8th, 2004 at 02:51 PM.

  2. #2
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    I use a php script that generates my index page and as it does that it makes a querry to my DB and this has a News table which it basically displays all the records in Date order and I have a priority system which handles if two items are on the same date. It also ignores dates that aren't reached yet so I can add news items that won't appear for X amount of days .
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  3. #3

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Anyone else know an easier way?

  4. #4
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    lol, I would say my way is the easiest you can get apart from editing the html each time you update. At least this way it all looks after itself once I coded it once, so to add a new item it takes a couple of seconds to add a DB record.
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  5. #5

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    I understand that, but if I can't get phpBB to work... then why make a database? and do all that... Could you help me get phpBB to work? lol...

  6. #6
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    Whats the prob with phpBB? Its that bad to use, have you got it installed already?


    phpBB2 is it?
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  7. #7

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    funny that you ask...


    well anyway, it keeps saying the database isnt created (i dont know crap about mysql) so i download myphpadmin (which creates databases) and it still doesn't make one.. its all messed up.. i can try to install it again, but in the end it just caused too much crap.

  8. #8
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    Sorry but the way I remember it is you uplaod all the files to the server and then run install.php it then asks some options then it creates the DB for you. Cos you can't do it your self without knowing the structure of all the tables .
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  9. #9

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Originally posted by Electroman
    Sorry but the way I remember it is you uplaod all the files to the server and then run install.php it then asks some options then it creates the DB for you. Cos you can't do it your self without knowing the structure of all the tables .
    I run the install.php, thats when it has the error. I'll try it again though.. maybe my other computer has problems...:P

  10. #10

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Oh Yes... When I run the install.php, I don't know what to put for the database name..... if it creates wahtever you type, then why do I get an error?

    phpBB : Critical Error

    Could not connect to the database
    EDIT: You do need a database, just nothing in it... And I need to create a MySQL database...

  11. #11

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Can anyone possibly help me? I know its VBFOrums, although ChitChat, but I tried posting in the PhpBB and they are real mean people.. LOL.. anyone installed this? how?

  12. #12
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    Are you using a hosting plan or your own server? Normally they have a option in the control pannel of hosting plans to create a new DB. I don't think phpMyAdmin can create the DBs only connect to them :unsure: at least my host won't give me access to create DBs my self.
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  13. #13

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Own Server...I installed everything that is required... (PHP, etc)

  14. #14
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    Did you manage to create DB at all? Like is it just not recognising it or can't you create it?
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  15. #15
    Frenzied Member Acidic's Avatar
    Join Date
    Sep 2003
    Location
    UK
    Posts
    1,090
    phpMyAdmin can definately create, edit, drop etc. databases. I use it all the time on my PC.
    Have I helped you? Please Rate my posts.

  16. #16
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    Posted by Acidic
    phpMyAdmin can definately create, edit, drop etc. databases. I use it all the time on my PC.
    Your not thinking about tables are you? Or does it do both?
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  17. #17

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Hello,
    If you can create one, can you give me one? I need a damn database for the forums, and I don't know CRAP about creating one. I tried using MyPhpAdmin and it doesn't do crap for me....

    Please help!!
    alacritous

  18. #18
    Frenzied Member Acidic's Avatar
    Join Date
    Sep 2003
    Location
    UK
    Posts
    1,090
    Originally posted by Electroman
    Your not thinking about tables are you? Or does it do both?
    it does both
    Have I helped you? Please Rate my posts.

  19. #19

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Originally posted by Acidic
    it does both
    Now I am real hyped up.. make me one .... when I downloaded it I get errors...

  20. #20
    Frenzied Member Acidic's Avatar
    Join Date
    Sep 2003
    Location
    UK
    Posts
    1,090
    I've attached my database which Ive used for testing stuff to this message.

    edit: unzip it, then import the file into phpMyAdmin through phpMyAdmin itself
    Attached Files Attached Files
    Have I helped you? Please Rate my posts.

  21. #21
    Frenzied Member Acidic's Avatar
    Join Date
    Sep 2003
    Location
    UK
    Posts
    1,090
    hhm. I don't think that file creates the database, only the tables in it. if all else fails to create a DB, do this:
    open MSDOS prompt
    get to the folder with mysqladmin.exe in it
    type: mysqladmin -u root create mydb
    type: exit

    then open phpMyAdmin and voila, you have a new db there for you, then import the sql file
    Have I helped you? Please Rate my posts.

  22. #22
    Frenzied Member Acidic's Avatar
    Join Date
    Sep 2003
    Location
    UK
    Posts
    1,090
    i think
    Have I helped you? Please Rate my posts.

  23. #23

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Ugh...

    Have you done this for PhpBB? It creates the tables for you, I suppose. But you need the database...

  24. #24
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    For phpBB all you nee is an empty Database and when running the install.php for it you tell it the name of the blank database .
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  25. #25

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Yes... I need help creating it... I was asking if Acidic made a blank database... I'm sorry for all the trouble, I am a complete newb at databases... And I don't feel like having the choice in my head to kill myself because I can't make an SQL Databse : \

  26. #26
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    Here you go, I opened my phpMyAdmin and on the page after loging in it shows this:


    The account I logged in as doesn't have access to add new Databases but the bit I circled is where you should find the option .
    Attached Images Attached Images  
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  27. #27

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Ugh... See when I try PhpMyAdmin, it has an error, again...

    I'm so pissed....

  28. #28
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    ....and the error is??
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  29. #29
    Addicted Member señorbadger's Avatar
    Join Date
    Oct 2003
    Location
    Mud pools of wellingborough
    Posts
    193
    i had a problem like this turns out you need to check the config file for phpmyadmin.

    make sure that the server port for mysql matches as well as the user (normally root).

  30. #30

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Lets do this by step...

    http://www.phpmyadmin.net/documentation/
    Installation
    Quick Install

    1. did
    2. ""host" means the MySQL server"
    *** sql server? im running my own server so do i need this?
    stuck...

    alacritous

  31. #31
    Frenzied Member Acidic's Avatar
    Join Date
    Sep 2003
    Location
    UK
    Posts
    1,090
    try this:
    open MSDOS prompt
    get to the folder with mysqladmin.exe in it
    type: mysqladmin -u root create mydb
    type: exit
    Have I helped you? Please Rate my posts.

  32. #32
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    Posted by alacritous
    Lets do this by step...

    http://www.phpmyadmin.net/documentation/
    Installation
    Quick Install

    1. did
    2. *** sql server? im running my own server... *** is this?
    stuck...

    alacritous
    Then make it localhost. 128.0.0.1 (thats right?)
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  33. #33
    Addicted Member señorbadger's Avatar
    Join Date
    Oct 2003
    Location
    Mud pools of wellingborough
    Posts
    193
    Originally posted by Electroman
    Then make it localhost. 128.0.0.1 (thats right?)
    isnt it 127.0.0.1 for localhost

  34. #34

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    When I do 127.0.0.1 for host (its 7, not 8)

    phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

    Error

    MySQL said:


    #2003 - Can't connect to MySQL server on '127.0.0.1' (10061)

    [Documentation]

  35. #35
    Frenzied Member Acidic's Avatar
    Join Date
    Sep 2003
    Location
    UK
    Posts
    1,090
    Originally posted by señorbadger
    isnt it 127.0.0.1 for localhost
    that's it
    Have I helped you? Please Rate my posts.

  36. #36
    Addicted Member señorbadger's Avatar
    Join Date
    Oct 2003
    Location
    Mud pools of wellingborough
    Posts
    193
    change the port to 3306

    like this localhost:3306

    this was the issue on my laptop

  37. #37
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    Doh, and I was thinking it was either 126 or 128 .



    If making it use port 3306 doesn't work then make sure that the mysql server program is running .
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  38. #38

    Thread Starter
    Hyperactive Member alacritous's Avatar
    Join Date
    Aug 2003
    Posts
    464
    Originally posted by Electroman
    Doh, and I was thinking it was either 126 or 128 .



    If making it use port 3306 doesn't work then make sure that the mysql server program is running .
    lol... see I told you I don't know databases... How do I run the mysql server?

    Also, what do I put for the other stuff like username and all that? Because I don't have a database so how do I know?

    ...

    And YES, I did install it :P

  39. #39
    Addicted Member señorbadger's Avatar
    Join Date
    Oct 2003
    Location
    Mud pools of wellingborough
    Posts
    193
    username should be root
    no password by default

  40. #40
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    Posted by señorbadger
    username should be root
    no password by default
    Yea but he wants to change them before he sets everything up. otherwise it'll be the easiest server to be hacked ever
    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

Page 1 of 3 123 LastLast

Posting Permissions

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



Click Here to Expand Forum to Full Width