Hi Thorsten
Ich bin grad auf dem int. Forum auf einen sehr interessanten Thread gestoßen.
forum.joomla.org/viewtopic.php?f=471&...jcollection#p2583736
.. Wallgas schreibt Folgendes:
Hi,
I'm new to this forum and hope I'm using the right place.
I have a problem installing JCollection extension from the extensions manager: I get the following error:
500 - An error has occurred.
DB function failed with error number 1064
| Code: |
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 CHARACTER SET utf8 COLLATE utf8_general_ci' at line 29 SQL=CREATE TABLE `jos_jc_cat` ( `id` INT(11)
UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL DEFAULT '', `parent` INT(11) UNSIGNED NOT NULL DEFAULT '0', `description` TEXT NOT NULL DEFAULT '', `img` VARCHAR(255) NOT NULL DEFAULT '', `alias` VARCHAR(255)
NOT NULL DEFAULT '', `date` DATETIME NOT NULL, `created_by` INT(11) UNSIGNED NOT NULL DEFAULT '0', `created_by_alias` VARCHAR(255) NOT NULL DEFAULT '', `modified` DATETIME NOT NULL, `modified_by` INT(11)
UNSIGNED NOT NULL DEFAULT '0', `published` INT(3) NOT NULL DEFAULT '0', `approved` INT(3) NOT NULL DEFAULT '0', `access` INT(11) NOT NULL DEFAULT '0', `checked_out` INT(11)
UNSIGNED NOT NULL DEFAULT '0', `checked_out_time` DATETIME NOT NULL, `ordering` INT NOT NULL DEFAULT '0', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`id`), INDEX(`name`), INDEX (`parent`), FOREIGN KEY (`created_by`) REFERENCES `jos_users`(`id`)
, FOREIGN KEY (`modified_by`) REFERENCES `jos_users`(`id`), FOREIGN KEY (`checked_out`) REFERENCES `jos_users`(`id`), INDEX (`created_by`), INDEX (`date`), INDEX (`ordering`) )
TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
I contacted the owner of the website and he says that my MySQl version is probably very old but I'm using the 5.5 and I already installed other extensions and made other sites with it without getting any message lik this one.
I really hope someone can help me understanding what the problem is.
Thank you in advance for any help!
W
Wallgas hatte leider keine Antwort bekommen - auf Anhieb fällt mir leider auch keine Hilfe für ihn ein...
forum.joomla.org/viewtopic.php?f=471&...jcollection#p2583736
Ich denke dass das Script nicht richtig durchgelaufen ist. DA ist irgend etwas schiefgegangen.
Was meinst du denn!? Kann man ihm nicht helfen?
Viele Grüße
FU
Forum
