Error column cannot be null

Please post general support questions for the phpBB3 core system on phpBB.com!
Bitte allgemeine Supportanfragen zu phpBB3 auf phpBB.de stellen!
Forum rules
Please post general support questions for the phpBB3 core system on phpBB.com!
Bitte allgemeine Supportanfragen zu phpBB3 auf phpBB.de stellen!

Topic author
Razer
Active Member
Active Member
Posts: 34
Joined: 14. March 2009 16:14

Error column cannot be null

Post by Razer » 12. April 2009 00:12

Your Portal Version: 1.0.2
Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Advanced Knowledge

What have you done before the problem was there?
Nicht, aber wegen einem Event waren 200 registrierte Mitglieder online!

What have you already tryed to solve the problem?
Ich habe einfach keine Vorgehensweise!

Description and Message
Was soll ich machen? Ich sehe den folgenden Fehler, wenn ich die portal.php mit dem Safari besuche:

Code: Select all

SQL ERROR [ mysqli ]

Column 'template_filename' cannot be null [1048]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Und das mit Firefox:

Code: Select all

SQL ERROR [ mysqli ]

Column 'template_filename' cannot be null [1048]

SQL

INSERT INTO phpbb_9styles_template_data (template_id, template_filename, template_included, template_mtime, template_data) VALUES ('3', NULL, '', 1239466721, '')

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_template.php
LINE: 85
CALL: dbal_mysqli->sql_query()

FILE: includes/template.php
LINE: 376
CALL: template_compile->_tpl_load_file()

FILE: includes/template.php
LINE: 603
CALL: template->_tpl_load()

FILE: includes/functions_template.php
LINE: 197
CALL: template->_tpl_include()

FILE: includes/functions_template.php
LINE: 66
CALL: template_compile->compile()

FILE: includes/template.php
LINE: 376
CALL: template_compile->_tpl_load_file()

FILE: includes/template.php
LINE: 181
CALL: template->_tpl_load()

FILE: includes/functions.php
LINE: 3900
CALL: template->display()

FILE: portal.php
LINE: 258
CALL: page_footer()
Wer kann helfen? DANKE![/i]

User avatar

Christian_N
Former Team Member
Former Team Member
Posts: 2266
Joined: 19. January 2008 02:17
phpBB.de User: Christian_N
phpBB.com User: Christian_N
Location: Frankfurt

Re: Error column cannot be null

Post by Christian_N » 12. April 2009 00:23

Hast mal ein Link zum Board? Um was für ein Style handelt es sich?
Meine Projekte: Chantals - Fanpage .::. phpBB Projekt
No support via PM, email or messenger!


Topic author
Razer
Active Member
Active Member
Posts: 34
Joined: 14. March 2009 16:14

Re: Error column cannot be null

Post by Razer » 12. April 2009 00:37

Christian_N wrote:Hast mal ein Link zum Board? Um was für ein Style handelt es sich?
Hast PM. Style ist eigener. Bisher hat es einwandfrei funktioniert!


Topic author
Razer
Active Member
Active Member
Posts: 34
Joined: 14. March 2009 16:14

Re: Error column cannot be null

Post by Razer » 12. April 2009 01:14

So, hier URL fuer alle:
Last edited by Razer on 12. April 2009 20:03, edited 1 time in total.

User avatar

Kevin
Site Admin
Site Admin
Posts: 2888
Joined: 7. January 2006 21:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg

Re: Error column cannot be null

Post by Kevin » 12. April 2009 09:43

Die URL wird nicht gefunden.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!


Topic author
Razer
Active Member
Active Member
Posts: 34
Joined: 14. March 2009 16:14

Re: Error column cannot be null

Post by Razer » 12. April 2009 10:29

Kevin wrote:Die URL wird nicht gefunden.
Warte kurz, ich musste was im Server aender, hat aber nicht mit dem Portal zutun, einfach, dsmit der Server nicht so schnell ueberlastet. Gleich.


Aber DANKE fuer deine Hilfe!


Topic author
Razer
Active Member
Active Member
Posts: 34
Joined: 14. March 2009 16:14

Re: Error column cannot be null

