phpBB.de

Code: Alles auswählen

Cannot delete rows.

DEBUG MODE

SQL Error : 1054 Unknown column 'chart_id' in 'where clause'

DELETE FROM phpbb_charts_voters WHERE chart_id = 16

Line : 166
File : /is/htdocs/42846/www.vahid.de/gbg/forum/admin/admin_charts.php

Code: Alles auswählen

define('CHARTS_TABLE', $table_prefix.'charts');
define('CHARTS_VOTERS_TABLE', $table_prefix.'charts_voters');

Code: Alles auswählen

SQL Error : 1064 You have an error in your SQL syntax near '(chart_hot-chart_not) DESC, chart_artist LIMIT 0,30' at line 1

SELECT chart_id, chart_hot, chart_not, chart_song_name, chart_artist, chart_album, chart_last_pos, chart_best_pos, username FROM technoforum_CHARTS_TABLE, technoforum_USERS_TABLE WHERE chart_poster_id=user_id ORDER BY (chart_hot-chart_not) DESC, chart_artist LIMIT 0,30

Line : 90
File : /mnt/ls6/14/228/00000002/htdocs/forum2/charts.php

Code: Alles auswählen

        	$v_num = ($mode == "list")?10:30;