By andyatkinson on

Hello. I'm running Drupal 4.6 through a web host with cPanel and Fantastico. Effective today, I can't update a node. I tried using my admin account and an account name that "created" the node (this account is also me). I can log-in and navigate around, but when I try to update a node, like by changing one character and hitting "preview" or "submit" -- I get a JavaScript alert in FF, and a "page not found" in IE.

Everything was fine last night. I've alerted my web host, although I think it is the drupal code and not the database that is acting up. Does anyone have a suggestion or experience? A db script I can run? Something I can do to "reset" the database?

I tried updating another node (to make sure it isn't just one) and am running into the same problem. Thanks in advance for any help.

⋅ Categories: Drupal 4.6.x

Comments

andyatkinson’s picture

andyatkinson commented

My web host has restarted the MySQL servers. I've also verified that I can't create any new node types, so it would appear that there are some permission errors. The problem still is that I can't modify any existing content or create new content. Is this a Drupal problem or a web host problem?

I have not seen anything strange in the log files, and one user left a comment on a node this morning (same day I noticed the problem), so I think there is some sort of "write" capability.

What are some troubleshooting tips I can try? I've been searching on and off for a couple hours and have found nothing.

I emptied the "cache" table. Are there other tables I can safely empty or drop? Can someone recommend a SQL script I can use to make sure my account permissions have not gotten corrupted?

Help?

Hugo Estrada’s picture

Hugo Estrada commented

Ask your host if they upgraded to MySQL 5.0. I and other people have ran into this problem.

http://drupal.org/node/38436

JasonDiceman’s picture

JasonDiceman commented

Using MySQL version 4.0.25-standard I get the same error - also running fron a cPanel (Build 10.8.1-RELEASE 30) Fantasico installation.

I noticed the error happens when the content includes "cc"
Weird.

Any ideas?