Beim Update von einigen Phoca-Komponenten von Joomla 2.5 auf Joomla 3.x kann es zu Fehlern kommen. Gelegentlich werden dabei fehlende Werte in einer "_phoca[NAME]_styles"-Tabelle angemahnt. Diese Fehler können durch ein nachträgliches Hinzufügen der Werte zur Tabelle gelöst werden.

Dies kann per phpMyAdmin oder mit einer einfachen PHP-Datei geschehen, die nur einmalig ausgeführt werden muss.

http://www.phoca.cz/forum/viewtopic.php?f=30&t=25731&start=10

define("PREFIX", "abc");
define("DBHOST", "localhost");
define("DBNAME", "db-name");
define("DBUSER", "db-user");
define("DBPASS", "db-pass");

define("PHOCA", "phocagallery");
// define("PHOCA", "phocadownload");


$mysqli = new mysqli(DBHOST, DBUSER, DBPASS, DBNAME);

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

/* execute multi query */
if ($mysqli->multi_query(getQuery(PHOCA))) {
    do {
        /* store first result set */
        if ($result = $mysqli->store_result()) {
            while ($row = $result->fetch_row()) {
                printf("%s\n", $row[0]);
            }
            $result->free();
        }
        /* print divider */
        if ($mysqli->more_results()) {
            printf("-----------------\n");
        }
    } while ($mysqli->next_result());
}

function getQuery($phoca) {
	switch($phoca) {
		case "phocadownload":
			return $query = "
				CREATE TABLE IF NOT EXISTS `".PREFIX."_phocadownload_styles` (
				`id` int(11) NOT NULL AUTO_INCREMENT,
				`title` varchar(255) NOT NULL DEFAULT '',
				`alias` varchar(255) NOT NULL DEFAULT '',
				`filename` varchar(255) NOT NULL DEFAULT '',
				`menulink` text,
				`type` tinyint(1) NOT NULL DEFAULT '0',
				`published` tinyint(1) NOT NULL DEFAULT '0',
				`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
				`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
				`ordering` int(11) NOT NULL DEFAULT '0',
				`params` text,
				`language` char(7) NOT NULL DEFAULT '',
				PRIMARY KEY (`id`)
				) DEFAULT CHARSET=utf8 ;

				INSERT INTO `".PREFIX."_phocadownload_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
				(1, 'Phocadownload', 'phocadownload', 'phocadownload.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
				(2, 'Rating', 'rating', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
				(3, 'Button', 'button', 'button.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
				(4, 'Button (Rounded Corners)', '', 'buttonrc.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*'),
				(5, 'Default', 'default', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
				(6, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 5, NULL, '*');
				";
		break;
		case "phocagallery":
			return $query = "
			CREATE TABLE IF NOT EXISTS `".PREFIX."_phocagallery_styles` (
			`id` int(11) NOT NULL AUTO_INCREMENT,
			`title` varchar(255) NOT NULL DEFAULT '',
			`alias` varchar(255) NOT NULL DEFAULT '',
			`filename` varchar(255) NOT NULL DEFAULT '',
			`menulink` text,
			`type` tinyint(1) NOT NULL DEFAULT '0',
			`published` tinyint(1) NOT NULL DEFAULT '0',
			`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
			`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
			`ordering` int(11) NOT NULL DEFAULT '0',
			`params` text,
			`language` char(7) NOT NULL DEFAULT '',
			PRIMARY KEY (`id`)
			) DEFAULT CHARSET=utf8 ;

			INSERT INTO `".PREFIX."_phocagallery_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
			(1, 'Phocagallery', 'phocagallery', 'phocagallery.css', '', 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
			(2, 'Rating', '', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
			(3, 'Default', '', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
			(4, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*');
			";
		break;
	}
}

Kommentar schreiben


Sicherheitscode
Aktualisieren