Pagina 1 van 1

SQL-query probleem bij instal Welcome PM on first Login mod.

Geplaatst: 19 jul 2011, 11:43
door yomi
Directe link naar de modificatie:
http://www.phpbb.com/customise/db/mod/w ... 3A-t_91086
Adres van je forum: http://www.witvisforum.nl
phpBB versie:3.0.9

Hallo,
vandaag heb ik de Mod Welcome PM on first Login (WPM) geinstalleerd op mijn forum.
Lukt goed totdat ik een SQL-query moest draaien.
Deze SQL-query wilt bij mij niet draaien.
Zie hieronder de query en zie daaronder de error die ik krijg.
Wat doe ik fout.

Volgens mij komt het door dat ik alles heb in mij SQL met phpbb1_wpm erbij en niet met phpbb_wpm zoals het nu in deze query staat.
Alleen geen idee waar ik dat moet aanpassen in deze query zodat hij het gaat aanmaken met phpbb1_wpm.

De SQL-query die ik moet draaien.

Code: Selecteer alles

 CREATE TABLE phpbb_wpm (
	wpm_config_id int(3) NOT NULL,
	wpm_enable tinyint(1) unsigned NOT NULL,
	wpm_send_id mediumint(8) NOT NULL,
	wpm_preview tinyint(1) unsigned NOT NULL,
	wpm_variables varchar(255) NOT NULL,
	wpm_subject varchar(100) NOT NULL,
	wpm_message mediumtext NOT NULL,
	wpm_version varchar(255) NOT NULL,
	PRIMARY KEY	(wpm_config_id)
	) ;

	INSERT INTO phpbb_wpm (wpm_config_id, wpm_enable, wpm_send_id, wpm_preview, wpm_variables, wpm_subject, wpm_message, wpm_version) VALUES(1, 1, 2, 0, '', 'Welcome to {SITE_NAME}!', 'Hello, [b]{USERNAME}[/b]!\n\nWelcome to {SITE_NAME}	({SITE_DESC})\n\nYou registered on [b]{USER_REGDATE}[/b]. According to your input, your email is [b]{USER_EMAIL}[/b] and you live in timezone [b]{USER_TZ}[/b]. It is nice to know that you speak {USER_LANG_LOCAL}.\n\nYou can contact us here: {BOARD_CONTACT} or here: {BOARD_EMAIL}, whichever you prefer, at anytime. Thank you for choosing us.\n\n-Thank you for registering at {SITE_NAME}!\n\nThanks, {SENDER}', '2.2.5');
	 
Probleem error is:

Code: Selecteer alles

Fout

SQL-query:

 INSERTINTO phpbb_wpm( wpm_config_id, wpm_enable, wpm_send_id, wpm_preview, wpm_variables, wpm_subject, wpm_message, wpm_version ) 
VALUES ( 1, 1, 2, 0,'','Welcome to {SITE_NAME}!','Hello, [b]{USERNAME}[/b]!\n\nWelcome to {SITE_NAME}	({SITE_DESC})\n\nYou registered on [b]{USER_REGDATE}[/b]. According to your input, your email is [b]{USER_EMAIL}[/b] and you live in timezone [b]{USER_TZ}[/b]. It is nice to know that you speak {USER_LANG_LOCAL}.\n\nYou can contact us here: {BOARD_CONTACT} or here: {BOARD_EMAIL}, whichever you prefer, at anytime. Thank you for choosing us.\n\n-Thank you for registering at {SITE_NAME}!\n\nThanks, {SENDER}','2.2.5') ;


MySQL retourneerde: 
#1062 - Duplicate entry '1' for key 1 
En dit is de fout meldingen die ik te zien krijg op mijn forum.

Code: Selecteer alles

Algemene fout
SQL ERROR [ mysqli ]

Table 'p5014_bLKsEphpbb.phpbb1wpm' doesn't exist [1146]

SQL

SELECT * FROM phpbb1wpm WHERE wpm_config_id = 1

BACKTRACE


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

FILE: includes/functions_wpm.php
LINE: 243
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_wpm.php
LINE: 30
CALL: welcome_pm->get_data()

FILE: includes/acp/acp_wpm.php
LINE: 35
CALL: welcome_pm->welcome_pm()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_wpm->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()



Re: SQL-query probleem bij instal Welcome PM on first Login

Geplaatst: 19 jul 2011, 12:09
door David
Je geeft zelf eigenlijk de oplossing al ;)

