Welcome, Guest
Username: Password: Remember me
Support for Eventlist 1.0.1

For all support requests, please provide your current versions of Joomla, and of the extensions.
  • Page:
  • 1

TOPIC:

error installing EventList "help" 8 years 10 months ago #6710

  • jonmi
  • jonmi's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 1
  • Thank you received: 0
English
EventList 1.0.1 to install it gives me error
which could be the solution, and try changing TYPE = MyISAM to ENGINE = MyISAM
I can not fix
I have joomla 1.5.26
I speak Spanish, if you can help would be much better in Spanish

español
al instalar eventlist 1.0.1 me da error
ya intentes solucionarlo cambiando TYPE = MyISAM to ENGINE = MyISAM
pero no puedo solucionarlo
uso joomla 1.5.26
hablo español, si pueden ayudarme en español seria mucho mejor

error
JInstaller::install: SQL Error. DB function failed with error number 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 'TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 29 SQL=CREATE TABLE IF NOT EXISTS `jos_eventlist_events` ( `id` int(11) unsigned NOT NULL auto_increment, `locid` int(11) unsigned NOT NULL default '0', `catsid` int(11) unsigned NOT NULL default '0', `dates` date NOT NULL default '0000-00-00', `enddates` date NULL default NULL, `times` time NULL default NULL, `endtimes` time NULL default NULL, `title` varchar(100) NOT NULL default '', `alias` varchar(100) NOT NULL default '', `created_by` int(11) unsigned NOT NULL default '0', `modified` datetime NOT NULL, `modified_by` int(11) unsigned NOT NULL default '0', `author_ip` varchar(15) NOT NULL default '', `created` datetime NOT NULL, `datdescription` mediumtext NOT NULL, `meta_keywords` varchar(200) NOT NULL default '', `meta_description` varchar(255) NOT NULL default '', `recurrence_number` int(2) NOT NULL default '0', `recurrence_type` int(2) NOT NULL default '0', `recurrence_counter` date NOT NULL default '0000-00-00', `datimage` varchar(100) NOT NULL default '', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `registra` tinyint(1) NOT NULL default '0', `unregistra` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =
CREATE TABLE IF NOT EXISTS `jos_eventlist_events` (
`id` int(11) unsigned NOT NULL auto_increment,
`locid` int(11) unsigned NOT NULL default '0',
`catsid` int(11) unsigned NOT NULL default '0',
`dates` date NOT NULL default '0000-00-00',
`enddates` date NULL default NULL,
`times` time NULL default NULL,
`endtimes` time NULL default NULL,
`title` varchar(100) NOT NULL default '',
`alias` varchar(100) NOT NULL default '',
`created_by` int(11) unsigned NOT NULL default '0',
`modified` datetime NOT NULL,
`modified_by` int(11) unsigned NOT NULL default '0',
`author_ip` varchar(15) NOT NULL default '',
`created` datetime NOT NULL,
`datdescription` mediumtext NOT NULL,
`meta_keywords` varchar(200) NOT NULL default '',
`meta_description` varchar(255) NOT NULL default '',
`recurrence_number` int(2) NOT NULL default '0',
`recurrence_type` int(2) NOT NULL default '0',
`recurrence_counter` date NOT NULL default '0000-00-00',
`datimage` varchar(100) NOT NULL default '',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`registra` tinyint(1) NOT NULL default '0',
`unregistra` tinyint(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY  (`id`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 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 'TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 29 SQL=CREATE TABLE IF NOT EXISTS `jos_eventlist_events` ( `id` int(11) unsigned NOT NULL auto_increment, `locid` int(11) unsigned NOT NULL default '0', `catsid` int(11) unsigned NOT NULL default '0', `dates` date NOT NULL default '0000-00-00', `enddates` date NULL default NULL, `times` time NULL default NULL, `endtimes` time NULL default NULL, `title` varchar(100) NOT NULL default '', `alias` varchar(100) NOT NULL default '', `created_by` int(11) unsigned NOT NULL default '0', `modified` datetime NOT NULL, `modified_by` int(11) unsigned NOT NULL default '0', `author_ip` varchar(15) NOT NULL default '', `created` datetime NOT NULL, `datdescription` mediumtext NOT NULL, `meta_keywords` varchar(200) NOT NULL default '', `meta_description` varchar(255) NOT NULL default '', `recurrence_number` int(2) NOT NULL default '0', `recurrence_type` int(2) NOT NULL default '0', `recurrence_counter` date NOT NULL default '0000-00-00', `datimage` varchar(100) NOT NULL default '', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `registra` tinyint(1) NOT NULL default '0', `unregistra` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =
CREATE TABLE IF NOT EXISTS `jos_eventlist_events` (
`id` int(11) unsigned NOT NULL auto_increment,
`locid` int(11) unsigned NOT NULL default '0',
`catsid` int(11) unsigned NOT NULL default '0',
`dates` date NOT NULL default '0000-00-00',
`enddates` date NULL default NULL,
`times` time NULL default NULL,
`endtimes` time NULL default NULL,
`title` varchar(100) NOT NULL default '',
`alias` varchar(100) NOT NULL default '',
`created_by` int(11) unsigned NOT NULL default '0',
`modified` datetime NOT NULL,
`modified_by` int(11) unsigned NOT NULL default '0',
`author_ip` varchar(15) NOT NULL default '',
`created` datetime NOT NULL,
`datdescription` mediumtext NOT NULL,
`meta_keywords` varchar(200) NOT NULL default '',
`meta_description` varchar(255) NOT NULL default '',
`recurrence_number` int(2) NOT NULL default '0',
`recurrence_type` int(2) NOT NULL default '0',
`recurrence_counter` date NOT NULL default '0000-00-00',
`datimage` varchar(100) NOT NULL default '',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`registra` tinyint(1) NOT NULL default '0',
`unregistra` tinyint(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY  (`id`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

Please Log in or Create an account to join the conversation.

Re: error installing EventList "help" 8 years 5 months ago #7554

Hi jonmi,

I had the same problem; since MySQL 5.5 the TYPE keyword is not allowed anymore. I unzipped the file, edited the files
admin/install.mysql.nonutf8.sql
admin/install.mysql.utf8.sql

replacing TYPE by ENGINE, zipped it again to the same filename and it installed ok in Joomla 1.5.26. Note: I did not find the same (or other) issues in the accompanying files
nl-NL.com_eventList_1.0.1_all.zip
plg_eventlist_mailer_1.0.1_schlu.zip
plg_eventlist_search_1.0.1_schlu.zip

The fixed file is attached.

Cheers,
Jan

Please Log in or Create an account to join the conversation.

Re: error installing EventList "help" 8 years 5 months ago #7555

The fixed file is too large for the forum, but you can do it yourself now.

Please Log in or Create an account to join the conversation.

error installing EventList "help" 8 years 1 month ago #8028

  • jojo12
  • jojo12's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 3334
  • Karma: 45
  • Thank you received: 363
Sorry, I think this is a kind of SPAM - don't use
on JEM 2.3.0 stable in latest Joomla (3.9.22) Protostar php7.4.5

Please Log in or Create an account to join the conversation.

error installing EventList "help" 8 years 1 month ago #8030

Hi All,

while I'm not active in the community in the moment, I will still make time to remove spammers and their spam (like I have above.)

regards,
Edmond
NEW? Please read the Welcome to the EventList Community post.
Click here to find out "How to get your issue solved quickly!"

EventList 1.0.2 Stable for Joomla 1.6/1.7/2.5 now available!
The following user(s) said Thank You: NEYW, jojo12

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.294 seconds

Donate

If you find JEM useful and if you use it on your site, please consider a donation to the project.

Private Messages

You are not logged in.

Follow us......