Install of Partial User Sharing 1.1.3 12 Years, 9 Months ago
|
Karma: 1
|
We are using Joomla 2.5.4.
I tried to install Partial User Sharing V1.1.3 and got following SQL error during installation.
It's a plain Joomla, we created one Site clone with Miltisites and then I wanted to install PUS.
Do I have to remove kreated sites first???
SymLink is not working as we are using Plesk and I could not figoure out how to activate, but this should not affekt the SQL.
Code: |
JInstaller: :Install: SQL-Fehler DB-Funktion mit Fehlercode 1064 fehlgeschlagen!
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 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8' at line 17 SQL=CREATE TABLE IF NOT EXISTS `main_multisites_users` ( `id` int(11)
NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL COMMENT 'reference to the joomla user id', `site_id` varchar(100) NOT NULL COMMENT 'reference to the MULTISITES_ID that created the record', `home` tinyint(1)
NOT NULL default '0' COMMENT 'Default or home websites where the user were registered', `params` text NULL COMMENT 'Additional parameters.', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:
00:00', `created_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Creation date/time', `created_by` int(10) unsigned NULL COMMENT 'reference to the user id who created the record', `modified_dt` datetime NOT NULL DEFAULT '0000-00-00 00:
00:00' COMMENT 'Date/Time of the modification', `modified_by` int(10) unsigned NULL COMMENT 'reference to the user id who modified the record', PRIMARY KEY (`id`), KEY `idx_usersite` (`user_id`, `site_id`) )
TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `#__multisites_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL COMMENT 'reference to the joomla user id',
`site_id` varchar(100) NOT NULL COMMENT 'reference to the MULTISITES_ID that created the record',
`home` tinyint(1) NOT NULL default '0' COMMENT 'Default or home websites where the user were registered',
`params` text NULL COMMENT 'Additional parameters.',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Creation date/time',
`created_by` int(10) unsigned NULL COMMENT 'reference to the user id who created the record',
`modified_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date/Time of the modification',
`modified_by` int(10) unsigned NULL COMMENT 'reference to the user id who modified the record',
PRIMARY KEY (`id`),
KEY `idx_usersite` (`user_id`, `site_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
Komponenteninstallation: SQL-Dateifehler DB-Funktion mit Fehlercode 1064 fehlgeschlagen!
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 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8' at line 17 SQL=CREATE TABLE IF NOT EXISTS `main_multisites_users` ( `id` int(11)
NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL COMMENT 'reference to the joomla user id', `site_id` varchar(100) NOT NULL COMMENT 'reference to the MULTISITES_ID that created the record', `home` tinyint(1)
NOT NULL default '0' COMMENT 'Default or home websites where the user were registered', `params` text NULL COMMENT 'Additional parameters.', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:
00:00', `created_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Creation date/time', `created_by` int(10) unsigned NULL COMMENT 'reference to the user id who created the record', `modified_dt` datetime NOT NULL DEFAULT '0000-00-00 00:
00:00' COMMENT 'Date/Time of the modification', `modified_by` int(10) unsigned NULL COMMENT 'reference to the user id who modified the record', PRIMARY KEY (`id`), KEY `idx_usersite` (`user_id`, `site_id`) )
TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `#__multisites_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL COMMENT 'reference to the joomla user id',
`site_id` varchar(100) NOT NULL COMMENT 'reference to the MULTISITES_ID that created the record',
`home` tinyint(1) NOT NULL default '0' COMMENT 'Default or home websites where the user were registered',
`params` text NULL COMMENT 'Additional parameters.',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Creation date/time',
`created_by` int(10) unsigned NULL COMMENT 'reference to the user id who created the record',
`modified_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date/Time of the modification',
`modified_by` int(10) unsigned NULL COMMENT 'reference to the user id who modified the record',
PRIMARY KEY (`id`),
KEY `idx_usersite` (`user_id`, `site_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
|
Thanks for Help!
|
|
|
|
|
Re: Install of Partial User Sharing 1.1.3 12 Years, 9 Months ago
|
Karma: 54
|
Which version of MySQL do you use.
Do you use a version greater than 5.1 ?
Do you use a MySQL 5.5 ?
If yes, they have changed the MySQL statement to create the table.
) TYPE=MyISAM
should be replaced by
) ENGINE=MyISAM
The word "type" must be replaced by "engine".
We will create a new package to reflect this new MySQL 5.5 syntax and no more support the MySQL 4.x.
|
|
|
Last Edit: 2012/04/10 18:21 By edwin2win.
|
|
Re:Install of Partial User Sharing 1.1.3 12 Years, 9 Months ago
|
Karma: 1
|
Hi
yes we are using MySQL greater then 5.1.
In which file are the SQL statements to edit?
Or when is the new package awaylable?
Tanks
|
|
|
|
|
Re:Install of Partial User Sharing 1.1.3 12 Years, 9 Months ago
|
Karma: 54
|
If you are using MySQL 5.1 this should work.
Just copy/past the SQL statement in a PHPMyAdmin and execute it to try identifying the reason. On MYSQL 5.1, the syntax is correct but on MySQL 5.5 or higher, the syntax has changed.
As I told you, try replacing the "type" by "engine" but type is accepted under MySQL 5.1
|
|
|
|
|
|