Greetings,
I've ALMOST got my 4.6.3 install of drupal on IIS 6/Windows 2003 (MySQL5/PHP5) working. I've installed the patches here: http://drupal.org/node/26033 since I experienced several white pages of death or fatal errors.

THe problem I can't find a solution to on these boards is that when I try to create new content such as a story or page, I can preview and submit it, but then I get this:

Page not found
Your page was created.

So, as administrator, I go to my content admin area and no page/content has been created. What am I missing? I get the following error under administer:

page not found Nov 21 2005 - 9:08pm node/7 not found.

I'm not a programmer but I do realize there must be something incorrect in my node.module along the same lines as the patches addressed above.

Does anyone have a solution to this?
Many thanks.
Lsabug

Comments

Hugo Estrada’s picture

I was having the same problem when I tried to use drupal with MySQL 5.0. Once I switched to 4.1, I was able to post.

Remember to check the error messages, if you got any, by clicking 'administer' and looking for error messages in the recent events list. This is the list that appears automatically when you click administer. Look for recent error messages and click on 'detail' to find out what went wrong.

Hugo Estrada’s picture

I missed that when I wrote the previous post. Yes, you got to switch to 4.1 for Drupal to work.

lias’s picture

Thanks Hugo for the recommendation. But if I replace MySQL5 with 4.1 how will that affect future installations of other applications/cmses? Isn't there any other way to add content? My install seems to be functioning correctly with the exception of adding content so I know that the db accepts data. It doesn't seem to create nodes because everytime I try to add a page it says the content was created but the page is not found. And it can't find the respective node either.

SHould this issue be listed as a bug or at least documented in the installation process. I don't recall reading that 4.6.3 was incompatible with MySQL 5.
lsabug

lias’s picture

I took a look at the html source of the error and it's showing an access denied error.

[div class="breadcrumb"][/div][h2]Access denied[/h2]
[!-- begin content --]
You are not authorized to access this page.
[!-- end content --]

In PhpMyAdmin I looked at the node table and it gives the following error:

More than one INDEX key was created for column `status`

Now I'm guessing this IS a permissions issue. I've granted all privileges to the user of the drupal db. This user doesn't have global privileges. I tried giving them global privileges but still couldn't add content?

I took a look at the node table privileges and got the following errors:

User 'user'@'localhost' - Database drupal - Table node

*
Edit Privileges

Notice: Undefined index: strPrivDescCreate ViewTbl in D:\Inetpub\wwwdrupal\phpmyadmin\server_privileges.php on line 312

Notice: Undefined index: strPrivDescCreate ViewTbl in D:\Inetpub\wwwdrupal\phpmyadmin\server_privileges.php on line 313

Notice: Undefined index: strPrivDescShow viewTbl in D:\Inetpub\wwwdrupal\phpmyadmin\server_privileges.php on line 312

Notice: Undefined index: strPrivDescShow viewTbl in D:\Inetpub\wwwdrupal\phpmyadmin\server_privileges.php on line 313

Any ideas?
lsabug

lias’s picture

http://drupal.org/node/36110

http://drupal.org/node/36133

Quick addition to the error message of no page/node found:

Under administer I get the following:

Type php
Date Wednesday, November 23, 2005 - 20:13
User admin
Location /index.php?q=node/add/page
Message Field
'revisions' doesn't have a default value query: INSERT INTO node (status, moderate, promote, sticky, comment, title, body, format, uid, created, type, teaser, changed, nid) VALUES('1', '0', '1', '0', '2', 'test', 'test', '', '1', '1132776797', 'page', 'test', '1132776816', '1') in D:\Inetpub\wwwsol\includes\database.mysql.inc on line 66.
Severity error

Should I add a default value to the revisions field?
Thanks.
Lsabug

matt_s’s picture

MySQL 5 expects default field values to be specified for any field that is not explicitly provided in an insert operation.

You'll need to edit the database.mysql file before creating your database.

The 'node' table is missing a few default definitions for a start.

Matt.

lias’s picture

Thanks Matt for your reply. If you wouldn't mind, could you elaborate on editing the database.mysql file with regards to the 'node' table's missing definitions?

In the database.mysql file is this the section that needs to have default definitions?


--
-- Table structure for table 'node'
--

CREATE TABLE node (
nid int(10) unsigned NOT NULL auto_increment,
type varchar(16) NOT NULL default '',
title varchar(128) NOT NULL default '',
uid int(10) NOT NULL default '0',
status int(4) NOT NULL default '1',
created int(11) NOT NULL default '0',
changed int(11) NOT NULL default '0',
comment int(2) NOT NULL default '0',
promote int(2) NOT NULL default '0',
moderate int(2) NOT NULL default '0',
teaser longtext NOT NULL,
body longtext NOT NULL,
revisions longtext NOT NULL,
sticky int(2) NOT NULL default '0',
format int(4) NOT NULL default '0',
PRIMARY KEY (nid),
KEY node_type (type(4)),
KEY node_title_type (title,type(4)),
KEY status (status),
KEY uid (uid),
KEY node_moderate (moderate),
KEY node_promote_status (promote, status),
KEY node_created (created),
KEY node_changed (changed),
KEY node_status_type (status, type, nid)
) TYPE=MyISAM;

Thank you for your help. I feel I am so close to getting this Drupal install working I can almost taste it : )

Lsabug

mjshirley79’s picture

Did this work for anyone else?

I'd hate to have to redo all that I have done so far by droping all the tables...

Parish Blair’s picture

I had the same error. After using MySQL Administrator to edit the node table, and unchecking "Not Null" for the revisions column, I was able to add content without losing anything.

santino’s picture

that worked for me too. :)