Pagina 1 van 1

MOD: edit Post date: Could not query Posts table.

Geplaatst: 09 mar 2005, 10:04
door Jan Heijnsdijk jr
Mod: Edit Post Date
Algemene Fout

Could not query Posts table.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

SELECT post_time FROM phpbb_posts WHERE post_id =

Line : 48
File : *.nl/forum/includes/edit_post_date.php

hier het betreffende stukje (lijn 40 t/m 53) lijn 48 is vetgedrukt:

// Pull current Post date for the Post in question
//
$sql = "SELECT post_time" .
" FROM ". POSTS_TABLE .
" WHERE post_id = $p";

if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query Posts table.', '', __LINE__, __FILE__, $sql);
}

$row = $db->sql_fetchrow($result);
$current_post_date = $row['post_time'];
$new_post_date = "";


-----
Alvast bedankt!

Geplaatst: 09 mar 2005, 11:41
door djrandall
http://www.phpbb.nl/viewtopic.php?p=138552#138552

Maar die MOD is vrij verouderd. Er zitten meerdere fouten in.

Geplaatst: 10 mar 2005, 07:40
door Jan Heijnsdijk jr
Thx voor zover in elk geval! :)

Groetjes,

Jan Heijnsdijk jr
ex-oosterhouter :)