Table 'my_*******.guxh5_session' non esiste SQL = INSERT INTO `guxh5_session` (`sessi

26-09-2013, 20.39.56

raga... ho bisogno di un favore..... quando aprio il mio sito mi dc: Table 'my_*******.guxh5_session' non esiste SQL = INSERT INTO `guxh5_session` (`session_id`, `client_id`, `` di tempo) VALUES ('q3nktiv9i44tt4d5ki1ucum5d3', 0, '1380220257 ')
cm pss fare???

**saitfainder** · 27-09-2013, 10.22.08

Se la tabella non esiste devi vedere come crearla. E cerca di scrivere in italiano per favore.

29-09-2013, 08.23.42

ok.... allora cosa dovrei scrivere nella tabella?

**miki92** · 29-09-2013, 10.35.32

Collegati a phpMyAdmin ed esegui questa query (o crea un file php che la esegua):

Codice PHP:


CREATE TABLE IF NOT EXISTS `guxh5_session` (
  `session_id` varchar(200) NOT NULL DEFAULT '',
  `client_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `guest` tinyint(4) unsigned DEFAULT '1',
  `time` varchar(14) DEFAULT '',
  `data` mediumtext,
  `userid` int(11) DEFAULT '0',
  `username` varchar(150) DEFAULT '',
  `usertype` varchar(50) DEFAULT '',
  PRIMARY KEY (`session_id`),
  KEY `whosonline` (`guest`,`usertype`),
  KEY `userid` (`userid`),
  KEY `time` (`time`)
)

N.B. Questa query è specifica per l'installazione del tuo joomla versione 2.5.x

29-09-2013, 16.45.30

ok adesso ho risolto... ma ho un altro problema mi dice che c'è un errore alla riga 15 di error.php..... sarebbe quella dopo 'get paramas'

Codice PHP:


<?php
/**
 * @package        Joomla.Site
 * @copyright    Copyright (C) 2005 - 2013 Open Source Matters, Inc. All rights reserved.
 * @license        GNU General Public License version 2 or later; see LICENSE.txt
 */

defined('_JEXEC') or die;
$params = JFactory::getApplication()->getTemplate(true)->params;
$showRightColumn = 1;
$showleft = 0;
$showbottom = 0;

// get params
$color = $params->get('templatecolor');
$navposition = $params->get('navposition');

//get language and direction
$doc = JFactory::getDocument();
$this->language = $doc->language;
$this->direction = $doc->direction;
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $this->language; ?>" lang="<?php echo $this->language; ?>" dir="<?php echo $this->direction; ?>">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />

<meta name="language" content="<?php echo $this->language; ?>" />

    <title><?php echo $this->error->getCode(); ?> - <?php echo $this->title; ?></title>
