PDA

Zobacz pełną wersję : Problem z instalacją phocamaps


shadowman25
04-05-2012, 16:26
Witam
Probuje zainstalowac phocamaps, pliki instalują sie jedak nie instaluje sie baza danych.
Pojawia się taki błąd: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /libraries/joomla/database/database/mysql.php on line 344

Zawartoś pliku: instal.bak

DROP TABLE IF EXISTS `jos_phocamaps_map`;

CREATE TABLE `jos_phocamaps_map` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`width` int(5) NOT NULL default '0',
`height` int(5) NOT NULL default '0',
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`zoom` int(3) NOT NULL default '0',
`lang` varchar(6) NOT NULL default '',
`border` tinyint(1) NOT NULL default '0',
`continuouszoom` tinyint(1) NOT NULL default '0',
`doubleclickzoom` tinyint(1) NOT NULL default '0',
`scrollwheelzoom` tinyint(1) NOT NULL default '0',
`zoomcontrol` tinyint(1) NOT NULL default '0',
`scalecontrol` tinyint(1) NOT NULL default '0',
`typeid` tinyint(1) NOT NULL default '0',
`typecontrol` tinyint(1) NOT NULL default '0',
`typecontrolposition` tinyint(1) NOT NULL default '0',
`collapsibleoverview` tinyint(1) NOT NULL default '0',
`dynamiclabel` tinyint(1) NOT NULL default '0',
`googlebar` tinyint(1) NOT NULL default '0',
`displayroute` tinyint(1) NOT NULL default '0',
`kmlfile` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`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',
`access` tinyint(3) unsigned NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

DROP TABLE IF EXISTS `jos_phocamaps_marker`;

CREATE TABLE `jos_phocamaps_marker` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`gpslatitude` varchar(50) NOT NULL default '',
`gpslongitude` varchar(50) NOT NULL default '',
`displaygps` tinyint(1) NOT NULL default '0',
`icon` tinyint(1) NOT NULL default '0',
`description` text NOT NULL,
`contentwidth` varchar(8) NOT NULL default '',
`contentheight` varchar(8) NOT NULL default '',
`markerwindow` 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',
`access` tinyint(3) unsigned NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) ENGINE=MyISAM CHARACTER SET `utf8`;


-- UPDATE 1.1.0
-- ALTER TABLE `jos_phocamaps_map` ADD `typecontrolposition` tinyint(1) NOT NULL default '0' AFTER `typecontrol`;
-- ALTER TABLE `jos_phocamaps_map` ADD `typeid` tinyint(1) NOT NULL default '0' AFTER `typecontrol`;
-- ALTER TABLE `jos_phocamaps_map` ADD `kmlfile` varchar(255) NOT NULL default '' AFTER `displayroute`;
-- ALTER TABLE `jos_phocamaps_marker` ADD `contentwidth` varchar(8) NOT NULL default '' AFTER `description`;
-- ALTER TABLE `jos_phocamaps_marker` ADD `contentheight` varchar(8) NOT NULL default '' AFTER `description`;
-- ALTER TABLE `jos_phocamaps_marker` ADD `markerwindow` tinyint(1) NOT NULL default '0' AFTER `description`;



Zawartość pliku: phocamapsinstall.php


<?php
/*
* @package Joomla 1.5
* @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
*
* @component Phoca Component
* @copyright Copyright (C) Jan Pavelka www.phoca.cz
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
*/
defined('_JEXEC') or die();
class PhocaMapsCpControllerPhocaMapsInstall extends PhocaMapsCpController
{
function __construct() {
parent::__construct();
$this->registerTask( 'install' , 'install' );
$this->registerTask( 'upgrade' , 'upgrade' );
}



function install() {
$db = &JFactory::getDBO();
//$dbPref = $db->getPrefix();
$msgSQL = '';
$msgFile = '';
$msgError = '';

// ------------------------------------------
// Phoca Maps - Maps
// ------------------------------------------

$query =' DROP TABLE IF EXISTS `jos_phocamaps_map`;';
$db->setQuery( $query );
if (!$result = $db->query()){$msgSQL .= $db->stderr() . '<br />';}

$query ='CREATE TABLE IF NOT EXISTS `jos_phocamaps_map` ('."\n";
$query.=' `id` int(11) NOT NULL auto_increment,'."\n";
$query.=' `title` varchar(255) NOT NULL default \'\','."\n";
$query.=' `alias` varchar(255) NOT NULL default \'\','."\n";
$query.=' `width` int(5) NOT NULL default \'0\','."\n";
$query.=' `height` int(5) NOT NULL default \'0\','."\n";
$query.=' `latitude` varchar(20) NOT NULL default \'\','."\n";
$query.=' `longitude` varchar(20) NOT NULL default \'\','."\n";
$query.=' `zoom` int(3) NOT NULL default \'0\','."\n";
$query.=' `lang` varchar(6) NOT NULL default \'\','."\n";
$query.=' `border` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `continuouszoom` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `doubleclickzoom` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `scrollwheelzoom` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `zoomcontrol` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `scalecontrol` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `typeid` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `typecontrol` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `typecontrolposition` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `collapsibleoverview` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `dynamiclabel` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `googlebar` tinyint(1) NOT NULL default \'0\',';
$query.=' `displayroute` tinyint(1) NOT NULL default \'0\',';
$query.=' `kmlfile` varchar(255) NOT NULL default \'\','."\n";
$query.=' `description` text NOT NULL,'."\n";
$query.=' `published` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `checked_out` int(11) unsigned NOT NULL default \'0\','."\n";
$query.=' `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\','."\n";
$query.=' `ordering` int(11) NOT NULL default \'0\','."\n";
$query.=' `access` tinyint(3) unsigned NOT NULL default \'0\','."\n";
$query.=' `hits` int(11) NOT NULL default \'0\','."\n";
$query.=' `params` text NOT NULL,'."\n";
$query.=' PRIMARY KEY (`id`),'."\n";
$query.=' KEY `cat_idx` (`published`,`access`),'."\n";
$query.=' KEY `idx_access` (`access`),'."\n";
$query.=' KEY `idx_checkout` (`checked_out`)'."\n";
$query.=') ENGINE=MyISAM CHARACTER SET `utf8`;';

