Error on install

13 years 7 months ago #13 by bsellers@lewisadvertising.com
Error on install was created by bsellers@lewisadvertising.com
Column length too big for column 'address' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS `jds2g_locatePlace` ( `id` int(11) NOT NULL auto_increment, `name` varchar(500) NOT NULL, `address` varchar(2000) NOT NULL default '', `lat` double NOT NULL default '0', `lng` double NOT NULL default '0', `catid` int NOT NULL default '1', `phone` varchar(2000) NOT NULL default '', `website` varchar(2000) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

Please Log in to join the conversation.

  • bsellers@lewisadvertising.com
  • Topic Author
  • Offline
More
13 years 7 months ago #14 by bsellers@lewisadvertising.com
Replied by bsellers@lewisadvertising.com on topic Error on install
And also...

Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1074
Column length too big for column 'address' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS `jds2g_locatePlace` ( `id` int(11) NOT NULL auto_increment, `name` varchar(500) NOT NULL, `address` varchar(2000) NOT NULL default '', `lat` double NOT NULL default '0', `lng` double NOT NULL default '0', `catid` int NOT NULL default '1', `phone` varchar(2000) NOT NULL default '', `website` varchar(2000) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

Please Log in to join the conversation.

  • bsellers@lewisadvertising.com
  • Topic Author
  • Offline
More
13 years 7 months ago - 13 years 7 months ago #16 by sysgenmedia
Replied by sysgenmedia on topic Error on install
I updated the Installation file to create proper columns according to the errors that you had received. That seems like it should solve the issues you had. Please let me know if you encounter any other problems so we can fix them right away.

We have now updated the Store Locator Component to v1.1.1. Please download the updated component from our Downloads Section.

Thanks,
Jared Bronz
Sysgen Media

Please Log in to join the conversation.

More