der-domi.de

Code: Alles auswählen

ALTER TABLE usr_FILME_TRAILER_TYP ADD TrailerBreite INT( 4 ) UNSIGNED DEFAULT NULL

Table 'usr_.usr_FILME_TRAILER_TYP' doesn't exist

ALTER TABLE usr_FILME_TRAILER_TYP ADD TrailerHoehe INT( 4 ) UNSIGNED DEFAULT NULL

Table 'usr_.usr_web202_1_FILME_TRAILER_TYP' doesn't exist 

Code: Alles auswählen

SELECT * FROM usr_FILME AS fi LEFT OUTER JOIN usr_FILME_TRAILER_TYP AS tr ON fi.FilmID = tr.filmeFilmID WHERE fi.FilmID = 500

Unknown column 'tr.filmeFilmID' in 'on clause'

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/filmeverwaltung/classes/class.db.php on line 138
cover

SELECT COUNT(*) AS Anz FROM usr_DISCS di INNER JOIN usr_FILME fi ON FILME_FilmID=FilmID WHERE COLLECT_CollectID= AND di.USERS_UserID!=0 AND DiscID=459

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 'AND di.USERS_UserID!=0 AND DiscID=459' at line 1

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/filmeverwaltung/classes/class.db.php on line 138

SELECT Bezeichnung FROM usr_COLLECT WHERE CollectID =

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 

Code: Alles auswählen

SELECT Bezeichnung as Name FROM usr_SPRACHE INNER JOIN usr_FILME_UNTERTITEL ON SPRACHE_SprachID = SprachID WHERE FILME_FilmID = 500

Table 'usr_.usr_FILME_UNTERTITEL' doesn't exist

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/filmeverwaltung/classes/class.db.php on line 138

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/filmeverwaltung/classes/class.db.php on line 138 

Code: Alles auswählen

SELECT TrailerConfig FROM usr_FILME_TRAILER_TYP WHERE filmeFilmID = 501 AND TrailerTypID = 3

Unknown column 'filmeFilmID' in 'where clause'

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/web202/html/filmeverwaltung/classes/class.db.php on line 138

UPDATE usr_FILME_TRAILER_TYP SET TrailerBreite = NULL, TrailerHoehe = NULL WHERE FILMEFilmID=501

Unknown column 'FILMEFilmID' in 'where clause'