Page 4 of 5 FirstFirst ... 2345 LastLast
Results 31 to 40 of 43

Thread: Setting Up A My SQL Database

  1. #31
    Join Date
    Sep 2006
    Location
    St. George, UT
    Posts
    2,769
    Thanks
    3
    Thanked 157 Times in 155 Posts

    Default

    When you run the setup exe file, it prompts you for input towards the end. Mostly all you have to do is click "Next" and it will do the rest. When you go to phpmyadmin, do you get an error message? If so, what is the error.

    Hope this helps.
    "Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music." - Kristian Wilson, Nintendo, Inc, 1989
    TheUnlimitedHost | The Testing Site | Southern Utah Web Hosting and Design

  2. #32
    Join Date
    Jan 2007
    Location
    The stage
    Posts
    568
    Thanks
    23
    Thanked 6 Times in 6 Posts

    Default

    Quote Originally Posted by thetestingsite View Post
    When you go to phpmyadmin, do you get an error message? If so, what is the error.
    Yeah i do get an error message... its
    Code:
    phpMyAdmin - Error
    Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.
    Its doesn't offer a link or anything... just the plain text above...
    Thanks

  3. #33
    Join Date
    Sep 2006
    Location
    St. George, UT
    Posts
    2,769
    Thanks
    3
    Thanked 157 Times in 155 Posts

    Default

    Ok, then check the error logs in your apache/logs/ directory. From there you will be able to get the exact error message.

    Hope this helps.
    "Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music." - Kristian Wilson, Nintendo, Inc, 1989
    TheUnlimitedHost | The Testing Site | Southern Utah Web Hosting and Design

  4. #34
    Join Date
    Jan 2007
    Location
    The stage
    Posts
    568
    Thanks
    23
    Thanked 6 Times in 6 Posts

    Default

    ok i checked the error log for apache and the entries for today are this:


    Code:
    [Wed Sep 12 13:42:21 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.4 configured -- resuming normal operations
    [Wed Sep 12 13:42:21 2007] [notice] Server built: Jan  9 2007 23:17:20
    [Wed Sep 12 13:42:21 2007] [notice] Parent: Created child process 3316
    [Wed Sep 12 13:42:22 2007] [notice] Child 3316: Child process is running
    [Wed Sep 12 13:42:22 2007] [notice] Child 3316: Acquired the start mutex.
    [Wed Sep 12 13:42:22 2007] [notice] Child 3316: Starting 250 worker threads.
    [Wed Sep 12 13:42:22 2007] [notice] Child 3316: Starting thread to listen on port 80.
    [Wed Sep 12 13:42:53 2007] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: mysql_version in C:\\wamp\\www\\index.php on line 179
    [Wed Sep 12 13:43:19 2007] [error] [client 127.0.0.1] PHP Warning:  session_start() [<a href='function.session-start'>function.session-start</a>]: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_iv0qgbdomkep49grqbad33eed0, O_RDWR) failed: No such file or directory (2) in C:\\wamp\\phpmyadmin\\libraries\\session.inc.php on line 89
    [Wed Sep 12 13:43:19 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_iv0qgbdomkep49grqbad33eed0, O_RDWR) failed: No such file or directory (2) in Unknown on line 0
    [Wed Sep 12 13:43:19 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session) in Unknown on line 0
    [Wed Sep 12 13:43:28 2007] [error] [client 127.0.0.1] PHP Warning:  session_start() [<a href='function.session-start'>function.session-start</a>]: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_vhesjbqeab81om18p9ttdt0t46, O_RDWR) failed: No such file or directory (2) in C:\\wamp\\phpmyadmin\\libraries\\session.inc.php on line 89
    [Wed Sep 12 13:43:28 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_vhesjbqeab81om18p9ttdt0t46, O_RDWR) failed: No such file or directory (2) in Unknown on line 0
    [Wed Sep 12 13:43:28 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session) in Unknown on line 0
    [Wed Sep 12 13:43:35 2007] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: mysql_version in C:\\wamp\\www\\index.php on line 179
    [Wed Sep 12 13:43:37 2007] [error] [client 127.0.0.1] PHP Warning:  session_start() [<a href='function.session-start'>function.session-start</a>]: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_la0n01skgrkf5iephj933bb6r5, O_RDWR) failed: No such file or directory (2) in C:\\wamp\\sqlitemanager\\index.php on line 8, referer: http://localhost/
    [Wed Sep 12 13:43:38 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_la0n01skgrkf5iephj933bb6r5, O_RDWR) failed: No such file or directory (2) in Unknown on line 0, referer: http://localhost/
    [Wed Sep 12 13:43:38 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session) in Unknown on line 0, referer: http://localhost/
    [Wed Sep 12 13:43:41 2007] [error] [client 127.0.0.1] PHP Warning:  session_start() [<a href='function.session-start'>function.session-start</a>]: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_ct03qsck7njo471ajecffq3pg5, O_RDWR) failed: No such file or directory (2) in C:\\wamp\\phpmyadmin\\libraries\\session.inc.php on line 89, referer: http://localhost/
    [Wed Sep 12 13:43:41 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_ct03qsck7njo471ajecffq3pg5, O_RDWR) failed: No such file or directory (2) in Unknown on line 0, referer: http://localhost/
    [Wed Sep 12 13:43:41 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session) in Unknown on line 0, referer: http://localhost/
    [Wed Sep 12 13:45:17 2007] [error] [client 127.0.0.1] PHP Warning:  session_start() [<a href='function.session-start'>function.session-start</a>]: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_qs3411ig30u98l6vh9h4mhegj7, O_RDWR) failed: No such file or directory (2) in C:\\wamp\\phpmyadmin\\libraries\\session.inc.php on line 89, referer: http://localhost/phpmyadmin/documentation.html
    [Wed Sep 12 13:45:17 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_qs3411ig30u98l6vh9h4mhegj7, O_RDWR) failed: No such file or directory (2) in Unknown on line 0, referer: http://localhost/phpmyadmin/documentation.html
    [Wed Sep 12 13:45:17 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session) in Unknown on line 0, referer: http://localhost/phpmyadmin/documentation.html
    [Wed Sep 12 13:49:13 2007] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: mysql_version in C:\\wamp\\www\\index.php on line 179
    [Wed Sep 12 14:02:45 2007] [error] [client 127.0.0.1] PHP Warning:  session_start() [<a href='function.session-start'>function.session-start</a>]: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_tlr3jajbd9ikjg4pfopgrsjd64, O_RDWR) failed: No such file or directory (2) in C:\\wamp\\phpmyadmin\\libraries\\session.inc.php on line 89
    [Wed Sep 12 14:02:45 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_tlr3jajbd9ikjg4pfopgrsjd64, O_RDWR) failed: No such file or directory (2) in Unknown on line 0
    [Wed Sep 12 14:02:45 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session) in Unknown on line 0
    [Wed Sep 12 16:55:51 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.4 configured -- resuming normal operations
    [Wed Sep 12 16:55:51 2007] [notice] Server built: Jan  9 2007 23:17:20
    [Wed Sep 12 16:55:51 2007] [notice] Parent: Created child process 3392
    [Wed Sep 12 16:55:52 2007] [notice] Child 3392: Child process is running
    [Wed Sep 12 16:55:52 2007] [notice] Child 3392: Acquired the start mutex.
    [Wed Sep 12 16:55:52 2007] [notice] Child 3392: Starting 250 worker threads.
    [Wed Sep 12 16:55:52 2007] [notice] Child 3392: Starting thread to listen on port 80.
    [Wed Sep 12 16:56:41 2007] [error] [client 127.0.0.1] PHP Warning:  session_start() [<a href='function.session-start'>function.session-start</a>]: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_h2u0dfuu93jmojvji9e3s9ta61, O_RDWR) failed: No such file or directory (2) in C:\\wamp\\phpmyadmin\\libraries\\session.inc.php on line 89
    [Wed Sep 12 16:56:41 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_h2u0dfuu93jmojvji9e3s9ta61, O_RDWR) failed: No such file or directory (2) in Unknown on line 0
    [Wed Sep 12 16:56:41 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session) in Unknown on line 0
    [Wed Sep 12 17:01:30 2007] [error] [client 127.0.0.1] PHP Warning:  session_start() [<a href='function.session-start'>function.session-start</a>]: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_u3in1crckoafcd5e2gj6lb34n4, O_RDWR) failed: No such file or directory (2) in C:\\wamp\\sqlitemanager\\index.php on line 8
    [Wed Sep 12 17:01:30 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: open(C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session\\sess_u3in1crckoafcd5e2gj6lb34n4, O_RDWR) failed: No such file or directory (2) in Unknown on line 0
    [Wed Sep 12 17:01:30 2007] [error] [client 127.0.0.1] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\\DOCUME~1\\OWNER~1.GAT\\LOCALS~1\\Temp\\php\\session) in Unknown on line 0
    Hope that that helps

  5. #35
    Join Date
    Sep 2006
    Location
    St. George, UT
    Posts
    2,769
    Thanks
    3
    Thanked 157 Times in 155 Posts

    Default

    Ok, in the phpmyadmin directory look for config.inc.php. In that file, look for the following:

    Code:
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = '';
    Whatever the auth_type is set to, change it to 'cookie'. If it is already set to cookie, then it is a problem with the phpmyadmin. You may have to re-download it and install from scratch.

    hope this helps.
    "Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music." - Kristian Wilson, Nintendo, Inc, 1989
    TheUnlimitedHost | The Testing Site | Southern Utah Web Hosting and Design

  6. #36
    Join Date
    Jan 2007
    Location
    The stage
    Posts
    568
    Thanks
    23
    Thanked 6 Times in 6 Posts

    Default

    Quote Originally Posted by Rockonmetal View Post
    Yeah i do get an error message... its
    Code:
    phpMyAdmin - Error
    Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.
    I still get that error after I changed that line. It now reads:
    PHP Code:
    $cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)? 
    If you want I'm going to put that file up on my site so you can look it over...

    i'll pm you the link to it... thanks!

  7. #37
    Join Date
    Sep 2006
    Location
    St. George, UT
    Posts
    2,769
    Thanks
    3
    Thanked 157 Times in 155 Posts

    Default

    I think you may need to re-download phpmyadmin by going to the following website:

    http://prdownloads.sourceforge.net/p...h.zip?download

    Remove all of the files in your current phpmyadmin install, then replace them with the above download. From there, edit config.inc.php to what I posted before. As for the MySQL server not working, run a simple telnet to localhost on port 3306 and see if MySQL is running. If you get a response, it is; otherwise, it isn't.

    Hope this helps.
    "Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music." - Kristian Wilson, Nintendo, Inc, 1989
    TheUnlimitedHost | The Testing Site | Southern Utah Web Hosting and Design

  8. #38
    Join Date
    Jan 2007
    Location
    The stage
    Posts
    568
    Thanks
    23
    Thanked 6 Times in 6 Posts

    Default

    I read what you said above wrong, i thought you said uninstall it, delete remaining files then reinstall from that link... so now heres what I"m doing...
    Redownloading wamp5 1.7.3
    Then unless you say other wise I will delete PHPMYADMIN folder and replace it with the new one from the link you gave above...
    I wish my internet connection was faster though...

  9. #39
    Join Date
    Sep 2006
    Location
    St. George, UT
    Posts
    2,769
    Thanks
    3
    Thanked 157 Times in 155 Posts

    Default

    You shouldn't have to re-download WAMP5, unless you are upgrading to the newer version; but since you are doing it anyway, oh well. After you finish the install, make sure that MySQL is running by opening the command prompt (Start > Run > cmd on Windows2000+) and typing the following:

    Code:
    telnet localhost 3306
    If you get a response like the following:

    Code:
    Connecting to localhost...Could not open connection to the host, on port 3306: Connection failed
    then mySQL is not running or not installed correcty. If you get a blank screen for a few seconds, then get a bunch of gibberish on the screen; then MySQL is up and running properly. I think if you install the newest version of phpmyadmin, your problems will be gone.

    Hope this helps.
    "Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music." - Kristian Wilson, Nintendo, Inc, 1989
    TheUnlimitedHost | The Testing Site | Southern Utah Web Hosting and Design

  10. #40
    Join Date
    Jan 2007
    Location
    The stage
    Posts
    568
    Thanks
    23
    Thanked 6 Times in 6 Posts

    Default

    k i'll try that!
    I'll let you know how it goes in a couple of seconds

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
  •