portal block fehler

[exhale]

das ändert aber doch nix daran das meine portal.php net geht.........hauptsache die geht erstma wieder..............

Code: Alles auswählen

Could not query album information

DEBUG MODE

SQL Error : 1054 Unknown column 'id' in 'field list'

SELECT id, title, username, timestamp FROM phpbb_album ORDER BY timestamp DESC LIMIT 0,1

Line : 110
File : /usr/export/www/vhosts/funnetwork/hosting/exhale1/phpBB2/portal.php

[Markus67]

Hi ...

Code: Alles auswählen

SELECT id, title, username, timestamp FROM phpbb_album 

Schau mal bitte in der Datenbank in der Tabelle

phpbb_album ob diese 4 Felder vorhanden sind ...

id
titel
username
timestamp

Markus

[exhale]

pic_id
pic_filename
pic_thumbnail
pic_title
pic_desc
pic_user_id
pic_username
pic_user_ip
pic_time
pic_cat_id
pic_view_count
pic_lock
pic_approval


Indizes
pic_cat_id
pic_user_id
pic_time

[Markus67]

Hi ...

ersetze mal in der portal.php

suche:

Code: Alles auswählen

// Get Newest Pic 
// 
$sql = "SELECT id, title, username, timestamp FROM phpbb_album ORDER BY timestamp DESC LIMIT 0,1"; 

if (!$result = $db->sql_query($sql)) 
{ 
   message_die(GENERAL_ERROR, 'Could not query album information', '', __LINE__, __FILE__, $sql); 
} 

$picrow = $db->sql_fetchrow($result); 
// 
// END - Get Newest Pic

ersetze mit:

Code: Alles auswählen

// Get Newest Pic 
// 
$sql = "SELECT pic_id, pic_title, pic_username, pic_time FROM phpbb_album ORDER BY pic_time DESC LIMIT 0,1"; 

if (!$result = $db->sql_query($sql)) 
{ 
   message_die(GENERAL_ERROR, 'Could not query album information', '', __LINE__, __FILE__, $sql); 
} 

$picrow = $db->sql_fetchrow($result); 
// 
// END - Get Newest Pic

Markus