Jason H

  • Content count

  • Joined

  • Last visited

About Jason H

  • Rank
    Needs Hobby
  • Birthday 11/20/1973

Recent Profile Visitors

62,760 profile views

Jason H's Activity

  1. Jason H added a comment: search_keywords column on windows SQL   

    Type of server SHOULDN'T matter, but.. I think it does. I may be wrong, but, this is one of those things.. There's a buttload of items that strict mode will affect in Windows but NOT on a Linux server.  Strict mode on Windows is actually stricter than it is on Linux for some oddball reason.
    I THINK this is one of those instances (I don't deal with them daily anymore, so.. Can't be sure I remember this correctly) but I believe if you submit 20 characters to a varchar(10) field on linux.. It will take it and truncate it.
    Either way.. It's a problem.. Just not a big problem, or something you'd encounter every day.. I mean, who the hell gets to a site via a search term like the one listed above?
  2. Jason H added a record in IP.Board   

    search_keywords column on windows SQL
    [code=auto:0]         `keyword` varchar(250) NOT NULL, [/code]
    That limits the column to 250 characters.. Windows servers in strict mode can have problems because of this. Linux will truncate to fit, however, if Windows mySQL in strict mode receives over 250 characters, it will error out.
    An example of this is
     [code=auto:0]  Date: Thu, 24 Jan 2013 23:54:52 +0000  Error: 1406 - Data too long for column 'keyword' at row 1  IP Address: - /foros/index.php?showtopic=19030  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  mySQL query error: INSERT INTO ibf_search_keywords (keyword, count) VALUES ('1- Miguel Olivo.  2- Fernando Tatis.  3- Ronnie Belliard.  4- Pablo Ozuna.  5- Miguel Tejada.  6- Adrian Beltré.  7- Wily Mo Peña.  8- Vladimir Guerrero.  9- Julián Tavárez.  10- José Veras.  11- Luis Vizcaíno.  12- Guillermo Mota.  13- Joaquín Benoit.  14- Santiago Casilla.  15- Octavio Dotel.  16- Daniel Cabrera.  17- Odalís Pérez.  18- José Valverde.  19- José Arredondo.  20 Miguel Batista.', 1) ON DUPLICATE KEY UPDATE count = count + 1 [/code]
    • 0 replies
  3. Jason H added a record in IP.Board   

    "Other" options in VNC
    Ok.. This.. Is in addition to the previous problem where the items don't save.

    SELECT COUNT(tid) as count FROM topics t WHERE state != 'link' AND t.forum_id IN (2,4,3) AND t.last_post > 1310420313 AND t.approved IN (1,0,-1) AND t.topic_archive_status IN (0,3) AND t.starter_id=1

    SELECT tid FROM topics t WHERE state != 'link' AND t.forum_id IN (2,4,3) AND t.last_post > 1310420313 AND t.approved IN (1,0,-1) AND t.topic_archive_status IN (0,3) AND t.starter_id=1 ORDER BY t.last_post desc LIMIT 0,25

    SELECT count(*) as count FROM topics WHERE last_post > 1310422197 AND forum_id IN (2,4,3) AND state != 'link' AND topic_archive_status IN (0,3) AND approved IN (1,0,-1) AND ( tid IN(1086,1085,1084,1083,1082,1081,1080,1079,1078,1077,1076,1075,1073,1074,1072,1071,1070,1069,1056,1055,1054,1053,1052,1039,1040) )

    SELECT tid, forum_id, last_post FROM topics WHERE last_post > 1310422197 AND forum_id IN (2,4,3) AND state != 'link' AND topic_archive_status IN (0,3) AND approved IN (1,0,-1) AND ( tid IN(1086,1085,1084,1083,1082,1081,1080,1079,1078,1077,1076,1075,1073,1074,1072,1071,1070,1069,1056,1055,1054,1053,1052,1039,1040) ) ORDER BY last_post DESC LIMIT 0,25

    That's.. basically 4 queries that are run for 'all posts in the past year - Items I started only"

    So.. the first one runs.. Pulls a count of about 40 topics.. The second runs.. Gets the Topics in question, but.. Only 25.. The next one runs.. Whcih sets the pagination.. "Hey, there's only 25.. happy, happy, happy. one page"

    So.. No matter what you do, you can't get more than one page of results returned.
    • 0 replies
  4. Jason H added a record in IP.Board   

    VSE cannot change menu bar text color
    You can actually set the color.. however.. It winds up getting overridden

    If you convert a VSE skin to templates.. You find this in the skingen.css, assuming you set the text color to c58aba

    #primary_nav a {

    background: #1c3b5f !important; background-color: #1c3b5f !important;
    color: #c58aba;


    However.. This seems to be the code that's actually used on the skin.


    #community_app_menu > li > a {

    background: none repeat scroll 0 0 #1C3B5F;
    color: #C5D5E2;
    display: block;
    padding: 6px 15px 8px;
    text-shadow: 0 1px 1px rgba(0, 0, 0, 0.5);

    Putting an !important in the skingen color works, but, you have to convert the skin to do that. I'm guessing this has something to do with the Content menu bar hook in some way.
    • 0 replies
  5. Jason H added a record in IP.Blog   

    Followed blogs
    The first followed blog shows up properly under "Content I follow"

    Past that.. no info shows


    Only seems to affect followed blogs, not followed entries.
    • 0 replies
  6. Jason H added a record in IP.Calendar   

    RSS exported event times
    OK.. This is.. one of those things that wraps around itself 7 or 8 times.

    And.. I'm not ENTIRELY sure.. Well, let me show you..


    ok.. So, event is in the calendar as 10pm GMT -5

    In the database as 2012-07-10 03:00:00

    Which is correct.. EXCEPT for the fact.. That while DST is in effect.. US East Coast time is NOT GMT -5, it's GMT -4. (Semantics, yes)

    Right now, it's

    Monday, 9 July
    6:41:12 p.m.

    GMT time

    It's 2:41pm here in GMT -5.. Which.. Since we're in DST, we're actually 'in' GMT -4

    The RSS export has the pubdate as


    <pubDate>Tue, 10 Jul 2012 03:00:00 +0000</pubDate>

    Which.. 3am GMT would be 11pm GMT -"5"

    Is this.. A problem with how Firefox and other RSS readers are displaying it? How we're generating it?

    It's almost like we need to remove the TZ offset for the user before sending it.. Or, not the timezone offset, but, the timezone offset MINUS an hour for DST, if it's in effect. Which.. We have no real way to figure out.

    But.. then this comes back to the whole 'guest' thing. We can't tell whether a guest is DST or not, so, we always say "not".. The difference here.. Instead of it always being an hour behind, it's an hour ahead.
    • 0 replies
  7. Jason H added a record in IP.Gallery   

    Users can move albums into image only albums
    From the profile, click on the Gallery tab, and edit one of your albums.

    Any album that you can upload to, shows up in the list. http://screencast.com/t/pZ4InA3WyBp

    in /admin/applications_addon/ips/gallery/modules_public/ajax/albumSelector.php, we have

    case 'edit':
    case 'editAlbum':
    $filters['isUploadable'] = 1;
    $filters['skip'] = array( $albumId );

    Which doesn't eliminate non-album albums.

    case 'edit':
    case 'editAlbum':
    $filters['isUploadable'] = 1;
    $filters['skip'] = array( $albumId );
    $filters['isCreatable'] = 1;

    Seems to work.
    • 0 replies
  8. Jason H added a record in IP.Nexus   

    Bulk discount issues
    Ok.. So.. Bulk discount.. There are actually ways to work around the 0 pricing, by adding second discounts and then removing them. But..

    That uncovers other problems.

    First.. The second discount listed.. Doesn't seem to work.. But, that's just something to test.

    This.. Is the part I see as a problem.

    If you add the item that triggers the discount first.. No problems.

    If you add the discounted item, before it's discounted, then add the item that triggers the discount.. you don't get the discount.


    That shows it clearer. Item B causes Item A's price to drop..

    If you add item B, then Item A.. All is well

    If you add Item A, then item B.. You don't get the discount.

    Another thing.. And, this.. Might be WAI.. If you go the other direction.. Set it up.. If you purchase Item B, then the cost of item A goes UP.. And set that up through bulk discounts.. My example above dropped the price from $5 to $2.. Let's say you wanted, if you purchase Item B, the price of item A goes to $10.. that doesn't work.

    While it *IS* labelled Bulk Discounts.. It also plainly says "base price becomes".. It never says that the base price has to be LOWER than the original price.

    I can see, perhaps, someone trying this.. Sort of like a product association.. If you bought a picture and a frame, the price goes up because you'll put the picture in the frame for them.
    • 0 replies
  9. Jason H added a record in IP.Nexus   

    Support Requests linked to packages
    It seems that if you set Requests should be associated with package? to yes.. You then have to select ALL packages(Or some, at least) from "Packages" for someone to be able to submit a support request.

    If you purchase a package called "Test", and a support department has association enabled, and you select NO packages.. You can't submit the support ticket.

    If you set packages to "Test", or select all packages.. Then you can submit the ticket. But, the "Leave blank for all" does not work

    A second question on this.. Might be an issue, might just be how it works... "Custom Packages" shows up in the list of items to select.. But, even if you have custom packages, those packages don't show up.. http://screencast.com/t/BTWQbE7j

    Is that right?

    If you select all packages.. Then, you're allowed to submit on the customs.. But, you can't restrict or allow based on custom packages it would seem.. Not sure if that's intended or not.. But, doesn't seem like it would be.
    • 0 replies
  10. Jason H added a record in IP.Board   

    Blank overview page
    This.. has been going on for a long time.. However.. It's annoying enough now.. Maybe we can do something?

    I've gone through this site.. One that is getting the blank page.. and.. There's just so much, outside of NOT making that the default page for 'support'.. Which would help, but isn't a real 'solution'.. I don't know what we could possibly do.

    This particular server..

    phpinfo has no disabled_functions.. BUT.. shell_exec is disabled. In addition.. open_basedir restrictions are in effect.

    So.. When you hit

    if ( file_exists('/proc/loadavg'))

    In getServerLoad It bombs.. White page.

    Ok.. That.. MAYBE we could do something with.. My idea was

    $test = ini_get('open_basedir');

    if( !$server_load_found )

    # @ supressor stops warning in > 4.3.2 with open_basedir restrictions
    if (! isset($test))

    if ( file_exists('/proc/loadavg'))

    Not pretty.. But.. It'll work.

    The problem is.. ini_get('disabled_functions') returns empty. BUT.. You comment out the suppression on it.. And you wind up with

    Warning: shell_exec() has been disabled for security reasons

    So, it's disabled.. But.. Not where we can read that it is. And, if you try to call it.. Boom.

    That's.. The big one here. But.. I'd say we have a goodly number of sites that have this problem. Enough that we should rethink things. Now.. I'll check several sites with it, and see if they're all the same, or if it's MAINLY the open_basedir problem.. If it's just that, we can likely work it, and cut the number this happens to way down.. But.. If it's both issues.. I can't see a good way around it.. Though, I'd think we need to do SOMETHING since that page just returns a white screen, which is bad.
    • 0 replies
  11. Jason H added a record in IP.Downloads   

    Tags are incorrect when rebuilding topics
    We have this in sortTopic

    if( !$_POST['ipsTags'] )
    $this->DB->build( array( 'select' => '*', 'from' => 'core_tags', 'where' => "tag_meta_app='downloads' AND tag_meta_area='files' AND tag_meta_id=" . $file['file_id'] ) );

    while( $r = $this->DB->fetch() )
    $_POST['ipsTags'][] = $r['tag_text'];

    Basically, if you're not submitting a new file, it's reading the tags from the database..

    However.. This is in a while.. So, $_POST['ipsTags'] never gets reset.

    So, it hits the first topic with a tag, and every subsequent one.. Gets the same tags.

    I added

    $_POST['ipsTags'] = '';

    Right above the return true on it.. But.. Something tells me I'm missing something that may cause a problem here..
    • 0 replies
  12. Jason H added a comment: HTML in descriptions   

    Is there.. Anything that can be done until 3.4? Any workaround? I mean.. Even something as strange as a power setting to force the RTE to standard mode in the ACP?

    The problem here is that if someone puts HTML in the description of a Nexus item.. Which.. Honestly, I don't know how common that would be. Obviously everyone doesn't do it, but, some do.. Then.. anytime you edit that item.. The HTML is going to blow up.

    That's just.. I dunno.. It's one of those things that isn't massively common, but, for the people who have to deal with it, it would be massively annoying. It's one of those things that.. You go into an item to adjust the cost on it.. And, forget that the editor is in RTE mode.. Boom, your HTML is shot. So, you basically have to keep a backup copy of it somewhere to put it back when you forget about it.

    Grand scheme.. It's probably not a massive deal.. but, one of those things that if you hit it.. You're not going to be happy. Especially after the 3rd or 4th time. So.. that's all i'll say on it.. Just.. Put a second of thought in on what people will have to deal with on this until 3.4.. Coupled with the time until 3.4.. And.. Is there something simple, quick and easy that could be done for a balance, even if it's not perfect? The power setting.. Honestly... I've had multiple requests for that in the forum itself.. Not where you CAN'T switch back to standard, but, where you could default the editor to manual mode in the forum.
  13. Jason H added a record in IP.Content   

    Guest commenting does not pass name to forum
    If you have comments stored in the forum, and guest commenting allowed, when you make a post as a guest, it's stored with the name of "Guest" rather than the name that the user enters on the form.

    Shouldn't this..

    $member = $comment['comment_user'] ? IPSMember::load( $comment['comment_user'] ) : IPSMember::setUpGuest();


    $member = $comment['comment_user'] ? IPSMember::load( $comment['comment_user'] ) : IPSMember::setUpGuest($comment['comment_author']);

    In topics.php?
    • 0 replies
  14. Jason H added a comment: View New Content   

    It's just the "other items" that's a problem.. When you change them.. It doesn't update the members_cache

    This video.. might show it better.


    If you toggle items I follow.. It doesn't save.. but, if you toggle it, AND change the time period.. It saves it.

    So, toggling items i follow alone(or any of the 'other' options) won't update the members cache. You have to change a time period as well, adn then it will write it to the cache.
  15. Jason H added a record in IP.Board   

    &sect in signatures
    That parses. Is this.. Maybe something that can be adjusted in 3.4? We've been fighting the &sect issue for quite some time, and.. for people not using FURL, it can cause all kinds of headaches sharing links.
    • 0 replies

