http://www.gossamer-threads.com/forum/ en-us gforum@gossamer-threads.com Fri, 24 May 2013 20:26:55 GMT Gossamer Forum by Gossamer Threads, Inc. http://www.rssboard.org/rss-specification http://static.gossamer-threads.com/forum/images/gforum-logo.png http://www.gossamer-threads.com/forum/ 50 50 http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/bug_of_sql_dump_%3F%3F%3F%3F_P314095/?page=unread#314095 Hi folks Recently i try to move data from mysql4 to mysql5. when i try to use embeded SQL dump and SQL monitor to transfer data. i found something wrong with the output file from sql dump here is what is the output from sql dump Code: Timestmp timestamp DEFAULT 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMP which will lead to error when do a restore in the sql monitor MySQL said: Invalid default value for 'Timestmp' then i compare it with dump from mysqldump output, and found it is go through restoring well Code: `Timestmp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP Any one notice it before??? Have a good day Austin f44d491664e14ff8f7eccf1ba6f982e2 May 1, 2012, 8:09 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Re%3A_%5Btommyliang%5D_Help!!!_Can_anyone_help_me_remove_the_post_from_maillist_%3F_P310725/?page=unread#310725 It's been deleted , many thanks:) 02cc6a3ea0ec741109a4ccb8d446eec7 Jul 18, 2011, 6:20 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Help!!!_Can_anyone_help_me_remove_the_post_from_maillist_%3F_P310710/?page=unread#310710 Can anyone please help delete my thread http://www.gossamer-threads.com/...o=post_view_threaded I was unaware when I post to the list and the thread has some private information(myaddress and phone number ) that I do not wish to be in the public domain. I would kindly appreciate it, if you could delete it for my personal security. Thanks Very Much! 7e249fa854e7ea011747b5ed0098fe1c Jul 17, 2011, 10:08 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Paypal_Payment_Options_P310673/?page=unread#310673 Hi There, Is it possible to use paypal allow access to paid links? Are different prices allowed for different links? I'm basically trying to design a website which will eventually use this functionality. The idea is to upload a file(link) and make it available to users only if they have paid for it. Is something like this possible. Regards, Pieter ---------------------------------------------------------------------- Sacrifice is not about what you lose, it is about what you gain in the process. 94f87d0160dc1dcaff80200596d775ee Jun 21, 2011, 7:36 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Re%3A_%5B604%5D_no_double_opt_in_toggle_to_modify_list_in_my_version_1.1.0_P303985/?page=unread#303985 great. fixed. thanks. 4244318228f88d2e79c8f429bb80ea90 Nov 3, 2008, 11:42 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Re%3A_%5Bdlarocque%5D_no_double_opt_in_toggle_to_modify_list_in_my_version_1.1.0_P303981/?page=unread#303981 This option is disabled by default. In order to enable it, you need to load email templates which is under Account - Email Templates menu. B. 38a0209631f9ea2052807a2dc43c4981 Nov 3, 2008, 3:33 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/no_double_opt_in_toggle_to_modify_list_in_my_version_1.1.0_P303818/?page=unread#303818 according to the manual there should be a "Require Double Opt In" toggle option when creating or modifying a list, yet this option doesn't come up in my version. My hosting provider requires double opt-in mailing lists. ??? Thanks for the help 1008b971885a278094bd03279bbc4481 Oct 24, 2008, 6:29 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/how_to_have_a_editable_field_which_column_has_been_defined_as_primary_key_P303634/?page=unread#303634 i have use below code to setup a table. #use lib '/path/to/admin'; ## use lib 'D:\webtest\admin'; use Links qw/$DB/; my $c = $DB->creator('list'); $c->cols([ date => { type => 'datetime'}, username => { type => 'varchar', size => 18 }, status => { type => 'varchar', size => 30 }, tel => { type => 'varchar', size => 38 }, ]); $c->pk('username'); # Set primary key $c->index({ tel_ndx => ['tel'], }); # Setup indexes for faster searches $c->create or die "Create failed: $GT::SQL::error"; then Then edit the db_nav.html template so that new table shows up in the editor (in order to manage things and add/remove item). The problem is when i try to update or modify username field in admin panel, it did not return me a editbale text field. actually it is non editable in the admin panel. i have saw the similar table called glink_users table, i wonder if i could create a similar table so i could edit the username with primary key flaged. thank in advance c879a52583a8ee497cc3550aa9045e6c Oct 5, 2008, 5:40 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Re%3A_%5B604%5D_export_or_merging_mailing_lists_P303106/?page=unread#303106 thanks for the fix, I'll try it. cda29ee254ed10db99fac0ef880eff20 Aug 7, 2008, 7:17 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Re%3A_%5Bdlarocque%5D_export_or_merging_mailing_lists_P303100/?page=unread#303100 Unfortunately, there is no way to merge lists together, but you can specify multiple list in the unsubscribe form as below: - Form: <input type="hidden" name="lid" value="LIST_ID1" /> <input type="hidden" name="lid" value="LIST_ID2" /> ... - URL: glist.cgi?do=user_unsubscribe;lid=LIST_ID1;lid=LIST_ID2... B. ada6bed2a731f2fedefdc4e2aa6a6a0b Aug 6, 2008, 2:08 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/export_or_merging_mailing_lists_P302979/?page=unread#302979 I see this question once or twice here but no posted answers. I need to either merge a few mailing lists together (so I can offer one consistent unsubscribe page on a multi-list mailout) OR export a list to an easily importable format like a delimited text file. Alternately, can I specify multiple list ids in the unsubscribe form? Thanks 7bdba2808681df90c2fc09529d90b591 Jul 29, 2008, 12:42 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Statistics_P302180/?page=unread#302180 Hi, I saw that I can track opens, bounces and clicks from the admin panel... but how can I see WHICH users opened or clicked or bounced? Thanks! b2b5ea91f655e2415cbba79a3065a2cd May 17, 2008, 9:12 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Css_Problem_with_firefox----Firefox_blows_P300372/?page=unread#300372 When i use ie explorer the screen is able to scroll. However when i vie the same problem in firefox there is no scroll bar even though the pages spread down the screen. Any suggestions? Jason Bishop f46bb855b938f0f9b6b0ca35c32922eb Feb 9, 2008, 8:03 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/editing_messages_P298554/?page=unread#298554 Although no one at Gossamer seems to be supporting this forum, still thought I'd give one more try. In the system I find I cannot edit messages apart from the time of the original creation. I create a new message, select the template, make edits and then click update. But if I want to edit it further I cant. I click on the message, then click edit, but I need select a new template again, the original message doesnt display. Can someone please tell me if this is a common issue and how can be fixed? Thanks 8e33227f08ec76b65dda12cd48da2187 Sep 16, 2007, 7:07 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/export_lists_P298535/?page=unread#298535 HI, can someone please help me with how to be able to export the lists from Glist, into a csv or text file? thanks 4d3339e22c54fdb3b453b819ea9be9bc Sep 13, 2007, 11:09 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Link_Tracking_P297543/?page=unread#297543 Hi, I have bought G.List, and I had hoped that it tracked more than just if someone had clicked a link in a sent email, but showed the actual link they clicked. I have seen this in other mailing programs. Is this feature available and I have simply missed it, or doen it not exist? Thanks 3832abfdc723da23c39a45d7f1dcda21 Jul 5, 2007, 11:57 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Re%3A_%5Bjohnnyb%5D_Mailing_Speed_P295969/?page=unread#295969 Hi, That's normal as you have debug mode on. Cheers, Alex -- Gossamer Threads Inc. 3485b41fe067a48df507053717d7591c Feb 13, 2007, 10:22 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Re%3A_%5BAlex%5D_Mailing_Speed_P295968/?page=unread#295968 Hi, I've got some information from the Apache logs and it appears there are some MySQL errors going on. Perhaps if we eliminate these it'll help. I don't have access to the while log but here are some example lines: Code: [Tue Feb 13 16:44:57 2007] [error] [client 167.127.163.203] GT::SQL::Driver::MYSQL::sth (6942): Executing query: SELECT COUNT(*) FROM glist_Users_Sessions WHERE (session_id = NULL) from GList::test_connection at /path_to_script/webroot/cgi-bin/glist/private/lib/GList.pm line 196 [Tue Feb 13 16:44:57 2007] [error] [client 167.127.163.203] GT::SQL::Driver::MYSQL::sth (6941): Executing query: SELECT COUNT(*) FROM glist_EmailMailings WHERE (eml_opened = 0 AND eml_code = '3yN6hKYSjmyCGGZLkJHf' AND eml_mailing_id_fk = 42) from GList::User::user_open at GList::User::user_open line 61 Any ideas? John 313365aca1ed46a0565e4a21989b1be4 Feb 13, 2007, 9:55 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Re%3A_%5Bjohnnyb%5D_Mailing_Speed_P295965/?page=unread#295965 Hi, Debugging enabled will slow it down, but not that significantly. You can check the Apache error logs for the debug output. The size should be ok, that won't matter. I'd check your sendmail configuration and see about getting it tuned for very high volume of mailings. Cheers, Alex -- Gossamer Threads Inc. 017df88cf97381420a6e96045bcae783 Feb 13, 2007, 1:32 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_List_C12/Discussion_F45/Re%3A_%5BAlex%5D_Mailing_Speed_P295964/?page=unread#295964 Hi, I checked with the hosting provider and virus scanning is off. We have the debug_level set to enabled, would this affect the speed very much? Also, where can I find the error logs it creates? Finally, would the size of the list, about 170,000 subscribers, cause a slowdown by eating memory or anything? Thanks, John fc0613113aa243f3ed69e2cc1e50d017 Feb 13, 2007, 1:26 PM