• Content count

  • Joined

  • Last visited

About ViruzcK

  • Rank
    IPB Member
  • Birthday 11/28/1983

ViruzcK's Activity

  1. ViruzcK added a record in IP.Board   

    Sitemap - Error in topics with pages
    I defined in the sitemap generation, including all pages of the topics, however they are not added correctly and always comes at the beginning of the topic
    Example :
    Sitemap URL:[code=auto:0][/code]

    Correct URL:[code=auto:0][/code]
    • 0 replies
  2. ViruzcK added a comment: mobileTagify() json_encode   

    I've also encountered this problem, the variables in the header notifications

    ipb.vars['notificationData'] = " . json_encode( $header_items['notifications'] ) . ";
  3. ViruzcK added a comment: Sphinx very long query   

    Dear, now I have opened a ticket, which reported another problem, you need to create a new one for this case, or add this problem to the same ticket?
  4. ViruzcK added a record in IP.Board   

    Sphinx very long query
    Sphinx very long query, which takes nearly 2 hours to scan more than 14 billion records, here is the MySQL Long Query Log

    # Time: 110902 5:54:57
    # User@Host: xxxxx[xxxxx] @ localhost []
    # Query_time: [b]6885[/b] Lock_time: 0 Rows_sent: 3034453 Rows_examined: [b]14765644292[/b]
    SELECT, as search_id, p.author_id, p.post_date,, p.topic_id, p.queued,
    t.tid, t.title, t.title as tordinal, t.views, t.posts, t.forum_id, t.last_post, t.state, t.start_date, t.starter_id, t.last_poster_id, t.topic_firstpost,
    CASE WHEN t.approved = -1 THEN 1 ELSE 0 END AS soft_deleted,
    CASE WHEN t.approved = -1 THEN 0 ELSE t.approved END AS approved,
    CONCAT(t.last_post, '.', t.tid ) as last_post_group,
    ( SELECT GROUP_CONCAT(tag.tag_text) FROM ibf_core_tags tag WHERE tag_meta_app='forums' AND tag_meta_area='topics' AND tag_meta_id IN(t.tid) ) as tag_text
    FROM ibf_posts p
    LEFT JOIN ibf_topics t ON ( p.topic_id=t.tid );
    • 0 replies
  5. ViruzcK added a comment: Warn log full, cannot scroll   

    Screenshot :
  6. ViruzcK added a comment: Warn log full, cannot scroll   

    I have the same problem
  7. ViruzcK added a comment: RTL: Emoticons parsed like IMG   

    [font="arial, sans-serif"][size="6"][size="2"]Thank you very much, anyway you look before but did not find it.[/size][/size][/font]
  8. ViruzcK added a record in IP.Board   

    RTL: Emoticons parsed like IMG
    When you insert emoticons, using the RTL editor, they are processed as IMG and edit or preview the message, the emoticon is lost and only shows an image like the following way [code][img][/img][/code]

    Example :


    • 0 replies
  9. ViruzcK added a record in IP.Content   

    Call to undefined method DirectoryIterator::getBasename()
    [code][b]Fatal error[/b]: Call to undefined method DirectoryIterator::getBasename() in [b]/home/devel/public_html/admin/applications_addon/ips/ccs/sources/databases/fields.php[/b] on line [b]169[/b][/code]

    This same problem was solved previously fields.php file according to this [url=""]link[/url], but the same is repeated a few lines below, I implemented the solution mentioned in the previous link, and the problem is resolved.

    [code]$className = 'fields_' . $dir->getBasename('.php');[/code]

    Replaced with :

    [code] if( method_exists( $dir, 'getBasename' ) )
    $className = 'fields_' . $dir->getBasename('.php');
    $filename = $dir->getFilename();
    $filename = substr( $filename, 0, strrpos( $filename, '.' ) );

    $className = 'fields_' . $filename;
    • 0 replies
  10. ViruzcK added a record in IP.Board   

    [b]ERROR SQL [/b]

    [i]ERROR 1062 (23000) at line 4: Duplicate entry '0' for key 1[/i]
    QUERY : [/b]

    [code]INSERT INTO ibf_profile_portal (notes,links,bio,ta_size,signature,avatar_location,avatar_size,avatar_type) SELECT notes,links,bio,ta_size,signature,avatar_location,avatar_size,avatar_type FROM `ibf_member_extra`;[/code]

    [code]INSERT INTO ibf_profile_portal (pp_member_id,notes,links,bio,ta_size,signature,avatar_location,avatar_size,avatar_type) SELECT id,notes,links,bio,ta_size,signature,avatar_location,avatar_size,avatar_type FROM `ibf_member_extra`;[/code]
    • 0 replies