drupal issues

Discussion in 'Web Design and Development' started by wmmk, Jul 11, 2006.

  1. wmmk macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #1
    i'm trying to install drupal on my server, and it keeps saying that it can't connect to my database. This is what I get:
    Unable to connect to database server

    This either means that the username and password information in your settings.php file is incorrect or we can't contact the MySQL database server. This could mean your hosting provider's database server is down.

    The MySQL error was: Access denied for user 'root'@'localhost' (using password: YES).

    Currently, the username is root and the database server is localhost.

    Are you sure you have the correct username and password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?
    For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.


    The weird thing is that I never told it to use the password YES in the config file. This is really odd. Please help.
     
  2. Squareball macrumors regular

    Joined:
    Mar 16, 2004
    Location:
    Palo Alto, CA
    #2
    It's not actually using the password as "YES" it's saying that the script *sent* it a password but that it failed.

    Check the config and make sure you are using the correct password in it.
     
  3. wmmk thread starter macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #3
    thanks, i actually did have the password wrong. still, i am getting errors.
     
  4. wmmk thread starter macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #4
    Warning: Table 'mysql.drupalsessions' doesn't exist query: SELECT sid FROM drupalsessions WHERE sid = '9d2f042596df3f5f016bcc0eec9deb51' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalusers' doesn't exist query: SELECT u.* FROM drupalusers u WHERE u.uid = 0 in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/bootstrap.inc on line 750

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/bootstrap.inc on line 750

    Warning: Table 'mysql.drupalaccess' doesn't exist query: SELECT * FROM drupalaccess WHERE status = 1 AND type = 'host' AND LOWER('::1') LIKE LOWER(mask) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalaccess' doesn't exist query: SELECT * FROM drupalaccess WHERE status = 0 AND type = 'host' AND LOWER('::1') LIKE LOWER(mask) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalcache' doesn't exist query: SELECT data, created, headers, expire FROM drupalcache WHERE cid = 'variables' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalvariable' doesn't exist query: SELECT * FROM drupalvariable in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalcache' doesn't exist query: LOCK TABLES drupalcache WRITE in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalcache' doesn't exist query: UPDATE drupalcache SET data = 'N;', created = 1152648000, expire = 0, headers = '' WHERE cid = 'variables' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalurl_alias' doesn't exist query: SELECT COUNT(pid) FROM drupalurl_alias in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Cannot modify header information - headers already sent by (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/common.inc on line 139.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT name, filename, throttle, bootstrap FROM drupalsystem WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT filename FROM drupalsystem WHERE name = 'filter' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT filename FROM drupalsystem WHERE name = 'node' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT filename FROM drupalsystem WHERE name = 'system' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT filename FROM drupalsystem WHERE name = 'user' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT filename FROM drupalsystem WHERE name = 'watchdog' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648002) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalcache' doesn't exist\nquery: SELECT data, created, headers, expire FROM drupalcache WHERE cid = 'menu::en' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalrole' doesn't exist\nquery: SELECT DISTINCT(p.perm) FROM drupalrole r INNER JOIN drupalpermission p ON p.rid = r.rid WHERE r.rid IN (1) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT * FROM drupalsystem WHERE type = 'theme' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120
     
  5. wmmk thread starter macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #5
    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalcache' doesn't exist\nquery: LOCK TABLES drupalcache WRITE in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalcache' doesn't exist\nquery: UPDATE drupalcache SET data = 'a:4:{s:10:\\"path index\\";a:44:{s:13:\\"admin/filters\\";i:-1;s:18:\\"admin/filters/list\\";i:-2;s:17:\\"admin/filters/add\\";i:-3;s:20:\\"admin/filters/delete\\";i:-4;s:11:\\"filter/tips\\";i:-5;s:10:\\"admin/node\\";i:-6;s:19:\\"admin/node/overview\\";i:-7;s:19:\\"admin/settings/node\\";i:-8;s:28:\\"admin/settings/content-types\\";i:-9;s:4:\\"node\\";i:-10;s:8:\\"node/add\\";i:-11;s:7:\\"rss.xml\\";i:-12;s:12:\\"system/files\\";i:-13;s:5:\\&qu in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Cannot modify header information - headers already sent by (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/common.inc on line 139.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT * FROM drupalsystem WHERE type = 'theme' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalurl_alias' doesn't exist\nquery: SELECT COUNT(pid) FROM drupalurl_alias in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table &#039;mysql.drupalwatchdog&#039; doesn&#039;t exist\nquery: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, &#039;access denied&#039;, &#039;<em>node</em> denied access.&#039;, 1, &#039;<a href=\\"/?q=node\\" class=\\"active\\">view</a>&#039;, &#039;http://localhost/&#039;, &#039;&#039;, &#039;::1&#039;, 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table &#039;mysql.drupalurl_alias&#039; doesn&#039;t exist\nquery: SELECT COUNT(pid) FROM drupalurl_alias in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120
     
  6. wmmk thread starter macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #6
    Access denied

    warning: Cannot modify header information - headers already sent by (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/common.inc on line 139.
    user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT name, filename, throttle, bootstrap FROM drupalsystem WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT filename FROM drupalsystem WHERE name = 'filter' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT filename FROM drupalsystem WHERE name = 'node' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT filename FROM drupalsystem WHERE name = 'system' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT filename FROM drupalsystem WHERE name = 'user' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT filename FROM drupalsystem WHERE name = 'watchdog' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalcache' doesn't exist query: SELECT data, created, headers, expire FROM drupalcache WHERE cid = 'menu::en' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalrole' doesn't exist query: SELECT DISTINCT(p.perm) FROM drupalrole r INNER JOIN drupalpermission p ON p.rid = r.rid WHERE r.rid IN (1) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT * FROM drupalsystem WHERE type = 'theme' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalcache' doesn't exist query: LOCK TABLES drupalcache WRITE in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
     
  7. wmmk thread starter macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #7
    user warning: Table 'mysql.drupalcache' doesn't exist query: UPDATE drupalcache SET data = 'a:4:{s:10:\"path index\";a:44:{s:13:\"admin/filters\";i:-1;s:18:\"admin/filters/list\";i:-2;s:17:\"admin/filters/add\";i:-3;s:20:\"admin/filters/delete\";i:-4;s:11:\"filter/tips\";i:-5;s:10:\"admin/node\";i:-6;s:19:\"admin/node/overview\";i:-7;s:19:\"admin/settings/node\";i:-8;s:28:\"admin/settings/content-types\";i:-9;s:4:\"node\";i:-10;s:8:\"node/add\";i:-11;s:7:\"rss.xml\";i:-12;s:12:\"system/files\";i:-13;s:5:\"admin\";i:-14;s:12:\"admin/themes\";i:-15;s:19:\"admin/themes/select\";i:-16;s:21:\"admin/themes/settings\";i:-17;s:28:\"admin/themes/settings/global\";i:-18;s:14:\"admin/settings\";i:-19;s:13:\"admin/modules\";i:-20;s:4:\"user\";i:-21;s:17:\"user/autocomplete\";i:-22;s:10:\"user/login\";i:-23;s:13:\"user/register\";i:-24;s:13:\"user/password\";i:-25;s:10:\"user/reset\";i:-26;s:9:\"user/help\";i:-27;s:10:\"admin/user\";i:-28;s:15:\"admin/user/list\";i:-29;s:17:\"admin/user/create\";i:-30;s:19:\"admin/settings/user\";i:-31;s:12:\"admin/access\";i:-32;s:24:\"admin/access/permissions\";i:-33;s:18:\"admin/access/roles\";i:-34;s:23:\"admin/access/roles/edit\";i:-35;s:18:\"admin/access/rules\";i:-36;s:23:\"admin/access/rules/list\";i:-37;s:22:\"admin/access/rules/add\";i:-38;s:24:\"admin/access/rules/check\";i:-39;s:23:\"admin/access/rules/edit\";i:-40;s:25:\"admin/access/rules/delete\";i:-41;s:6:\"logout\";i:-42;s:10:\"admin/logs\";i:-43;s:16:\"admin/logs/event\";i:-44;}s:5:\"items\";a:46:{i:0;a:5:{s:4:\"path\";s:0:\"\";s:5:\"title\";s:0:\"\";s:4:\"type\";i:1;s:3:\"pid\";i:1;s:8:\"children\";a:1:{i:0;i:1;}}i:1;a:7:{s:3:\"pid\";i:0;s:4:\"path\";s:0:\"\";s:5:\"title\";s:10:\"Navigation\";s:6:\"weight\";i:-50;s:6:\"access\";b:1;s:4:\"type\";i:3;s:8:\"children\";a:7:{i:0;i:-5;i:1;i:-10;i:2;i:-12;i:3;i:-13;i:4;i:-14;i:5;i:-21;i:6;i:-42;}}i:-1;a:7:{s:4:\"path\";s:13:\"admin/filters\";s:5:\"title\";s:13:\"input formats\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:3:{i:0;i:-2;i:1;i:-3;i:2;i:-4;}}i:-2;a:6:{s:4:\"path\";s:18:\"admin/filters/list\";s:5:\"title\";s:4:\"list\";s:4:\"type\";i:640;s:6:\"access\";b:0;s:6:\"weight\";i:0;s:3:\"pid\";i:-1;}i:-3;a:6:{s:4:\"path\";s:17:\"admin/filters/add\";s:5:\"title\";s:16:\"add input format\";s:4:\"type\";i:128;s:6:\"weight\";i:1;s:6:\"access\";b:0;s:3:\"pid\";i:-1;}i:-4;a:6:{s:4:\"path\";s:20:\"admin/filters/delete\";s:5:\"title\";s:19:\"delete input format\";s:4:\"type\";i:4;s:6:\"access\";b:0;s:6:\"weight\";i:0;s:3:\"pid\";i:-1;}i:-5;a:6:{s:4:\"path\";s:11:\"filter/tips\";s:5:\"title\";s:12:\"compose tips\";s:6:\"access\";b:1;s:4:\"type\";i:20;s:6:\"weight\";i:0;s:3:\"pid\";i:1;}i:-6;a:7:{s:4:\"path\";s:10:\"admin/node\";s:5:\"title\";s:7:\"content\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:1:{i:0;i:-7;}}i:-7;a:5:{s:4:\"path\";s:19:\"admin/node/overview\";s:5:\"title\";s:4:\"list\";s:4:\"type\";i:640;s:6:\"weight\";i:-10;s:3:\"pid\";i:-6;}i:-8;a:6:{s:4:\"path\";s:19:\"admin/settings/node\";s:5:\"title\";s:5:\"posts\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-19;}i:-9;a:6:{s:4:\"path\";s:28:\"admin/settings/content-types\";s:5:\"title\";s:13:\"content types\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-19;}i:-10;a:7:{s:4:\"path\";s:4:\"node\";s:5:\"title\";s:7:\"content\";s:6:\"access\";b:0;s:4:\"type\";i:16;s:6:\"weight\";i:0;s:3:\"pid\";i:1;s:8:\"children\";a:1:{i:0;i:-11;}}i:-11;a:6:{s:4:\"path\";s:8:\"node/add\";s:5:\"title\";s:14:\"create content\";s:6:\"access\";b:0;s:4:\"type\";i:28;s:6:\"weight\";i:1;s:3:\"pid\";i:-10;}i:-12;a:6:{s:4:\"path\";s:7:\"rss.xml\";s:5:\"title\";s:8:\"rss feed\";s:6:\"access\";b:0;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:1;}i:-13;a:6:{s:4:\"path\";s:12:\"system/files\";s:5:\"title\";s:13:\"file download\";s:6:\"access\";b:1;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:1;}i:-14;a:7:{s:4:\"path\";s:5:\"admin\";s:5:\"title\";s:10:\"administer\";s:6:\"access\";b:0;s:6:\"weight\";i:9;s:4:\"type\";i:22;s:8:\"children\";a:8:{i:0;i:-1;i:1;i:-6;i:2;i:-15;i:3;i:-19;i:4;i:-20;i:5;i:-28;i:6;i:-32;i:7;i:-43;}s:3:\"pid\";i:1;}i:-15;a:7:{s:4:\"path\";s:12:\"admin/themes\";s:5:\"title\";s:6:\"themes\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:2:{i:0;i:-16;i:1;i:-17;}}i:-16;a:6:{s:4:\"path\";s:19:\"admin/themes/select\";s:5:\"title\";s:4:\"list\";s:6:\"access\";b:0;s:4:\"type\";i:640;s:6:\"weight\";i:-1;s:3:\"pid\";i:-15;}i:-17;a:7:{s:4:\"path\";s:21:\"admin/themes/settings\";s:5:\"title\";s:9:\"configure\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-15;s:8:\"children\";a:1:{i:0;i:-18;}}i:-18;a:6:{s:4:\"path\";s:28:\"admin/themes/settings/global\";s:5:\"title\";s:15:\"global settings\";s:6:\"access\";b:0;s:4:\"type\";i:640;s:6:\"weight\";i:-1;s:3:\"pid\";i:-17;}i:-19;a:7:{s:4:\"path\";s:14:\"admin/settings\";s:5:\"title\";s:8:\"settings\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:8:\"children\";a:3:{i:0;i:-8;i:1;i:-9;i:2;i:-31;}s:3:\"pid\";i:-14;}i:-20;a:6:{s:4:\"path\";s:13:\"admin/modules\";s:5:\"title\";s:7:\"modules\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;}i:-21;a:7:{s:4:\"path\";s:4:\"user\";s:5:\"title\";s:12:\"user account\";s:6:\"access\";b:1;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:1;s:8:\"children\";a:6:{i:0;i:-22;i:1;i:-23;i:2;i:-24;i:3;i:-25;i:4;i:-26;i:5;i:-27;}}i:-22;a:6:{s:4:\"path\";s:17:\"user/autocomplete\";s:5:\"title\";s:17:\"user autocomplete\";s:6:\"access\";b:0;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-23;a:5:{s:4:\"path\";s:10:\"user/login\";s:5:\"title\";s:6:\"log in\";s:4:\"type\";i:640;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-24;a:6:{s:4:\"path\";s:13:\"user/register\";s:5:\"title\";s:8:\"register\";s:6:\"access\";b:1;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-25;a:6:{s:4:\"path\";s:13:\"user/password\";s:5:\"title\";s:20:\"request new password\";s:6:\"access\";b:1;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-26;a:6:{s:4:\"path\";s:10:\"user/reset\";s:5:\"title\";s:14:\"reset password\";s:6:\"access\";b:1;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-27;a:5:{s:4:\"path\";s:9:\"user/help\";s:5:\"title\";s:4:\"help\";s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-28;a:7:{s:4:\"path\";s:10:\"admin/user\";s:5:\"title\";s:5:\"users\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:2:{i:0;i:-29;i:1;i:-30;}}i:-29;a:5:{s:4:\"path\";s:15:\"admin/user/list\";s:5:\"title\";s:4:\"list\";s:4:\"type\";i:640;s:6:\"weight\";i:-10;s:3:\"pid\";i:-28;}i:-30;a:6:{s:4:\"path\";s:17:\"admin/user/create\";s:5:\"title\";s:8:\"add user\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-28;}i:-31;a:5:{s:4:\"path\";s:19:\"admin/settings/user\";s:5:\"title\";s:5:\"users\";s:4:\"type\";i:22;s:6:
     
  8. wmmk thread starter macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #8
    \"weight\";i:0;s:3:\"pid\";i:-19;}i:-32;a:7:{s:4:\"path\";s:12:\"admin/access\";s:5:\"title\";s:14:\"access control\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:3:{i:0;i:-33;i:1;i:-34;i:2;i:-36;}}i:-33;a:6:{s:4:\"path\";s:24:\"admin/access/permissions\";s:5:\"title\";s:11:\"permissions\";s:6:\"access\";b:0;s:4:\"type\";i:640;s:6:\"weight\";i:-10;s:3:\"pid\";i:-32;}i:-34;a:7:{s:4:\"path\";s:18:\"admin/access/roles\";s:5:\"title\";s:5:\"roles\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-32;s:8:\"children\";a:1:{i:0;i:-35;}}i:-35;a:6:{s:4:\"path\";s:23:\"admin/access/roles/edit\";s:5:\"title\";s:9:\"edit role\";s:6:\"access\";b:0;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-34;}i:-36;a:7:{s:4:\"path\";s:18:\"admin/access/rules\";s:5:\"title\";s:12:\"access rules\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:10;s:3:\"pid\";i:-32;s:8:\"children\";a:5:{i:0;i:-37;i:1;i:-38;i:2;i:-39;i:3;i:-40;i:4;i:-41;}}i:-37;a:6:{s:4:\"path\";s:23:\"admin/access/rules/list\";s:5:\"title\";s:4:\"list\";s:6:\"access\";b:0;s:4:\"type\";i:640;s:6:\"weight\";i:-10;s:3:\"pid\";i:-36;}i:-38;a:6:{s:4:\"path\";s:22:\"admin/access/rules/add\";s:5:\"title\";s:8:\"add rule\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-36;}i:-39;a:6:{s:4:\"path\";s:24:\"admin/access/rules/check\";s:5:\"title\";s:11:\"check rules\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-36;}i:-40;a:6:{s:4:\"path\";s:23:\"admin/access/rules/edit\";s:5:\"title\";s:9:\"edit rule\";s:6:\"access\";b:0;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-36;}i:-41;a:6:{s:4:\"path\";s:25:\"admin/access/rules/delete\";s:5:\"title\";s:11:\"delete rule\";s:6:\"access\";b:0;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-36;}i:-42;a:6:{s:4:\"path\";s:6:\"logout\";s:5:\"title\";s:7:\"log out\";s:6:\"access\";b:0;s:6:\"weight\";i:10;s:4:\"type\";i:22;s:3:\"pid\";i:1;}i:-43;a:6:{s:4:\"path\";s:10:\"admin/logs\";s:5:\"title\";s:4:\"logs\";s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:1:{i:0;i:-44;}}i:-44;a:5:{s:4:\"path\";s:16:\"admin/logs/event\";s:5:\"title\";s:7:\"details\";s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-43;}}s:9:\"callbacks\";a:41:{s:13:\"admin/filters\";a:1:{s:8:\"callback\";s:21:\"filter_admin_overview\";}s:18:\"admin/filters/list\";a:1:{s:8:\"callback\";s:21:\"filter_admin_overview\";}s:17:\"admin/filters/add\";a:1:{s:8:\"callback\";s:24:\"filter_admin_format_form\";}s:20:\"admin/filters/delete\";a:1:{s:8:\"callback\";s:19:\"filter_admin_delete\";}s:11:\"filter/tips\";a:1:{s:8:\"callback\";s:16:\"filter_tips_long\";}s:10:\"admin/node\";a:1:{s:8:\"callback\";s:16:\"node_admin_nodes\";}s:19:\"admin/settings/node\";a:1:{s:8:\"callback\";s:14:\"node_configure\";}s:28:\"admin/settings/content-types\";a:1:{s:8:\"callback\";s:20:\"node_types_configure\";}s:4:\"node\";a:1:{s:8:\"callback\";s:9:\"node_page\";}s:8:\"node/add\";a:1:{s:8:\"callback\";s:9:\"node_page\";}s:7:\"rss.xml\";a:1:{s:8:\"callback\";s:9:\"node_feed\";}s:12:\"system/files\";a:1:{s:8:\"callback\";s:13:\"file_download\";}s:5:\"admin\";a:1:{s:8:\"callback\";s:17:\"watchdog_overview\";}s:12:\"admin/themes\";a:1:{s:8:\"callback\";s:13:\"system_themes\";}s:19:\"admin/themes/select\";a:1:{s:8:\"callback\";s:13:\"system_themes\";}s:21:\"admin/themes/settings\";a:1:{s:8:\"callback\";s:21:\"system_theme_settings\";}s:28:\"admin/themes/settings/global\";a:1:{s:8:\"callback\";s:21:\"system_theme_settings\";}s:14:\"admin/settings\";a:1:{s:8:\"callback\";s:20:\"system_site_settings\";}s:13:\"admin/modules\";a:1:{s:8:\"callback\";s:14:\"system_modules\";}s:4:\"user\";a:1:{s:8:\"callback\";s:10:\"user_login\";}s:17:\"user/autocomplete\";a:1:{s:8:\"callback\";s:17:\"user_autocomplete\";}s:10:\"user/login\";a:1:{s:8:\"callback\";s:10:\"user_login\";}s:13:\"user/register\";a:1:{s:8:\"callback\";s:13:\"user_register\";}s:13:\"user/password\";a:1:{s:8:\"callback\";s:9:\"user_pass\";}s:10:\"user/reset\";a:1:{s:8:\"callback\";s:15:\"user_pass_reset\";}s:9:\"user/help\";a:1:{s:8:\"callback\";s:14:\"user_help_page\";}s:10:\"admin/user\";a:1:{s:8:\"callback\";s:10:\"user_admin\";}s:17:\"admin/user/create\";a:1:{s:8:\"callback\";s:10:\"user_admin\";}s:19:\"admin/settings/user\";a:1:{s:8:\"callback\";s:14:\"user_configure\";}s:12:\"admin/access\";a:1:{s:8:\"callback\";s:15:\"user_admin_perm\";}s:24:\"admin/access/permissions\";a:1:{s:8:\"callback\";s:15:\"user_admin_perm\";}s:18:\"admin/access/roles\";a:1:{s:8:\"callback\";s:15:\"user_admin_role\";}s:23:\"admin/access/roles/edit\";a:1:{s:8:\"callback\";s:15:\"user_admin_role\";}s:18:\"admin/access/rules\";a:1:{s:8:\"callback\";s:17:\"user_admin_access\";}s:22:\"admin/access/rules/add\";a:1:{s:8:\"callback\";s:21:\"user_admin_access_add\";}s:24:\"admin/access/rules/check\";a:1:{s:8:\"callback\";s:23:\"user_admin_access_check\";}s:23:\"admin/access/rules/edit\";a:1:{s:8:\"callback\";s:22:\"user_admin_access_edit\";}s:25:\"admin/access/rules/delete\";a:1:{s:8:\"callback\";s:24:\"user_admin_access_delete\";}s:6:\"logout\";a:1:{s:8:\"callback\";s:11:\"user_logout\";}s:10:\"admin/logs\";a:1:{s:8:\"callback\";s:17:\"watchdog_overview\";}s:16:\"admin/logs/event\";a:1:{s:8:\"callback\";s:14:\"watchdog_event\";}}s:7:\"visible\";a:2:{i:1;a:5:{s:5:\"title\";s:10:\"Navigation\";s:4:\"path\";s:0:\"\";s:8:\"children\";a:0:{}s:4:\"type\";i:3;s:3:\"pid\";i:0;}i:0;a:4:{s:5:\"title\";s:0:\"\";s:4:\"path\";s:0:\"\";s:8:\"children\";a:1:{i:0;i:1;}s:4:\"type\";i:1;}}}', created = 1152648003, expire = 1152734403, headers = '' WHERE cid = 'menu::en' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    warning: Cannot modify header information - headers already sent by (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/common.inc on line 139.
    user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT * FROM drupalsystem WHERE type = 'theme' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalurl_alias' doesn't exist query: SELECT COUNT(pid) FROM drupalurl_alias in /Library/WebServer/Documents/includes/database.mysql.inc on line 120. user warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'access denied', '<em>node</em> denied access.', 1, '<a href=\"/?q=node\" class=\"active\">view</a>', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
    user warning: Table 'mysql.drupalurl_alias' doesn't exist query: SELECT COUNT(pid) FROM drupalurl_alias in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
     
  9. wmmk thread starter macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #9
    You are not authorized to access this page.

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table &#039;mysql.drupalsessions&#039; doesn&#039;t exist\nquery: SELECT sid FROM drupalsessions WHERE sid = &#039;9d2f042596df3f5f016bcc0eec9deb51&#039; in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

    Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table &#039;mysql.drupalsessions&#039; doesn&#039;t exist\nquery: INSERT INTO drupalsessions (sid, uid, cache, hostname, session, timestamp) VALUES (&#039;9d2f042596df3f5f016bcc0eec9deb51&#039;, 0, 0, &#039;::1&#039;, &#039;&#039;, 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120
     
  10. wmmk thread starter macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #10
    Now could somebody tell me what all this goddeldygook actually MEANS?
    :confused: :mad: :eek:
     
  11. Squareball macrumors regular

    Joined:
    Mar 16, 2004
    Location:
    Palo Alto, CA
    #11
    Every one of those errors stems from this

    You don't have a database table named "mysql.drupalsessions" which is what Drupal is looking for. So maybe you missed a step where drupal creates this or maybe you have to create it yourself? I've never actually setup drual before
     
  12. wmmk thread starter macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #12
    ah, yes. you're right again. I'm supposed to do this:

    // $Id: INSTALL.mysql.txt,v 1.6 2006/04/17 20:48:25 dries Exp $

    CONTENTS OF THIS FILE
    ---------------------

    * Introduction
    * Installation and configuration:
    - Database and user creation
    - Drupal schema loading

    INTRODUCTION
    ------------

    This file describes how to create a MySQL database for Drupal.

    If you control your databases through a web-based control panel,
    check its documentation, as the following instructions are for the
    command line only.

    INSTALLATION AND CONFIGURATION
    ------------------------------

    1. CREATE THE DRUPAL DATABASE

    This step is only necessary if you don't already have a database
    set-up (e.g. by your host). In the following examples, 'dba_user' is
    an example MySQL user which has the CREATE and GRANT privileges. Use
    the appropriate user name for your system.

    First, you must create a new database for your Drupal site
    (here, 'databasename' is the name of the new database):

    mysqladmin -u dba_user -p create databasename

    MySQL will prompt for the 'dba_user' database password and then create
    the initial database files. Next you must login and set the access
    database rights:

    mysql -u dba_user -p

    Again, you will be asked for the 'dba_user' database password.
    At the MySQL prompt, enter following command:

    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
    ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
    ON databasename.*
    TO 'username'@'localhost' IDENTIFIED BY 'password';

    where

    'databasename' is the name of your database
    'username@localhost' is the username of your MySQL account
    'password' is the password required for that username

    Note: Unless your database user has all of the privileges listed
    above, you will not be able to run Drupal.

    If successful, MySQL will reply with:

    Query OK, 0 rows affected

    To activate the new permissions, enter the following command:

    FLUSH PRIVILEGES;

    2. LOAD THE DRUPAL DATABASE SCHEMA

    Once you have a database, you must load the required tables into it.
    Depending on the version of MySQL you are using, you must use the
    file 'database.4.0.mysql' (for MySQL 4.0 or lower) or
    'database.4.1.mysql' (for MySQL 4.1 or higher). Both files are
    located in Drupal's database directory.

    If you use a web-based control panel, you should be able to upload
    the appropriate file and run it directly as SQL commands.

    From the command line, use (again, replacing 'username' and
    'databasename' with your MySQL username and database name):

    for MySQL 4.0 or lower:
    mysql -u username -p databasename < database/database.4.0.mysql

    for MySQL 4.1 or higher:
    mysql -u username -p databasename < database/database.4.1.mysql


    So, how do I do this? In english? I feel like such a n00b today:eek:
     
  13. Squareball macrumors regular

    Joined:
    Mar 16, 2004
    Location:
    Palo Alto, CA
    #13
    I would try using CocoaMYSQL or just drop into the terminal and do what the instructions said step by step. They are pretty clear :)
     
  14. wmmk thread starter macrumors 68020

    wmmk

    Joined:
    Mar 28, 2006
    Location:
    The Library.
    #14
    LOL, not if you're a n00b to MySQL like I am:eek:
     

Share This Page