By NewbieOne on
This is my situation. I created a new drupal instance and linked it up with the database by creating a new database name. Everything show up fine in the database in the phpmyadmin page but none of the nodes are showing up in the node category. My new site has almost 20 nodes or pages but none of them are showing up in the node row. The browse icon is grayed out as well. Any help will be greatly appreciated.
Comments
If it's a new database and
If it's a new database and new Drupal install why do you expect there to be any nodes? The the browse icon is greyed out tells you that there are no rows in the table.
I didn't expect the nodes to
I didn't expect the nodes to be there at the time of the install but after adding several nodes in drupal I expected them to show up in the node row. Perhaps I am wrong in assuming that the database automatically updates. But if that is not the case, what is the point of having a database connected with a drupal site?
Do the nodes show on the
Do the nodes show on the site? Either on the front page or on the content admin page?
Oh yeah, they all show up
Oh yeah, they all show up fine. I can create new nodes ad infinitum, no problem. It's really strange for them not to show up in the nodes row.
I am guessing by "nodes row"
I am guessing by "nodes row" you mean the node table. Since Drupal is working, it sounds like you are looking at a different database that the one you have the site configured to use. You can look at sites/default/settings.php for $databases to see which database and login you have the site configured for.
I'm guessing that these need
I'm guessing that these need to be uncommented by removing all asterisks and specific info added:
* @code
* array(
* 'driver' => 'mysql',
* 'database' => 'databasename',
* 'username' => 'username',
* 'password' => 'password',
* 'host' => 'localhost',
* 'port' => 3306,
* 'prefix' => 'myprefix_',
* 'collation' => 'utf8_general_ci',
* );
* @endcode
I did this and and updated the database but no change in the node row in PhpMyAdmin.
Try using the same
Try using the same username/password to log into PhpMyAdmin, access the 'databasename' database and look at the table myprefix_node.
Hmmm... myprefix_node is not
Hmmm... myprefix_node is not an option in the phpMyAdmin menu. Here is what is available:
node
node_access
node_comment_statistics
node_revision
node_type
The only reference to myprefix is in the "settings.php" as 'prefix'=>'myprefix_',
this is really strange...
this is really strange... both databases are on the same mysql istances?