http://www.gossamer-threads.com/forum/ en-us gforum@gossamer-threads.com Fri, 24 May 2013 23:41:24 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/Others_C4/MySQLMan_F13/Re%3A_%5Btheguy%5D_command_to_list_all_data_on_one_page_P311389/?page=unread#311389 Unfortunatly mySQLMan is pretty out of date ... you would probably be best to use phpMyAdmin to do the task you need (much newer, and constantly updated) Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates efef77d022115d5621cba9eb673a8215 Jan 19, 2012, 6:38 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5Btheguy%5D_command_to_list_all_data_on_one_page_P311388/?page=unread#311388 2 weeks and nobody answered me. please someone help me e416b49954c748b1c0fc993e1d38a155 Jan 19, 2012, 5:38 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/command_to_list_all_data_on_one_page_P311332/?page=unread#311332 I had to change the software for one of the sites i own on my server so i need to retrieve all e-mails from the old database to send an e-mail to old members to join the site again. using mysqlman i clicked on sql monitor and entered SELECT * FROM email ORDER BY id LIMIT 0, 20 but it only list 20 e-mails per page even if i change 20 to 100 what command do i need to use to list them all on one page? 2639b1b545969aab38d90eec2ebae4bd Jan 5, 2012, 2:12 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5Bbrewt%5D_entering_a_default_value_of_0_with_not_null_for_an_int_column_P305583/?page=unread#305583 Thanks for the fix Adrian it worked.... there is something else I noticed, unlike mysql 4 mysql 5 gives back 'NO' instead of '' for a column that is not null, this meant the selector in the alter form was defaulting to null even when the column was marked as not null so I mad a fix for it. mysqlman/html.pl sub html_alter_col changed: if ($null) { $null_select = '<option>null</option>' } to: if ($null eq 'YES') { $null_select = '<option>null</option>' } Cheers a008f62abfbbd70a9b6b28119b64a505 May 8, 2009, 6:37 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5Bbrewt%5D_entering_a_default_value_of_0_with_not_null_for_an_int_column_P305392/?page=unread#305392 Sorry it took so long - it's been a busy week. Here's a patch: Code: Index: MySQLMan.pm =================================================================== RCS file: mysqlman/MySQLMan.pm,v retrieving revision 1.28 diff -u -r1.28 MySQLMan.pm --- MySQLMan.pm 10 Jun 2008 03:59:24 -0000 1.28 +++ MySQLMan.pm 25 Apr 2009 03:09:56 -0000 @@ -2942,8 +2942,9 @@ } $col_spec .= ' ' . $IN->param("attributes_$i") . ' '; $col_spec .= $IN->param("null_$i") . ' '; - if ( $IN->param("default_$i") ) { - $col_spec .= 'DEFAULT ' . $DBH->quote( $IN->param("default_$i") ) . ' '; + my $default = $IN->param("default_$i"); + if (length $default) { + $col_spec .= 'DEFAULT ' . $DBH->quote($default) . ' '; } $col_spec .= $IN->param("extra_$i"); Adrian 04fcf139cb7e75e09f089c5202a91bdb Apr 24, 2009, 8:15 PM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5Bbrewt%5D_entering_a_default_value_of_0_with_not_null_for_an_int_column_P305297/?page=unread#305297 Thx Adrian, look forward to it... b9d95e28e2a51b72e6dcfd5656aa2d73 Apr 18, 2009, 4:32 PM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5Bchmodphil%5D_entering_a_default_value_of_0_with_not_null_for_an_int_column_P305296/?page=unread#305296 That looks like a bug. I'll look into a fix and getting you a patch on Monday. Adrian 5e9cdf07878b4167f131d4c34ec9d574 Apr 18, 2009, 3:40 PM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/entering_a_default_value_of_0_with_not_null_for_an_int_column_P305293/?page=unread#305293 Having problem with int column since upgrading to mysql 5.0 when setting 'not null' and default 0 (zero) the column comes back not null but without a default....when entered as sql in SQL Monitor it works fine??? Any help appreciated. Cheers bd75d5b5e2b2b70c20bedb9552574bb7 Apr 18, 2009, 7:33 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5BArtimesia_2%5D_website_search_feature_P302376/?page=unread#302376 Hi, Sounds like you really could with with DBMan ( http://www.gossamer-threads.com/scripts/dbman-sql/ ) This lets you do searches on databases, via a search form - and then returns the results. Hope that helps. Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates e01f3330949d3c6228837514a7eb615a Jun 3, 2008, 4:34 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5BAndy%5D_website_search_feature_P302375/?page=unread#302375 LOL - I mis-typed. I don't want to search YOUR database. What we want to do. We wish to add products, etc. to our MYSQLMan database and put a search feature on our site so visitors can search our large product list for a particular product. Can you do this using MYSQLMan? How? Does that make sense? We want visitors to find our stuff easily by search term in a search box.... Anything you can tell us would help. Thx Art b29cd202e8ed9bc4ca210ba81876aadf Jun 3, 2008, 4:30 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5BArtimesia_2%5D_website_search_feature_P302363/?page=unread#302363 Why would you want to do that? What exactly are you wanting to do a search on? 9d4b15a22bb4353116a8dd99d84fc5c1 Jun 2, 2008, 11:07 PM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/website_search_feature_P302359/?page=unread#302359 Is it possible to put a search on your website and read your MYSQL Man database? Anyone able to do that? Thanks Art 2e642bc72c080afe2b417d31915ef3a6 Jun 2, 2008, 2:55 PM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Get_intermittent_error%3A_malformed_header_from_script._Bad_header%3D_P302121/?page=unread#302121 I'm trying to run this on apache2.0 and I'm not sure if the conf is setup correctly, could you please tell me what it should look like for /mysqlman? Currently have this: Alias /mysqlman /data/sites/mysql/cgi-bin/mysqlman-1.09 <Location /mysqlman> SetHandler perl-script PerlSendHeader On PerlResponseHandler ModPerl::Registry PerlOptions +ParseHeaders Options +ExecCGI Order allow,deny Allow from all </Location> Right now it works sometimes but I have to click back and forth....and keep getting errors like this: [Wed May 14 14:29:03 2008] [error] [client 66.80.210.90] malformed header from script. Bad header=<HTML>: mysql.cgi, referer: http://myhost/mysqlman/mysql.cgi Please help. Thanks, Chris ec6b73d5bd780fb374b686783618697a May 14, 2008, 11:36 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5BAndy%5D_Enquire_on_issues_of_mysqlman_P301398/?page=unread#301398 alright thanks a lot f95329588694bb52132ac83ee5ba1459 Apr 7, 2008, 6:37 PM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5Bpoolboi%5D_Enquire_on_issues_of_mysqlman_P301389/?page=unread#301389 Hi, Maybe best to email support @ gossamer-threads.com, to see what their official reply is Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates fad82f8e7b86af3e21b9806da854a8b1 Apr 7, 2008, 12:41 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Enquire_on_issues_of_mysqlman_P301387/?page=unread#301387 hi, this is with regards to usage issues well is there any restrictions if i'm using mysqlman for commercial use? although it's free i just would like to know if there's any legal restrictions binding mysqlman for commercial use? 7888bff7db14b30f1e68957399b382db Apr 6, 2008, 8:59 PM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5Bpoolboi%5D_trouble_installing_mysqlman_P301353/?page=unread#301353 Hi, It should be very simple to setup. Open the file, and inside the mysqlman-1.09 folder, upload ALL the files. Then, CHMOD the following: Code: mysql.cgi to 755 templates\local - 777 templates\compiled - 777 Hope that helps. Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates f98308a530471e8de79e291890502bf4 Apr 3, 2008, 1:28 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/trouble_installing_mysqlman_P301349/?page=unread#301349 hi, i'm having trouble in placing the GT files and the template files so far i've place my sql.cgi, sql.cfg, html.pl file in the "cg-bin" folder but i'm still left with where to put the libraries GT at when i use my browser to exexute as of now i get the error "fatal undef error: GT::Template (4524): Unable to create compiled template directory 'C:\Program Files\Apache Software Foundation\Apache2.2\cgi-bin\mysql.cfg/templates/compiled'. Reason: No such file or directory at html.pl line 447." any idea why? edb72c82fed96cd5ddea60ace1775510 Apr 2, 2008, 8:24 PM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5BAndy%5D_Mysql_Error_restoring_Wordpress_P299237/?page=unread#299237 Hi Andy, It always gave those strange characters on the first line, doesn't matter what line it is. Testing many times I understood that happens if I save the file in UTF-8. If I save the file in ANSI the restore goes fine. Why this? Thanks. cb4ac0bd99cd42584214b7a71efab3cc Nov 27, 2007, 7:04 AM http://www.gossamer-threads.com/forum/Products_C9/Others_C4/MySQLMan_F13/Re%3A_%5Bjulius2007%5D_Mysql_Error_restoring_Wordpress_P299234/?page=unread#299234 Hi, Does it make a difference if you remove all the commented bits? i.e # MySQL dump # Generated by MySQLMan 1.09 (http://gossamer-threads.com/scripts/) # Host: localhost Database: rester_wordpress #-------------------------------------------------------- # # Table structure for table 'wx_categories' # ..etc Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 697cd36c96d3f5f7f6906f161f1886de Nov 27, 2007, 3:09 AM