ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

cannot add sql to template

February 21, 2011 6:46pm

Subscribe [3]
  • #1 / Feb 21, 2011 6:46pm

    shanemesser

    8 posts

    whenever I add sql to a template, it doesn’t work and instead redirects me to the home page of the entire website

    for example, going into a template and typeing only “SELECT * FROM XYZ” and hitting UPDATE takes me to the home page.  the issue here is the word FROM.  If i add the sql statement and use the word FROM, it simply doesn’t work.  I can update and edit templates as much as I want, however when I add a sql statement and hit update, it just doesn’t work.

  • #2 / Feb 21, 2011 7:11pm

    Mark Bowen

    12637 posts

    Sounds a bit weird. Are you using the actual {exp:query sql=""} code or just that text as above?

    I personally suspect a mod_security issue here.

    Best wishes,

    Mark

  • #3 / Feb 22, 2011 10:26am

    Sue Crocker

    26054 posts

    Thanks for the assist, Mark.

    Shane?

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases