[sql] Double Post Merge

[Diablo Gamer]

ik moest dit bestandje laten lopen maar ik krijg gelijk deze error double_post_merge_mod_install.php

Code: Selecteer alles

Could not update database

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'AFTER flood_interval' at line 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('join_interval', '18') AFTER flood_interval

Line : 55
File : double_post_merge_mod_install.php

en via phpMyAdmin krijg ik deze error

Code: Selecteer alles

Error 
SQL-query: 

INSERT INTO bbcc_config (config_name, config_value) VALUES ('join_interval', '18');
MySQL said: Table 'tb316505.bbcc_config' doesn't exist

[Muiter]

Code: Selecteer alles

INSERT INTO bbcc_config

Je moet de prefix aanpassen:

Code: Selecteer alles

INSERT INTO phpbb_config

[Diablo Gamer]

en waar kan ik dat doe in de install bestand

double_post_merge_mod_install.php

Code: Selecteer alles

<?php
/***************************************************************************
 *                      double_post_merge_mod_install.php
 *                            -------------------
 *   copyright            : ©2004 Mercuree
 *   built for            : Double post merge
 *
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//


if( !$userdata['session_logged_in'] )
{
	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
	header($header_location . append_sid('login.'.$phpEx.'?redirect=double_post_merge_mod_install.'.$phpEx));
	exit;
}

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}


$sql = array();
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('join_interval', '18') AFTER flood_interval";

for( $i = 0; $i < count($sql); $i++ )
{
	if( !$result = $db->sql_query ($sql[$i]) )
	{
		message_die(GENERAL_ERROR, 'Could not update database', '', __LINE__, __FILE__, $sql[$i]);
	}

	$sql_message .= '* ' . $sql[$i] . '<br />';
}

$message = 'Database updated successfully<br />The following queries were executed:<br /><br /><span class="genmed">' . $sql_message . '</span><br /><br />Please be sure to delete this file now<br /><br />' . sprintf ($lang['Click_return_index'], '<a href="' . append_sid ('index.'.$phpEx) . '">', '</a>');
message_die (GENERAL_MESSAGE, $message);

?>

[Muiter]

en waar kan ik dat doe in de install bestand

Niet, pas je SQL commando aan in phpbb_double_post_merge.txt en verwerk die dan in phpMyAdmin.

[Diablo Gamer]

dus deze ?

Code: Selecteer alles

#-----[ SQL ]------------------------------------------
#
# during 18 (you can change this) hours messages will join to the last
#
# if you don't know nothing about SQL just run double_post_merge_mod_install.php
#
INSERT INTO bbcc_config (config_name, config_value) VALUES ('join_interval', '18');
#
#-----[ OPEN ]------------------------------------------

[Muiter]

dus deze ?

Ja, volgens mij is dat de enige SQL commando die je hebt.

[Diablo Gamer]

dus deze ?

Ja, volgens mij is dat de enige SQL commando die je hebt.

via phpMyAdmin krijg ik deze error

Code: Selecteer alles

Error 
SQL-query: 

INSERT INTO bbcc_config (config_name, config_value) VALUES ('join_interval', '18');
MySQL said: Table 'tb316505.bbcc_config' doesn't exist

[Muiter]

Je moet wel de prefix wel aanpassen. Als je phpbb_ gebruikt word het dus:

Code: Selecteer alles

INSERT INTO phpbb_config (config_name, config_value) VALUES ('join_interval', '18');

[Diablo Gamer]

mijn fout dat komt dat ik geen verstant van SQL heb

[Muiter]

mijn fout dat komt dat ik geen verstant van SQL heb

Zo is iedereen begonnen.