Foutmelding na installatie Profile control panel!

[patz]

Support template:

• Wat is het probleem? Ik krijg een foutmelding als ik het profiel opvraag
  Wanneer ontstond het probleem? Na de installatie van Profile Control Panel
  Adres van je forum: http://www.paboforum.nl
  Geïnstalleerde mods: KB, calendar, album, links, pafiledb
  Huidige template: Swiftblue
  phpBB versie: 2.0.17
  Host:Sohosted
  Heb je onlangs een mod of stijl geïnstalleerd? Calendar
  Heb je gezocht naar een antwoord?

Ja
Overige opmerkingen:
Het gaat om de volgende foutmelding:

Code: Selecteer alles

Could not get buddy information

DEBUG MODE

SQL Error : 1146 Table 'paboforum2.buddys_table' doesn't exist

SELECT * FROM BUDDYS_TABLE WHERE (user_id=143 AND buddy_id=108) OR (user_id=108 AND buddy_id=143)

Line : 90
File : profilcp_public_base.php

Alle SQL's zijn goed uitgevoegd:

Code: Selecteer alles

#-----[ SQL ]-------------------------------------------------
#
ALTER TABLE phpbb_users ADD user_realname VARCHAR(25) NOT NULL;
ALTER TABLE phpbb_users ADD user_gender TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_birthday VARCHAR(8) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_last_birthday INT(11) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_home_phone VARCHAR(20);
ALTER TABLE phpbb_users ADD user_home_fax VARCHAR(20);
ALTER TABLE phpbb_users ADD user_work_phone VARCHAR(20);
ALTER TABLE phpbb_users ADD user_work_fax VARCHAR(20);
ALTER TABLE phpbb_users ADD user_cellular VARCHAR(20);
ALTER TABLE phpbb_users ADD user_pager VARCHAR(20);
ALTER TABLE phpbb_users ADD user_summer_time TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_list_option VARCHAR(255);
ALTER TABLE phpbb_users ADD user_allow_email TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_allow_website TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_allow_messanger TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_allow_real TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_allow_sig TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_viewpm TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_viewwebsite TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_viewmessanger TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_viewreal TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_viewavatar TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_viewsig TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_viewimg TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD user_buddy_friend_display TINYINT(1) DEFAULT '1';
ALTER TABLE phpbb_users ADD user_buddy_ignore_display TINYINT(1) DEFAULT '1';
ALTER TABLE phpbb_users ADD user_buddy_friend_of_display TINYINT(1) DEFAULT '1';
ALTER TABLE phpbb_users ADD user_buddy_ignored_by_display TINYINT(1) DEFAULT '1';
ALTER TABLE phpbb_users ADD user_watched_topics_per_page SMALLINT(3) DEFAULT '15';
ALTER TABLE phpbb_users ADD user_privmsgs_per_page SMALLINT(3) DEFAULT '5';
#
#-----[ SQL ]-------------------------------------------------
#
ALTER TABLE phpbb_sessions ADD session_robot VARCHAR(32);
#
#-----[ SQL ]-------------------------------------------------
#
ALTER TABLE phpbb_ranks CHANGE rank_title rank_title VARCHAR(255) NOT NULL;
ALTER TABLE phpbb_ranks ADD rank_max MEDIUMINT(8) NOT NULL AFTER rank_min; 
#
#-----[ SQL ]-------------------------------------------------
#
CREATE TABLE phpbb_buddy (
  user_id mediumint(8) NOT NULL default '0',
  buddy_id mediumint(8) NOT NULL default '0',
  buddy_ignore tinyint(1) NOT NULL default '0',
  buddy_visible tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (user_id, buddy_id)
) TYPE=MyISAM;

Regel 85-108 van profilcp_public_base.php

Code: Selecteer alles

// get buddy infos
$sql = "SELECT * FROM " . BUDDYS_TABLE . " 
		WHERE (user_id=$user_id AND buddy_id=$view_user_id) OR (user_id=$view_user_id AND buddy_id=$user_id)";
if ( !$result = $db->sql_query($sql) )
{
	message_die(GENERAL_ERROR, 'Could not get buddy information', '', __LINE__, __FILE__, $sql);	
}
while ( $row = $db->sql_fetchrow($result) )
{
	if ( $row['user_id'] = $user_id )
	{
		$view_userdata['user_my_friend'] = !$row['buddy_ignore'];
		$view_userdata['user_my_ignore'] = $row['buddy_ignore'];
		$view_userdata['user_my_visible'] = $row['buddy_visible'];
	}
	else
	{
		$view_userdata['user_friend'] = !$row['buddy_ignore'];
		$view_userdata['user_ignore'] = $row['buddy_ignore'];
		$view_userdata['user_visible'] = $row['buddy_visible'];
	}
}
$view_userdata['user_online'] = ( $view_userdata['user_session_time'] >= (time()-300) );
$view_userdata['user_pm'] = pcp_get_class_check('pm', $view_userdata);

[/code]

[Paul]

Niet alle sql goed uitgevoerd(Die van de buddys table niet )

[patz]

Hij gaf aan dat het goed was. Dus tabel verwijderen en opnieuw uitvoeren lijkt mij. Ik zal eens kijken.

[Paul]

Sorry, ik kijk verkeerd, je hebt constants.php niet goed aangepast.

[patz]

Aha, dan ga ik nog eens kijken

[patz]

Ik kan geen fout vinden in canstants.php:

Of er moet iets in deze code niet kloppen?

Code: Selecteer alles

//-- mod : profile cp ------------------------------------------------------------------------------
//-- add
define('ADMIN_FOUNDER', 99);

define('NO', 0);
define('YES', 1);
define('FRIEND_ONLY',2);

define('UNKNOWN', 0);
define('MALE', 1);
define('FEMALE', 2);

define('BUDDYS_TABLE', $table_prefix . 'buddy');
//-- fin mod : profile cp --------------------------------------------------------------------------

Klopt de naam buddy en buddys wel? MIsschien lees ik het verkeerd?

[Paul]

Heb je hem wel geupload?