phpBB.de

Verfasst: **01.01.2008 22:53**

Moin!

Konnte erfolgreich mein Board von Version 2.0.22 auf V3 updaten.

Nachdem ich aber das Portal eingebunden habe, kommt immer diese FM

Code: Alles auswählen

SQL ERROR [ mysql4 ]

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 'AND t.template_id = s.template_id AND c.theme_id = s.theme [1064]

SQL

SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name FROM phpbb_v3styles s, phpbb_v3styles_template t, phpbb_v3styles_theme c, phpbb_v3styles_imageset i WHERE s.style_id = AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/session.php
LINE: 1377
CALL: dbal_mysql->sql_query()

FILE: portal.php
LINE: 26
CALL: user->setup()

Soweit so gut.

Hier der Inhalt von der portal.php

Code: Alles auswählen

<?php
/*
*
* @package phpBB3 Portal  a.k.a canverPortal  ( www.phpbb3portal.com )
* @version $Id: portal.php,v 1.5 2007/08/19 17:51:00 angelside Exp $
* @copyright (c) Canver Software - www.canversoft.net
* @license http://opensource.org/licenses/gpl-license.php GNU Public License 
*
*/

// Note: If you would like to have the portal in a different location than in the main phpBB3 directory
// You must change the following variable, and change the 'U_PORTAL' template variable in functions.php
define('IN_PHPBB', true);
define('IN_PORTAL', true);

$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpbb_portal_path = (defined('PHPBB_PORTAL_PATH')) ? PHPBB_PORTAL_PATH : './portal/';

$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_portal_path . '/includes/functions.'.$phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup('portal');  <--- hier scheint der Wurm zu sein!?

Wo ist nun mein Fehler?

Bin zwar neu hier im Forum, werde mich aber dennoch bemühen hier öfters auf zu tauchen.

Gruss
Schnibbel

+ + + + + + + + + + + + + + + + + + + +

EDIT*

habe das Problem selber lokalisieren können. War ein Ausgabefehler in der "function/session.php"

Hatte eine Zeile doppelt eingeführt.

+ + + + + + + + + + + + + + + + + + + +

Nachtrag...

Mein Portal Button oben links ist nicht aktiv. Wo ändere ich dieses?

Verfasst: **02.01.2008 03:12**

Hallo,erstmal

besser ist immer,wenn Du in solchen Fällen mal einen Link zu Deinem Forum an gibst.
Den Link änderst Du in der overall_header.html .

Der Link ist falsch eingebaut.

Verfasst: **02.01.2008 15:59**

redbull254 hat geschrieben:Hallo,erstmal

besser ist immer,wenn Du in solchen Fällen mal einen Link zu Deinem Forum an gibst.
Den Link änderst Du in der overall_header.html .

Der Link ist falsch eingebaut.

URL entfernt!

Aber ich glaube, ich habe etwas in der overall_header.html verkehrt gemacht.

Hier mal der Code:

Code: Alles auswählen

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}" xml:lang="{S_USER_LANG}">
<head>

<meta http-equiv="content-type" content="text/html; charset={S_CONTENT_ENCODING}" />
<meta http-equiv="content-style-type" content="text/css" />
<meta http-equiv="content-language" content="{S_USER_LANG}" />
<meta http-equiv="imagetoolbar" content="no" />
<meta name="resource-type" content="document" />
<meta name="distribution" content="global" />
<meta name="copyright" content="2002-2006 phpBB Group" />
<meta name="keywords" content="" />
<meta name="description" content="" />
{META}
<title>{SITENAME} &bull; <!-- IF S_IN_MCP -->{L_MCP} &bull; <!-- ELSEIF S_IN_UCP -->{L_UCP} &bull; <!-- ENDIF -->{PAGE_TITLE}</title>