$db->setQuery( $query );
if (!$result = $db->query()){$msgSQL .= $db->stderr() . '<br />';}


// ------------------------------------------
// Phoca Maps - Markers
// ------------------------------------------

$query=' DROP TABLE IF EXISTS `jos_phocamaps_marker`;'."\n";

$db->setQuery( $query );
if (!$result = $db->query()){$msgSQL .= $db->stderr() . '<br />';}

$query ='CREATE TABLE IF NOT EXISTS `jos_phocamaps_marker` ('."\n";
$query.=' `id` int(11) unsigned NOT NULL auto_increment,'."\n";
$query.=' `catid` int(11) NOT NULL default \'0\','."\n";
$query.=' `title` varchar(250) NOT NULL default \'\','."\n";
$query.=' `alias` varchar(255) NOT NULL default \'\','."\n";
$query.=' `latitude` varchar(20) NOT NULL default \'\','."\n";
$query.=' `longitude` varchar(20) NOT NULL default \'\','."\n";
$query.=' `gpslatitude` varchar(50) NOT NULL default \'\','."\n";
$query.=' `gpslongitude` varchar(50) NOT NULL default \'\','."\n";
$query.=' `displaygps` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `icon` tinyint(1) NOT NULL default \'0\',';
$query.=' `description` text NOT NULL,'."\n";
$query.=' `contentwidth` varchar(8) NOT NULL default \'\','."\n";
$query.=' `contentheight` varchar(8) NOT NULL default \'\','."\n";
$query.=' `markerwindow` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `published` tinyint(1) NOT NULL default \'0\','."\n";
$query.=' `checked_out` int(11) unsigned NOT NULL default \'0\','."\n";
$query.=' `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\','."\n";
$query.=' `ordering` int(11) NOT NULL default \'0\','."\n";
$query.=' `access` tinyint(3) unsigned NOT NULL default \'0\','."\n";
$query.=' `hits` int(11) NOT NULL default \'0\','."\n";
$query.=' `params` text NOT NULL,'."\n";
$query.=' PRIMARY KEY (`id`),'."\n";
$query.=' KEY `catid` (`catid`,`published`)'."\n";
$query.=') ENGINE=MyISAM CHARACTER SET `utf8`;';

$db->setQuery( $query );
if (!$result = $db->query()){$msgSQL .= $db->stderr() . '<br />';}


// Error
if ($msgSQL !='') {
$msgError .= '<br />' . $msgSQL;
}
/*
if ($msgFile !='') {
$msgError .= '<br />' . $msgFile;
}
*/
// End Message
if ($msgError !='') {
$msg = JText::_( 'Phoca Maps not successfully installed' ) . ': ' . $msgError;
} else {
$msg = JText::_( 'Phoca Maps successfully installed' );
}

