Sql error when email button selected in Coupons

[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.