Je moet de phpbb_ (prefix) uit de query wijzigen naar de prefix van jouw forum dus phpbb1_! Hier onder heb ik het voor je aangepast, probeer deze eens en als het goed is pakt die hem nu wel.

Code: Selecteer alles

    CREATE TABLE phpbb1_wpm (
       wpm_config_id int(3) NOT NULL,
       wpm_enable tinyint(1) unsigned NOT NULL,
       wpm_send_id mediumint(8) NOT NULL,
       wpm_preview tinyint(1) unsigned NOT NULL,
       wpm_variables varchar(255) NOT NULL,
       wpm_subject varchar(100) NOT NULL,
       wpm_message mediumtext NOT NULL,
       wpm_version varchar(255) NOT NULL,
       PRIMARY KEY   (wpm_config_id)
       ) ;

       INSERT INTO phpbb1_wpm (wpm_config_id, wpm_enable, wpm_send_id, wpm_preview, wpm_variables, wpm_subject, wpm_message, wpm_version) VALUES(1, 1, 2, 0, '', 'Welcome to {SITE_NAME}!', 'Hello, [b]{USERNAME}[/b]!\n\nWelcome to {SITE_NAME}   ({SITE_DESC})\n\nYou registered on [b]{USER_REGDATE}[/b]. According to your input, your email is [b]{USER_EMAIL}[/b] and you live in timezone [b]{USER_TZ}[/b]. It is nice to know that you speak {USER_LANG_LOCAL}.\n\nYou can contact us here: {BOARD_CONTACT} or here: {BOARD_EMAIL}, whichever you prefer, at anytime. Thank you for choosing us.\n\n-Thank you for registering at {SITE_NAME}!\n\nThanks, {SENDER}', '2.2.5');
        

Re: SQL-query probleem bij instal Welcome PM on first Login

Geplaatst: 19 jul 2011, 12:26
door yomi
Hoi David,

In mijn QSL paneel krijg ik de volgende fout melding.
Dat hij al bestaat maar op mijn forum krijg ik de meldingen dat hij niet bestaat.

Code: Selecteer alles

Fout

SQL-query:

CREATETABLE phpbb1_wpm(

wpm_config_id int( 3)NOTNULL ,
wpm_enable tinyint( 1)unsigned NOTNULL ,
wpm_send_id mediumint( 8)NOTNULL ,
wpm_preview tinyint( 1)unsigned NOTNULL ,
wpm_variables varchar( 255)NOTNULL ,
wpm_subject varchar( 100)NOTNULL ,
wpm_message mediumtext NOTNULL ,
wpm_version varchar( 255)NOTNULL ,
 PRIMARYKEY ( wpm_config_id ) 
);


 
MySQL retourneerde: 
#1050 - Table 'phpbb1_wpm' already exists 

En op mijn forum krijg ik de volgende fout melding .
i

Code: Selecteer alles

Algemene fout
SQL ERROR [ mysqli ]

Table 'p5014_bLKsEphpbb.phpbb1wpm' doesn't exist [1146]

SQL

SELECT * FROM phpbb1wpm WHERE wpm_config_id = 1

BACKTRACE

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

FILE: includes/functions_wpm.php
LINE: 243
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_wpm.php
LINE: 30
CALL: welcome_pm->get_data()

FILE: includes/acp/acp_wpm.php
LINE: 35
CALL: welcome_pm->welcome_pm()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_wpm->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Re: SQL-query probleem bij instal Welcome PM on first Login

Geplaatst: 19 jul 2011, 12:32
door David
Heb je in je database ook gekeken of deze er daadwerkelijk staat?

Ik weet het niet zeker, maar zou ik je includes/constants.php eens mogen zien.

Re: SQL-query probleem bij instal Welcome PM on first Login

Geplaatst: 19 jul 2011, 12:40
door yomi
Tuurlijk David,
Hierbij de code.

Code: Selecteer alles

<?php
/**
*
* @package phpBB3
* @version $Id: constants.php 10268 2009-11-14 20:15:50Z acydburn $
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
	exit;
}

/**
* valid external constants:
* PHPBB_MSG_HANDLER
* PHPBB_DB_NEW_LINK
* PHPBB_ROOT_PATH
* PHPBB_ADMIN_PATH
*/

// phpBB Version
define('PHPBB_VERSION', '3.0.9');

// QA-related
// define('PHPBB_QA', 1);

// User related
define('ANONYMOUS', 1);

