Debug mode: Move topic

[soulcreeper]

wat is er verkeerd gegaan in de MySQL als ik deze error krijg:

Code: Selecteer alles

Could not update topics table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ') AND forum_id = 7 AND topic_moved_id = 0' at line 2

SELECT * FROM phpbb_topics WHERE topic_id IN () AND forum_id = 7 AND topic_moved_id = 0

Line : 520
File : modcp.php

plz, help me!

[soulcreeper]

any one?

[Bee]

Aanpassingen gemaakt?

[soulcreeper]

niet dat ik weet iig. k heb net op phpbb.com een lijst ingevuld. ik post hem hier ook wel even...

URL: forum.soulcreeper.net
Template(s) used: Eos - modified to own style
Any and all MODs: Prune User Posts, Attach Mod, Close topic after X posts, Customizable 1.2.2, Disable Board Message, Merge Topics, Move topics when locked, Post icons, Pseudo subforums 1.06, Quick reply 1.15 by Smartor, Redirection suite, Resizefix
Do you use a port of phpBB: ?
Version of phpBB: 2.0.17
Version of PHP: ?
Which database server and version: MySQL 3.23.58
Host: flexwebhosting.nl
Did someone install this for you/who: no, did it myself
Is this an upgrade/from what to what: not that i know of
Is this a conversion/from what to what: not that i know of
Have you searched for your problem: yes, without any useable result
If so, what terms did you try: the complete text which the error created
State the nature of your problem: whenever i have moved a topic, after the move, this error occurs. the topic has been moved, but the error is just bothering me
Do you have a test account for us: no

[soulcreeper]

k heb het nog es ff uitgezocht en ik denk dat het met deze mod heeft te maken: Move topics when locked.
want de error verwijst naar het bestand modcp.php
klopt alles wel gewoon in deze code?

Code: Selecteer alles

#
#-----[ OPEN ]------------------------------------------
#
modcp.php

#
#-----[ FIND ]------------------------------------------
#
		$sql = "UPDATE " . TOPICS_TABLE . " 
			SET topic_status = " . TOPIC_LOCKED . "
			WHERE topic_id IN ($topic_id_sql) 
				AND forum_id = $forum_id
				AND topic_moved_id = 0";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not update topics table', '', __LINE__, __FILE__, $sql);
		}

#
#-----[ AFTER, ADD ]------------------------------------------
#
//
// START OF THE MOVE TOPICS WHEN LOCKED MODIFICATION
// 
if($board_config['move_when_locked_stat'] != -1 && $board_config['move_when_locked_stat'] == 1)
{
$move_to_forum = $board_config['move_when_locked_id'];

//
// Let's check for special topics :)
//
$sql = "SELECT * FROM " . TOPICS_TABLE . " 
WHERE topic_id IN ($topic_id_sql) 
AND forum_id = $forum_id
AND topic_moved_id = 0";
if ( !($special_result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update topics table', '', __LINE__, __FILE__, $sql);
}

while($row = $db->sql_fetchrow($special_result))
{
$move_topic_id_system = $row['topic_id'];

if(($board_config['leave_special_topic_stat'] == -1) || (($board_config['leave_special_topic_stat'] == 1) && (($row['topic_type'] == 1) || ($row['topic_type'] == 0))) || (($board_config['leave_special_topic_stat'] == 2) && ($row['topic_type'] == 0))) 
{

//
// Start moving topic and posts
//
		$sql = "UPDATE " . TOPICS_TABLE . " 
			SET forum_id = $move_to_forum
			WHERE topic_id = $move_topic_id_system
				AND forum_id = $forum_id
				AND topic_moved_id = 0";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not update topics table', '', __LINE__, __FILE__, $sql);
		}

		$sql = "UPDATE " . POSTS_TABLE . " 
			SET forum_id = $move_to_forum
			WHERE topic_id = $move_topic_id_system
				AND forum_id = $forum_id";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not update topics table', '', __LINE__, __FILE__, $sql);
		}
}
}
//
// Resync index :)
// 
				sync('forum', $forum_id);
				sync('forum', $move_to_forum);

}
//
// END OF THE MOVE TOPICS WHEN LOCKED MODIFICATION
//

[soulcreeper]

hoe kan ik deze SQL query terugdraaien?

Code: Selecteer alles

INSERT INTO phpbb_config VALUES('move_when_locked_stat',-1);
INSERT INTO phpbb_config VALUES('move_when_locked_id',1);
INSERT INTO phpbb_config VALUES('leave_special_topic_stat',-1);
INSERT INTO phpbb_config VALUES('leave_global_topic_stat',-1);

[Bee]

Code: Selecteer alles

DELETE FROM phpbb_config WHERE config_name = move_when_locked_stat; 
DELETE FROM phpbb_config WHERE config_name = move_when_locked_id; 
DELETE FROM phpbb_config WHERE config_name = leave_special_topic_stat; 
DELETE FROM phpbb_config WHERE config_name = leave_global_topic_stat;

[Paul]

Geeft denk ik een sql fout, deze is sneller:

Code: Selecteer alles

DELETE FROM phpbb_config WHERE config_name = 'move_when_locked_stat' OR config_name = 'move_when_locked_id' OR config_name = 'leave_special_topic_stat' OR config_name =  'leave_global_topic_stat';

[Bee]

Waarom zou die van mij een SQL error geven? Een beetje onderbouwing is wel handig in dit geval.

[Paul]

Niet tussen '. Volgens mij moet dat wel, alleen bij int niet.

[Bee]

Niet tussen '. Volgens mij moet dat wel, alleen bij int niet.

Dat is een onzinopmerking. De aanhalingstekens zijn optioneel. Kijk maar bij het maken van een backup in phpMyAdmin, daar kan je de aanhalingstekens ook gewoon uitzetten 8)