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?
Results 1 to 5 of 5
-
4 Jun 2011, 09: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
-
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, 02:05 PM #3
New Zenner
- Join Date
- Jan 2004
- Posts
- 8
- Plugin Contributions
- 0
Re: Database Won't Update from 1.3.8 to 1.3.9
mySQL 4.0
Originally Posted by DrByte
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, 03:03 PM #4
New Zenner
- Join Date
- Jan 2004
- Posts
- 8
- Plugin Contributions
- 0
Re: Database Won't Update from 1.3.8 to 1.3.9
mySQL 4.0 Originally Posted by DrByte
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.
-
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.
Reply With Quote
Similar Threads
-
Update database from 1.3.8 to 1.3.9
By bargincircus in forum Upgrading from 1.3.x to 1.3.9Replies: 3Last Post: 4 Dec 2010, 05:47 PM -
Products Won't Delete From Database
By TesterServers in forum General QuestionsReplies: 1Last Post: 6 Dec 2009, 01:39 AM -
sql tables won't update from admin
By cherylkemp in forum General QuestionsReplies: 6Last Post: 6 Aug 2009, 04:40 PM
Bookmarks