define('USER_ACTIVATION_NONE', 0);
define('USER_ACTIVATION_SELF', 1);
define('USER_ACTIVATION_ADMIN', 2);
define('USER_ACTIVATION_DISABLE', 3);

define('AVATAR_UPLOAD', 1);
define('AVATAR_REMOTE', 2);
define('AVATAR_GALLERY', 3);

define('USER_NORMAL', 0);
define('USER_INACTIVE', 1);
define('USER_IGNORE', 2);
define('USER_FOUNDER', 3);

define('INACTIVE_REGISTER', 1);
define('INACTIVE_PROFILE', 2);
define('INACTIVE_MANUAL', 3);
define('INACTIVE_REMIND', 4);

// ACL
define('ACL_NEVER', 0);
define('ACL_YES', 1);
define('ACL_NO', -1);

// Login error codes
define('LOGIN_CONTINUE', 1);
define('LOGIN_BREAK', 2);
define('LOGIN_SUCCESS', 3);
define('LOGIN_SUCCESS_CREATE_PROFILE', 20);
define('LOGIN_ERROR_USERNAME', 10);
define('LOGIN_ERROR_PASSWORD', 11);
define('LOGIN_ERROR_ACTIVE', 12);
define('LOGIN_ERROR_ATTEMPTS', 13);
define('LOGIN_ERROR_EXTERNAL_AUTH', 14);
define('LOGIN_ERROR_PASSWORD_CONVERT', 15);

// Maximum login attempts
// The value is arbitrary, but it has to fit into the user_login_attempts field.
define('LOGIN_ATTEMPTS_MAX', 100);

// Group settings
define('GROUP_OPEN', 0);
define('GROUP_CLOSED', 1);
define('GROUP_HIDDEN', 2);
define('GROUP_SPECIAL', 3);
define('GROUP_FREE', 4);

// Forum/Topic states
define('FORUM_CAT', 0);
define('FORUM_POST', 1);
define('FORUM_LINK', 2);
define('ITEM_UNLOCKED', 0);
define('ITEM_LOCKED', 1);
define('ITEM_MOVED', 2);

// Forum Flags
define('FORUM_FLAG_LINK_TRACK', 1);
define('FORUM_FLAG_PRUNE_POLL', 2);
define('FORUM_FLAG_PRUNE_ANNOUNCE', 4);
define('FORUM_FLAG_PRUNE_STICKY', 8);
define('FORUM_FLAG_ACTIVE_TOPICS', 16);
define('FORUM_FLAG_POST_REVIEW', 32);
define('FORUM_FLAG_QUICK_REPLY', 64);

// Forum Options... sequential order. Modifications should begin at number 10 (number 29 is maximum)
define('FORUM_OPTION_FEED_NEWS', 1);
define('FORUM_OPTION_FEED_EXCLUDE', 2);

// Optional text flags
define('OPTION_FLAG_BBCODE', 1);
define('OPTION_FLAG_SMILIES', 2);
define('OPTION_FLAG_LINKS', 4);

// Topic types
define('POST_NORMAL', 0);
define('POST_STICKY', 1);
define('POST_ANNOUNCE', 2);
define('POST_GLOBAL', 3);

// Lastread types
define('TRACK_NORMAL', 0);
define('TRACK_POSTED', 1);

// Notify methods
define('NOTIFY_EMAIL', 0);
define('NOTIFY_IM', 1);
define('NOTIFY_BOTH', 2);

// Notify status
define('NOTIFY_YES', 0);
define('NOTIFY_NO', 1);

// Email Priority Settings
define('MAIL_LOW_PRIORITY', 4);
define('MAIL_NORMAL_PRIORITY', 3);
define('MAIL_HIGH_PRIORITY', 2);

// Log types
define('LOG_ADMIN', 0);
define('LOG_MOD', 1);
define('LOG_CRITICAL', 2);
define('LOG_USERS', 3);
define('LOG_GALLERY', 4);

// Private messaging - Do NOT change these values
define('PRIVMSGS_HOLD_BOX', -4);
define('PRIVMSGS_NO_BOX', -3);
define('PRIVMSGS_OUTBOX', -2);
define('PRIVMSGS_SENTBOX', -1);
define('PRIVMSGS_INBOX', 0);

// Full Folder Actions
define('FULL_FOLDER_NONE', -3);
define('FULL_FOLDER_DELETE', -2);
define('FULL_FOLDER_HOLD', -1);

