[ Поиск ] - [ Пользователи ] - [ Календарь ]
Полная Версия: DB function failed with error number 1064
Espey
Здравствуйте, надеюсь поможете решить проблему. При установки компонента в joomla выдает ошибку - DB function failed with error number 1064.

Я читал, что нужно заменить в файле install.sgl TYPE=MyISAM на ENGINE=MyISAM.
Однако в компоненте нету файла install.sgl и нету TYPE=MyISAM.

Есть только install.coment.php


<?php defined('_VALID_MOS') or die('Direct Access to this location is not allowed.');

/*
* Copyright © 2008 Compojoom.com. All rights reserved.
* Copyright Copyright © 2007 Alain Georgette. All rights reserved.
* Copyright Copyright © 2006 Frantisek Hliva. All rights reserved.
* License
http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
*
* !JoomlaComment is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* !JoomlaComment is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
* MA 02110-1301, USA.
*/


function com_install()
{
global $mosConfig_absolute_path, $mosConfig_live_site, $database;

/*
* set the release compatibility
*/

if (!defined('_JOSC_J10') && !defined('_JOSC_J15')) {
if (version_compare($GLOBALS['_VERSION']->RELEASE, '1.5', '>='))
DEFINE('_JOSC_J15', true);
else
DEFINE('_JOSC_J10', true);
}

if (defined('_JOSC_J15'))
$mambots = 'plugins';
else
$mambots = 'mambots';

$adminDir = dirname(__FILE__);
require_once("$mosConfig_absolute_path/administrator/components/com_comment/library.comment.php");
require_once("$mosConfig_absolute_path/components/com_comment/joscomment/utils.php");
require_once("$mosConfig_absolute_path/administrator/components/com_comment/class.config.comment.php");
?>
<table
class="adminheading" cellpadding="4" cellspacing="0" border="0">
<tr>
<td>
<?php

$msgstart = "<h2><p style='color:red;'>There was a problem with your installation</p></h2>";
$msgend = "<h2>Please, contact the <a target=\"_blank\" href=\"http://joomlacode.org/gf/project/joomagecomment\">support</a>."
. "<br/>Thanks.</h2>";

if (!JOSC_TableUtils::existsTable('#__comment')) {
/* one day, when param will be in database we could set here or not complete_uninstall param */
}

/*
* check mambot path is writable
*/

if (!is_writable("$mosConfig_absolute_path/$mambots/content/")) {
$msgend = "<h2><p>Please:</p>" .
"<ul>" .
" <li>Uninstall !JoomlaComment</li>" .
" <li>Modify the file permissions if needed</li>" .
" <li>Reinstall</li>" .
"</ul>" .
"<br/>Thanks.</p>" .
"</h2>";
echo $msgstart . "<p>The directory \"$mosConfig_absolute_path/$mambots/content/\" is not writeable</p>". $msgend;
return false;
}

$install_log = "";
if (!JOSC_install::checkDatabase($install_log)) {
echo $msgstart ."<p>". $install_log ."</p>". $msgend;
return false;
}

$install_log = "<p>Installation of joscomment & josccacheclean bots</p>";
/* joscomment.php */
$movefrom = $adminDir."/plugin/joscomment.php";
$moveto = "$mosConfig_absolute_path/$mambots/content/joscomment.php";
if (!@rename($movefrom, $moveto)) {
echo $msgstart."<p style='color:red;'><b>error when moving</b> $movefrom <br /><b>TO</b> $moveto</p>".$msgend;
$msgstart = $msgend = "";
}
/* joscomment.xml */
$movefrom = $adminDir."/plugin/joscomment.xml";
$moveto = "$mosConfig_absolute_path/$mambots/content/joscomment.xml";
if (!@rename($movefrom, $moveto)) {
echo $msgstart."<p style='color:red;'><b>error when moving</b> $movefrom <br /><b>TO</b> $moveto</p>".$msgend;
$msgstart = $msgend = "";
}
/* josccleancache.php */
$movefrom = $adminDir."/plugin/josccleancache.php";
$moveto = "$mosConfig_absolute_path/$mambots/system/josccleancache.php";
if (!@rename($movefrom, $moveto)) {
echo $msgstart."<p style='color:red;'><b>error when moving</b> $movefrom <br /><b>TO</b> $moveto</p>".$msgend;
$msgstart = $msgend = "";
}
/* josccleancache.xml */
$movefrom = $adminDir."/plugin/josccleancache.xml";
$moveto = "$mosConfig_absolute_path/$mambots/system/josccleancache.xml";
if (!@rename($movefrom, $moveto)) {
echo $msgstart."<p><b>error when moving</b> $movefrom <br /><b>TO</b> $moveto</p>".$msgend;
$msgstart = $msgend = "";
}

/*
* joscomment
*/
/*
* better to place after pagebreak
*/

$database->setQuery("SELECT ordering"
. "\n FROM #__$mambots"
. "\n WHERE element LIKE 'pagebreak'"
. "\n AND folder = 'content'"
);
$ordering = (int) $database->loadResult();
$database->setQuery("SELECT COUNT(*)"
. "\n FROM #__$mambots"
. "\n WHERE element LIKE 'joscomment%'"
. "\n AND folder = 'content'"
. "\n AND published = 1 ");
$total = $database->loadResult();
$published = $total ? '0' : '1'; // if joscomment% (example : joscomment_expert bot ) exists and published : do not publish
$ordering++;
$database->setQuery( "INSERT INTO `#__$mambots` "
. " (`name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) "
. " VALUES ('Content - !JoomlaComment', 'joscomment', 'content', 0, ".$ordering.", ".$published.", 0, 0, 0, '0000-00-00 00:00:00', '');");
$result = $database->query();
if($result) {
/*
* josccleancache
*/

$ordering = 0;
if (defined('_JOSC_J15')) {
/*
* get legacy place and if published
* (normally should be published because it is obligatory to install joomlacomment 3.25)
*/

$database->setQuery("SELECT ordering"
. "\n FROM #__$mambots"
. "\n WHERE element LIKE 'legacy'"
. "\n AND folder = 'system'"
. "\n AND published = 1 "
);
$ordering = (int) $database->loadResult();
}
$database->setQuery("SELECT COUNT(*)"
. "\n FROM #__$mambots"
. "\n WHERE element LIKE 'josccleancache%'"
. "\n AND folder = 'system'"
. "\n AND published = 1 ");
$total = $database->loadResult();
$published = ($total || (defined('_JOSC_J15') && $ordering<1)) ? '0' : '1'; // if joscomment% (example : joscomment_expert bot ) exists and published : do not publish
$ordering++;
$database->setQuery( "INSERT INTO `#__$mambots` "
. " (`name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) "
. " VALUES ('System - !JoomlaComment CleanCache', 'josccleancache', 'system', 0, ".$ordering.", ".$published.", 0, 0, 0, '0000-00-00 00:00:00', '');");
$result = $database->query();
}
if(!$result) {
$install_log .= "$mambots install error: " . $database->stderr() . "<br /><br />";
echo $msgstart ."<p>". $install_log ."</p>". $msgend;
return false;
}

//add new admin menu images
$database->setQuery("UPDATE #__components SET admin_menu_img='../components/com_comment/joscomment/images/logoicon.png' " .
" WHERE admin_menu_link='option=com_comment'");
$database->query();

$database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/edit.png' " .
" WHERE admin_menu_link='option=com_comment&task=comments'");
$database->query();

$database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/config.png' " .
" WHERE admin_menu_link='option=com_comment&task=settingssimple'");
$database->query();

$database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/config.png' " .
" WHERE admin_menu_link='option=com_comment&task=settings'");
$database->query();

$database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/config.png' " .
" WHERE admin_menu_link='option=com_comment&task=settingsexpert'");
$database->query();

$database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/controlpanel.png' " .
" WHERE admin_menu_link='option=com_comment&task=importcomment'");
$database->query();

$database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/credits.png' " .
" WHERE admin_menu_link='option=com_comment&task=about'");
$database->query();
?>
</td>
</tr>
</table>
<?php

JOSC_library
::viewAbout();
}
?>



Что здесь нужно сделать, чтоб установить компонент?

_____________
www.godbook.cc.ua — Новый Завет!
Быстрый ответ:

 Графические смайлики |  Показывать подпись
Здесь расположена полная версия этой страницы.
Invision Power Board © 2001-2024 Invision Power Services, Inc.