phpBB.nl

Code: Selecteer alles

DELETE FROM phpbb_warnings WHERE user_id = GEBRUIKER_ID LIMIT 1;
UPDATE phpbb_warnings SET user_warnings = user_warnings -1 WHERE user_id = GEBRUIKER_ID LIMIT 1;

Code: Selecteer alles

SQL ERROR [ mysql4 ]

Unknown column 'user_warnings' in 'field list' [1054]

SQL

UPDATE phpbb_warnings SET user_warnings = user_warnings -1 WHERE user_id = 77 LIMIT 1

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: sql.php
LINE: 45
CALL: dbal_mysql->sql_query()

Code: Selecteer alles

DELETE FROM phpbb_warnings WHERE user_id = 77 LIMIT 1;
UPDATE phpbb_warnings SET user_warnings = user_warnings -1 WHERE user_id = 77 LIMIT 1;

Code: Selecteer alles

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'db.gamerookie.nl';
$dbport = '';
$dbname = '*******';
$dbuser = '*******';
$dbpasswd = '******';

$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

Code: Selecteer alles

DELETE FROM phpbb_warnings WHERE user_id = 77 LIMIT 1;
UPDATE phpbb_users SET user_warnings = user_warnings -1 WHERE user_id = 77 LIMIT 1;