phpBB.de

Code: Alles auswählen

Tabelle 'xxxxx.phpbb_gallery_watch' existiert nicht [1146]

SQL

SELECT a.*, w.watch_id FROM phpbb_gallery_albums AS a LEFT JOIN phpbb_gallery_watch AS w ON a.album_id = w.album_id AND w.user_id = 2 WHERE a.album_id = 1

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: gallery/includes/functions.php
LINE: 85
CALL: dbal_mysqli->sql_query()

FILE: gallery/album.php
LINE: 44
CALL: get_album_info()

Code: Alles auswählen

CREATE TABLE phpbb_gallery_watch (
	watch_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	album_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	image_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	PRIMARY KEY (watch_id),
	KEY user_id (user_id),
	KEY image_id (image_id),
	KEY album_id (album_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;