Help - Search - Members - Calendar
Full Version: Can't use the text "insert into"
Movable Type Community Forum > Other Product Discussion > Bugs and Odd Behavior
dvd
If I use the text "insert into" anywhere in a post, MT [version 3.11] completely gives up the ghost and reports a 500 Internal Server error, not even allowing the entry preview, let alone saving it.

It even does it with a post that contains nothing but the text "insert into".

I'm not kidding! huh.gif
dvd
Perhaps it's worth pointing out that INSERT INTO is a mySQL command. Still not sure why anything that's in an entry field would be parsed as a command instead of just saved in the database.
dvd
DELETE FROM also causes a 500 error.
shelley
I was able to create an entry with both of those in it without incident.

Are you using any plugins that might cause this?
dvd
QUOTE (shelley @ Sep 28 2004, 07:54 PM)
Are you using any plugins that might cause this?

I'd not thought of that. Unfortunately, no joy. I deleted all of my plugins and still had the same problem.
dvd
I've discovered it also affects comments on my site: you can't submit [or even preview] a comment which contains INSERT INTO or DELETE FROM.
shelley
Hmm. I can enter those statements into a comment too. huh.gif

Do you have background tasks enabled?

What database option are you using?
dvd
QUOTE (shelley @ Sep 28 2004, 08:56 PM)
Do you have background tasks enabled?

What database option are you using?

Yes, I have background tasks enabled, but disabling them didn't fix it. sad.gif

I'm using the mySQL option, which is why I thought there might be something to do with the fact these strings are SQL commands.
dvd
Okay, I had a brainwave and it seems that this problem is common to MT weblogs that share the same host as me. I'm contacting their support desk now to see if they can help!
crz-e-d
According to this Bug report this issue is due to a configuration issue of the ModSecurity software.

Get in touch with your ISP.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.