Newsletter/ email error

[DanAllkins]

Hi.

I'm running Zen-cart 1.3.0.1 and have a problem sending emails and newsletters.

When I go to send them I get this error:

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.

Have I done somethign wrong or has something happend?

[bunyip]

What you appear to have is a mis-match between your database version and your fileset version. (What version info do you see when you go to Admin > Tools > Server Info ?)

You claim to be running v1.3.0.1, but the sql query string you are having problems with was only added to the database in v1.3.0.2

The function parsed_query_string($read_string) in includes/functions/audience.php was also modified in v1.3.0.2 to work with that sql query.

The version of that function file in your store hasn't been modified to work with that sql query string.

You're well overdue for a version upgrade...

[DanAllkins]

I went to Admin>Tools?server info and this is what I see

Zen Cart 1.3.0.1
Database Patch Level: 1.3.5
v1.3.0.2 [2006-10-13 12:04:41] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2006-10-13 12:04:40] (Version Update 1.3.0->1.3.0.1)
v1.3.0.1 [2006-08-02 14:55:22] (Fresh Installation)
v1.3.0.1 [2006-08-02 14:55:22] (Fresh Installation)


Cheers
Dan

[TheOracle]

Based on these issues, upgrading to the latest version of Zen-Cart would be a good idea.

[DanAllkins]

I was thinking about doing this.

The problem I may have is that when I built the shop I didnt use the override. I mearly changed the CSS files in Classic and template_default, and also any changes to the php files I did in these directories also... will I find an upgrade hard?

Dan

[TheOracle]

will I find an upgrade hard?

By following all the upgrade documentation from your docs folder (in the downloaded zip file), and by reading the wiki documentation from this site, there should be no problem for upgrading. However, make sure to do a full backup before proceeding.