// Download Modes - Attachments
define('INLINE_LINK', 1);
// This mode is only used internally to allow modders extending the attachment functionality
define('PHYSICAL_LINK', 2);

// Confirm types
define('CONFIRM_REG', 1);
define('CONFIRM_LOGIN', 2);
define('CONFIRM_POST', 3);

// Categories - Attachments
define('ATTACHMENT_CATEGORY_NONE', 0);
define('ATTACHMENT_CATEGORY_IMAGE', 1); // Inline Images
define('ATTACHMENT_CATEGORY_WM', 2); // Windows Media Files - Streaming
define('ATTACHMENT_CATEGORY_RM', 3); // Real Media Files - Streaming
define('ATTACHMENT_CATEGORY_THUMB', 4); // Not used within the database, only while displaying posts
define('ATTACHMENT_CATEGORY_FLASH', 5); // Flash/SWF files
define('ATTACHMENT_CATEGORY_QUICKTIME', 6); // Quicktime/Mov files

// BBCode UID length
define('BBCODE_UID_LEN', 8);

// Number of core BBCodes
define('NUM_CORE_BBCODES', 12);

// BBCode hard limit
define('BBCODE_LIMIT', 1511);

// Smiley hard limit
define('SMILEY_LIMIT', 1000);

// Magic url types
define('MAGIC_URL_EMAIL', 1);
define('MAGIC_URL_FULL', 2);
define('MAGIC_URL_LOCAL', 3);
define('MAGIC_URL_WWW', 4);

// Profile Field Types
define('FIELD_INT', 1);
define('FIELD_STRING', 2);
define('FIELD_TEXT', 3);
define('FIELD_BOOL', 4);
define('FIELD_DROPDOWN', 5);
define('FIELD_DATE', 6);

// referer validation
define('REFERER_VALIDATE_NONE', 0);
define('REFERER_VALIDATE_HOST', 1);
define('REFERER_VALIDATE_PATH', 2);

// phpbb_chmod() permissions
@define('CHMOD_ALL', 7);
@define('CHMOD_READ', 4);
@define('CHMOD_WRITE', 2);
@define('CHMOD_EXECUTE', 1);

// Captcha code length
define('CAPTCHA_MIN_CHARS', 4);
define('CAPTCHA_MAX_CHARS', 7);

// Additional constants
define('WPM_CONFIG_ID', 1);
define('VOTE_CONVERTED', 127);