Post by Razer » 12. April 2009 10:53

So, jetzt ist die Seite wieder online. Wer kann helfen?


DANKE!

User avatar

Kevin
Site Admin
Site Admin
Posts: 2888
Joined: 7. January 2006 21:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg

Re: Error column cannot be null

Post by Kevin » 12. April 2009 11:04

Schalte mal als Erstes bitte den Styleswitcher auf dem Portal ab. Dann sollte das Portal schon mal wieder laufen.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!


Topic author
Razer
Active Member
Active Member
Posts: 34
Joined: 14. March 2009 16:14

Re: Error column cannot be null

Post by Razer » 12. April 2009 11:12

Kevin wrote:Schalte mal als Erstes bitte den Styleswitcher auf dem Portal ab. Dann sollte das Portal schon mal wieder laufen.
Danke fuer deine Hilfe, jedoch war derStyleswitcher nie an und ist nicht an. Habe ihn jetzt auch noch manuell aus der portal_body geloescht, keine Wirkung.

Kannst du mir weiterhelfen? DANKE!!!

Brauchst du FTP Zugang?


Topic author
Razer
Active Member
Active Member
Posts: 34
Joined: 14. March 2009 16:14

Re: Error column cannot be null

Post by Razer » 12. April 2009 11:21

Uebrigens, hier nochmal die Fehlermeldung:

Code: Select all

SQL ERROR [ mysqli ]

Column 'template_filename' cannot be null [1048]

SQL

INSERT INTO phpbb_9styles_template_data (template_id, template_filename, template_included, template_mtime, template_data) VALUES ('3', NULL, '', 1239527493, '')

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_template.php
LINE: 85
CALL: dbal_mysqli->sql_query()

FILE: includes/template.php
LINE: 376
CALL: template_compile->_tpl_load_file()

FILE: includes/template.php
LINE: 603
CALL: template->_tpl_load()

FILE: includes/functions_template.php
LINE: 197
CALL: template->_tpl_include()

FILE: includes/functions_template.php
LINE: 66
CALL: template_compile->compile()

FILE: includes/template.php
LINE: 376
CALL: template_compile->_tpl_load_file()

FILE: includes/template.php
LINE: 181
CALL: template->_tpl_load()

FILE: includes/functions.php
LINE: 3900
CALL: template->display()

FILE: portal.php
LINE: 258
CALL: page_footer()
Mir kam so 'ne Idee, die MySQL Befehle einfach nochmal ausfuehren, oder bringt das nichts?

User avatar

Marc
Dev
Dev
Posts: 2487
Joined: 17. July 2008 21:08
phpBB.de User: marc1706
phpBB.com User: Marc
Location: Clausthal-Zellerfeld / München

Re: Error column cannot be null

Post by Marc » 12. April 2009 11:52

Also der Fehler liegt definitiv in deinem Style:

Code: Select all

FILE: portal.php
LINE: 258
CALL: page_footer()
page_footer ist ein Teil von phpBB. Wenn das bei deinem Style Probleme bereitet, dann kann das meiner Meinung nach nur an der style.cfg oder etwas ähnlichem liegen. Evtl. kannst du auch versuchen dein Style noch einmal im ACP zu löschen und neu zu installieren. Vielleicht ist da ja was schief gelaufen.

Trotzdem verschiebe ich das ganze mal in den General phpBB Support.

User avatar

Kevin
Site Admin
Site Admin
Posts: 2888
Joined: 7. January 2006 21:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg

Re: Error column cannot be null

Post by Kevin » 12. April 2009 11:53

Da brauchst du nix ausführen, das wird den Fehler nicht beheben.
Schalte mal bitte den Style auf prosilver um, um zu schauen ob es dort läuft. Das wird ein Einbaufehler oder ein Fehler mit deinem Style sein.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!


Topic author
Razer
Active Member
Active Member
Posts: 34
Joined: 14. March 2009 16:14

Re: Error column cannot be null

Post by Razer » 12. April 2009 12:05

