Elxis CMS Forum

Extensions => Components => Topic started by: adonasta on February 22, 2015, 20:49:29

Title: mysql Error στην εγκατασταση του ios newsletter component 1.3
Post by: adonasta on February 22, 2015, 20:49:29
στην εγκατασταση του ios newsletter component 1.3 μου βγαζει

mysql Error [1064] : EXECUTE
Message: 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 11
CREATE TABLE `elx_iosnl_messages` ( `id` INTEGER NOT NULL AUTO_INCREMENT, `subject` VARCHAR(255), `textplain` TEXT, `texthtml` TEXT, `htmlfile` VARCHAR(255), `lastsent` VARCHAR(20), `recipients` INTEGER NOT NULL DEFAULT 0, `msglang` VARCHAR(255), PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci

mysql Error [1146] : EXECUTE
Message: Table 'action_actionss_19052011.elx_iosnl_messages' doesn't exist
INSERT INTO elx_iosnl_messages VALUES (1, 'Elxis News (sample message)', 'If you read this message is because your mail client does not support html e-mails.\nIn this case you can set IOS Newsletter to display an alternative message in plain text format.\n\n-------------------------------------\nIOS Newsletter by Is Open Source', NULL, 'elxis-news.html', 0, 0, 'english')

mysql Error [1064] : EXECUTE
Message: 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 13
CREATE TABLE `elx_iosnl_subscribers` ( `sid` INTEGER NOT NULL AUTO_INCREMENT, `userid` INTEGER NOT NULL DEFAULT 0, `subname` VARCHAR(60), `subsurname` VARCHAR(60), `subemail` VARCHAR(80), `confirmed` SMALLINT NOT NULL DEFAULT 0, `subtime` VARCHAR(20), `sublang` VARCHAR(80), `confirmcode` VARCHAR(20), `subgroup` VARCHAR(80), PRIMARY KEY (`sid`) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci

=============================

και επομενως δε μπορω ουτε να προσθεσω subscribers μου βγαζει παλι 3 αντιστοιχα errors

mysql Error [1146] : EXECUTE
URI: index2.php?option=com_newsletter&task=subscribers
Message: Table 'action_actionss_19052011.elx_iosnl_subscribers' doesn't exist
SELECT COUNT(s.sid) FROM elx_iosnl_subscribers s

mysql Error [1146] : EXECUTE
URI: index2.php?option=com_newsletter&task=subscribers
Message: Table 'action_actionss_19052011.elx_iosnl_subscribers' doesn't exist
SELECT s.*, u.username FROM elx_iosnl_subscribers s LEFT JOIN elx_users u ON u.id=s.userid ORDER BY s.subname ASC LIMIT 0,20

mysql Error [1146] : EXECUTE
URI: index2.php?option=com_newsletter&task=subscribers
Message: Table 'action_actionss_19052011.elx_iosnl_subscribers' doesn't exist
SELECT subgroup FROM elx_iosnl_subscribers WHERE ((subgroup IS NOT NULL) AND (subgroup != '')) GROUP BY subgroup ORDER BY subgroup ASC


καποια ιδεα τι θα μπορουσα να τσεκαρω ? ευχαριστω !
Title: Re: mysql Error στην εγκατασταση του ios newsletter component 1.3
Post by: datahell on February 23, 2015, 12:27:21
You use an outdated Elxis version. Elxis 200x.x is old software, better consider upgrade to Elxis 4.x.
"TYPE" is deprecated, you must replace it with "ENGINE". This has been fixed in Elxis 2009.3, i guess you use an even older version.

Either update to 2009.3 or open this Elxis file:
includes/adodb/adodb-datadict.inc.php

and arround line 590 you will find something like that:

if ( preg_match('/mysql/i', $this->connection->databaseType )) { //Elxis addition
   $sql[0] .= ' TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci';
}

Change "TYPE" with "ENGINE".
Title: Re: mysql Error στην εγκατασταση του ios newsletter component 1.3
Post by: adonasta on February 26, 2015, 12:45:10
ΤΗΑΝΧ !
ΙΤ WORKED !