Status Feed

  1. JFL Owner » Jason H

    Your the best!

  2. Jamie. » Jason H

    Nice name lol

    1. ShadowPuppet

      You should be.

  3. Jason H

    test status update

  4. ash somers » Jason H

    thank you :)

  5. Ashen » Jason H

    Jason is not a human, he's a help bot :)

  6. The Old Man » Jason H

    Thanks for the super-quick IP.Content Support Ticket help Jason, much appreciated!

  7. Jason H

    twitter test

  8. AndyF » Jason H

    Happy Birthday Jason :)

  9. Joerg-K » Jason H

    thank you for your very good support!

  10. Jason H

    Thinks the next product we release should be IP.Od. Probably a Cease and Desist already on the way from Apple.

    1. Massive Dynamics

      Wow, I never thought of that!

    2. Massive Dynamics

      IP.Od, that is.

    3. AndyF

      O_o why what have you been doing ? :p

    4. Dreamlander

      what is IP.Od ?

    5. Fishfish0001

      i Pod...

    6. Jason H

      This isn't Dennis Miller material, folks.

    7. AnthonyKinson

      *points and laughs at the slow people*

    8. Glumbo

      This only works if IP.Od could actually be an IPS product

    9. Joshua Hina


    10. Ryan11433


  11. XBN Jamie » Jason H

    thanks for the help :)

  12. TheGamingCenter » Jason H

    Why did u kick me?

  13. sebastian3288 » Jason H

    Thank you for your very fast support.

  14. Mama Gail » Jason H

    Thanks Jason for all your support you give me with my dumb forums. You always seem to be able to fix my messes. lol

  15. Power Optix » Jason H

    Thank you once again for the rescue. :D Hope your Christmas is a goodun. ^^

  16. SICK.boy » Jason H

    I need to download a skin but I can not

  17. JonJon2 » Jason H

    Jason rules BIG TIME! Thanks for your help on my dissected mess called a skin

  18. skinbydragonfly » Jason H

    Many Thanks for your help!

  19. Jυra » Jason H

    You are my hero.

  20. Lindsey_ » Jason H

    Happy Birthday :)

  21. vesperala » Jason H

    happy birthday!

  22. Amy T » Jason H

    Good job on putting the siggy back in the profiles!!

  23. Lindsey_ » Jason H

    Hey Jason.. :)