Fatal error: mysql error (1064 error) -- v1.0-alpha

[DrByte]

I was also thinking [upgrading] would be the best way. I'm wondering how much trouble it's goin to be to import the database into a new cart.

Easy.
Backup the old database.
Import it to a new database for testing.
Upgrade it.
Customize the site (files etc)
Then move the new 'files' to the old site, and upgrade the old database in-place.

It's documented in the various instructions docs which can be found in the /docs folder of your Zen Cart files.

[Petike1007]

Hi!
I've got this message,when i try to send a newsletter?
Anyone knows the solution?

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 'WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or cust' at line 1
in:
[SELECT email_address as customers_email_address FROM WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address ]
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.

[DrByte]

You've installed an addon that alters or adds records in the query_builder table, and now you've got something in there that's got bad syntax, and is thus triggering your error.