SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    Senior Webdesigner koolbrian's Avatar
    Join Date
    Dec 2000
    Location
    Mauritius
    Posts
    599
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hey,
    i was only having problems with a script i tried to install. The fact is that i don't really know Php and mysql. And i downloaded a script i think which work with those. I KNOW u will tell me to go to a tutorial like kevin's......... but please , the tutorials won't really help me with this piticular problem QUICKLY. Here is what they ask me to do !

    1. Installation

    Installing CommentIt! is easy. Just follow these 6 steps:

    1. Be sure you have a webserver running php4.x and MySql.

    2. Edit the ' comment_config.inc.php ' file to fit your needs.

    3. Edit the ' $PathToConfigFile ' variable in 'output.php',

    'output_admin.php' and 'output_admin_frame.php'. YOU HAVE

    TO ADD A TRAILING SLASH ! (like: /var/httpd/comments/ )


    4. Import or manually create a table in your database, the sql command is:

    !!!! Donīt forget to rename the table according to the table name in the config file !!!
    It has to be the _SAME_ name !

    CREATE TABLE NameOfChoice (
    commentID bigint(20) DEFAULT '0' NOT NULL auto_increment,
    towhat varchar(25) DEFAULT 'main' NOT NULL,
    commentator varchar(25) NOT NULL,
    commentator_email varchar(25) NOT NULL,
    commentator_url varchar(50) NOT NULL,
    comment text NOT NULL,
    datum datetime,
    PRIMARY KEY (commentID)
    );

    You can use the comment_engine.sql file on the console like this:

    jim@linux$>mysql MY_DATABASE < comment_engine.sql



    5. Upload all files (except readme.txt)

    6. You are ready !



    could someone help me please.

    Brian
    Thanx!

  2. #2
    SitePoint Wizard edshuck's Avatar
    Join Date
    Jul 2000
    Posts
    1,198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wrong

    I am going to read just what you have here and try to answer the specifics of the question.

    back soon

    peace

  3. #3
    SitePoint Wizard edshuck's Avatar
    Join Date
    Jul 2000
    Posts
    1,198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi

    First, These are my assumptions from previous posts

    1) The server is not yours. As the server I use is not mine, but rather the service provider server.

    I cannot answer the first few questions and I will be most interested in what those answers are. I may want to do the same on my site.

    2) Your server (the one you are using) has both php4 and mySQL installed.

    3) You have access to the mySQL. This would be the user id and password for the service. It may or may not be the same as the telnet.

    4) I am assuming you have and can telnet to the location.

    The first thing is to telnet to the site.

    Next log onto the mySql server.

    Next access your database on the Server. There are many on mine, but I can use only one.

    Do a cut and paste of the create information. Then change the table name to the name you want to use.

    CREATE TABLE NameOfChoice (
    commentID bigint(20) DEFAULT '0' NOT NULL auto_increment,
    towhat varchar(25) DEFAULT 'main' NOT NULL,
    commentator varchar(25) NOT NULL,
    commentator_email varchar(25) NOT NULL,
    commentator_url varchar(50) NOT NULL,
    comment text NOT NULL,
    datum datetime,
    PRIMARY KEY (commentID)
    );

    To make sure the table is created use the command
    DESCRIBE NameOfChoice;

    This will come back immediately and tell you each of the fields and all of the attributes of each of the fields.

    I cannot answer line 2 and 3 in your question for you. That will be another member. But the sql table will be in place.

    peace

  4. #4
    Grumpy Mole Man Skunk's Avatar
    Join Date
    Jan 2001
    Location
    Lawrence, Kansas
    Posts
    2,067
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Which bit are you stuck with?

    Do you have access to a server already running PHP and mySQL or do you need help setting that up?

    If you do do you have telnet access to the server (if you don't know you probably haven't).

  5. #5
    SitePoint Wizard edshuck's Avatar
    Join Date
    Jul 2000
    Posts
    1,198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hi Skunk

    This discussion is ne arly the same as previous discussions around the same topic.

    I am just going to let it run till he tells me.

    peace

  6. #6
    Grumpy Mole Man Skunk's Avatar
    Join Date
    Jan 2001
    Location
    Lawrence, Kansas
    Posts
    2,067
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    gotcha

  7. #7
    Senior Webdesigner koolbrian's Avatar
    Join Date
    Dec 2000
    Location
    Mauritius
    Posts
    599
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the problem is that i wanted to know how to create the database. I have apache on my pc. What can i do with it ?,
    they ask me to upload it, am i obliged, even if i have my "own" apache server ?

    Brian

  8. #8
    Senior Webdesigner koolbrian's Avatar
    Join Date
    Dec 2000
    Location
    Mauritius
    Posts
    599
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hey,
    sorry i didn't reply to tell you what was exactly my problem, because
    1) i go to school from 8:00 AM to 15:30 PM !!!!!
    2) i go to bed from 23:00 to 7:00 !!

    I would also like to know something. Access my mysql program is not working!. in what format is a table saved? . can't i create it in a text [notepad] editor and save it the format ???. I would also like to know where should i put the name of the table in the script ??

    Brian

  9. #9
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    No you can't just create a text file and stick it somewhere then call that a database.

    Before you go any further you need to read Designing a Database Driven Web-Site with PHP and MySQL.

    You might want to check out the documentation for PHP and MySQL.

    Until you do a little leg work for yourself and ascertain whether these applications are available to you then we can't help you.
    Wayne Luke
    ------------



Bookmarks

Posting Permissions

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