Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Pawel_el

Pages: [1] 2
1
Installation, Update & Configuration / ein Problem mit Fotos
« on: February 03, 2018, 09:00:13 PM »
Hallo. Ich habe ein Problem, was zu tun ist

Es gibt immer noch ein Problem beim Hochladen von Fotos:
Quote
Warning: move_uploaded_file(./data/media/31/image596.jpg) [function.move-uploaded-file]: failed to open stream: No such file or directory in /profiles/p/ph/pho/photo-komunikacja/photo-komunikacja.cba.pl/includes/upload.php on line 113

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpQaEQiC' to './data/media/31/image596.jpg' in /profiles/p/ph/pho/photo-komunikacja/photo-komunikacja.cba.pl/includes/upload.php on line 113

2
Hallo.
Bitte laden Sie die Datei herunter
Grüße

3
Installation, Update & Configuration / Problem
« on: December 27, 2017, 04:04:50 PM »
Hallo. Im Jahr 2012 habe ich ein Konto eingerichtet, jetzt ein Problem, weil ich versehentlich mein Konto gelöscht habe, aber der Server ist ... was kann ich tun?
1.Die Datenbank ist
2.FTP ist auch
3.Mysql ist auch
2012 war alles gut gemacht, aber leider muss ich es wieder installieren ;; /

