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
What db are you using?
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.
Ah, you are using 5.0!
I missed that when I wrote the previous post. Yes, you got to switch to 4.1 for Drupal to work.
Replace MySQL5 with MySQL 4.1 in order to add new content?
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
Page/node not found error continuation...
I took a look at the html source of the error and it's showing an access denied error.
In PhpMyAdmin I looked at the node table and it gives the following error:
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:
Any ideas?
lsabug
More troubleshooting info on MySQL 5 here
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:
Should I add a default value to the revisions field?
Thanks.
Lsabug
Default field values missing from table definitions
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.
Editing the database.mysql file for MySQL 5 to add page content
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
This discussion might fix your content creation problems
http://drupal.org/node/40178
This didn't seem to do the trick...
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...
Fixed by unchecking "Not Null"...
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.
Thanks Parish
that worked for me too. :)