SQL-Befehl: #%% # ---------------------------------------------------------- # # structur for table 'cms_cpg_pictures' # CREATE TABLE cms_cpg_pictures( `pid` int( 11 ) NOT NULL AUTO_INCREMENT , `aid` int( 11 ) DEFAULT '0' NOT NULL , `filepath` varchar( 255 ) NOT NULL , `filename` varchar( 255 ) NOT NULL , `filesize` int( 11 ) DEFAULT '0' NOT NULL , `total_filesize` int( 11 ) DEFAULT '0' NOT NULL , `pwidth` smallint( 6 ) DEFAULT '0' NOT NULL , `pheight` smallint( 6 ) DEFAULT '0' NOT NULL , `hits` int( 11 ) DEFAULT '0' NOT NULL , `mtime` timestamp DEFAULT 'CURRENT_TIMESTAMP', `ctime` int( 11 ) DEFAULT '0' NOT NULL , `owner_id` int( 11 ) DEFAULT '0' NOT NULL , `owner_name` varchar( 40 ) NOT NULL , `pic_rating` int( 11 ) DEFAULT '0' NOT NULL , `votes` int( 11 ) DEFAULT '0' NOT NULL , `title` varchar( 255 ) NOT NULL , `caption` text NOT NULL , `keywords` varchar( 255 ) NOT NULL , `approved` enum( 'YES', 'NO' ) DEFAULT 'NO' NOT NULL , `user1` varchar( 255 ) NOT NULL , `user2` varchar( 255 ) NOT NULL , `user3` varchar( 255 ) NOT NULL , `user4` varchar( 255 ) NOT NULL , `url_prefix` tinyint( 4 ) DEFAULT '0' NOT NULL , `randpos` int( 11 ) DEFAULT '0' NOT NULL , `pic_raw_ip` tinytext, `pic_hdr_ip` tinytext, PRIMARY KEY ( `pid` ) , KEY pic_hits( `hits` ) , KEY pic_rate( `pic_rating` ) , KEY aid_approved( `aid` , `approved` ) , KEY randpos( `randpos` ) , KEY pic_aid( `aid` ) , KEY search( `title` , `caption` , `keywords` , `filename` , `user1` , `user2` , `user3` , `user4` ) ) MySQL meldet: Dokumentation #1170 - BLOB column 'caption' used in key specification without a key length
Please help!
Da meine andere Datenbank nicht mehr funktioniert wäre dies also die einzigste Chance, meine Homepage Daten zu retten!
Edit: Und wenn ich trotzdem auf die Page geh, kommt dieser Fehler:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/hosting/crazykenny03/eoa/include/includes/func/db/mysql.php on line 48 Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/export/www/hosting/crazykenny03/eoa/include/includes/func/db/mysql.php on line 44 Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/export/www/hosting/crazykenny03/eoa/include/includes/func/db/mysql.php on line 44 Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/hosting/crazykenny03/eoa/include/includes/func/db/mysql.php on line 48 Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/hosting/crazykenny03/eoa/include/includes/func/db/mysql.php on line 48 Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/export/www/hosting/crazykenny03/eoa/include/includes/func/db/mysql.php on line 48
verwendete ilchClan Version: 1.1
betroffene Homepage: crazykenny03.cr.ohost.de/eoa/
Zuletzt modifiziert von kenny am 08.06.2006 - 23:41:14