// Table names
define('ACL_GROUPS_TABLE',			$table_prefix . 'acl_groups');
define('ACL_OPTIONS_TABLE',			$table_prefix . 'acl_options');
define('ACL_ROLES_DATA_TABLE',		$table_prefix . 'acl_roles_data');
define('ACL_ROLES_TABLE',			$table_prefix . 'acl_roles');
define('ACL_USERS_TABLE',			$table_prefix . 'acl_users');
define('ATTACHMENTS_TABLE',			$table_prefix . 'attachments');
define('BANLIST_TABLE',				$table_prefix . 'banlist');
define('BBCODES_TABLE',				$table_prefix . 'bbcodes');
define('BOOKMARKS_TABLE',			$table_prefix . 'bookmarks');
define('BOTS_TABLE',				$table_prefix . 'bots');
define('CALENDAR_CONFIG_TABLE',		$table_prefix . 'calendar_config');
define('CALENDAR_EVENTS_TABLE',		$table_prefix . 'calendar_events');
define('CALENDAR_EVENT_TYPES_TABLE',	$table_prefix . 'calendar_event_types');
define('CALENDAR_RSVP_TABLE',		$table_prefix . 'calendar_rsvps');
define('CALENDAR_RECURRING_EVENTS_TABLE',	$table_prefix . 'calendar_recurring_events');
define('CALENDAR_EVENTS_WATCH',		$table_prefix . 'calendar_events_watch');
define('CALENDAR_WATCH',			$table_prefix . 'calendar_watch');
define('CONFIG_TABLE',				$table_prefix . 'config');
define('CONFIRM_TABLE',				$table_prefix . 'confirm');
define('DISALLOW_TABLE',			$table_prefix . 'disallow');
define('DRAFTS_TABLE',				$table_prefix . 'drafts');
define('EXTENSIONS_TABLE',			$table_prefix . 'extensions');
define('EXTENSION_GROUPS_TABLE',	$table_prefix . 'extension_groups');
define('FORUMS_TABLE',				$table_prefix . 'forums');
define('FORUMS_ACCESS_TABLE',		$table_prefix . 'forums_access');
define('FORUMS_TRACK_TABLE',		$table_prefix . 'forums_track');
define('FORUMS_WATCH_TABLE',		$table_prefix . 'forums_watch');
define('GROUPS_TABLE',				$table_prefix . 'groups');
define('ICONS_TABLE',				$table_prefix . 'icons');
define('LANG_TABLE',				$table_prefix . 'lang');
define('LOG_TABLE',					$table_prefix . 'log');
define('LOGIN_ATTEMPT_TABLE',		$table_prefix . 'login_attempts');
define('MODERATOR_CACHE_TABLE',		$table_prefix . 'moderator_cache');
define('MODULES_TABLE',				$table_prefix . 'modules');
define('POLL_OPTIONS_TABLE',		$table_prefix . 'poll_options');
define('POLL_VOTES_TABLE',			$table_prefix . 'poll_votes');
define('POSTS_TABLE',				$table_prefix . 'posts');
define('PRIVMSGS_TABLE',			$table_prefix . 'privmsgs');
define('PRIVMSGS_FOLDER_TABLE',		$table_prefix . 'privmsgs_folder');
define('PRIVMSGS_RULES_TABLE',		$table_prefix . 'privmsgs_rules');
define('PRIVMSGS_TO_TABLE',			$table_prefix . 'privmsgs_to');
define('PROFILE_FIELDS_TABLE',		$table_prefix . 'profile_fields');
define('PROFILE_FIELDS_DATA_TABLE',	$table_prefix . 'profile_fields_data');
define('PROFILE_FIELDS_LANG_TABLE',	$table_prefix . 'profile_fields_lang');
define('PROFILE_LANG_TABLE',		$table_prefix . 'profile_lang');
define('RANKS_TABLE',				$table_prefix . 'ranks');
define('REPORTS_TABLE',				$table_prefix . 'reports');
define('REPORTS_REASONS_TABLE',		$table_prefix . 'reports_reasons');
define('SEARCH_RESULTS_TABLE',		$table_prefix . 'search_results');
define('SEARCH_WORDLIST_TABLE',		$table_prefix . 'search_wordlist');
define('SEARCH_WORDMATCH_TABLE',	$table_prefix . 'search_wordmatch');
define('SESSIONS_TABLE',			$table_prefix . 'sessions');
define('SESSIONS_KEYS_TABLE',		$table_prefix . 'sessions_keys');
define('SITELIST_TABLE',			$table_prefix . 'sitelist');
define('SMILIES_TABLE',				$table_prefix . 'smilies');
define('STYLES_TABLE',				$table_prefix . 'styles');
define('STYLES_TEMPLATE_TABLE',		$table_prefix . 'styles_template');
define('STYLES_TEMPLATE_DATA_TABLE',$table_prefix . 'styles_template_data');
define('STYLES_THEME_TABLE',		$table_prefix . 'styles_theme');
define('STYLES_IMAGESET_TABLE',		$table_prefix . 'styles_imageset');
define('STYLES_IMAGESET_DATA_TABLE',$table_prefix . 'styles_imageset_data');
define('TOPICS_TABLE',				$table_prefix . 'topics');
define('TOPICS_POSTED_TABLE',		$table_prefix . 'topics_posted');
define('TOPICS_TRACK_TABLE',		$table_prefix . 'topics_track');
define('TOPICS_WATCH_TABLE',		$table_prefix . 'topics_watch');
define('USER_GROUP_TABLE',			$table_prefix . 'user_group');
define('USERS_TABLE',				$table_prefix . 'users');
define('WARNINGS_TABLE',			$table_prefix . 'warnings');
define('WORDS_TABLE',				$table_prefix . 'words');
define('ZEBRA_TABLE',				$table_prefix . 'zebra');

// Additional tables
define('STATS_ADDONS_TABLE',		$table_prefix . 'stats_addons');
define('STATS_CONFIG_TABLE',		$table_prefix . 'stats_config');
define('STATS_SMILIES_TABLE',		$table_prefix . 'stats_smilies');
define('STATS_BBCODES_TABLE',		$table_prefix . 'stats_bbcodes');

// lefty74's User Reminder Constants
define('ENABLED', 1);
define('AUTOMATIC', 0);
define('OVERRIDE', 1);
define('RETAIN_POSTS', 1);
define('DELETE_POSTS', 0);
define('PAGES_TABLE',				$table_prefix . 'pages');