<?php if ($this->error->getCode()>=400 && $this->error->getCode() < 500) {     ?>


        <link rel="stylesheet" href="<?php echo $this->baseurl ?>/templates/system/css/system.css" type="text/css" />
        <link rel="stylesheet" href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/position.css" type="text/css" media="screen,projection" />
        <link rel="stylesheet" href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/layout.css" type="text/css" media="screen,projection" />
        <link rel="stylesheet" href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/print.css" type="text/css" media="Print" />
        <link rel="stylesheet" href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/<?php echo htmlspecialchars($color); ?>.css" type="text/css" />
<?php
    $files = JHtml::_('stylesheet', 'templates/'.$this->template.'/css/general.css', null, false, true);
    if ($files):
        if (!is_array($files)):
            $files = array($files);
        endif;
        foreach($files as $file):
?>
        <link rel="stylesheet" href="<?php echo $file;?>" type="text/css" />
<?php
        endforeach;
    endif;
?>
         <link rel="stylesheet" href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/<?php echo htmlspecialchars($color); ?>.css" type="text/css" />
        <?php if ($this->direction == 'rtl') : ?>
            <link rel="stylesheet" href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/template_rtl.css" type="text/css" />
            <?php if (file_exists(JPATH_SITE . '/templates/'.$this->template.'/css/' . $color . '_rtl.css')) :?>
                <link rel="stylesheet" href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/<?php echo $color ?>_rtl.css" type="text/css" />
            <?php endif; ?>
        <?php endif; ?>
        <!--[if lte IE 6]>
            <link href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/ieonly.css" rel="stylesheet" type="text/css" />
        <![endif]-->
        <!--[if IE 7]>
            <link href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/ie7only.css" rel="stylesheet" type="text/css" />
        <![endif]-->


<style type="text/css">
            <!--
            #errorboxbody
            {margin:30px}
            #errorboxbody h2
            {font-weight:normal;
            font-size:1.5em}
            #searchbox
            {background:#eee;
            padding:10px;
            margin-top:20px;
            border:solid 1px #ddd
            }
            -->
</style>

</head>

<body>


    <div id="all">
        <div id="back">

        <div id="header">

                    <div class="logoheader">
                        <?php
                                $params = JFactory::getApplication()->getTemplate(true)->params;
                                $logo =  $params->get('logo');
                            ?>

                            <?php jimport( 'joomla.application.module.helper' ); ?>

                         <h1 id="logo">

                                        <?php if ($logo): ?>
                                        <img src="<?php echo $this->baseurl ?>/<?php echo htmlspecialchars($logo); ?>"  alt="<?php echo htmlspecialchars($params->get('sitetitle'));?>" />
                                        <?php endif;?>
                                        <?php if (!$logo ): ?>
                                        <?php echo htmlspecialchars($params->get('sitetitle'));?>
                                        <?php endif; ?>
                                        <span class="header1">
                                        <?php echo htmlspecialchars($params->get('sitedescription'));?>
                                        </span></h1>
                    </div><!-- end logoheader -->

                        <ul class="skiplinks">
                            <li><a href="#wrapper2" class="u2"><?php echo JText::_('TPL_BEEZ2_SKIP_TO_ERROR_CONTENT'); ?></a></li>
                            <li><a href="#nav" class="u2"><?php echo JText::_('TPL_BEEZ2_ERROR_JUMP_TO_NAV'); ?></a></li>

                        </ul>
                        <div id="line"></div>



                </div><!-- end header -->

        <div id="contentarea2" >


                            <div class="left1" id="nav">

                <h2 class="unseen"><?php echo JText::_('TPL_BEEZ2_NAVIGATION'); ?></h2>
                                            <?php $module = JModuleHelper::getModule( 'menu' );
                                            echo JModuleHelper::renderModule( $module);    ?>

                            </div>

                    <!-- end navi -->
            <div id="wrapper2">
            <div id="errorboxbody">
                        <h2><?php echo JText::_('JERROR_AN_ERROR_HAS_OCCURRED'); ?><br />
                                <?php echo JText::_('JERROR_LAYOUT_PAGE_NOT_FOUND'); ?></h2>
                                <?php if (JModuleHelper::getModule( 'search' )) : ?>
                                    <div id="searchbox">
                                    <h3 class="unseen"><?php echo JText::_('TPL_BEEZ2_SEARCH'); ?></h3>
                                    <p><?php echo JText::_('JERROR_LAYOUT_SEARCH'); ?></p>
                                    <?php $module = JModuleHelper::getModule( 'search' );
                                    echo JModuleHelper::renderModule( $module);    ?>
                                    </div>
                                <?php endif; ?>
                                <div>
                                <p><a href="<?php echo $this->baseurl; ?>/index.php" title="<?php echo JText::_('JERROR_LAYOUT_GO_TO_THE_HOME_PAGE'); ?>"><?php echo JText::_('JERROR_LAYOUT_HOME_PAGE'); ?></a></p>
                                </div>

                        <h3><?php echo JText::_('JERROR_LAYOUT_PLEASE_CONTACT_THE_SYSTEM_ADMINISTRATOR'); ?></h3>

                        <h2>#<?php echo $this->error->getCode() ;?>&nbsp;<?php echo $this->error->getMessage();?></h2> <br />


            </div><!-- end wrapper -->
        </div><!-- end contentarea -->

                        <?php if ($this->debug) :
                            echo $this->renderBacktrace();
                        endif; ?>


            </div>  <!--end all -->

            </div>
            </div>
             <div id="footer-outer">

            <div id="footer-sub">


                                <div id="footer">
                                        <p>
                                                <?php echo JText::_('TPL_BEEZ2_POWERED_BY');?> <a href="http://www.joomla.org/">Joomla!®</a>
                                        </p>

                                </div><!-- end footer -->
                         </div><!-- end footer-sub -->

                       </div>



</body>
</html>
<?php } else { ?>
<?php
if (!isset($this->error)) {
    $this->error = JError::raiseWarning(404, JText::_('JERROR_ALERTNOAUTHOR'));
    $this->debug = false;
}
?>
    <link rel="stylesheet" href="<?php echo $this->baseurl; ?>/templates/system/css/error.css" type="text/css" />
</head>
<body>
    <div class="error">
        <div id="outline">
        <div id="errorboxoutline">
            <div id="errorboxheader"> <?php echo $this->title; ?></div>
            <div id="errorboxbody">
            <p><strong><?php echo JText::_('JERROR_LAYOUT_NOT_ABLE_TO_VISIT'); ?></strong></p>
                <ol>
                    <li><?php echo JText::_('JERROR_LAYOUT_AN_OUT_OF_DATE_BOOKMARK_FAVOURITE'); ?></li>
                    <li><?php echo JText::_('JERROR_LAYOUT_SEARCH_ENGINE_OUT_OF_DATE_LISTING'); ?></li>
                    <li><?php echo JText::_('JERROR_LAYOUT_MIS_TYPED_ADDRESS'); ?></li>
                    <li><?php echo JText::_('JERROR_LAYOUT_YOU_HAVE_NO_ACCESS_TO_THIS_PAGE'); ?></li>
                    <li><?php echo JText::_('JERROR_LAYOUT_REQUESTED_RESOURCE_WAS_NOT_FOUND'); ?></li>
                    <li><?php echo JText::_('JERROR_LAYOUT_ERROR_HAS_OCCURRED_WHILE_PROCESSING_YOUR_REQUEST'); ?></li>
                </ol>
            <p><strong><?php echo JText::_('JERROR_LAYOUT_PLEASE_TRY_ONE_OF_THE_FOLLOWING_PAGES'); ?></strong></p>

                <ul>
                    <li><a href="<?php echo $this->baseurl; ?>/index.php" title="<?php echo JText::_('JERROR_LAYOUT_GO_TO_THE_HOME_PAGE'); ?>"><?php echo JText::_('JERROR_LAYOUT_HOME_PAGE'); ?></a></li>
                    <li><a href="<?php echo $this->baseurl; ?>/index.php?option=com_search" title="<?php echo JText::_('JERROR_LAYOUT_SEARCH_PAGE'); ?>"><?php echo JText::_('JERROR_LAYOUT_SEARCH_PAGE'); ?></a></li>

                </ul>

            <p><?php echo JText::_('JERROR_LAYOUT_PLEASE_CONTACT_THE_SYSTEM_ADMINISTRATOR'); ?>.</p>
            <div id="techinfo">
            <p><?php echo $this->error->getMessage(); ?></p>
            <p>
                <?php if ($this->debug) :
                    echo $this->renderBacktrace();
                endif; ?>
            </p>
            </div>
            </div>
        </div>
        </div>
    </div>
</body>
</html>


<?php } ?>

**miki92** · 29-09-2013, 18.13.30

Come prima cosa non aprire topic inutili (mi scuso con i moderatori perchè non avevo visto quest'ultimo messaggio), seconda cosa la prossima volta sii un po' più dettagliato (come ti ho scritto anche dillà) includendo il testo dell'errore.

02-10-2013, 19.13.10

ok... il messaggio è questo: Fatal error: Call to a member function get() on a non-object in /membri/viaggip/templates/beez_20/error.php on line 15

Discussione: Table 'my_*******.guxh5_session' non esiste SQL = INSERT INTO `guxh5_session` (`sessi

LinkBack

Strumenti discussione

Display

Table 'my_*******.guxh5_session' non esiste SQL = INSERT INTO `guxh5_session` (`sessi

Regole di scrittura