Database Won't Update from 1.3.8 to 1.3.9

4 Jun 2011, 8:08 PM

#1

New Zenner

Join Date:: Jan 2004
Posts:: 8
Plugin Contributions:: 0

Database Won't Update from 1.3.8 to 1.3.9

It doesn't appear to be the same error that others are experiencing re: charsets...this is what the error message is...

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 'SELECT media_id FROM media_manager)' at line 1
in:
[DELETE FROM media_to_products where media_id not in ( SELECT media_id FROM media_manager);]

I did a test store with the same data, same files etc, the only difference was that the version of mySQL was newer. Is that what's causing the issue? If so are there any work arounds beyond creating a new database, backing up the old data into it and changing the config file info?

5 Jun 2011, 4:20 AM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: Database Won't Update from 1.3.8 to 1.3.9

What version of MySQL is on the server that you're running zc_install on?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

5 Jun 2011, 1:05 PM

#3

aevalin

New Zenner

Join Date:: Jan 2004
Posts:: 8
Plugin Contributions:: 0

Re: Database Won't Update from 1.3.8 to 1.3.9

DrByte:

What version of MySQL is on the server that you're running zc_install on?

mySQL 4.0
Apparently the hosting company updated what version of mySQL they use, so when I created my new test database, it was using 5.0.

5 Jun 2011, 2:03 PM

#4

aevalin

New Zenner

Join Date:: Jan 2004
Posts:: 8
Plugin Contributions:: 0

Re: Database Won't Update from 1.3.8 to 1.3.9

DrByte:

What version of MySQL is on the server that you're running zc_install on?

mySQL 4.0
Apparently the hosting company updated what version of mySQL they use, so when I created my new test database, it was using 5.0.

Ok - I suspect that may have been the issue. I updated the data in the mySQL database I used for testing and connected the site to it, did the database upgrade and it's fine and dandy now- or at least it seems to be.

5 Jun 2011, 5:39 PM

#5

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: Database Won't Update from 1.3.8 to 1.3.9

Should be fine using the newer version of MySQL.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.