// BEGIN : OurTube
define('TUBE_CATEGORIES_TABLE',			$table_prefix . 'tube_categories');
define('TUBE_ITEMS_TABLE',				$table_prefix . 'tube_items');
define('TUBE_RATINGS_TABLE',			$table_prefix . 'tube_ratings');
define('TUBE_COMMENTS_TABLE',			$table_prefix . 'tube_comments');
// END

define('WWH_TABLE',							$table_prefix . 'wwh');
define('PORTAL_CONFIG_TABLE',		        $table_prefix . 'portal_config');
define('LINKPAGE_ROOT_PATH', 'linkpage/');
define('LINKPAGE_CONFIG_TABLE',				$table_prefix . 'linkpage_config');
define('LINKPAGE_CATEGORIES_TABLE',			$table_prefix . 'linkpage_categories');
define('LINKPAGE_URL_TABLE',				$table_prefix . 'linkpage_url');
define('GALLERY_ROOT_PATH', 'gallery/');
define('GALLERY_ALBUMS_TABLE',			$table_prefix . 'gallery_albums');
define('GALLERY_ATRACK_TABLE',			$table_prefix . 'gallery_albums_track');
define('GALLERY_COMMENTS_TABLE',		$table_prefix . 'gallery_comments');
define('GALLERY_CONFIG_TABLE',			$table_prefix . 'gallery_config');
define('GALLERY_CONTESTS_TABLE',		$table_prefix . 'gallery_contests');
define('GALLERY_FAVORITES_TABLE',		$table_prefix . 'gallery_favorites');
define('GALLERY_IMAGES_TABLE',			$table_prefix . 'gallery_images');
define('GALLERY_MODSCACHE_TABLE',		$table_prefix . 'gallery_modscache');
define('GALLERY_PERMISSIONS_TABLE',		$table_prefix . 'gallery_permissions');
define('GALLERY_RATES_TABLE',			$table_prefix . 'gallery_rates');
define('GALLERY_REPORTS_TABLE',			$table_prefix . 'gallery_reports');
define('GALLERY_ROLES_TABLE',			$table_prefix . 'gallery_roles');
define('GALLERY_USERS_TABLE',			$table_prefix . 'gallery_users');
define('GALLERY_WATCH_TABLE',			$table_prefix . 'gallery_watch');
define('WWH_TABLE',						$table_prefix . 'wwh');

// lefty74 Announcement Centre
define('ANNOUNCEMENTS_CENTRE_TABLE',$table_prefix . 'announcement_centre');
define('GROUPS_ONLY', 0);
define('EVERYONE', 1);
define('GUESTS_ONLY', 2);
define('WPM_TABLE',					$table_prefix . 'wpm');

?>

Re: SQL-query probleem bij instal Welcome PM on first Login

Geplaatst: 19 jul 2011, 12:56
door David
Wil jij eens proberen om een witte regel tussen te zetten tussen het stukje code wat er stond en die jij hebt toegevoegd. Zoals hier onder. Het is een gokje(weet niet zeker of het de oplossing is) maar het kan geen kwaad!

Code: Selecteer alles

define('GUESTS_ONLY', 2);

define('WPM_TABLE',               $table_prefix . 'wpm');

Re: SQL-query probleem bij instal Welcome PM on first Login

Geplaatst: 19 jul 2011, 13:01
door Paul
De prefix is niet phpbb1_, maar phpbb1 dus zonder _. De create table statement klopt dus nog steeds niet, en daarom krijg je die error ;).

Re: SQL-query probleem bij instal Welcome PM on first Login

Geplaatst: 19 jul 2011, 13:03
door yomi
Helaas geen verbetering,
Heb de witte regel er tussen gezet, alleen de error code blijft het zelfde.

Re: SQL-query probleem bij instal Welcome PM on first Login

Geplaatst: 19 jul 2011, 13:05
door David
yomi schreef:Helaas geen verbetering,
Heb de witte regel er tussen gezet, alleen de error code blijft het zelfde.
Ik ging er vanuit dat de tabel al bestond dus zocht de oplossing in je bestanden.

Wat Paul nu aangeeft is dat de prefix nog steeds niet klopt, en de tabel er dus nog steeds niet is ;)

Re: SQL-query probleem bij instal Welcome PM on first Login

Geplaatst: 19 jul 2011, 13:08
door yomi
Update, helemaal te gek probleem is opgelost.
David en Paul heel erg bedank voor jullie hulp.
het was inderdaad dat _ dat weg moest.
Weer een hoop geleerd vandaag.

:D