[Tue Dec 2 21:19:00 2008] StartLog OK [Tue Dec 2 21:19:00 2008] FileExists OK 2/kit.hostconf/config/hostconf_db.conf.en.comp.pl [Tue Dec 2 21:19:00 2008] MySQLCheck OK [Tue Dec 2 21:19:00 2008] VersionRead OK 2/jin_par/VERSION $Tmp{VersionOld} jin-001-014 [Tue Dec 2 21:19:00 2008] FileCopy OK 2/kit.hostconf/config/hostconf_db.conf.en.comp.pl to 2/TMP_DB_CONFIG [Tue Dec 2 21:19:00 2008] FileRemove OK 2/.htaccess [Tue Dec 2 21:19:01 2008] ArchUnzip OK /home/awebpro/public_html/fantasos-install.zip /home/awebpro/public_html/2/ [Tue Dec 2 21:19:01 2008] FileCopy OK fantasos-jin.par to 2/jin.par [Tue Dec 2 21:19:01 2008] FileRmtree OK 2/jin_par [Tue Dec 2 21:19:02 2008] ArchUnzip OK /home/awebpro/public_html/2/jin.par /home/awebpro/public_html/2/jin_par/ [Tue Dec 2 21:19:02 2008] FileRemove OK 2/jin.par [Tue Dec 2 21:19:02 2008] FileCopy OK 2/TMP_DB_CONFIG to 2/kit.hostconf/config/hostconf_db.conf.en.comp.pl [Tue Dec 2 21:19:02 2008] FileRemove OK 2/TMP_DB_CONFIG [Tue Dec 2 21:19:02 2008] VersionRead OK 2/jin_par/VERSION $Tmp{VersionNew} jin-001-017 [Tue Dec 2 21:19:02 2008] MySQLUpdate Import SQL file 2/jin_par/sql/changes/jin-001-015.sql [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: # fix update jin_product set dlv_otos='' where dlv_otos='0' [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_testimonial_page ( id int(11) not null primary key, owner_id int(11) not null, tag varchar(255) not null default '', add_code varchar(255) not null default '', ipp int(11) not null default 0, template longtext not null default '', key(owner_id,tag) ) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_testimonial ( id int(11) not null primary key, owner_id int(11) not null, approved int(1) not null default 0, ctime datetime null, tag varchar(255) not null default '', name varchar(255) not null default '', email varchar(255) not null default '', image varchar(30) not null default '', website_title varchar(255) not null default '', website_url varchar(255) not null default '', testimonial text not null default '', videofile varchar(30) not null default '', player varchar(30) not null default '', youtube_id varchar(30) not null default '', url varchar(255) not null default '', key(owner_id,tag,approved) ) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_role add priv_master_tools_testimonials int(1) not null default 0 after priv_master_tools_extscripts [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_sale add aweber_done int(1) not null default 0 after oto_shown [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: update jin_sale set aweber_done=1 [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: # use-sell point create table jin_priceinc ( id int(11) not null primary key, owner_id int(11) not null, date_start date null, date_end date null, time_start time null, time_end time null, price_start decimal(8,2) not null default '0', price_end decimal(8,2) not null default '0', incr varchar(32) not null default '', period_l int(4) not null default 0, period_u varchar(15) not null default '', jsflow int(1) not null default 0, template text not null default '' ) [Tue Dec 2 21:19:02 2008] MySQLImport OK [Tue Dec 2 21:19:02 2008] MySQLUpdate OK SQL file 2/jin_par/sql/changes/jin-001-015.sql [Tue Dec 2 21:19:02 2008] MySQLUpdate Import SQL file 2/jin_par/sql/changes/jin-001-016.sql [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_role add priv_master_tools_followupman int(1) not null default 0 after priv_master_tools_testimonials [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_followupman_series ( id int(11) not null primary key, owner_id int(11) not null, prods varchar(255) not null default '', title varchar(255) not null default '', from_name varchar(255) not null default '', from_email varchar(255) not null default '', double_optin int(1) not null default 0, key(owner_id) ) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_followupman_series_message ( id int(11) not null primary key, owner_id int(11) not null, series_id int(11) not null default 0, delay int(11) not null default 0, message text not null default '', subject varchar(255) not null default '', seq int(3) not null, plain_text int(1) not null default 0, key(owner_id, series_id) ) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_followupman_user_series ( id int(11) not null primary key, owner_id int(11) not null, user_id int(11) not null default 0, message_id int(11) not null default 0, series_id int(11) not null default 0, stime datetime null, confirmed int(1) not null default 0, signature char(8) not null, optout int(1) not null default 0, optout_tstamp datetime null, sale_id int(11) not null default 0, key(owner_id, user_id), key(owner_id, sale_id), key(owner_id, series_id), key(confirmed, optout, message_id) ) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_followupman_template ( id int(11) not null primary key, owner_id int(11) not null, confirm_subscription text not null default '', key(owner_id) ) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_user_dlv ( id int(11) not null primary key, owner_id int(11) not null, obj_type varchar(50) not null default '', obj_id int(11) not null, obj_title varchar(255) not null, user_id int(11) not null, sale_id int(11) not null default 0, expires date null, expired int(1) not null default 0, key(owner_id,obj_type,obj_id), key(owner_id,user_id), key(owner_id,sale_id) ) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_package add aweber_settings text not null default '' after aweber_yes [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_quest_item add seq int(11) not null default 0 after qsfield [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: update jin_quest_item set seq=id where seq=0 [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: drop index owner_id on jin_quest_item [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create index owner_id on jin_quest_item(owner_id,quest_id,seq) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_product add comm_recur_stop int(3) not null default 0 after period_guarantee_no4recur [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_brandpdf ( id int(11) not null primary key, owner_id int(11) not null, title varchar(150) not null default '', filename varchar(150) not null default '', template longtext not null default '', key(owner_id) ) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_role add priv_master_store_brandpdfs int(1) not null default 0 after priv_master_store_downloads [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_product add dlv_brandpdfs varchar(255) not null default '' after dlv_downloads_expire [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_package add use_terms int(1) not null default 0 after shipping [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_terms ( id int(11) not null primary key, owner_id int(11) not null, terms longtext not null default '', key(owner_id) ) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_download add signature char(8) not null default '' after owner_id [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_role add limit_dlvuploadone int(6) not null default 0 after limit_massmailperiod [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_role add limit_dlvuploadall int(6) not null default 0 after limit_dlvuploadone [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_followupman_series add hide_thank int(1) not null default 0 after double_optin [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_followupman_series_message add recur_yes int(1) not null default 0 after plain_text [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_followupman_series_message add recur_num int(8) not null default 0 after recur_yes [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_followupman_series_message add recur_delay int(11) not null default 0 after recur_num [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_followupman_user_recur ( user_series_id int(11) not null default 0, message_id int(11) not null default 0, num int(8) not null default 0, stime datetime null, key(user_series_id), key(message_id) ) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_coupon add hidden int(1) not null default 0 after owner_id [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_coupon add parent_coupon_id int(11) not null after hidden [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_coupon add otc_selected varchar(255) not null default '' after otc_all [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: drop index owner_id on jin_coupon [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create index owner_id on jin_coupon(owner_id,hidden) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_product add dlv_coupons varchar(255) not null default '' after dlv_quests [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create index parent_coupon_id on jin_coupon(parent_coupon_id) [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_role add priv_master_tools_invoicepdfs int(1) not null default 0 after priv_master_tools_emails [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: alter table jin_package add invoicepdfs varchar(255) not null default '' after shipping [Tue Dec 2 21:19:02 2008] MySQLImport SQL OK: create table jin_invoicepdf ( id int(11) not null primary key, owner_id int(11) not null, title varchar(150) not null default '', template longtext not null default '', format varchar(10) not null default '', key(owner_id) ) [Tue Dec 2 21:19:02 2008] MySQLImport OK [Tue Dec 2 21:19:02 2008] MySQLUpdate OK SQL file 2/jin_par/sql/changes/jin-001-016.sql [Tue Dec 2 21:19:02 2008] MySQLUpdate Import SQL file 2/jin_par/sql/changes/jin-001-017.sql [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create table jin_supro ( id int(11) not null primary key, owner_id int(11) not null, alias varchar(255) not null default '', url varchar(255) not null default '', username varchar(255) not null default '', password varchar(255) not null default '', limit_ips int(6) not null default 0, limit_ips_user int(6) not null default 0, limit_downloads int(6) not null default 0, limit_downloads_user int(6) not null default 0, limit_referer text not null default '', expires date null, admin_notes text not null default '', u_all int(1) not null default 0, u_selected varchar(255) not null default '', u_since date null, u_cust_new int(1) not null default 0, u_cust_packs varchar(255) not null default '', u_cust_prods varchar(255) not null default '', u_affprogs varchar(255) not null default '', u_roles varchar(255) not null default '', u_rmems varchar(255) not null default '', u_lmems varchar(255) not null default '', u_cmsmems varchar(255) not null default '', u_paid_min varchar(20) not null default '', u_paid_max varchar(20) not null default '', u_generated_min varchar(20) not null default '', u_generated_max varchar(20) not null default '', u_count_sales_from date null, u_count_sales_until date null, key(owner_id) ) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create table jin_supro_stat ( supro_id int(11) not null default 0, tstamp datetime null, ip varchar(32) not null default '', referer varchar(255) not null default '', user_id int(11) not null default 0, user_email varchar(255) not null default '', key(supro_id) ) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_role add priv_master_tools_supro int(1) not null default 0 after priv_master_tools_shorturls [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_package add pay_now_text varchar(255) not null default '' after html_head [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: # reselling fixes alter table jin_download add resprog_base_obj_id int(11) not null after owner_id [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create index resprog_base_obj_id on jin_download(resprog_base_obj_id) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_brandpdf add resprog_base_obj_id int(11) not null after owner_id [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create index resprog_base_obj_id on jin_brandpdf(resprog_base_obj_id) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_lmem add resprog_base_obj_id int(11) not null after owner_id [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create index resprog_base_obj_id on jin_lmem(resprog_base_obj_id) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_rmem add resprog_base_obj_id int(11) not null after owner_id [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create index resprog_base_obj_id on jin_rmem(resprog_base_obj_id) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_cmsmem add resprog_base_obj_id int(11) not null after owner_id [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create index resprog_base_obj_id on jin_cmsmem(resprog_base_obj_id) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create table jin_jvevent ( id int(11) not null primary key, owner_id int(11) not null, signature char(8) not null default '', title varchar(255) not null default '', rmem_id int(11) not null default 0, rights varchar(255) not null default '', pagesize int(3) not null default 0, period_validity int(11) not null default 0, max_video_size int(6) not null default 0, max_image_size int(6) not null default 0, max_download_size int(6) not null default 0, def_user_image varchar(255) not null default '', template_list longtext not null default '', template_submit longtext not null default '', style_id int(11) not null default 0, key(owner_id), key(signature) ) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create table jin_jvevent_prod ( id int(11) not null primary key, owner_id int(11) not null, signature char(8) not null default '', ctime datetime null, jvevent_id int(11) not null default 0, approved int(1) not null default 0, sortdate datetime null, title varchar(255) not null default '', url varchar(255) not null default '', descr text not null default '', price varchar(30) not null default '', prod_image varchar(255) not null default '', prod_download varchar(255) not null default '', rights varchar(255) not null default '', name varchar(255) not null default '', email varchar(255) not null default '', user_image varchar(255) not null default '', website_title varchar(255) not null default '', website_url varchar(255) not null default '', testimonial text not null default '', videofile varchar(255) not null default '', player varchar(30) not null default '', youtube_id varchar(30) not null default '', video_url varchar(255) not null default '', key(owner_id,jvevent_id,approved) ) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create table jin_jvevent_rights ( id int(11) not null primary key, title varchar(255) not null default '' ) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: create table jin_style ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', width varchar(30) not null default '', bgcolor varchar(30) not null default '', font_color varchar(30) not null default '', font_style varchar(30) not null default '', font_size varchar(30) not null default '', css_class varchar(50) not null default '', css_style varchar(255) not null default '', key(owner_id) ) [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (1, 'Can be sold') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (2, 'Sales page included') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (3, 'Can be given away') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (4, 'Can be added to free membership sites') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (5, 'Can be added to paid membership sites') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (6, 'Can be offered as a bonus') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (7, 'Can be packaged with other products') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (8, 'Can be offered through auction sites') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (9, 'Can be customized') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (10, 'Can be edited completely and your name put on it') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (11, 'Can be broken down into smaller articles') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (12, 'Can be added to an e-course or autoresponder') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (13, 'Can be used as web content') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (14, 'Can sell Resale Rights') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (15, 'Can sell Master Resale Rights') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (16, 'Can sell Private Label Rights') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (17, 'Can sell Transferable Master Resale Rights') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (18, 'Can sell Transferable Private Label Rights') [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_role add priv_master_tools_jvevents int(1) not null default 0 after priv_master_tools_followupman [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_user_rmem add ctime datetime null after owner_id [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_coupon add limit_amount int(11) not null default 0 after discount [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_product add no_thank_you_email int(1) not null default 0 after no_cust_salelist [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_followupman_series add del_series varchar(255) not null default '' after hide_thank [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_followupman_series_message add co_mode int(1) not null default 0 after recur_delay [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_followupman_series_message add co_from_email varchar(255) not null default '' after co_mode [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_followupman_series_message add co_to_emails text not null default '' after co_from_email [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_followupman_series_message add co_subject varchar(255) not null default '' after co_to_emails [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_followupman_series_message add co_message text not null default '' after co_subject [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_followupman_series_message add co_plain_text int(1) not null default 0 after co_message [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_specusers add u_cmsmems varchar(255) not null default '' after u_lmems [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_api_user add u_cmsmems varchar(255) not null default '' after u_lmems [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_merchant_settings add from_name varchar(255) not null default '' after sitename [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_merchant_settings add from_email varchar(255) not null default '' after from_name [Tue Dec 2 21:19:03 2008] MySQLImport SQL OK: alter table jin_user add cb_aff_id varchar(150) not null default '' after pg_paypal_email [Tue Dec 2 21:19:03 2008] MySQLImport OK [Tue Dec 2 21:19:03 2008] MySQLUpdate OK SQL file 2/jin_par/sql/changes/jin-001-017.sql [Tue Dec 2 21:19:03 2008] MySQLUpdate Import PL file 2/jin_par/sql/changes/jin-001-015.pl [Tue Dec 2 21:19:03 2008] MySQLUpdate OK PL file 2/jin_par/sql/changes/jin-001-015.pl [Tue Dec 2 21:19:03 2008] MySQLUpdate Import PL file 2/jin_par/sql/changes/jin-001-016.pl [Tue Dec 2 21:19:03 2008] MySQLUpdate OK PL file 2/jin_par/sql/changes/jin-001-016.pl [Tue Dec 2 21:19:03 2008] MySQLUpdate Import PL file 2/jin_par/sql/changes/jin-001-017.pl [Tue Dec 2 21:19:03 2008] MySQLUpdate OK PL file 2/jin_par/sql/changes/jin-001-017.pl [Tue Dec 2 21:19:03 2008] MySQLUpdate OK [Tue Dec 2 21:19:03 2008] FileCopy OK 2/jin_par/main.cgi to 2/jin.cgi [Tue Dec 2 21:19:03 2008] FileChmod OK 2/jin.cgi 0755 [Tue Dec 2 21:19:03 2008] FileChmod OK 2/php/*.php 0644 [Tue Dec 2 21:19:03 2008] TstampFile OK 2/install.tstamp [Tue Dec 2 21:19:03 2008] EndLog OK