Author Topic: 4images Installation  (Read 180342 times)

0 Members and 1 Guest are viewing this topic.

Offline Dennyboy

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #30 on: April 10, 2007, 01:09:55 AM »
Ok, here they are....


Quote
An unexpected error occured. Please try again later. (mit dem Hinweis "dieser fehler tritt ca. 30 mal auf" hätte es auch gereicht)

Es sind Fehler bei der Erstellung der Datenbankeinträge aufgetreten:

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)) TYPE=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)) TYPE=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)) TYPE=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)) TYPE=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)) TYPE=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)) TYPE=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)) TYPE=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)) TYPE=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)) TYPE=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)) TYPE=HEAP

CREATE TABLE 4images_settings (setting_name varchar(255) NOT NULL default '',setting_value mediumtext NOT NULL,PRIMARY KEY (setting_name)) TYPE=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')
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', 'none')
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', '0')
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)) TYPE=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)) TYPE=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)) TYPE=MyISAM
« Last Edit: April 10, 2007, 12:24:50 PM by Acidgod »

Offline Acidgod

  • 4images Moderator
  • 4images Guru
  • *****
  • Posts: 2.420
  • It's me?
    • View Profile
    • Flash-Webdesign
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #31 on: April 10, 2007, 12:31:17 PM »
should I change the CHMOD's listed before or after runnig the installation?

Ooops...

I didn't  read this before... *g
Do it before!

And try to delete all DB entry's and Scripts and then upload it a second time, please...

Offline Cu_Bi

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #32 on: May 16, 2007, 04:53:05 AM »
Hi
Came some one help me how to do it.I  install but is keep go back to index.They said An unexpected error occured. Please try again later.
ERROR: Could not load configuration settings!
Came some one tell me how to install it.
Thank You

Offline namtav

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #33 on: May 21, 2007, 09:02:10 PM »
Hello,

I've searched for some answer on my problem. I'm trying to install, but after I put all the data required, and click on start installation,
I only get the "An unexpected error occured. Please try again later." and no more details...  :?:
can anyone help me?

Thenks
Nuno

Offline hitman1985

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #34 on: May 25, 2007, 08:46:30 AM »
DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id LIMIT 0, 1
Unknown column 'i.user_id' in 'on clause'

koennte mir einer sagen, was das ist? und evtl. dazu noch wie ich das 4 images in meine hp einbinde, habe eine sql5.0 db gemacht und dann 4 images auf meinen ftp geladen, die bilder laden hoch, man kann sie aber niemals sehn, es kommen immer solche errors?

bin neu in der welt des php und html scripten, deswegen, verzeiht mir bitte, wenn ich da ein bissl langsamer in der aufnahme von bestimmten sachen bin.

DANKE
mfg andre

Offline 2030vietnam

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #35 on: June 04, 2007, 08:44:50 AM »
Why i have blank page?I install ok.
my site www.yenquynh.com
thanks!

Offline Yvonne

  • Pre-Newbie
  • Posts: 9
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #36 on: October 03, 2007, 11:25:58 PM »
Hallo Jungs ,
könnt ihr mir mal bitte ne Frage beantworten ??

Ich habe mir 4images runtergeladen und auf mein Server gemacht ( mit Filezilla ) sonun öffne ich Dreamweaver und ja nun weis ich nicht weiter ??!! Es steht , ich soll das Programm mit meinem Browser öffnen ! Wie mache ich das?

Ich hab auch alles hochgeladen nur lässt es dich nicht aufrufen, was mache ich falsch

Offline afghanicafe

  • Pre-Newbie
  • Posts: 3
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #37 on: November 01, 2007, 06:44:29 PM »
HI I HAVE STIL THE SAME PROBLEM EVEEN AFTER DOING ALL THE THINGS WHICH U HAVE SAID ..

NOW EACH TIME I UPLOAD AN IMAGE I HAVE TO MAKE A FOLDER FOR THAT IMAGE .. IN MEDIA AND THUM


Warning: move_uploaded_file(): Unable to access ./data/media/4/XXXX.png in /hsphere/local/home/XXXXX/XXXXXX.com/XXXX/includes/upload.php on line 113 



PLEASE HELP ME WHAT CAN BE WRONG I THINK SO FAR I AM DOING EVERYTHING FINE ...

Offline KurtW

  • 4images Guru
  • *******
  • Posts: 2.778
    • View Profile
    • Malediven-Bilder ~~Dreams~~
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #38 on: November 01, 2007, 07:07:59 PM »
HI I HAVE STIL THE SAME PROBLEM EVEEN AFTER DOING ALL THE THINGS WHICH U HAVE SAID ..

NOW EACH TIME I UPLOAD AN IMAGE I HAVE TO MAKE A FOLDER FOR THAT IMAGE .. IN MEDIA AND THUM


Warning: move_uploaded_file(): Unable to access ./data/media/4/XXXX.png in /hsphere/local/home/XXXXX/XXXXXX.com/XXXX/includes/upload.php on line 113 



PLEASE HELP ME WHAT CAN BE WRONG I THINK SO FAR I AM DOING EVERYTHING FINE ...

Hi,

nothing is wrong in your install...

Only your server have: SafeMod on

=> Searchin forum about: SafeMod
=> Ask your hoster about: SafeMod off    (the the folders in thumbnails and media are generated automaticly)


Kurt

Offline Frankieloum

  • Pre-Newbie
  • Posts: 7
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #39 on: November 26, 2007, 08:43:20 PM »
i unzipped the files said EXTRACT ALL

now what? What exact steps do I take to get this working
I am NOT Computer smart so please say it simple lol

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #40 on: November 26, 2007, 09:03:29 PM »
when you did extract all files..

create folder on your ftp
upload content of 4images folder from your PC to your ftp.

chmod data data folder on ftp and all subdirs with 777

prepare you mysql account information

go to http://www.yoursite.com/yourcreatedfolder/

you will see the installation screen.
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline Matt335

  • Pre-Newbie
  • Posts: 3
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #41 on: January 19, 2008, 09:19:08 AM »
How do I do what it says in point 5?
  5. Set permissions for the following directories:
regards
Matt.
« Last Edit: January 19, 2008, 09:45:54 AM by Nicky »

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #42 on: January 19, 2008, 09:47:42 AM »
hi,

you can do that with your FTP software.

or post which FTP client are you using.
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline Matt335

  • Pre-Newbie
  • Posts: 3
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #43 on: January 19, 2008, 12:46:31 PM »
Hi Nicky

I'm using a Mac and using FETCH

thanks
Matt

hi,

you can do that with your FTP software.

or post which FTP client are you using.

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: 4images 1.7.4 Installation [from DOCS Folder]
« Reply #44 on: January 19, 2008, 03:04:49 PM »
Or if use SSH Tunnel, is possible (yes, MAC include but need host for enable first). ;)
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

 

Post your comments here