- Mensajes
- 121
- Puntuación de reacción
- 0
soy novato en esto de instalar scripts
estoy intentando instalar una version del script interspire email marketer ya la probe y en 000webhost funciona bien peo en localhost me bota full errores no entiendo esto me aparece:
Oops, something went wrong...
While trying to install the database the following errors occurred:
Unable to run the following query: CREATE TABLE email_usergroups ( groupid INT NOT NULL AUTO_INCREMENT, groupname VARCHAR(255) NOT NULL, createdate INT NOT NULL, limit_list INT DEFAULT 0, limit_hourlyemailsrate INT DEFAULT 0, limit_emailspermonth INT DEFAULT 0, limit_totalemailslimit INT DEFAULT NULL, forcedoubleoptin CHAR(1) DEFAULT '0', forcespamcheck CHAR(1) DEFAULT '0', systemadmin CHAR(1) DEFAULT '0', listadmin CHAR(1) DEFAULT '0', segmentadmin CHAR(1) DEFAULT '0', templateadmin CHAR(1) DEFAULT '0', PRIMARY KEY (groupid) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_usergroups_permissions ( groupid INT NOT NULL, area VARCHAR(255) NOT NULL, subarea VARCHAR(255) DEFAULT NULL, FOREIGN KEY (groupid) REFERENCES email_usergroups(groupid) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_usergroups_access ( groupid INT NOT NULL, resourcetype VARCHAR(100) NOT NULL, resourceid INT NOT NULL, FOREIGN KEY (groupid) REFERENCES email_usergroups(groupid) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_users ( userid INT AUTO_INCREMENT NOT NULL, groupid INT NOT NULL, trialuser CHAR(1) DEFAULT '0', username VARCHAR(255) NOT NULL, unique_token VARCHAR(128) DEFAULT NULL, password VARCHAR(32) DEFAULT NULL, admintype CHAR(1) DEFAULT NULL, listadmintype CHAR(1) DEFAULT NULL, templateadmintype CHAR(1) DEFAULT NULL, segmentadmintype CHAR(1) DEFAULT NULL, status CHAR(1) DEFAULT '0', fullname VARCHAR(255) DEFAULT NULL, emailaddress VARCHAR(100) DEFAULT NULL, settings TEXT DEFAULT NULL, editownsettings CHAR(1) DEFAULT '0', usertimezone VARCHAR(10) DEFAULT NULL, textfooter TEXT DEFAULT NULL, htmlfooter TEXT DEFAULT NULL, infotips CHAR(1) DEFAULT '1', smtpserver VARCHAR(255) DEFAULT NULL, smtpusername VARCHAR(255) DEFAULT NULL, smtppassword VARCHAR(255) DEFAULT NULL, smtpport INT DEFAULT 0, createdate INT DEFAULT 0, lastloggedin INT DEFAULT 0, forgotpasscode CHAR(32) DEFAULT '', usewysiwyg CHAR(1) DEFAULT '1', enableactivitylog CHAR(1) DEFAULT '0', xmlapi CHAR(1) DEFAULT '0', xmltoken CHAR(40) DEFAULT NULL, gettingstarted INT NOT NULL DEFAULT 0, googlecalendarusername VARCHAR(255) DEFAULT NULL, googlecalendarpassword VARCHAR(255) DEFAULT NULL, user_language VARCHAR(25) NOT NULL DEFAULT 'default', eventactivitytype LONGTEXT DEFAULT NULL, credit_warning_time INT DEFAULT NULL, -- The last time credit_warning was sent out to this user credit_warning_percentage INT DEFAULT NULL, -- At which percentage credit_warning_fixed INT DEFAULT NULL, -- or at which credit level adminnotify_email VARCHAR(100) DEFAULT NULL, adminnotify_send_flag CHAR(1) DEFAULT '0', adminnotify_send_threshold INT DEFAULT NULL, adminnotify_send_emailtext TEXT DEFAULT NULL, adminnotify_import_flag CHAR(1) DEFAULT '0', adminnotify_import_threshold INT DEFAULT NULL, adminnotify_import_emailtext TEXT DEFAULT NULL, PRIMARY KEY (userid), FOREIGN KEY (groupid) REFERENCES email_usergroups(groupid) ON DELETE RESTRICT ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_autoresponders ( autoresponderid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, subject varchar(255) default NULL, format char(1) default NULL, textbody longtext, htmlbody longtext, createdate int(11) default 0, active int default 0, pause int default 0, hoursaftersubscription int(11) default 0, ownerid int(11) NOT NULL default 0 references email_users(userid), searchcriteria mediumtext, listid int(11) default 0 references email_lists(listid), tracklinks char(1) default 1, trackopens char(1) default 1, multipart char(1) default 1, queueid int(11) default 0, sendfromname varchar(255) default NULL, sendfromemail varchar(255) default NULL, replytoemail varchar(255) default NULL, bounceemail varchar(255) default NULL, charset varchar(255) default NULL, embedimages char(1) default '0', to_firstname int default 0 references email_customfields(fieldid), to_lastname int default 0 references email_customfields(fieldid), autorespondersize int default 0 ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_banned_emails ( banid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, emailaddress varchar(255) default NULL, list varchar(10) default NULL, bandate int(11) default NULL ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_customfield_lists ( cflid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, fieldid int(11) NOT NULL default '0' references email_customfields(fieldid), listid int(11) NOT NULL default '0' references email_lists(listid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_customfields ( fieldid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, fieldtype varchar(100) default NULL, defaultvalue varchar(255) default NULL, required char(1) default 0, fieldsettings mediumtext, createdate int(11) default 0, ownerid int(11) default 0 references email_users(userid), isglobal char(1) default '0' ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_form_customfields ( formid int(11) default 0 references email_forms(formid), fieldid varchar(10) default 0 references email_customfields(fieldid), fieldorder int default 0 ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_form_lists ( formid int(11) default 0 references email_forms(formid), listid int(11) default 0 references email_lists(listid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_form_pages ( pageid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, formid int(11) default 0 references email_forms(formid), pagetype varchar(100) default NULL, html longtext, url varchar(255) default NULL, sendfromname varchar(255) default NULL, sendfromemail varchar(255) default NULL, replytoemail varchar(255) default NULL, bounceemail varchar(255) default NULL, emailsubject varchar(255) default NULL, emailhtml longtext, emailtext longtext ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_forms ( formid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, design varchar(255) default NULL, formhtml longtext, chooseformat varchar(2) default NULL, changeformat varchar(1) default 0, sendthanks varchar(1) default 0, requireconfirm varchar(1) default 0, ownerid int(11) default 0 references email_users(userid), formtype char(1) default NULL, createdate int(11) default 0, contactform varchar(1) default 0, usecaptcha varchar(1) default 0 ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_jobs ( jobid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, jobtype varchar(255) default NULL, jobstatus char(1) default NULL, jobtime int(11) default 0, jobdetails text, fkid int(11) default '0', lastupdatetime int(11) default '0', fktype varchar(255) default NULL, queueid int(11) default '0', ownerid int(11) default 0 references email_users(userid), approved int default 0 references email_users(userid), authorisedtosend int default 0 references email_users(userid), resendcount int default 0 ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_jobs_lists ( jobid int(11) default 0 references email_jobs(jobid), listid int(11) default 0 references email_lists(listid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_list_subscribers ( subscriberid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, listid int(11) NOT NULL default '0' references email_lists(listid), emailaddress varchar(200), domainname varchar(100), format char(1) default NULL, confirmed char(1) default 0, confirmcode varchar(32) default NULL, requestdate int(11) default '0', requestip varchar(20) default NULL, confirmdate int(11) default '0', confirmip varchar(20) default NULL, subscribedate int(11) default '0', bounced int(11) default '0', unsubscribed int(11) default '0', unsubscribeconfirmed char(1) default 0, formid int(11) default '0' ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_list_subscribers_unsubscribe ( subscriberid int(11) NOT NULL default '0' references email_list_subscribers(subscriberid), unsubscribetime int(11) NOT NULL default '0', unsubscribeip varchar(20) default NULL, unsubscriberequesttime int(11) default '0', unsubscriberequestip varchar(20) default NULL, listid int(11) NOT NULL default '0' references email_lists(listid), statid int(11) default '0', unsubscribearea varchar(20) default NULL ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_lists ( listid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, ownername varchar(255) default NULL, owneremail varchar(100) default NULL, bounceemail varchar(100) default NULL, replytoemail varchar(100) default NULL, bounceserver varchar(100) default NULL, bounceusername varchar(100) default NULL, bouncepassword varchar(100) default NULL, extramailsettings varchar(100) default NULL, companyname varchar(255) default NULL, companyaddress varchar(255) default NULL, companyphone varchar(20) default NULL, format char(1) default NULL, notifyowner char(1) default 0, imapaccount char(1) default 0, createdate int(11) default 0, subscribecount int(11) default '0', unsubscribecount int(11) default '0', bouncecount int(11) default '0', processbounce char(1) default '0', agreedelete char(1) default '0', agreedeleteall char(1) default '0', visiblefields text not null, ownerid int(11) default 0 references email_users(userid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_newsletters ( newsletterid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, format char(1) default NULL, subject varchar(255) default NULL, textbody longtext, htmlbody longtext, createdate int(11) default 0, active int default 0 references email_users(userid), archive int default 0 references email_users(userid), ownerid int(11) NOT NULL default '0' references email_users(userid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_queues ( queueid int(11) default '0', queuetype varchar(255) default NULL, ownerid int(11) NOT NULL default '0' references email_users(userid), recipient int(11) default 0 references email_list_subscribers(subscriberid), processed char(1) default '0', sent char(1) default '0', processtime datetime ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_queues_sequence ( id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: INSERT INTO email_queues_sequence(id) VALUES (0) (Table 'data.email_queues_sequence' doesn't exist)
Unable to run the following query: CREATE TABLE email_settings ( cronok char(1) default '0', cronrun1 int(11) default '0', cronrun2 int(11) default '0', database_version int default '0' ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: INSERT INTO email_settings(cronok, cronrun1, cronrun2, database_version) VALUES (0, 0, 0, 20130816) (Table 'data.email_settings' doesn't exist)
Unable to run the following query: CREATE TABLE email_config_settings(area varchar(255), areavalue text) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_settings_cron_schedule ( jobtype VARCHAR(20), lastrun INT default '0' ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: INSERT INTO email_settings_cron_schedule (jobtype, lastrun) VALUES ('send', '-1') (Table 'data.email_settings_cron_schedule' doesn't exist)
Unable to run the following query: INSERT INTO email_settings_cron_schedule (jobtype, lastrun) VALUES ('bounce', '-1') (Table 'data.email_settings_cron_schedule' doesn't exist)
Unable to run the following query: INSERT INTO email_settings_cron_schedule (jobtype, lastrun) VALUES ('autoresponder', '-1') (Table 'data.email_settings_cron_schedule' doesn't exist)
Unable to run the following query: CREATE TABLE email_list_subscriber_bounces ( bounceid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, subscriberid int(11) default 0 references email_list_subscribers(subscriberid), statid int(11) default 0, listid int(11) default 0 references email_lists(listid), bouncetime int(11) default 0, bouncetype varchar(255) default NULL, bouncerule varchar(255) default NULL, bouncemessage longtext ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_autoresponders ( statid int(11) NOT NULL default '0', htmlrecipients int(11) default '0', textrecipients int(11) default '0', multipartrecipients int(11) default '0', bouncecount_soft int(11) default '0', bouncecount_hard int(11) default '0', bouncecount_unknown int(11) default '0', unsubscribecount int(11) default '0', autoresponderid int(11) default '0' references email_autoresponders(autoresponderid), linkclicks int(11) default '0', emailopens int(11) default '0', emailforwards int(11) default '0', emailopens_unique int(11) default '0', htmlopens int default 0, htmlopens_unique int default 0, textopens int default 0, textopens_unique int default 0, hiddenby int default 0 references email_users(userid), PRIMARY KEY(statid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_emailopens ( openid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, subscriberid int(11) default 0 references email_list_subscribers(subscriberid), statid int(11) default 0, opentime int(11) default 0, openip varchar(20) default NULL, fromlink CHAR(1) DEFAULT 0, opentype char(1) DEFAULT 'u' ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_linkclicks ( clickid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, clicktime int(11) default 0, clickip varchar(20) default NULL, subscriberid int(11) default 0 references email_list_subscribers(subscriberid), statid int(11) default 0, linkid int(11) default 0 references email_links(linkid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_links ( statid int(11) default 0, linkid int(11) default 0 references email_links(linkid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_links ( linkid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, url varchar(255) default NULL ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_newsletter_lists ( statid int(11) default NULL, listid int(11) default 0 references email_lists(listid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_newsletters ( statid int(11) NOT NULL default '0', queueid int(11) default 0, jobid int(11) default 0 references email_jobs(jobid), starttime int(11) default 0, finishtime int(11) default 0, htmlrecipients int(11) default '0', textrecipients int(11) default '0', multipartrecipients int(11) default '0', trackopens char(1) default '0', tracklinks char(1) default '0', bouncecount_soft int(11) default '0', bouncecount_hard int(11) default '0', bouncecount_unknown int(11) default '0', unsubscribecount int(11) default '0', newsletterid int(11) default 0 references email_newsletters(newsletterid), sendfromname varchar(200) default NULL, sendfromemail varchar(200) default NULL, bounceemail varchar(200) default NULL, replytoemail varchar(200) default NULL, charset varchar(200) default NULL, sendinformation mediumtext, sendsize int(11) default 0, sentby int(11) default 0 references email_users(userid), notifyowner char(1) default 0, linkclicks int(11) default '0', emailopens int(11) default '0', emailforwards int(11) default '0', emailopens_unique int(11) default '0', htmlopens int default 0, htmlopens_unique int default 0, textopens int default 0, textopens_unique int default 0, hiddenby int default 0 references email_users(userid), sendtestmode int default 0, sendtype varchar(100) default 'newsletter', PRIMARY KEY (statid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_sequence ( id int(11) NOT NULL auto_increment, PRIMARY KEY (id) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: INSERT INTO email_stats_sequence(id) VALUES (0) (Table 'data.email_stats_sequence' doesn't exist)
Unable to run the following query: CREATE TABLE email_stats_users ( userid int(11) default 0 references email_users(userid), statid int(11) default 0, jobid int(11) default 0 references email_jobs(jobid), queuesize int(11) default 0, queuetime int(11) default 0 ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_subscribers_data ( subscriberid int(11) NOT NULL default '0' references email_list_subscribers(subscriberid), fieldid int(11) NOT NULL default '0' references email_customfields(fieldid), data text ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_templates ( templateid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, format char(1) default NULL, textbody longtext, htmlbody longtext, createdate int(11) default 0, active int default 0 references email_users(userid), isglobal int default 0 references email_users(userid), ownerid int(11) NOT NULL default '0' references email_users(userid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: INSERT INTO email_usergroups( groupname, createdate, systemadmin ) VALUES ( 'System Admin', UNIX_TIMESTAMP(NOW()), '1' ) (Table 'data.email_usergroups' doesn't exist)
Unable to run the following query: INSERT INTO email_users( groupid, username, password, status, admintype, listadmintype, templateadmintype, createdate, lastloggedin, infotips, usewysiwyg, gettingstarted ) VALUES ( 1, 'admin', md5('password'), '1', 'a', 'a', 'a', UNIX_TIMESTAMP(NOW()), 0, '1', '1', '0' ) (Table 'data.email_users' doesn't exist)
Y CONTINUA ASI...
gracias por la ayuda
estoy intentando instalar una version del script interspire email marketer ya la probe y en 000webhost funciona bien peo en localhost me bota full errores no entiendo esto me aparece:
Oops, something went wrong...
While trying to install the database the following errors occurred:
Unable to run the following query: CREATE TABLE email_usergroups ( groupid INT NOT NULL AUTO_INCREMENT, groupname VARCHAR(255) NOT NULL, createdate INT NOT NULL, limit_list INT DEFAULT 0, limit_hourlyemailsrate INT DEFAULT 0, limit_emailspermonth INT DEFAULT 0, limit_totalemailslimit INT DEFAULT NULL, forcedoubleoptin CHAR(1) DEFAULT '0', forcespamcheck CHAR(1) DEFAULT '0', systemadmin CHAR(1) DEFAULT '0', listadmin CHAR(1) DEFAULT '0', segmentadmin CHAR(1) DEFAULT '0', templateadmin CHAR(1) DEFAULT '0', PRIMARY KEY (groupid) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_usergroups_permissions ( groupid INT NOT NULL, area VARCHAR(255) NOT NULL, subarea VARCHAR(255) DEFAULT NULL, FOREIGN KEY (groupid) REFERENCES email_usergroups(groupid) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_usergroups_access ( groupid INT NOT NULL, resourcetype VARCHAR(100) NOT NULL, resourceid INT NOT NULL, FOREIGN KEY (groupid) REFERENCES email_usergroups(groupid) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_users ( userid INT AUTO_INCREMENT NOT NULL, groupid INT NOT NULL, trialuser CHAR(1) DEFAULT '0', username VARCHAR(255) NOT NULL, unique_token VARCHAR(128) DEFAULT NULL, password VARCHAR(32) DEFAULT NULL, admintype CHAR(1) DEFAULT NULL, listadmintype CHAR(1) DEFAULT NULL, templateadmintype CHAR(1) DEFAULT NULL, segmentadmintype CHAR(1) DEFAULT NULL, status CHAR(1) DEFAULT '0', fullname VARCHAR(255) DEFAULT NULL, emailaddress VARCHAR(100) DEFAULT NULL, settings TEXT DEFAULT NULL, editownsettings CHAR(1) DEFAULT '0', usertimezone VARCHAR(10) DEFAULT NULL, textfooter TEXT DEFAULT NULL, htmlfooter TEXT DEFAULT NULL, infotips CHAR(1) DEFAULT '1', smtpserver VARCHAR(255) DEFAULT NULL, smtpusername VARCHAR(255) DEFAULT NULL, smtppassword VARCHAR(255) DEFAULT NULL, smtpport INT DEFAULT 0, createdate INT DEFAULT 0, lastloggedin INT DEFAULT 0, forgotpasscode CHAR(32) DEFAULT '', usewysiwyg CHAR(1) DEFAULT '1', enableactivitylog CHAR(1) DEFAULT '0', xmlapi CHAR(1) DEFAULT '0', xmltoken CHAR(40) DEFAULT NULL, gettingstarted INT NOT NULL DEFAULT 0, googlecalendarusername VARCHAR(255) DEFAULT NULL, googlecalendarpassword VARCHAR(255) DEFAULT NULL, user_language VARCHAR(25) NOT NULL DEFAULT 'default', eventactivitytype LONGTEXT DEFAULT NULL, credit_warning_time INT DEFAULT NULL, -- The last time credit_warning was sent out to this user credit_warning_percentage INT DEFAULT NULL, -- At which percentage credit_warning_fixed INT DEFAULT NULL, -- or at which credit level adminnotify_email VARCHAR(100) DEFAULT NULL, adminnotify_send_flag CHAR(1) DEFAULT '0', adminnotify_send_threshold INT DEFAULT NULL, adminnotify_send_emailtext TEXT DEFAULT NULL, adminnotify_import_flag CHAR(1) DEFAULT '0', adminnotify_import_threshold INT DEFAULT NULL, adminnotify_import_emailtext TEXT DEFAULT NULL, PRIMARY KEY (userid), FOREIGN KEY (groupid) REFERENCES email_usergroups(groupid) ON DELETE RESTRICT ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_autoresponders ( autoresponderid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, subject varchar(255) default NULL, format char(1) default NULL, textbody longtext, htmlbody longtext, createdate int(11) default 0, active int default 0, pause int default 0, hoursaftersubscription int(11) default 0, ownerid int(11) NOT NULL default 0 references email_users(userid), searchcriteria mediumtext, listid int(11) default 0 references email_lists(listid), tracklinks char(1) default 1, trackopens char(1) default 1, multipart char(1) default 1, queueid int(11) default 0, sendfromname varchar(255) default NULL, sendfromemail varchar(255) default NULL, replytoemail varchar(255) default NULL, bounceemail varchar(255) default NULL, charset varchar(255) default NULL, embedimages char(1) default '0', to_firstname int default 0 references email_customfields(fieldid), to_lastname int default 0 references email_customfields(fieldid), autorespondersize int default 0 ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_banned_emails ( banid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, emailaddress varchar(255) default NULL, list varchar(10) default NULL, bandate int(11) default NULL ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_customfield_lists ( cflid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, fieldid int(11) NOT NULL default '0' references email_customfields(fieldid), listid int(11) NOT NULL default '0' references email_lists(listid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_customfields ( fieldid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, fieldtype varchar(100) default NULL, defaultvalue varchar(255) default NULL, required char(1) default 0, fieldsettings mediumtext, createdate int(11) default 0, ownerid int(11) default 0 references email_users(userid), isglobal char(1) default '0' ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_form_customfields ( formid int(11) default 0 references email_forms(formid), fieldid varchar(10) default 0 references email_customfields(fieldid), fieldorder int default 0 ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_form_lists ( formid int(11) default 0 references email_forms(formid), listid int(11) default 0 references email_lists(listid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_form_pages ( pageid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, formid int(11) default 0 references email_forms(formid), pagetype varchar(100) default NULL, html longtext, url varchar(255) default NULL, sendfromname varchar(255) default NULL, sendfromemail varchar(255) default NULL, replytoemail varchar(255) default NULL, bounceemail varchar(255) default NULL, emailsubject varchar(255) default NULL, emailhtml longtext, emailtext longtext ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_forms ( formid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, design varchar(255) default NULL, formhtml longtext, chooseformat varchar(2) default NULL, changeformat varchar(1) default 0, sendthanks varchar(1) default 0, requireconfirm varchar(1) default 0, ownerid int(11) default 0 references email_users(userid), formtype char(1) default NULL, createdate int(11) default 0, contactform varchar(1) default 0, usecaptcha varchar(1) default 0 ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_jobs ( jobid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, jobtype varchar(255) default NULL, jobstatus char(1) default NULL, jobtime int(11) default 0, jobdetails text, fkid int(11) default '0', lastupdatetime int(11) default '0', fktype varchar(255) default NULL, queueid int(11) default '0', ownerid int(11) default 0 references email_users(userid), approved int default 0 references email_users(userid), authorisedtosend int default 0 references email_users(userid), resendcount int default 0 ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_jobs_lists ( jobid int(11) default 0 references email_jobs(jobid), listid int(11) default 0 references email_lists(listid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_list_subscribers ( subscriberid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, listid int(11) NOT NULL default '0' references email_lists(listid), emailaddress varchar(200), domainname varchar(100), format char(1) default NULL, confirmed char(1) default 0, confirmcode varchar(32) default NULL, requestdate int(11) default '0', requestip varchar(20) default NULL, confirmdate int(11) default '0', confirmip varchar(20) default NULL, subscribedate int(11) default '0', bounced int(11) default '0', unsubscribed int(11) default '0', unsubscribeconfirmed char(1) default 0, formid int(11) default '0' ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_list_subscribers_unsubscribe ( subscriberid int(11) NOT NULL default '0' references email_list_subscribers(subscriberid), unsubscribetime int(11) NOT NULL default '0', unsubscribeip varchar(20) default NULL, unsubscriberequesttime int(11) default '0', unsubscriberequestip varchar(20) default NULL, listid int(11) NOT NULL default '0' references email_lists(listid), statid int(11) default '0', unsubscribearea varchar(20) default NULL ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_lists ( listid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, ownername varchar(255) default NULL, owneremail varchar(100) default NULL, bounceemail varchar(100) default NULL, replytoemail varchar(100) default NULL, bounceserver varchar(100) default NULL, bounceusername varchar(100) default NULL, bouncepassword varchar(100) default NULL, extramailsettings varchar(100) default NULL, companyname varchar(255) default NULL, companyaddress varchar(255) default NULL, companyphone varchar(20) default NULL, format char(1) default NULL, notifyowner char(1) default 0, imapaccount char(1) default 0, createdate int(11) default 0, subscribecount int(11) default '0', unsubscribecount int(11) default '0', bouncecount int(11) default '0', processbounce char(1) default '0', agreedelete char(1) default '0', agreedeleteall char(1) default '0', visiblefields text not null, ownerid int(11) default 0 references email_users(userid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_newsletters ( newsletterid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, format char(1) default NULL, subject varchar(255) default NULL, textbody longtext, htmlbody longtext, createdate int(11) default 0, active int default 0 references email_users(userid), archive int default 0 references email_users(userid), ownerid int(11) NOT NULL default '0' references email_users(userid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_queues ( queueid int(11) default '0', queuetype varchar(255) default NULL, ownerid int(11) NOT NULL default '0' references email_users(userid), recipient int(11) default 0 references email_list_subscribers(subscriberid), processed char(1) default '0', sent char(1) default '0', processtime datetime ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_queues_sequence ( id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: INSERT INTO email_queues_sequence(id) VALUES (0) (Table 'data.email_queues_sequence' doesn't exist)
Unable to run the following query: CREATE TABLE email_settings ( cronok char(1) default '0', cronrun1 int(11) default '0', cronrun2 int(11) default '0', database_version int default '0' ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: INSERT INTO email_settings(cronok, cronrun1, cronrun2, database_version) VALUES (0, 0, 0, 20130816) (Table 'data.email_settings' doesn't exist)
Unable to run the following query: CREATE TABLE email_config_settings(area varchar(255), areavalue text) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_settings_cron_schedule ( jobtype VARCHAR(20), lastrun INT default '0' ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: INSERT INTO email_settings_cron_schedule (jobtype, lastrun) VALUES ('send', '-1') (Table 'data.email_settings_cron_schedule' doesn't exist)
Unable to run the following query: INSERT INTO email_settings_cron_schedule (jobtype, lastrun) VALUES ('bounce', '-1') (Table 'data.email_settings_cron_schedule' doesn't exist)
Unable to run the following query: INSERT INTO email_settings_cron_schedule (jobtype, lastrun) VALUES ('autoresponder', '-1') (Table 'data.email_settings_cron_schedule' doesn't exist)
Unable to run the following query: CREATE TABLE email_list_subscriber_bounces ( bounceid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, subscriberid int(11) default 0 references email_list_subscribers(subscriberid), statid int(11) default 0, listid int(11) default 0 references email_lists(listid), bouncetime int(11) default 0, bouncetype varchar(255) default NULL, bouncerule varchar(255) default NULL, bouncemessage longtext ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_autoresponders ( statid int(11) NOT NULL default '0', htmlrecipients int(11) default '0', textrecipients int(11) default '0', multipartrecipients int(11) default '0', bouncecount_soft int(11) default '0', bouncecount_hard int(11) default '0', bouncecount_unknown int(11) default '0', unsubscribecount int(11) default '0', autoresponderid int(11) default '0' references email_autoresponders(autoresponderid), linkclicks int(11) default '0', emailopens int(11) default '0', emailforwards int(11) default '0', emailopens_unique int(11) default '0', htmlopens int default 0, htmlopens_unique int default 0, textopens int default 0, textopens_unique int default 0, hiddenby int default 0 references email_users(userid), PRIMARY KEY(statid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_emailopens ( openid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, subscriberid int(11) default 0 references email_list_subscribers(subscriberid), statid int(11) default 0, opentime int(11) default 0, openip varchar(20) default NULL, fromlink CHAR(1) DEFAULT 0, opentype char(1) DEFAULT 'u' ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_linkclicks ( clickid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, clicktime int(11) default 0, clickip varchar(20) default NULL, subscriberid int(11) default 0 references email_list_subscribers(subscriberid), statid int(11) default 0, linkid int(11) default 0 references email_links(linkid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_links ( statid int(11) default 0, linkid int(11) default 0 references email_links(linkid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_links ( linkid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, url varchar(255) default NULL ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_newsletter_lists ( statid int(11) default NULL, listid int(11) default 0 references email_lists(listid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_newsletters ( statid int(11) NOT NULL default '0', queueid int(11) default 0, jobid int(11) default 0 references email_jobs(jobid), starttime int(11) default 0, finishtime int(11) default 0, htmlrecipients int(11) default '0', textrecipients int(11) default '0', multipartrecipients int(11) default '0', trackopens char(1) default '0', tracklinks char(1) default '0', bouncecount_soft int(11) default '0', bouncecount_hard int(11) default '0', bouncecount_unknown int(11) default '0', unsubscribecount int(11) default '0', newsletterid int(11) default 0 references email_newsletters(newsletterid), sendfromname varchar(200) default NULL, sendfromemail varchar(200) default NULL, bounceemail varchar(200) default NULL, replytoemail varchar(200) default NULL, charset varchar(200) default NULL, sendinformation mediumtext, sendsize int(11) default 0, sentby int(11) default 0 references email_users(userid), notifyowner char(1) default 0, linkclicks int(11) default '0', emailopens int(11) default '0', emailforwards int(11) default '0', emailopens_unique int(11) default '0', htmlopens int default 0, htmlopens_unique int default 0, textopens int default 0, textopens_unique int default 0, hiddenby int default 0 references email_users(userid), sendtestmode int default 0, sendtype varchar(100) default 'newsletter', PRIMARY KEY (statid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_stats_sequence ( id int(11) NOT NULL auto_increment, PRIMARY KEY (id) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: INSERT INTO email_stats_sequence(id) VALUES (0) (Table 'data.email_stats_sequence' doesn't exist)
Unable to run the following query: CREATE TABLE email_stats_users ( userid int(11) default 0 references email_users(userid), statid int(11) default 0, jobid int(11) default 0 references email_jobs(jobid), queuesize int(11) default 0, queuetime int(11) default 0 ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_subscribers_data ( subscriberid int(11) NOT NULL default '0' references email_list_subscribers(subscriberid), fieldid int(11) NOT NULL default '0' references email_customfields(fieldid), data text ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: CREATE TABLE email_templates ( templateid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) default NULL, format char(1) default NULL, textbody longtext, htmlbody longtext, createdate int(11) default 0, active int default 0 references email_users(userid), isglobal int default 0 references email_users(userid), ownerid int(11) NOT NULL default '0' references email_users(userid) ) character set utf8 engine=innodb (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working)
Unable to run the following query: INSERT INTO email_usergroups( groupname, createdate, systemadmin ) VALUES ( 'System Admin', UNIX_TIMESTAMP(NOW()), '1' ) (Table 'data.email_usergroups' doesn't exist)
Unable to run the following query: INSERT INTO email_users( groupid, username, password, status, admintype, listadmintype, templateadmintype, createdate, lastloggedin, infotips, usewysiwyg, gettingstarted ) VALUES ( 1, 'admin', md5('password'), '1', 'a', 'a', 'a', UNIX_TIMESTAMP(NOW()), 0, '1', '1', '0' ) (Table 'data.email_users' doesn't exist)
Y CONTINUA ASI...
gracias por la ayuda