mysql error

Locked

Started by ramanuk on 13 Mar 2007, 9:33 PM · Views: 2,099

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
13 Mar 2007, 9:33 PM
#1
ramanuk avatar

ramanuk

New Zenner

Join Date:
Mar 2007
Posts:
4
Plugin Contributions:
0

mysql error

i have this in my server info
** Zen Cart 1.2.6**

 ** Database Patch Level:  1.3.5

**

when i try to send email out 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

Can anyone please guide the right way to proceed and fix the problem.

Thanx

13 Mar 2007, 9:41 PM
#2
louis avatar

louis

Zen Follower

Join Date:
Jul 2006
Location:
Johannesburg
Posts:
408
Plugin Contributions:
0

Re: mysql error

From what I can see your software version and database version is completely out of sync. 1.2.6 versus 1.3.5. :no:

I suggest you update to the latest version 1.3.7 or at least update your program files to 1.3.5 to get in sync with the database.

13 Mar 2007, 9:46 PM
#3
ramanuk avatar

ramanuk

New Zenner

Join Date:
Mar 2007
Posts:
4
Plugin Contributions:
0

Re: mysql error

Thanx for your reply.
ok for upgrading to 1.3.7, is there a specific patch files or whats the right way to of upgrading.

Thanx

13 Mar 2007, 9:52 PM
#4
louis avatar

louis

Zen Follower

Join Date:
Jul 2006
Location:
Johannesburg
Posts:
408
Plugin Contributions:
0

Re: mysql error

I suggest you download the FULL 1.3.7 from the download link above. (top of page)

Is this shop running live?

13 Mar 2007, 9:59 PM
#5
ramanuk avatar

ramanuk

New Zenner

Join Date:
Mar 2007
Posts:
4
Plugin Contributions:
0

Re: mysql error

Yes the shop is live.
Replacing 1.3.7 full files will change the frontend aswell and how to go about upgrading DB as it has already got data in it.

14 Mar 2007, 10:41 AM
#6
ramanuk avatar

ramanuk

New Zenner

Join Date:
Mar 2007
Posts:
4
Plugin Contributions:
0

Re: mysql error

Is there any exact change log for files which have been changed for
**1.2.6 to 1.3.7

I need to upgrade to latest version so looking for what files to replace from latest version.

Thanx
**

15 Mar 2007, 7:39 PM
#7
louis avatar

louis

Zen Follower

Join Date:
Jul 2006
Location:
Johannesburg
Posts:
408
Plugin Contributions:
0

Re: mysql error

Upgrading from 1.2.x to 1.3.x is a big step. New functionality and structures were introduced with the release of 1.3

You should copy your live shop to a local server (not live) install the FULL 1.3.7 and then make all the required changes on the store front. Once you are satisfied with the end product you could just port this to production.

BACKUP, BACKUP first.

For more detail on upgrading from 1.2 to 1.3 just search the forum. There are a number of threads dealing with the various procedures.

Good Luck