From david at thbuo.gov.tw Mon Apr 21 10:03:49 2003 From: david at thbuo.gov.tw (David Chang) Date: Sun Apr 20 17:51:42 2003 Subject: [midas] unable to upload image file Message-ID: <1050887029.a8f592b49e8de@webmail.thbuo.gov.tw> Hi all: After click "Store" button at "New Ad" screen.Midas complain that, Error uploading file: study_logo.jpg. DB Error: syntax error David Chang From david at thbuo.gov.tw Mon Apr 21 13:20:22 2003 From: david at thbuo.gov.tw (David Chang) Date: Sun Apr 20 21:08:25 2003 Subject: [midas] unable to upload image file Message-ID: <1050898822.e846cb2cd960f@webmail.thbuo.gov.tw> =A4=DE=A5=CE Chuck Hagenbuch : > Quoting David Chang : > > > After click "Store" button at "New Ad" screen.Midas complain that, > > > > Error uploading file: study_logo.jpg > > DB Error: syntax error > > What database? What's the rest of the error (from your Horde or database > logs)? > Database:Mysql There are no reset of the log either /tmp/horde.log or database log. > -chuck > > -- > Charles Hagenbuch, > "... It is not more light we need, but more warmth! We die of cold, not of > darkness. It is not the night that kills, but the frost." - Miguel de > Unamuno > > -- > midas mailing list > Frequently Asked Questions: http://horde.org/faq/ > To unsubscribe, mail: midas-unsubscribe@lists.horde.org > From david at thbuo.gov.tw Mon Apr 21 13:34:20 2003 From: david at thbuo.gov.tw (David Chang) Date: Sun Apr 20 21:22:17 2003 Subject: [midas] unable to upload image file In-Reply-To: <1050886311.165b095638ad6@marina.horde.org> References: <1050887029.a8f592b49e8de@webmail.thbuo.gov.tw> <1050886311.165b095638ad6@marina.horde.org> Message-ID: <1050899660.d2c2bc59fec20@webmail.thbuo.gov.tw> Hi Chuck: It seems the image size problem,if i resize the image small than 15x15 then problem was fixed.If that is true there should be a description in "New Ad" = for people. Another question is how do i see the "Ad" that i have just added. David Chang =A4=DE=A5=CE Chuck Hagenbuch : > Quoting David Chang : > > > After click "Store" button at "New Ad" screen.Midas complain that, > > > > Error uploading file: study_logo.jpg > > DB Error: syntax error > > What database? What's the rest of the error (from your Horde or database > logs)? > > -chuck > > -- > Charles Hagenbuch, > "... It is not more light we need, but more warmth! We die of cold, not of > darkness. It is not the night that kills, but the frost." - Miguel de > Unamuno > > -- > midas mailing list > Frequently Asked Questions: http://horde.org/faq/ > To unsubscribe, mail: midas-unsubscribe@lists.horde.org > From marko at oblo.com Mon Apr 21 08:38:54 2003 From: marko at oblo.com (Marko Djukic) Date: Sun Apr 20 22:39:12 2003 Subject: [midas] unable to upload image file In-Reply-To: <1050899660.d2c2bc59fec20@webmail.thbuo.gov.tw> References: <1050887029.a8f592b49e8de@webmail.thbuo.gov.tw> <1050886311.165b095638ad6@marina.horde.org> <1050899660.d2c2bc59fec20@webmail.thbuo.gov.tw> Message-ID: <1050903534.514b5ad8bb4e6@my.oblo.com> Quoting David Chang : > Hi Chuck: > It seems the image size problem,if i resize the image small than 15x15 then > problem was fixed.If that is true there should be a description in "New Ad" > for > people. this sounds very weird.... what's your DB table structure? > Another question is how do i see the "Ad" that i have just added. yes docs a bit lacking, this is by far the easiest way, just put this on any page: m. From david at thbuo.gov.tw Mon Apr 21 16:06:56 2003 From: david at thbuo.gov.tw (David Chang) Date: Sun Apr 20 23:55:02 2003 Subject: [midas] unable to upload image file In-Reply-To: <1050903534.514b5ad8bb4e6@my.oblo.com> References: <1050887029.a8f592b49e8de@webmail.thbuo.gov.tw> <1050886311.165b095638ad6@marina.horde.org> <1050899660.d2c2bc59fec20@webmail.thbuo.gov.tw> <1050903534.514b5ad8bb4e6@my.oblo.com> Message-ID: <1050908816.b5a01de42ae15@webmail.thbuo.gov.tw> There are four tables exist in DB:horde # # Table structure for table `midas_campaigns` # CREATE TABLE midas_campaigns ( campaign_id int(11) NOT NULL default '0', client_id int(11) NOT NULL default '0', campaign_name varchar(255) NOT NULL default '', campaign_link varchar(255) NOT NULL default '', campaign_start date default NULL, campaign_end date default NULL, campaign_quantity int(11) NOT NULL default '0', campaign_keywords varchar(255) default NULL, campaign_image varchar(255) NOT NULL default '', campaign_showings int(11) NOT NULL default '0', campaign_clicks int(11) NOT NULL default '0', PRIMARY KEY (campaign_id) ) TYPE=3DMyISAM; # # Table structure for table `midas_campaigns_seq` # CREATE TABLE midas_campaigns_seq ( id int(10) unsigned NOT NULL auto_increment, PRIMARY KEY (id) ) TYPE=3DMyISAM; # # Table structure for table `midas_clients` # CREATE TABLE midas_clients ( client_id int(11) NOT NULL default '0', client_name varchar(255) NOT NULL default '', PRIMARY KEY (client_id) ) TYPE=3DMyISAM; # # Table structure for table `midas_clients_seq` # CREATE TABLE midas_clients_seq ( id int(10) unsigned NOT NULL auto_increment, PRIMARY KEY (id) ) TYPE=3DMyISAM; =A4=DE=A5=CE Marko Djukic : > Quoting David Chang : > > > Hi Chuck: > > It seems the image size problem,if i resize the image small than 15x15 t= hen > > problem was fixed.If that is true there should be a description in "New = Ad" > > for > > people. > > this sounds very weird.... what's your DB table structure? > > > Another question is how do i see the "Ad" that i have just added. > > yes docs a bit lacking, this is by far the easiest way, just put this on a= ny > page: > > > m. > > -- > midas mailing list > Frequently Asked Questions: http://horde.org/faq/ > To unsubscribe, mail: midas-unsubscribe@lists.horde.org > From marko at oblo.com Mon Apr 21 10:02:34 2003 From: marko at oblo.com (Marko Djukic) Date: Mon Apr 21 00:02:55 2003 Subject: [midas] unable to upload image file In-Reply-To: <1050908816.b5a01de42ae15@webmail.thbuo.gov.tw> References: <1050887029.a8f592b49e8de@webmail.thbuo.gov.tw> <1050886311.165b095638ad6@marina.horde.org> <1050899660.d2c2bc59fec20@webmail.thbuo.gov.tw> <1050903534.514b5ad8bb4e6@my.oblo.com> <1050908816.b5a01de42ae15@webmail.thbuo.gov.tw> Message-ID: <1050908554.c6d6d6c5e0c26@my.oblo.com> you have vfs set up properly? marko Quoting David Chang : > There are four tables exist in DB:horde > # > # Table structure for table `midas_campaigns` > # > > CREATE TABLE midas_campaigns ( > campaign_id int(11) NOT NULL default '0', > client_id int(11) NOT NULL default '0', > campaign_name varchar(255) NOT NULL default '', > campaign_link varchar(255) NOT NULL default '', > campaign_start date default NULL, > campaign_end date default NULL, > campaign_quantity int(11) NOT NULL default '0', > campaign_keywords varchar(255) default NULL, > campaign_image varchar(255) NOT NULL default '', > campaign_showings int(11) NOT NULL default '0', > campaign_clicks int(11) NOT NULL default '0', > PRIMARY KEY (campaign_id) > ) TYPE=MyISAM; > > # > # Table structure for table `midas_campaigns_seq` > # > > CREATE TABLE midas_campaigns_seq ( > id int(10) unsigned NOT NULL auto_increment, > PRIMARY KEY (id) > ) TYPE=MyISAM; > > > # > # Table structure for table `midas_clients` > # > > CREATE TABLE midas_clients ( > client_id int(11) NOT NULL default '0', > client_name varchar(255) NOT NULL default '', > PRIMARY KEY (client_id) > ) TYPE=MyISAM; > > > # > # Table structure for table `midas_clients_seq` > # > > CREATE TABLE midas_clients_seq ( > id int(10) unsigned NOT NULL auto_increment, > PRIMARY KEY (id) > ) TYPE=MyISAM; > > > > > > > > > > ???? Marko Djukic : > > > Quoting David Chang : > > > > > Hi Chuck: > > > It seems the image size problem,if i resize the image small than 15x15 > then > > > problem was fixed.If that is true there should be a description in "New > Ad" > > > for > > > people. > > > > this sounds very weird.... what's your DB table structure? > > > > > Another question is how do i see the "Ad" that i have just added. > > > > yes docs a bit lacking, this is by far the easiest way, just put this on > any > > page: > > > > > > m. > > > > -- > > midas mailing list > > Frequently Asked Questions: http://horde.org/faq/ > > To unsubscribe, mail: midas-unsubscribe@lists.horde.org > > > > > > From david at thbuo.gov.tw Mon Apr 21 16:26:57 2003 From: david at thbuo.gov.tw (David Chang) Date: Mon Apr 21 00:14:51 2003 Subject: [midas] unable to upload image file In-Reply-To: <1050908554.c6d6d6c5e0c26@my.oblo.com> References: <1050887029.a8f592b49e8de@webmail.thbuo.gov.tw> <1050886311.165b095638ad6@marina.horde.org> <1050899660.d2c2bc59fec20@webmail.thbuo.gov.tw> <1050903534.514b5ad8bb4e6@my.oblo.com> <1050908816.b5a01de42ae15@webmail.thbuo.gov.tw> <1050908554.c6d6d6c5e0c26@my.oblo.com> Message-ID: <1050910017.6de63eb0321e3@webmail.thbuo.gov.tw> Yes, in horde/config/conf.php /** ** Virtual File Storage **/ // If a VFS (virtual filesystem) backend is required, which one should // we use? Options are 'file' and 'sql'. $conf['vfs']['type'] =3D 'sql'; // What configuration parameters should be set for the VFS system? For // the 'file' driver, the only parameter is 'vfsroot' - where on the // real filesystem should Horde use as root of the virtual // filesystem. For the 'sql' driver, configure $conf['sql'] in the // Horde Database section above. $conf['vfs']['params']['vfsroot'] =3D '/tmp'; =A4=DE=A5=CE Marko Djukic : > you have vfs set up properly? > > marko > > > Quoting David Chang : > > > There are four tables exist in DB:horde > > # > > # Table structure for table `midas_campaigns` > > # > > > > CREATE TABLE midas_campaigns ( > > campaign_id int(11) NOT NULL default '0', > > client_id int(11) NOT NULL default '0', > > campaign_name varchar(255) NOT NULL default '', > > campaign_link varchar(255) NOT NULL default '', > > campaign_start date default NULL, > > campaign_end date default NULL, > > campaign_quantity int(11) NOT NULL default '0', > > campaign_keywords varchar(255) default NULL, > > campaign_image varchar(255) NOT NULL default '', > > campaign_showings int(11) NOT NULL default '0', > > campaign_clicks int(11) NOT NULL default '0', > > PRIMARY KEY (campaign_id) > > ) TYPE=3DMyISAM; > > > > # > > # Table structure for table `midas_campaigns_seq` > > # > > > > CREATE TABLE midas_campaigns_seq ( > > id int(10) unsigned NOT NULL auto_increment, > > PRIMARY KEY (id) > > ) TYPE=3DMyISAM; > > > > > > # > > # Table structure for table `midas_clients` > > # > > > > CREATE TABLE midas_clients ( > > client_id int(11) NOT NULL default '0', > > client_name varchar(255) NOT NULL default '', > > PRIMARY KEY (client_id) > > ) TYPE=3DMyISAM; > > > > > > # > > # Table structure for table `midas_clients_seq` > > # > > > > CREATE TABLE midas_clients_seq ( > > id int(10) unsigned NOT NULL auto_increment, > > PRIMARY KEY (id) > > ) TYPE=3DMyISAM; > > > > > > > > > > > > > > > > > > > > ???? Marko Djukic : > > > > > Quoting David Chang : > > > > > > > Hi Chuck: > > > > It seems the image size problem,if i resize the image small than 15x= 15 > > then > > > > problem was fixed.If that is true there should be a description in "= New > > Ad" > > > > for > > > > people. > > > > > > this sounds very weird.... what's your DB table structure? > > > > > > > Another question is how do i see the "Ad" that i have just added. > > > > > > yes docs a bit lacking, this is by far the easiest way, just put this = on > > any > > > page: > > > > > > > > > m. > > > > > > -- > > > midas mailing list > > > Frequently Asked Questions: http://horde.org/faq/ > > > To unsubscribe, mail: midas-unsubscribe@lists.horde.org > > > > > > > > > > > > > > >