While trying to load my zen cart 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 'cartupgrade_exceptions' at line 1. I am totally a novice at all of this and am not sure what I need to do to correct this problem. Any help would greatly be appreciated. Thanks in advance.
Results 1 to 7 of 7
-
17 Sep 2007, 05:59 PM #1
New Zenner
- Join Date
- Sep 2007
- Posts
- 4
- Plugin Contributions
- 0
1064 error cartupgrade_exceptions
-
17 Sep 2007, 07:07 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,450
- Plugin Contributions
- 81
Re: 1064 error cartupgrade_exceptions
What version of Zen Cart are you trying to install?
Why are you using a table-prefix? Is there a specific need for one? If not, try leaving it blank instead (ie: skip using "cart").
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.
-
17 Sep 2007, 08:22 PM #3
New Zenner
- Join Date
- Sep 2007
- Posts
- 4
- Plugin Contributions
- 0
Re: 1064 error cartupgrade_exceptions
i am installing the zen cart 3.7.1-full patched. Where would I delete using cart? again I am totally green. I thought this zen cart/ template would be a easy solution for my e-commerce store, I'm finding it a little more difficult than I expected.
-
17 Sep 2007, 08:26 PM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,450
- Plugin Contributions
- 81
Re: 1064 error cartupgrade_exceptions
*how* are you doing this install ?
.
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.
-
17 Sep 2007, 08:33 PM #5
New Zenner
- Join Date
- Sep 2007
- Posts
- 4
- Plugin Contributions
- 0
Re: 1064 error cartupgrade_exceptions
Downloaded the zen cart onto my hard drive- unziped the file - moved the files to my web site by the FTP program and ran the install. Everything was fine until after the questions about my SQL database was answered and then this error popped up.
-
17 Sep 2007, 08:35 PM #6
Sensei
- Join Date
- Jan 2004
- Posts
- 66,450
- Plugin Contributions
- 81
Re: 1064 error cartupgrade_exceptions
Okay -- then ... what I mentioned earlier about the "table prefix" being "cart" ..... Do you see on the "database setup" screen (the one you said asked about your SQL settings) where the "table prefix" is asked for (2nd field)? You'll note that it says if you don't need to use one, don't. Just leave it blank.
What happens then ?.
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.
-
17 Sep 2007, 09:06 PM #7
New Zenner
- Join Date
- Sep 2007
- Posts
- 4
- Plugin Contributions
- 0
Re: 1064 error cartupgrade_exceptions
Yahhhhhh! I have now moved on the my store setup! Thanks ever so much for the info. Your the best!!!!!
Similar Threads
-
Fatal error: mysql error (1064 error) -- v1.0-alpha
By Dale Schibbelhut in forum General QuestionsReplies: 9Last Post: 18 Nov 2010, 08:08 PM -
Error with new install 1.3.9d 1064 error in SQL syntax
By Joseph M in forum Installing on a Linux/Unix ServerReplies: 21Last Post: 28 Jun 2010, 06:36 PM -
Error message 1064 you have an error in your sql syntax
By honrheart in forum General QuestionsReplies: 1Last Post: 11 Sep 2009, 02:38 AM -
MySQL Error 1064 You have an error in your SQL syntax;
By dmm2020 in forum General QuestionsReplies: 2Last Post: 22 Feb 2009, 05:02 AM -
error message 1064 you have an error in your sql syntax
By ngsl in forum General QuestionsReplies: 0Last Post: 22 Aug 2008, 06:44 AM
