Sql error when email button selected in Coupons

[Ryk]

This error message appears when I select the email button in Coupon Admin for any coupon that's been created.

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ':admin_id' at line 1
in:
[select 'ADMIN' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from zen_admin where admin_id = $SESSION:admin_id ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

As there's no real hint (to me!) of where to start looking, I could do with some direction please.

I have tried re-loading the coupon_admin.php.

Site is 1.3.0.2

[Ajeh]

Reload the /includes/functions/audience.php see if that helps ...

[Ajeh]

NOTE: upgrading to v1.3.5 is of course suggested strongly ...

[Ryk]

NOTE: upgrading to v1.3.5 is of course suggested strongly ...

As it will be, but I can't do everyone at once!!

[paulm]

Same issue here it seems:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':admin_id' at line 1
in:
[select 'ADMIN' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from admin where admin_id = $SESSION:admin_id ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Trying to e-mail form customers.php . I have this problem on 1.3.5 (upgraded formolder version) and 1.3.0.1 (but that one is in the middle of an upgrade, and uses a 1.3.5 database so that could be the problem there).

Both on:

Server OS: Linux 2.6.17-1.2142_FC4 Database: MySQL 4.1.12-standard

PHP versie: 4.4.2 (Zend versie: 1.3.0)
HTTP Server: Apache/1.3.34 (Unix) mod_ssl/2.8.25 OpenSSL/0.9.7f PHP/4.4.2 mod_perl/1.29 FrontPage/5.0.2.2510

[paulm]

Hmmmm... a clean 1.3.5 install on the same server does not have this problem :-o

[paulm]

Weird: $SESSION ?

Shouldn't that be $_SESSION ? Or is that coming from elsewhere? (I see this in the error message: "where admin_id = $SESSION:admin_id")

[paulm]

The sql upgrade from 1301 to 1302 shows:

# add ability to send newsletters to self
INSERT INTO query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');

Is that correct?

[DrByte]

your includes/functions/audience.php is not up-to-date.

[paulm]

You are are right, thanks DrByte!

I knew I skipped some files, I wonder how many more I left out somehow

    } elseif ( substr( $val, 0, 9) == '$SESSION:' ) {
      //return the value of the SESSION var indicated
      $param = str_replace('$SESSION:', '', $val);
      $val = $_SESSION[$param];

And it also clarifies the mysterious $SESSION "var" :-)