Jump to content
The Uniform Server Community

rbrown

Member
  • Posts

    7
  • Joined

  • Last visited

Previous Fields

  • Main OS
    Windows XP

rbrown's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. rbrown

    PDO not working in

    Just went back to using PDO from mysqli and figured it out... When I added the array to start the PDO I forgot the ' quotes around the dsn and un/pw The quotes need to be there. $db = new PDO('mysql:host=localhost;dbname=testdb;charset=utf8', 'username', 'password');
  2. Using XP Pro I have PDO working with this version: ---------------------------- The Uniform Server 8.4.0 Apache 2.4.1 MySQL 5.5.21-community PHP 5.4.0 phpMyAdmin 3.4.10.1 eAccelerator 1.0-svn427 APC 3.1.7 UniController ---------------------------- tried updating to: ---------------------------- The Uniform Server 8.4.0 Apache 2.4.3 VC10 - OpenSSl 0.9.8x MySQL 5.5.29-community PHP 5.4.11 phpMyAdmin 3.5.5 eAccelerator 1.0-git42067ac7e2 APC 3.1.14 Xdebug 2.2.1 UniController ---------------------------- now with test connect script I'm getting: ---------------------------- Server port: 3306 Connecting to mysql Database... Connected successfully Connecting to mysqli Database... Connected successfully mysqli PDO connect array: Array ( [db] => Array ( [driver] => mysql [host] => localhost [dbname] => test [username] => test [password] => q4w3e2r1 ) ) SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO) ---------------------------- Any Ideas why? I have dragged and dropped the db, manually added the db, Double checked the all the ini files and compared them with a program to the earlier version ini's deleted and resetup the server a least 8-9 times... PDO will not work but if I switch back to old version it works... Also tried replacing the extensions with the older versions in php. And tried other usernames in mysql and tried connecting as root... Still won't work...
  3. Using XP Pro I have PDO working with this version: ---------------------------- The Uniform Server 8.4.0 Apache 2.4.1 MySQL 5.5.21-community PHP 5.4.0 phpMyAdmin 3.4.10.1 eAccelerator 1.0-svn427 APC 3.1.7 UniController ---------------------------- tried updating to: ---------------------------- The Uniform Server 8.4.0 Apache 2.4.3 VC10 - OpenSSl 0.9.8x MySQL 5.5.29-community PHP 5.4.11 phpMyAdmin 3.5.5 eAccelerator 1.0-git42067ac7e2 APC 3.1.14 Xdebug 2.2.1 UniController ---------------------------- now with test connect script I'm getting: ---------------------------- Server port: 3306 Connecting to mysql Database... Connected successfully Connecting to mysqli Database... Connected successfully mysqli PDO connect array: Array ( [db] => Array ( [driver] => mysql [host] => localhost [dbname] => test [username] => test [password] => q4w3e2r1 ) ) SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO) ---------------------------- Any Ideas why? I have dragged and dropped the db, manually added the db, Double checked the all the ini files and compared them with a program to the earlier version ini's deleted and resetup the server a least 8-9 times... PDO will not work but if I switch back to old version it works...
  4. Trying to search for a 500 server error even tried with quotes and it errors saying it is less than 4 chars or has html or what ever in the query... Server was working perfect rebooted now I'm getting a 500 error and apache says it's running... so instead of poting a new topic wanted to search for anyone else who might have run across the same thing. Bob
  5. I have this problem only after I either crash apache or lose the explorer window. So the only way around it is to log out and log back in to windows.
×
×
  • Create New...