Pagina 1 van 1

sql error in Links on IM Portal.

Geplaatst: 13 dec 2005, 19:37
door gies
Ik heb de mod:

Links on IM Portal geinstalleerd.

Ik krijg de volgende error:

Code: Selecteer alles

			     
Could not query Link

DEBUG MODE

SQL Error : 1146 Table 'deb1295_nl_1.LINKS' doesn't exist

SELECT * FROM LINKS ORDER BY name

Line : 37
File : blocks_imp_links.php 
  
Op de één of andere manier zoekt hij in de tabel: 'deb1295_nl_1.LINKS'
terwijl hij moet zoeken in de tabel: 'deb1295_nl_phpbb2_LINKS

wat is er fout ??? dit is lijn 37 uit mijn blocks_imp_links.php



global $template, $db;
$sql = "SELECT * FROM " . LINKS . " ORDER BY name";
if (!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query Link', '', __LINE__, __FILE__, $sql);
}

while ($row = $db->sql_fetchrow($result))



Wat is er fout?

Geplaatst: 13 dec 2005, 19:41
door Paul
constants.php niet goed aangepast.

Geplaatst: 13 dec 2005, 19:46
door gies

Code: Selecteer alles

#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]------------------------------------------
#
define('GROUPS_TABLE', $table_prefix.'groups');

#
#-----[ AFTER, ADD ]------------------------------------------
#
define('links', $table_prefix.'links');

#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_admin.php

dit is de connstant

Code: Selecteer alles

// Auth settings
define('AUTH_LIST_ALL', 0);
define('AUTH_ALL', 0);

define('AUTH_REG', 1);
define('AUTH_ACL', 2);
define('AUTH_MOD', 3);
define('AUTH_ADMIN', 5);

define('AUTH_VIEW', 1);
define('AUTH_READ', 2);
define('AUTH_POST', 3);
define('AUTH_REPLY', 4);
define('AUTH_EDIT', 5);
define('AUTH_DELETE', 6);
define('AUTH_ANNOUNCE', 7);
define('AUTH_STICKY', 8);
define('AUTH_POLLCREATE', 9);
define('AUTH_VOTE', 10);
define('AUTH_ATTACH', 11);


// Table names

	//Nickpage
	define('NICKPAGE_TABLE', $table_prefix.'nickpagemod');
	define('BUDDIE_TABLE', $table_prefix.'nickpagebuddies');
	define('FAVORITEN_TABLE', $table_prefix.'nickpagefavs');
	define('GAESTEBUCH_TABLE', $table_prefix.'nickpagegb');
	define('GALERIE_TABLE', $table_prefix.'nickpagegalerie');
	define('VOTES_TABLE', $table_prefix.'nickpagevotes');
	define('NICKPAGECONFIG_TABLE', $table_prefix.'nickpageconf');


define('CONFIRM_TABLE', $table_prefix.'confirm');
define('AUTH_ACCESS_TABLE', $table_prefix.'auth_access');
define('ADD_PAGES_TABLE', $table_prefix.'add_pages');

define('BANLIST_TABLE', $table_prefix.'banlist');
define('CATEGORIES_TABLE', $table_prefix.'categories');
define('CONFIG_TABLE', $table_prefix.'config');
define('DESC_LANGUAGE_TABLE', $table_prefix.'desc_language');
define('DISALLOW_TABLE', $table_prefix.'disallow');
define('FORUMS_TABLE', $table_prefix.'forums');
define('GROUPS_TABLE', $table_prefix.'groups');
define('links', $table_prefix.'links');
define('POSTS_TABLE', $table_prefix.'posts');
define('POSTS_TEXT_TABLE', $table_prefix.'posts_text');
define('PRIVMSGS_TABLE', $table_prefix.'privmsgs');
define('PRIVMSGS_TEXT_TABLE', $table_prefix.'privmsgs_text');
define('PRIVMSGS_IGNORE_TABLE', $table_prefix.'privmsgs_ignore');
define('PRUNE_TABLE', $table_prefix.'forum_prune');
define('RANKS_TABLE', $table_prefix.'ranks');
define('RANKS_CONFIG_TABLE', $table_prefix.'ranks_config');
define('RANKS_SETS_TABLE', $table_prefix.'ranks_sets');

define('SEARCH_TABLE', $table_prefix.'search_results');
define('SEARCH_WORD_TABLE', $table_prefix.'search_wordlist');
define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch');
define('SESSIONS_TABLE', $table_prefix.'sessions');
define('SMILIES_TABLE', $table_prefix.'smilies');
define('THEMES_TABLE', $table_prefix.'themes');
define('THEMES_NAME_TABLE', $table_prefix.'themes_name');
define('TOPICS_TABLE', $table_prefix.'topics');
define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');
define('USER_GROUP_TABLE', $table_prefix.'user_group');
define('USERS_TABLE', $table_prefix.'users');

// Start add - Complete banner MOD
define('BANNER_STATS_TABLE', $table_prefix.'banner_stats');
define('BANNERS_TABLE', $table_prefix.'banner');
// End add - Complete banner MOD

define('WORDS_TABLE', $table_prefix.'words');
define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');
define('LINKS_TABLE', $table_prefix.'links');
define('LINK_CATEGORIES_TABLE', $table_prefix.'link_categories');
define('LINK_CONFIG_TABLE', $table_prefix.'link_config');

define('TOPLIST_TABLE', $table_prefix.'toplist');
define('TOPLIST_ANTI_FLOOD_TABLE', $table_prefix.'toplist_anti_flood');


// password protection mod
define('BAD_PASS_LOG_TABLE', $table_prefix.'bad_pass_log');

define('WPM', $table_prefix.'wpm');
Ik zie dat van die andere mod

define('LINKS_TABLE', $table_prefix.'links');

er instaat, heeft het hier iets mee te maken???

Wat kan ik eraan veranderen ?

Geplaatst: 13 dec 2005, 20:01
door Paul
verander:

Code: Selecteer alles

define('links', $table_prefix.'links');
in

Code: Selecteer alles

define('links', $table_prefix.'links',true);

Geplaatst: 13 dec 2005, 20:04
door gies

Code: Selecteer alles

 
Could not query Link

DEBUG MODE

SQL Error : 1054 Unknown column 'name' in 'order clause'

SELECT * FROM phpbb2_links ORDER BY name

Line : 37
File : blocks_imp_links.php 
  
hij zoekt nu in phpbb2_links, maar hij moet in phpbb2_LINKS zoeken. aangezien de phpbb2_links van een andere mod is ???

Wat moet ik veranderen ???

Geplaatst: 13 dec 2005, 20:10
door Paul
Dan zal je de tabelnamen helemaal moeten veranderen, mysql is niet hoofdlettergevoelig.

Geplaatst: 13 dec 2005, 20:19
door gies
misschien een stomme vraag, maar hoe kan ik een tabel naam veranderen? in mysql ?

Geplaatst: 13 dec 2005, 20:44
door gies
het is gelukt thanx!