Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter mats53

    (@mats53)

    Hi again!

    Sorry for late respons, but have been out of touch for a while.

    You, were right, of course. I found that transient and deleted it and that was it.

    Thanks a lot for great support.

    /Mats

    Thread Starter mats53

    (@mats53)

    The testsite (working) says InnoDB.
    The production site (not working) says MyISAM.

    Thread Starter mats53

    (@mats53)

    Hi again!

    You are right, i did this by running a query from external programs (phpMyAdmin for the local, and MySQLWorkbench for the sharp).

    So I made a new test. I Placed this code at line 405 in my-calendar-events.php:
    $my_calendar = my_calendar_table();
    $dbs = $wpdb->get_results( $wpdb->prepare( ‘SHOW TABLE STATUS WHERE name=%s’, $my_calendar ) );
    print_r($dbs);

    And got the following outputs:
    Working testsite:
    Array ( [0] => stdClass Object ( [Name] => wp_1my_calendar [Engine] => InnoDB [Version] => 10 [Row_format] => Compact [Rows] => 4 [Avg_row_length] => 4096 [Data_length] => 16384 [Max_data_length] => 0 [Index_length] => 16384 [Data_free] => 0 [Auto_increment] => 5 [Create_time] => 2019-03-15 10:40:49 [Update_time] => [Check_time] => [Collation] => utf8mb4_unicode_ci [Checksum] => [Create_options] => [Comment] => ) )

    Not working production site:
    Array ( [0] => stdClass Object ( [Name] => wp_1my_calendar [Engine] => InnoDB [Version] => 10 [Row_format] => Compact [Rows] => 65 [Avg_row_length] => 756 [Data_length] => 49152 [Max_data_length] => 0 [Index_length] => 16384 [Data_free] => 5242880 [Auto_increment] => 63 [Create_time] => 2019-05-09 14:42:19 [Update_time] => [Check_time] => [Collation] => utf8mb4_unicode_ci [Checksum] => [Create_options] => [Comment] => ) )

    Thread Starter mats53

    (@mats53)

    Hi again,

    I was able to run the ‘SHOW TABLE STATUS’ on both servers, so I guess that is not the problem.

    Thread Starter mats53

    (@mats53)

    It seems that the My Calendar tables are InnoDB on both sites, but most of the other tables are MyISAM.

    Both sites seems to be InnoDB as standard engine, but I have little control of the live site, so I am not sure about that.

    /Mats

    Thread Starter mats53

    (@mats53)

    For the testversion i got:
    ==Extra info:==
    PHP Version: 5.6.15
    DB Version: 5.5.5
    Server Software: Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.6.15
    User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36

    and the sharp version:
    ==Extra info:==
    PHP Version: 7.2.17-0ubuntu0.18.04.1
    DB Version: 5.5.63
    Server Software: Apache/2.4.29 (Ubuntu)
    User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36

    there are also different Themes.

    I also made a test by placing an Echo of the $search in ‘function mc_get_search_results’ line ~411 and got:
    On testsite: AND ( event_title LIKE ‘%soppa%’ OR event_desc LIKE ‘%soppa%’ OR event_short LIKE ‘%soppa%’ OR event_label LIKE ‘%soppa%’ OR event_city LIKE ‘%soppa%’ OR event_postcode LIKE ‘%soppa%’ OR event_registration LIKE ‘%soppa%’ )

    and on the sharp site: AND MATCH(event_title,event_desc,event_short,event_label,event_city,event_postcode,event_registration) AGAINST ( ‘soppa’ IN BOOLEAN MODE )

    (Search word is Soppa (swedish for Soup)

    /Mats

Viewing 6 replies - 1 through 6 (of 6 total)