Kevin wrote:Da brauchst du nix ausführen, das wird den Fehler nicht beheben.
Schalte mal bitte den Style auf prosilver um, um zu schauen ob es dort läuft. Das wird ein Einbaufehler oder ein Fehler mit deinem Style sein.
Also, ich habe nichts geaendert an meinen Style und bisher war alles problemlos! Index.php laeuft ja!


Topic author
Razer
Active Member
Active Member
Posts: 34
Joined: 14. March 2009 16:14

Re: Error column cannot be null

Post by Razer » 12. April 2009 12:15

Ich habe als letztes an der portal_body was geaendert, ist da alles richtig?

Code: Select all

<!-- DEFINE $S_IN_PORTAL = 1 -->
<!-- INCLUDE overall_header.html -->

<!--version $Id: portal_body.html 347 2008-08-29 20:26:42Z kevin74 $ //-->
<table cellpadding="0" cellspacing="0" border="0" width="100%" align="center">
<tr>
<!-- [+] left block area -->
	<td width="160px" valign="top" style="padding-right:6px;">
	
		<!-- IF S_DISPLAY_MAINMENU -->
			<!-- INCLUDE portal/block/main_menu.html -->
		<!-- ENDIF -->
		
		<!-- IF S_DISPLAY_BIRTHDAY_LIST -->
			<!-- INCLUDE portal/block/birthday_list.html -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_CLOCK -->
			<!-- INCLUDE portal/block/clock.html -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_PORTALSEARCH and S_DISPLAY_SEARCH -->
			<!-- INCLUDE portal/block/search.html -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_ATTACHMENTS -->
			<!-- INCLUDE portal/block/attachments.html -->
		<!-- ENDIF -->

		<!-- IF S_CUSTOM_SMALL -->
			<!-- INCLUDE portal/block/custom_small.html -->
		<!-- ENDIF -->		
        
		<!-- IF S_DISPLAY_LINK_US -->
			<!-- INCLUDE portal/block/link_us.html -->
		<!-- ENDIF -->

	</td>
<!-- [-] left block area -->
	<td style="width:4px;" valign="top"></td>

<!-- [+] center block area -->
	<td valign="top">

		<!-- IF S_DISPLAY_GENERAL -->
			<!-- INCLUDE portal/block/general_block.html -->
		<!-- ENDIF -->

		<!-- IF U_RESTORE_PERMISSIONS and S_DISPLAY_MAINMENU -->
			<!-- INCLUDE portal/block/general_block.html -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_WELCOME -->
			<!-- IF S_DISPLAY_WELCOME_GUEST and S_USER_LOGGED_IN -->
			<!-- ELSE -->
				<!-- INCLUDE portal/block/welcome.html -->
			<!-- ENDIF -->
		<!-- ENDIF -->

		<!-- IF S_CUSTOM_CENTER -->
			<!-- INCLUDE portal/block/custom_center.html -->
		<!-- ENDIF -->
		
		<!-- IF S_DISPLAY_RECENT -->
			<!-- INCLUDE portal/block/recent.html -->
		<!-- ENDIF -->			

		<!-- IF S_DISPLAY_ANNOUNCEMENTS -->
			<!-- IF S_ANNOUNCE_COMPACT -->
				<!-- INCLUDE portal/block/announce  ments_compact.html -->
			<!-- ELSE -->
				<!-- INCLUDE portal/block/announcements.html -->
			<!-- ENDIF -->
		<!-- ENDIF -->
		
		<!-- IF S_DISPLAY_NEWS -->
			<!-- IF S_NEWS_COMPACT -->
				<!-- INCLUDE portal/block/news_compact.html -->
			<!-- ELSE -->
				<!-- INCLUDE portal/block/news.html -->
			<!-- ENDIF -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_POLL -->
			<!-- INCLUDE portal/block/poll.html -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_PORTAL_FORUM_INDEX -->
			<!-- INCLUDE forumlist_body.html -->
			<br clear="all" />
			<table class="legend">
				<tr>
					<td width="20" align="center">{FORUM_NEW_IMG}</td>
					<td><span class="gensmall">{L_NEW_POSTS}</span></td>
					<td>&nbsp;&nbsp;</td>
					<td width="20" align="center">{FORUM_IMG}</td>
					<td><span class="gensmall">{L_NO_NEW_POSTS}</span></td>
					<td>&nbsp;&nbsp;</td>
					<td width="20" align="center">{FORUM_LOCKED_IMG}</td>
					<td><span class="gensmall">{L_FORUM_LOCKED}</span></td>
				</tr>
			</table>
			<br clear="all" />
		<!-- ENDIF -->
	
       	<!-- IF S_DISPLAY_ONLINE_PORTAL_LIST and S_DISPLAY_ONLINE_LIST -->
			<!-- INCLUDE portal/block/whois_online.html -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_PAY_C -->
			<!-- INCLUDE portal/block/donation.html -->
		<!-- ENDIF -->
		
		<!-- IF S_DISPLAY_WORDGRAPH -->
			<!-- INCLUDE portal/block/wordgraph.html -->
		<!-- ENDIF -->
		
		<!-- IF S_DISPLAY_JUMPBOX -->
			<!-- INCLUDE portal/block/jumpbox.html -->
		<!-- ENDIF -->	

		<br />
	</td>
                         