$link = 'index.php?option=com_phocamaps';
$this->setRedirect($link, $msg);
}


function upgrade() {

$db =& JFactory::getDBO();
$dbPref = $db->getPrefix();
$msgSQL = '';
$msgFile = '';
$msgError = '';

// CHECK TABLES

$query =' SELECT * FROM `jos_phocamaps_map` LIMIT 1;';
$db->setQuery( $query );
$result = $db->loadResult();
if ($db->getErrorNum()) {
$msgSQL .= $db->getErrorMsg(). '<br />';
}


$query=' SELECT * FROM `jos_phocamaps_marker` LIMIT 1;'."\n";

$db->setQuery( $query );
$result = $db->loadResult();
if ($db->getErrorNum()) {
$msgSQL .= $db->getErrorMsg(). '<br />';
}

//Version 1.0.1
// UPDATE displayroute
$updateDR = false;
$updateDR = $this->AddColumnIfNotExists("jos_phocamaps_map", "displayroute", "tinyint(1) NOT NULL default '0'", "googlebar" );
if (!$updateDR) {
$msgSQL .= 'Error while updating Display Route column<br />';
}

// Version 1.1.0
$updateTCP = false;
$updateTCP = $this->AddColumnIfNotExists("jos_phocamaps_map", "typecontrolposition", "tinyint(1) NOT NULL default '0'", "typecontrol" );
if (!$updateTCP) {
$msgSQL .= 'Error while updating Type Control Position column<br />';
}
$updateTID = false;
$updateTID = $this->AddColumnIfNotExists("jos_phocamaps_map", "typeid", "tinyint(1) NOT NULL default '0'", "typecontrol" );
if (!$updateTID) {
$msgSQL .= 'Error while updating Type ID column<br />';
}

$updateKML = false;
$updateKML = $this->AddColumnIfNotExists("jos_phocamaps_map", "kmlfile", "varchar(255) NOT NULL default ''", "displayroute" );
if (!$updateKML) {
$msgSQL .= 'Error while updating KML File column<br />';
}

$updateCW = false;
$updateCW = $this->AddColumnIfNotExists("jos_phocamaps_marker", "contentwidth", "varchar(8) NOT NULL default ''", "description" );
if (!$updateCW) {
$msgSQL .= 'Error while updating Marker Content Width column<br />';
}
$updateCH = false;
$updateCH = $this->AddColumnIfNotExists("jos_phocamaps_marker", "contentheight", "varchar(8) NOT NULL default ''", "description" );
if (!$updateCH) {
$msgSQL .= 'Error while updating Marker Content Height column<br />';
}

$updateMW = false;
$updateMW = $this->AddColumnIfNotExists("jos_phocamaps_marker", "markerwindow", "tinyint(1) NOT NULL default '0'", "description" );
if (!$updateMW) {
$msgSQL .= 'Error while updating Open Marker Window column<br />';
}

// Error
if ($msgSQL !='') {
$msgError .= '<br />' . $msgSQL;
}
/*
if ($msgFile !='') {
$msgError .= '<br />' . $msgFile;
}
*/
// End Message
if ($msgError !='') {
$msg = JText::_( 'Phoca Maps not successfully upgraded' ) . ': ' . $msgError;
} else {
$msg = JText::_( 'Phoca Maps successfully upgraded' );
}

$link = 'index.php?option=com_phocamaps';
$this->setRedirect($link, $msg);
}


function AddColumnIfNotExists($table, $column, $attributes = "INT( 11 ) NOT NULL DEFAULT '0'", $after = '' ) {

global $mainframe;
$db =& JFactory::getDBO();
$columnExists = false;

$query = 'SHOW COLUMNS FROM '.$table;
$db->setQuery( $query );
if (!$result = $db->query()){return false;}
$columnData = $db->loadObjectList();


foreach ($columnData as $valueColumn) {
if ($valueColumn->Field == $column) {
$columnExists = true;
break;
}
}

if (!$columnExists) {
if ($after != '') {
$query = "ALTER TABLE `".$table."` ADD `".$column."` ".$attributes." AFTER `".$after."`";
} else {
$query = "ALTER TABLE `".$table."` ADD `".$column."` ".$attributes."";
}
$db->setQuery( $query );
if (!$result = $db->query()){return false;}
}

return true;
}
}
// utf-8 test: ä,ö,ü,ř,ž
?>