Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

error on install
 
Reply
   X-Cart forums > Considering X-Cart > Considering using X-Cart for my project
 
Thread Tools Search this Thread
  #1  
Old 02-01-2011, 07:06 AM
 
norman106 norman106 is offline
 

Newbie
  
Join Date: Feb 2011
Posts: 1
 

Default error on install

Hi, I'm trying to install X-Cart locally to test it out but I'm getting an error...

Quote:
xcart_tables.sql Creating table: [xcart_address_book] ... [FAILED] 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 'TYPE=MyISAM' at line 1

any idea how to fix it?

thanks!
__________________
hi
Reply With Quote
  #2  
Old 02-01-2011, 07:55 PM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 13,429
 

Default Re: error on install

Change "TYPE" to "ENGINE" in the sql files, in all of them
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote

The following user thanks cflsystems for this useful post:
ambal (02-02-2011)
  #3  
Old 03-11-2011, 02:12 PM
 
AQA pool supplies AQA pool supplies is offline
 

Newbie
  
Join Date: Jul 2010
Posts: 2
 

Default Re: error on install

How?

where?

on windows server 2003 with mysql 5.5.8
__________________
X-cart 4.3 x-magnifier x-configurator x-special offers
Reply With Quote
  #4  
Old 03-14-2011, 12:21 AM
  ADDISON's Avatar 
ADDISON ADDISON is offline
 

X-Man
  
Join Date: Jan 2008
Posts: 2,613
 

Default Re: error on install

Before starting X-Cart installation do the following:

1) Go to the folder you unzip the X-Cart and look for sql folder. It is in X-Cart root.

2) Open file named xcart_tables.sql with Wordpad

3) Menu Edit -> Replace ...

4) Find What: TYPE=MyISAM, Replace with: ENGINE=MyISAM. Push Replace All. Save your document.

5) Start X-Cart installation

Quote:
Originally Posted by AQA pool supplies
How?

where?

on windows server 2003 with mysql 5.5.8
__________________
X-Cart Next: Business 5.2 (learning and testing)
X-Cart Classic: Gold and Gold Plus 4.7
Lots of Modules and Customizations
OS in use: Red Hat Enterprise, Fedora, CentOS, Debian, Ubuntu, Linux Mint, Kali Linux
Ideas for Server configuration (basicaly): Nginx/Pound (reverse proxy), Apache/Nginx (webserver), Squid/Varnish (cache server), HHVM or (PHP-FPM + PHP 5.6 + opcache), MariaDB/Percona MySQL Server, Redis (storing sessions)

You can catch my ideas here: http://ideas.x-cart.com
Reply With Quote

The following 2 users thank ADDISON for this useful post:
ambal (03-14-2011), qualiteam (03-16-2011)
  #5  
Old 03-23-2013, 02:17 AM
 
jamiehype jamiehype is offline
 

Newbie
  
Join Date: Feb 2010
Posts: 3
 

Thumbs up Re: error on install

Quote:
Originally Posted by ADDISON
Before starting X-Cart installation do the following:

1) Go to the folder you unzip the X-Cart and look for sql folder. It is in X-Cart root.

2) Open file named xcart_tables.sql with Wordpad

3) Menu Edit -> Replace ...

4) Find What: TYPE=MyISAM, Replace with: ENGINE=MyISAM. Push Replace All. Save your document.

5) Start X-Cart installation

Great. thanks. This helped me.
I assumed it'l be x-cart's internal error but turns out that newer mysql versions don't support "TYPE" for specifying engine for the database table. "TYPE" is replaced with "ENGINE".
__________________
X- Cart Gold- Version 4.3.0
Reply With Quote
  #6  
Old 07-10-2013, 07:03 AM
 
Fran4 Fran4 is offline
 

Member
  
Join Date: Jul 2013
Posts: 11
 

Default Re: error on install

Same problem occurred with me. But I solved it myself. Just open the file xcart_tables.sql in notepad, pressed control+F and searched by MyISAM and replaced it with ENGINE.
__________________
Fran
Reply With Quote
Reply
   X-Cart forums > Considering X-Cart > Considering using X-Cart for my project


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 04:44 PM.

   

 
X-Cart forums © 2001-2018