<!--
	phpBB style name: prosilver
	Based on style:   prosilver (this is the default phpBB3 style)
	Original author:  Tom Beddard ( http://www.subBlue.com/ )
	Modified by:      
	
	NOTE: This page was generated by phpBB, the free open-source bulletin board package.
	      The phpBB Group is not responsible for the content of this page and forum. For more information
	      about phpBB please visit http://www.phpbb.com
-->

<script type="text/javascript">
// <![CDATA[
	var jump_page = '{LA_JUMP_PAGE}:';
	var on_page = '{ON_PAGE}';
	var per_page = '{PER_PAGE}';
	var base_url = '{A_BASE_URL}';
	var style_cookie = 'phpBBstyle';
	var onload_functions = new Array();
	var onunload_functions = new Array();

	<!-- IF S_USER_PM_POPUP -->
		if ({S_NEW_PM})
		{
			var url = '{UA_POPUP_PM}';
			window.open(url.replace(/&/g, '&'), '_phpbbprivmsg', 'height=225,resizable=yes,scrollbars=yes, width=400');
		}
	<!-- ENDIF -->

	/**
	* Find a member
	*/
	function find_username(url)
	{
		popup(url, 760, 570, '_usersearch');
		return false;
	}

	/**
	* New function for handling multiple calls to window.onload and window.unload by pentapenguin
	*/
	window.onload = function()
	{
		for (i = 0; i <= onload_functions.length; i++)
		{
			eval(onload_functions[i]);
		}
	}

	window.onunload = function()
	{
		for (i = 0; i <= onunload_functions.length; i++)
		{
			eval(onunload_functions[i]);
		}
	}

// ]]>
</script>
<script type="text/javascript" src="{T_TEMPLATE_PATH}/styleswitcher.js"></script>
<script type="text/javascript" src="{T_TEMPLATE_PATH}/forum_fn.js"></script>

<link href="{T_THEME_PATH}/print.css" rel="stylesheet" type="text/css" media="print" title="printonly" />
<link href="{T_STYLESHEET_LINK}" rel="stylesheet" type="text/css" media="screen, projection" />

<link href="{T_THEME_PATH}/normal.css" rel="stylesheet" type="text/css" title="A" />
<link href="{T_THEME_PATH}/medium.css" rel="alternate stylesheet" type="text/css" title="A+" />
<link href="{T_THEME_PATH}/large.css" rel="alternate stylesheet" type="text/css" title="A++" />

<!-- IF S_CONTENT_DIRECTION eq 'rtl' -->
	<link href="{T_THEME_PATH}/bidi.css" rel="stylesheet" type="text/css" media="screen, projection" />
<!-- ENDIF -->

</head>

<body id="phpbb" class="section-{SCRIPT_NAME} {S_CONTENT_DIRECTION}">

<div id="wrap">
	<a id="top" name="top" accesskey="t"></a>
	<div id="page-header">
		<div class="headerbar">
			<div class="inner"><span class="corners-top"><span></span></span>

			<div id="site-description">
				<a href="{U_INDEX}" title="{L_INDEX}" id="logo">{SITE_LOGO_IMG}</a>
				<h1>{SITENAME}</h1>
				<p>{SITE_DESCRIPTION}</p>
				<p style="display: none;"><a href="#start_here">{L_SKIP}</a></p>
			</div>

		<!-- IF S_DISPLAY_SEARCH and not S_IN_SEARCH -->
			<div id="search-box">
				<form action="{U_SEARCH}" method="post" id="search">
				<fieldset>
					<input name="keywords" id="keywords" type="text" maxlength="128" title="{L_SEARCH_KEYWORDS}" class="inputbox search" value="<!-- IF SEARCH_WORDS-->{SEARCH_WORDS}<!-- ELSE -->{L_SEARCH_MINI}<!-- ENDIF -->" onclick="if(this.value=='{LA_SEARCH_MINI}')this.value='';" onblur="if(this.value=='')this.value='{LA_SEARCH_MINI}';" /> 
					<input class="button2" value="{L_SEARCH}" type="submit" /><br />
					<a href="{U_SEARCH}" title="{L_SEARCH_ADV_EXPLAIN}">{L_SEARCH_ADV}</a> {S_SEARCH_HIDDEN_FIELDS}
				</fieldset>
				</form>
			</div>
		<!-- ENDIF -->

			<span class="corners-bottom"><span></span></span></div>
		</div>
<!-- IF not $S_IN_PORTAL -->
		<div class="navbar">
			<div class="inner"><span class="corners-top"><span></span></span>

			<ul class="linklist navlinks">
				<a class="icon-home" href="{U_PORTAL}">{L_PORTAL}</a> » <a href="{U_INDEX}" accesskey="h">{L_INDEX}</a> <!-- BEGIN navlinks --> <strong>‹</strong> <a href="{navlinks.U_VIEW_FORUM}">{navlinks.FORUM_NAME}</a><!-- END navlinks --></li>

				<li class="rightside"><a href="#" onclick="fontsizeup(); return false;" class="fontsize" title="{L_CHANGE_FONT_SIZE}">{L_CHANGE_FONT_SIZE}</a></li>

				<!-- IF U_EMAIL_TOPIC --><li class="rightside"><a href="{U_EMAIL_TOPIC}" title="{L_EMAIL_TOPIC}" class="sendemail">{L_EMAIL_TOPIC}</a></li><!-- ENDIF -->
				<!-- IF U_EMAIL_PM --><li class="rightside"><a href="{U_EMAIL_PM}" title="{L_EMAIL_PM}" class="sendemail">{L_EMAIL_PM}</a></li><!-- ENDIF -->
				<!-- IF U_PRINT_TOPIC --><li class="rightside"><a href="{U_PRINT_TOPIC}" title="{L_PRINT_TOPIC}" accesskey="p" class="print">{L_PRINT_TOPIC}</a></li><!-- ENDIF -->
				<!-- IF U_PRINT_PM --><li class="rightside"><a href="{U_PRINT_PM}" title="{L_PRINT_PM}" accesskey="p" class="print">{L_PRINT_PM}</a></li><!-- ENDIF -->
			</ul>

			<!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
			<ul class="linklist leftside">
				<li class="icon-ucp">
					<a href="{U_PROFILE}" title="{L_PROFILE}" accesskey="u">{L_PROFILE}</a>
						<!-- IF S_DISPLAY_PM --> (<a href="{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a>)<!-- ENDIF --> &bull; 
					<a href="{U_SEARCH_SELF}">{L_SEARCH_SELF}</a>
					<!-- IF U_RESTORE_PERMISSIONS --> &bull;
					<a href="{U_RESTORE_PERMISSIONS}">{L_RESTORE_PERMISSIONS}</a>
					<!-- ENDIF -->
				</li>
			</ul>
			<!-- ENDIF -->

			<ul class="linklist rightside">
				<li class="icon-faq"><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a></li>
				<!-- IF not S_IS_BOT -->
					<!-- IF S_DISPLAY_MEMBERLIST --><li class="icon-members"><a href="{U_MEMBERLIST}" title="{L_MEMBERLIST_EXPLAIN}">{L_MEMBERLIST}</a></li><!-- ENDIF -->
					<!-- IF not S_USER_LOGGED_IN --><li class="icon-register"><a href="{U_REGISTER}">{L_REGISTER}</a></li><!-- ENDIF -->
					<li class="icon-logout"><a href="{U_LOGIN_LOGOUT}" title="{L_LOGIN_LOGOUT}" accesskey="l">{L_LOGIN_LOGOUT}</a></li>
				<!-- ENDIF -->
			</ul>

			<span class="corners-bottom"><span></span></span></div>
		</div>
<!-- ENDIF -->
	</div>

	<a name="start_here"></a>
	<div id="page-body">
		
		 <!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN and (U_MCP or U_ACP) --> 
		<div id="message" class="rules">
			<div class="inner"><span class="corners-top"><span></span></span>
				<strong>{L_INFORMATION}:</strong> {L_BOARD_DISABLED}
			<span class="corners-bottom"><span></span></span></div>
		</div>
		<!-- ENDIF -->

Verfasst: **02.01.2008 16:13**

Verlinke die Datei und poste nicht den Inhalt. Das gibt "Mecker".

Aber ich glaube, ich habe etwas in der overall_header.html verkehrt gemacht.

Habe ich etwas anderes geschrieben?

suche :

Code: Alles auswählen

<a class="icon-home" href="{U_PORTAL}">{L_PORTAL}</a> » <a href="{U_INDEX}" accesskey="h">{L_INDEX}</a>

ersetze mit:

Code: Alles auswählen

<li><a class="icon-home" href="{U_PORTAL}">{L_PORTAL}</a> » <a href="{U_INDEX}" accesskey="h">{L_INDEX}</a>

EDIT:

in der overall_footer.html stimmt der Link auch nicht.

Verfasst: **02.01.2008 17:05**

redbull254 hat geschrieben:ersetze mit:
Code: Alles auswählen
<li><a class="icon-home" href="{U_PORTAL}">{L_PORTAL}</a> » <a href="{U_INDEX}" accesskey="h">{L_INDEX}</a> 

besser:

Code: Alles auswählen

<li><a class="icon-home" href="{U_PORTAL}">{L_PORTAL}</a> &raquo; <a href="{U_INDEX}" accesskey="h">{L_INDEX}</a>

Verfasst: **02.01.2008 20:44**

Hi!

Danke vorab für die schnelle Hilfe, aber nachdem auch dieses geändert wurde, besteht das Problem weiterhin.

Hier mal die Zeilen aus den beiden Dateien:

"overall_header.html"

Code: Alles auswählen

<li><a class="icon-home" href="{U_PORTAL}">{L_PORTAL}</a> &raquo; <a href="{U_INDEX}" accesskey="h">{L_INDEX}</a>

"overall_footer.html"

Code: Alles auswählen

<li><a class="icon-home" href="{U_PORTAL}">{L_PORTAL}</a> &raquo; <a href="{U_INDEX}" accesskey="h">{L_INDEX}</a>

Wie gesagt, Problem besteht weiterhin....

Verfasst: **02.01.2008 21:08**

verlinke die Datei mal hier. Hast Du den Cache gelöscht und vor allem die Templates aktualisiert ?

Verfasst: **02.01.2008 22:26**

redbull254 hat geschrieben:verlinke die Datei mal hier. Hast Du den Cache gelöscht und vor allem die Templates aktualisiert ?

Mensch dooo....ich könnt dich knutschen bist du schielst!

An dem "Cache leeren" hat es gelegen. Darauf muss man erst einmal kommen! *respekt* (ziehe meinen Hut)

phpBB.de

[ERLEDIGT] session Problem

[ERLEDIGT] session Problem