<!-- [-] center block area -->
	<td style="width:4px;" valign="top"> </td>

<!-- [+] right block area -->
	<td width="70px" valign="top" style="padding-left:6px;">
		<!-- IF S_DISPLAY_USERMENU -->
			<!-- IF not S_USER_LOGGED_IN -->
				<!-- INCLUDE portal/block/login_box.html -->
			<!-- ENDIF -->

			<!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
				<!-- INCLUDE portal/block/user_menu.html -->
			<!-- ENDIF -->
		<!-- ENDIF -->

		<!-- IF not S_IS_BOT and S_USER_LOGGED_IN and S_ZEBRA_ENABLED and S_DISPLAY_FRIENDS -->
			<!-- INCLUDE portal/block/online_friends.html -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_ADVANCED_STAT -->
			<!-- INCLUDE portal/block/statistics.html -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_MINICAL -->
			<!-- INCLUDE portal/block/mini_calendar.html -->
		<!-- ENDIF -->        
        		
		<!-- IF S_DISPLAY_RANDOM_MEMBER -->
			<!-- INCLUDE portal/block/random_member.html -->
		<!-- ENDIF -->
        
        <!-- IF S_DISPLAY_TOP_POSTERS -->
			<!-- INCLUDE portal/block/top_poster.html -->
		<!-- ENDIF -->		

		<!-- IF S_DISPLAY_LATEST_MEMBERS -->
			<!-- INCLUDE portal/block/latest_members.html -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_LEADERS_EXT -->
			<!-- INCLUDE portal/block/leaders_ext.html -->
		<!-- ELSEIF S_DISPLAY_LEADERS -->
			<!-- INCLUDE portal/block/leaders.html -->
		<!-- ENDIF -->		

        <!-- IF S_DISPLAY_LAST_BOTS and S_LAST_VISITED_BOTS -->
			<!-- INCLUDE portal/block/latest_bots.html -->
		<!-- ENDIF -->		

		<!-- IF S_DISPLAY_LINKS -->
			<!-- INCLUDE portal/block/links.html -->
		<!-- ENDIF -->

		<!-- IF S_DISPLAY_PAY_S -->
			<!-- INCLUDE portal/block/donation_small.html -->
		<!-- ENDIF -->
	</td>
<!-- [-] right block area -->
</tr>
</table>
<!--// board3 Portal by www.board3.de //-->
<!-- INCLUDE overall_footer.html -->


Topic author
Razer
Active Member
Active Member
Posts: 34
Joined: 14. March 2009 16:14

Re: Error column cannot be null

Post by Razer » 12. April 2009 12:19

Hey, ich habe den styleswitcher.js script im overall header geloescht und die Seite ist aufrufbar, jedoch irgendwie komisch und ohne footer...

Die Seite zeigt wirwarr bloecke an den falschen Stellen an. Ausserdem:
Image

Auloggen + Username, aber gelcihzeitig anmeldung vorhanden. Und der bLock wird in der Mitte angezeigt!

Ist die portal_body korrect?
Last edited by Razer on 12. April 2009 20:03, edited 1 time in total.

Return to “General phpBB3 Support”