Quote
DB Error: Bad SQL Query: CREATE TABLE 4images_categories (cat_id int(10) unsigned NOT NULL auto_increment,cat_name varchar(255) NOT NULL default '',cat_description text NOT NULL,cat_parent_id int(10) unsigned NOT NULL default '0',cat_hits int(10) unsigned NOT NULL default '0',cat_order int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(2) NOT NULL default '0',auth_viewimage tinyint(2) NOT NULL default '0',auth_download tinyint(2) NOT NULL default '0',auth_upload tinyint(2) NOT NULL default '0',auth_directupload tinyint(2) NOT NULL default '0',auth_vote tinyint(2) NOT NULL default '0',auth_sendpostcard tinyint(2) NOT NULL default '0',auth_readcomment tinyint(2) NOT NULL default '0',auth_postcomment tinyint(2) NOT NULL default '0',PRIMARY KEY (cat_id),KEY cat_parent_id (cat_parent_id),KEY cat_order (cat_order)) ENGINE=MyISAM
Table '4images_categories' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_comments (comment_id int(10) unsigned NOT NULL auto_increment,image_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',user_name varchar(100) NOT NULL default '',comment_headline varchar(255) NOT NULL default '',comment_text text NOT NULL,comment_ip varchar(20) NOT NULL default '',comment_date int(11) unsigned NOT NULL default '0',PRIMARY KEY (comment_id),KEY image_id (image_id),KEY user_id (user_id),KEY comment_date (comment_date)) ENGINE=MyISAM
Table '4images_comments' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_groupaccess (group_id int(10) unsigned NOT NULL default '0',cat_id int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(1) NOT NULL default '0',auth_viewimage tinyint(1) NOT NULL default '0',auth_download tinyint(1) NOT NULL default '0',auth_upload tinyint(1) NOT NULL default '0',auth_directupload tinyint(1) NOT NULL default '0',auth_vote tinyint(1) NOT NULL default '0',auth_sendpostcard tinyint(1) NOT NULL default '0',auth_readcomment tinyint(1) NOT NULL default '0',auth_postcomment tinyint(1) NOT NULL default '0',KEY group_id (group_id),KEY cat_id (cat_id)) ENGINE=MyISAM
Table '4images_groupaccess' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_groupmatch (group_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',groupmatch_startdate int(11) unsigned NOT NULL default '0',groupmatch_enddate int(11) unsigned NOT NULL default '0',KEY group_id (group_id),KEY user_id (user_id)) ENGINE=MyISAM
Table '4images_groupmatch' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_groups (group_id int(10) unsigned NOT NULL auto_increment,group_name varchar(100) NOT NULL default '',group_type tinyint(2) NOT NULL default '1',PRIMARY KEY (group_id)) ENGINE=MyISAM
Table '4images_groups' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_images (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_active tinyint(1) NOT NULL default '1',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',image_allow_comments tinyint(1) NOT NULL default '1',image_comments int(10) unsigned NOT NULL default '0',image_downloads int(10) unsigned NOT NULL default '0',image_votes int(10) unsigned NOT NULL default '0',image_rating decimal(4,2) NOT NULL default '0.00',image_hits int(10) unsigned NOT NULL default '0',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id),KEY image_date (image_date),KEY image_active (image_active)) ENGINE=MyISAM
Table '4images_images' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_images_temp (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id)) ENGINE=MyISAM
Table '4images_images_temp' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_lightboxes (lightbox_id varchar(32) NOT NULL default '',user_id int(11) NOT NULL default '0',lightbox_lastaction int(11) unsigned NOT NULL default '0',lightbox_image_ids text,KEY lightbox_id (lightbox_id),KEY user_id (user_id)) ENGINE=MyISAM
Table '4images_lightboxes' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_postcards (postcard_id varchar(32) NOT NULL default '',image_id int(10) unsigned NOT NULL default '0',postcard_date int(11) unsigned NOT NULL default '0',postcard_bg_color varchar(100) NOT NULL default '',postcard_border_color varchar(100) NOT NULL default '',postcard_font_color varchar(100) NOT NULL default '',postcard_font_face varchar(100) NOT NULL default '',postcard_sender_name varchar(255) NOT NULL default '',postcard_sender_email varchar(255) NOT NULL default '',postcard_recipient_name varchar(255) NOT NULL default '',postcard_recipient_email varchar(255) NOT NULL default '',postcard_headline varchar(255) NOT NULL default '',postcard_message text NOT NULL,PRIMARY KEY (postcard_id)) ENGINE=MyISAM
Table '4images_postcards' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_sessions (session_id varchar(32) NOT NULL default '',session_user_id int(11) NOT NULL default '0',session_lastaction int(11) unsigned NOT NULL default '0',session_location varchar(255) NOT NULL default '',session_ip varchar(15) NOT NULL default '',PRIMARY KEY (session_id),KEY session_user_id (session_user_id),KEY session_id_ip_user_id (session_id,session_ip,session_user_id)) ENGINE=HEAP
Table '4images_sessions' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_settings (setting_name varchar(255) NOT NULL default '',setting_value mediumtext NOT NULL,PRIMARY KEY (setting_name)) ENGINE=MyISAM
Table '4images_settings' already exists

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('site_name', '4images - Image Gallery Management System')
Duplicate entry 'site_name' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('site_email', 'admin@yourdomain.com')
Duplicate entry 'site_email' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('use_smtp', '0')
Duplicate entry 'use_smtp' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('smtp_host', '')
Duplicate entry 'smtp_host' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('smtp_username', '')
Duplicate entry 'smtp_username' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('smtp_password', '')
Duplicate entry 'smtp_password' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('template_dir', 'default_960px')
Duplicate entry 'template_dir' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('language_dir', 'deutsch')
Duplicate entry 'language_dir' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('date_format', 'd.m.Y')
Duplicate entry 'date_format' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('time_format', 'H:i')
Duplicate entry 'time_format' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('convert_tool', 'gd')
Duplicate entry 'convert_tool' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('convert_tool_path', '')
Duplicate entry 'convert_tool_path' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('gz_compress', '0')
Duplicate entry 'gz_compress' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('gz_compress_level', '6')
Duplicate entry 'gz_compress_level' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_cells', '2')
Duplicate entry 'cat_cells' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_table_width', '100%')
Duplicate entry 'cat_table_width' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_table_cellspacing', '1')
Duplicate entry 'cat_table_cellspacing' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('cat_table_cellpadding', '3')
Duplicate entry 'cat_table_cellpadding' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('num_subcats', '3')
Duplicate entry 'num_subcats' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_order', 'image_name')
Duplicate entry 'image_order' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_sort', 'ASC')
Duplicate entry 'image_sort' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('new_cutoff', '10')
Duplicate entry 'new_cutoff' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_border', '1')
Duplicate entry 'image_border' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_cells', '3')
Duplicate entry 'image_cells' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('default_image_rows', '3')
Duplicate entry 'default_image_rows' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('custom_row_steps', '10')
Duplicate entry 'custom_row_steps' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_table_width', '100%')
Duplicate entry 'image_table_width' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_table_cellspacing', '1')
Duplicate entry 'image_table_cellspacing' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('image_table_cellpadding', '3')
Duplicate entry 'image_table_cellpadding' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('upload_mode', '2')
Duplicate entry 'upload_mode' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('allowed_mediatypes', 'jpg,gif,png,aif,au,avi,mid,mov,mp3,mpg,swf,wav,ra,rm,zip,pdf')
Duplicate entry 'allowed_mediatypes' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_thumb_width', '300')
Duplicate entry 'max_thumb_width' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_thumb_height', '300')
Duplicate entry 'max_thumb_height' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_thumb_size', '100')
Duplicate entry 'max_thumb_size' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_image_width', '1024')
Duplicate entry 'max_image_width' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_image_height', '1024')
Duplicate entry 'max_image_height' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('max_media_size', '2000')
Duplicate entry 'max_media_size' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('upload_notify', '0')
Duplicate entry 'upload_notify' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('upload_emails', '')
Duplicate entry 'upload_emails' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail', '1')
Duplicate entry 'auto_thumbnail' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail_dimension', '100')
Duplicate entry 'auto_thumbnail_dimension' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail_resize_type', '1')
Duplicate entry 'auto_thumbnail_resize_type' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('auto_thumbnail_quality', '75')
Duplicate entry 'auto_thumbnail_quality' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('badword_list', '<i>tra-la-la</i> {<i>tra-la-la</i>}')
Duplicate entry 'badword_list' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('badword_replace_char', '*')
Duplicate entry 'badword_replace_char' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('wordwrap_comments', '50')
Duplicate entry 'wordwrap_comments' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('html_comments', '0')
Duplicate entry 'html_comments' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('bb_comments', '1')
Duplicate entry 'bb_comments' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('bb_img_comments', '0')
Duplicate entry 'bb_img_comments' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('category_separator', '&nbsp;/&nbsp;')
Duplicate entry 'category_separator' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('paging_range', '5')
Duplicate entry 'paging_range' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_edit_image', '1')
Duplicate entry 'user_edit_image' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_delete_image', '1')
Duplicate entry 'user_delete_image' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_edit_comments', '1')
Duplicate entry 'user_edit_comments' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('user_delete_comments', '1')
Duplicate entry 'user_delete_comments' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('account_activation', '1')
Duplicate entry 'account_activation' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('activation_time', '14')
Duplicate entry 'activation_time' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('session_timeout', '15')
Duplicate entry 'session_timeout' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('display_whosonline', '1')
Duplicate entry 'display_whosonline' for key 'PRIMARY'

DB Error: Bad SQL Query: INSERT INTO 4images_settings VALUES ('highlight_admin', '1')
Duplicate entry 'highlight_admin' for key 'PRIMARY'

DB Error: Bad SQL Query: CREATE TABLE 4images_users (user_id int(11) NOT NULL auto_increment,user_level int(11) NOT NULL default '1',user_name varchar(255) NOT NULL default '',user_password varchar(255) NOT NULL default '',user_email varchar(255) NOT NULL default '',user_showemail tinyint(1) NOT NULL default '0',user_allowemails tinyint(1) NOT NULL default '1',user_invisible tinyint(1) NOT NULL default '0',user_joindate int(11) unsigned NOT NULL default '0',user_activationkey varchar(32) NOT NULL default '',user_lastaction int(11) unsigned NOT NULL default '0',user_location varchar(255) NOT NULL default '',user_lastvisit int(11) unsigned NOT NULL default '0',user_comments int(10) unsigned NOT NULL default '0',user_homepage varchar(255) NOT NULL default '',user_icq varchar(20) NOT NULL default '',PRIMARY KEY (user_id),KEY user_lastaction (user_lastaction),KEY user_name (user_name)) ENGINE=MyISAM
Table '4images_users' already exists

DB Error: Bad SQL Query: INSERT INTO 4images_users VALUES (-1, -1, 'Guest', '0493984f537120be0b8d96bc9b69cdd2', '', 0, 0, 0, 0, '', 0, '', 0, 0, '', '')
Column count doesn't match value count at row 1

DB Error: Bad SQL Query: INSERT INTO 4images_users VALUES (1, 9, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 1, 1, 0, 1016023608, '1e3457c0b2052a9633b886fd75ef91e0', 1016023608, '', 0, 0, '', '')
Column count doesn't match value count at row 1

DB Error: Bad SQL Query: CREATE TABLE 4images_wordlist (word_text varchar(50) NOT NULL default '',word_id int(10) unsigned NOT NULL auto_increment,PRIMARY KEY (word_id),UNIQUE KEY word_text (word_text)) ENGINE=MyISAM
Table '4images_wordlist' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_wordmatch (image_id int(10) unsigned NOT NULL default '0',word_id int(10) unsigned NOT NULL default '0',name_match tinyint(1) NOT NULL default '0',desc_match tinyint(1) NOT NULL default '0',keys_match tinyint(1) NOT NULL default '0',UNIQUE KEY image_word_id (image_id,word_id)) ENGINE=MyISAM
Table '4images_wordmatch' already exists
Wyst±pi³y b³êdy podczas aktualizacji bazy danych:

CREATE TABLE 4images_categories (cat_id int(10) unsigned NOT NULL auto_increment,cat_name varchar(255) NOT NULL default '',cat_description text NOT NULL,cat_parent_id int(10) unsigned NOT NULL default '0',cat_hits int(10) unsigned NOT NULL default '0',cat_order int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(2) NOT NULL default '0',auth_viewimage tinyint(2) NOT NULL default '0',auth_download tinyint(2) NOT NULL default '0',auth_upload tinyint(2) NOT NULL default '0',auth_directupload tinyint(2) NOT NULL default '0',auth_vote tinyint(2) NOT NULL default '0',auth_sendpostcard tinyint(2) NOT NULL default '0',auth_readcomment tinyint(2) NOT NULL default '0',auth_postcomment tinyint(2) NOT NULL default '0',PRIMARY KEY (cat_id),KEY cat_parent_id (cat_parent_id),KEY cat_order (cat_order)) ENGINE=MyISAM
CREATE TABLE 4images_comments (comment_id int(10) unsigned NOT NULL auto_increment,image_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',user_name varchar(100) NOT NULL default '',comment_headline varchar(255) NOT NULL default '',comment_text text NOT NULL,comment_ip varchar(20) NOT NULL default '',comment_date int(11) unsigned NOT NULL default '0',PRIMARY KEY (comment_id),KEY image_id (image_id),KEY user_id (user_id),KEY comment_date (comment_date)) ENGINE=MyISAM
CREATE TABLE 4images_groupaccess (group_id int(10) unsigned NOT NULL default '0',cat_id int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(1) NOT NULL default '0',auth_viewimage tinyint(1) NOT NULL default '0',auth_download tinyint(1) NOT NULL default '0',auth_upload tinyint(1) NOT NULL default '0',auth_directupload tinyint(1) NOT NULL default '0',auth_vote tinyint(1) NOT NULL default '0',auth_sendpostcard tinyint(1) NOT NULL default '0',auth_readcomment tinyint(1) NOT NULL default '0',auth_postcomment tinyint(1) NOT NULL default '0',KEY group_id (group_id),KEY cat_id (cat_id)) ENGINE=MyISAM
CREATE TABLE 4images_groupmatch (group_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',groupmatch_startdate int(11) unsigned NOT NULL default '0',groupmatch_enddate int(11) unsigned NOT NULL default '0',KEY group_id (group_id),KEY user_id (user_id)) ENGINE=MyISAM
CREATE TABLE 4images_groups (group_id int(10) unsigned NOT NULL auto_increment,group_name varchar(100) NOT NULL default '',group_type tinyint(2) NOT NULL default '1',PRIMARY KEY (group_id)) ENGINE=MyISAM
CREATE TABLE 4images_images (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_active tinyint(1) NOT NULL default '1',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',image_allow_comments tinyint(1) NOT NULL default '1',image_comments int(10) unsigned NOT NULL default '0',image_downloads int(10) unsigned NOT NULL default '0',image_votes int(10) unsigned NOT NULL default '0',image_rating decimal(4,2) NOT NULL default '0.00',image_hits int(10) unsigned NOT NULL default '0',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id),KEY image_date (image_date),KEY image_active (image_active)) ENGINE=MyISAM
CREATE TABLE 4images_images_temp (image_id int(10) unsigned NOT NULL auto_increment,cat_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',image_name varchar(255) NOT NULL default '',image_description text NOT NULL,image_keywords text NOT NULL,image_date int(11) unsigned NOT NULL default '0',image_media_file varchar(255) NOT NULL default '',image_thumb_file varchar(255) NOT NULL default '',image_download_url varchar(255) NOT NULL default '',PRIMARY KEY (image_id),KEY cat_id (cat_id),KEY user_id (user_id)) ENGINE=MyISAM
CREATE TABLE 4images_lightboxes (lightbox_id varchar(32) NOT NULL default '',user_id int(11) NOT NULL default '0',lightbox_lastaction int(11) unsigned NOT NULL default '0',lightbox_image_ids text,KEY lightbox_id (lightbox_id),KEY user_id (user_id)) ENGINE=MyISAM
CREATE TABLE 4images_postcards (postcard_id varchar(32) NOT NULL default '',image_id int(10) unsigned NOT NULL default '0',postcard_date int(11) unsigned NOT NULL default '0',postcard_bg_color varchar(100) NOT NULL default '',postcard_border_color varchar(100) NOT NULL default '',postcard_font_color varchar(100) NOT NULL default '',postcard_font_face varchar(100) NOT NULL default '',postcard_sender_name varchar(255) NOT NULL default '',postcard_sender_email varchar(255) NOT NULL default '',postcard_recipient_name varchar(255) NOT NULL default '',postcard_recipient_email varchar(255) NOT NULL default '',postcard_headline varchar(255) NOT NULL default '',postcard_message text NOT NULL,PRIMARY KEY (postcard_id)) ENGINE=MyISAM
CREATE TABLE 4images_sessions (session_id varchar(32) NOT NULL default '',session_user_id int(11) NOT NULL default '0',session_lastaction int(11) unsigned NOT NULL default '0',session_location varchar(255) NOT NULL default '',session_ip varchar(15) NOT NULL default '',PRIMARY KEY (session_id),KEY session_user_id (session_user_id),KEY session_id_ip_user_id (session_id,session_ip,session_user_id)) ENGINE=HEAP
CREATE TABLE 4images_settings (setting_name varchar(255) NOT NULL default '',setting_value mediumtext NOT NULL,PRIMARY KEY (setting_name)) ENGINE=MyISAM
INSERT INTO 4images_settings VALUES ('site_name', '4images - Image Gallery Management System')
INSERT INTO 4images_settings VALUES ('site_email', 'admin@yourdomain.com')
INSERT INTO 4images_settings VALUES ('use_smtp', '0')
INSERT INTO 4images_settings VALUES ('smtp_host', '')
INSERT INTO 4images_settings VALUES ('smtp_username', '')
INSERT INTO 4images_settings VALUES ('smtp_password', '')
INSERT INTO 4images_settings VALUES ('template_dir', 'default_960px')
INSERT INTO 4images_settings VALUES ('language_dir', 'deutsch')
INSERT INTO 4images_settings VALUES ('date_format', 'd.m.Y')
INSERT INTO 4images_settings VALUES ('time_format', 'H:i')
INSERT INTO 4images_settings VALUES ('convert_tool', 'gd')
INSERT INTO 4images_settings VALUES ('convert_tool_path', '')
INSERT INTO 4images_settings VALUES ('gz_compress', '0')
INSERT INTO 4images_settings VALUES ('gz_compress_level', '6')
INSERT INTO 4images_settings VALUES ('cat_cells', '2')
INSERT INTO 4images_settings VALUES ('cat_table_width', '100%')
INSERT INTO 4images_settings VALUES ('cat_table_cellspacing', '1')
INSERT INTO 4images_settings VALUES ('cat_table_cellpadding', '3')
INSERT INTO 4images_settings VALUES ('num_subcats', '3')
INSERT INTO 4images_settings VALUES ('image_order', 'image_name')
INSERT INTO 4images_settings VALUES ('image_sort', 'ASC')
INSERT INTO 4images_settings VALUES ('new_cutoff', '10')
INSERT INTO 4images_settings VALUES ('image_border', '1')
INSERT INTO 4images_settings VALUES ('image_cells', '3')
INSERT INTO 4images_settings VALUES ('default_image_rows', '3')
INSERT INTO 4images_settings VALUES ('custom_row_steps', '10')
INSERT INTO 4images_settings VALUES ('image_table_width', '100%')
INSERT INTO 4images_settings VALUES ('image_table_cellspacing', '1')
INSERT INTO 4images_settings VALUES ('image_table_cellpadding', '3')
INSERT INTO 4images_settings VALUES ('upload_mode', '2')
INSERT INTO 4images_settings VALUES ('allowed_mediatypes', 'jpg,gif,png,aif,au,avi,mid,mov,mp3,mpg,swf,wav,ra,rm,zip,pdf')
INSERT INTO 4images_settings VALUES ('max_thumb_width', '300')
INSERT INTO 4images_settings VALUES ('max_thumb_height', '300')
INSERT INTO 4images_settings VALUES ('max_thumb_size', '100')
INSERT INTO 4images_settings VALUES ('max_image_width', '1024')
INSERT INTO 4images_settings VALUES ('max_image_height', '1024')
INSERT INTO 4images_settings VALUES ('max_media_size', '2000')
INSERT INTO 4images_settings VALUES ('upload_notify', '0')
INSERT INTO 4images_settings VALUES ('upload_emails', '')
INSERT INTO 4images_settings VALUES ('auto_thumbnail', '1')
INSERT INTO 4images_settings VALUES ('auto_thumbnail_dimension', '100')
INSERT INTO 4images_settings VALUES ('auto_thumbnail_resize_type', '1')
INSERT INTO 4images_settings VALUES ('auto_thumbnail_quality', '75')
INSERT INTO 4images_settings VALUES ('badword_list', '<i>tra-la-la</i> {<i>tra-la-la</i>}')
INSERT INTO 4images_settings VALUES ('badword_replace_char', '*')
INSERT INTO 4images_settings VALUES ('wordwrap_comments', '50')
INSERT INTO 4images_settings VALUES ('html_comments', '0')
INSERT INTO 4images_settings VALUES ('bb_comments', '1')
INSERT INTO 4images_settings VALUES ('bb_img_comments', '0')
INSERT INTO 4images_settings VALUES ('category_separator', ' / ')
INSERT INTO 4images_settings VALUES ('paging_range', '5')
INSERT INTO 4images_settings VALUES ('user_edit_image', '1')
INSERT INTO 4images_settings VALUES ('user_delete_image', '1')
INSERT INTO 4images_settings VALUES ('user_edit_comments', '1')
INSERT INTO 4images_settings VALUES ('user_delete_comments', '1')
INSERT INTO 4images_settings VALUES ('account_activation', '1')
INSERT INTO 4images_settings VALUES ('activation_time', '14')
INSERT INTO 4images_settings VALUES ('session_timeout', '15')
INSERT INTO 4images_settings VALUES ('display_whosonline', '1')
INSERT INTO 4images_settings VALUES ('highlight_admin', '1')
CREATE TABLE 4images_users (user_id int(11) NOT NULL auto_increment,user_level int(11) NOT NULL default '1',user_name varchar(255) NOT NULL default '',user_password varchar(255) NOT NULL default '',user_email varchar(255) NOT NULL default '',user_showemail tinyint(1) NOT NULL default '0',user_allowemails tinyint(1) NOT NULL default '1',user_invisible tinyint(1) NOT NULL default '0',user_joindate int(11) unsigned NOT NULL default '0',user_activationkey varchar(32) NOT NULL default '',user_lastaction int(11) unsigned NOT NULL default '0',user_location varchar(255) NOT NULL default '',user_lastvisit int(11) unsigned NOT NULL default '0',user_comments int(10) unsigned NOT NULL default '0',user_homepage varchar(255) NOT NULL default '',user_icq varchar(20) NOT NULL default '',PRIMARY KEY (user_id),KEY user_lastaction (user_lastaction),KEY user_name (user_name)) ENGINE=MyISAM
INSERT INTO 4images_users VALUES (-1, -1, 'Guest', '0493984f537120be0b8d96bc9b69cdd2', '', 0, 0, 0, 0, '', 0, '', 0, 0, '', '')
INSERT INTO 4images_users VALUES (1, 9, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 1, 1, 0, 1016023608, '1e3457c0b2052a9633b886fd75ef91e0', 1016023608, '', 0, 0, '', '')
CREATE TABLE 4images_wordlist (word_text varchar(50) NOT NULL default '',word_id int(10) unsigned NOT NULL auto_increment,PRIMARY KEY (word_id),UNIQUE KEY word_text (word_text)) ENGINE=MyISAM
CREATE TABLE 4images_wordmatch (image_id int(10) unsigned NOT NULL default '0',word_id int(10) unsigned NOT NULL default '0',name_match tinyint(1) NOT NULL default '0',desc_match tinyint(1) NOT NULL default '0',keys_match tinyint(1) NOT NULL default '0',UNIQUE KEY image_word_id (image_id,word_id)) ENGINE=MyISAM

4
Hallo.
Für mich ist es einfach passiert:
Quote
DB Error: Bad SQL Query: SELECT SUM(uvp.view_count) AS total_visits FROM 4images_users_viewprofile uvp LEFT JOIN 4images_users u ON (u.user_id = uvp.user_id) WHERE uvp.other_user_id = 1 AND u.user_level >= '2' ORDER BY uvp.view_date DESC
Table 'foto_komunikacja_cba_pl.4images_users_viewprofile' doesn't exist

DB Error: Bad SQL Query: SELECT SUM(uvp.user_id) AS total_rows FROM 4images_users_viewprofile uvp LEFT JOIN 4images_users u ON (u.user_id = uvp.user_id) WHERE uvp.other_user_id = 1 AND u.user_level >= '2' ORDER BY uvp.view_date DESC
Table 'foto_komunikacja_cba_pl.4images_users_viewprofile' doesn't exist

DB Error: Bad SQL Query: SELECT uvp.user_id, uvp.view_date, uvp.view_count, u.user_name FROM 4images_users_viewprofile uvp LEFT JOIN 4images_users u ON (u.user_id = uvp.user_id) WHERE uvp.other_user_id = 1 AND u.user_level >= '2' ORDER BY uvp.view_date DESC LIMIT 0, 10
Table 'foto_komunikacja_cba_pl.4images_users_viewprofile' doesn't exist

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /profiles/f/fo/fot/foto-komunikacja/foto-komunikacja.cba.pl/includes/db_mysql.php on line 120


Was kann ich tun?
Grüße

5
Discussion & Troubleshooting / Problem (Failed to write session data)
« on: June 12, 2015, 06:59:31 PM »
Hello. I have a problem with logging into the site and proved to be a mistake:" Warning: Unknown: write failed: Disk quota exceeded (122) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php5) in Unknown on line 0"
What to do with this? How does it solve the problem?
Thank you and best regards

7
hello if you can still add the field "containing the user"?

9
Discussion & Troubleshooting / Protection against theft
« on: May 09, 2014, 06:37:46 PM »
Welcome.
It is possible to block the right mouse, or protection against theft? Please reply

10
If it works for version 1.7.10?

11
Mods & Plugins (Requests & Discussions) / Re: More fields in keywords
« on: September 26, 2013, 12:29:23 AM »
It does not work. Task # 2 for
improvement.

12
What does it mean "DB:"?

13
Even I do not understand. Can I have photos of
screen shots step by step (I'm talking about the
task 5). I think it would be better with pictures.

14
phpmyadmin is found, but that is to edit the file?

15
root-> data-> database-> default-> mysql_default.sql ?

Pages: [1] 2