mats53
Forum Replies Created
-
Forum: Plugins
In reply to: [My Calendar - Accessible Event Manager] Search problemHi 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
Forum: Plugins
In reply to: [My Calendar - Accessible Event Manager] Search problemThe testsite (working) says InnoDB.
The production site (not working) says MyISAM.Forum: Plugins
In reply to: [My Calendar - Accessible Event Manager] Search problemHi 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] => ) )Forum: Plugins
In reply to: [My Calendar - Accessible Event Manager] Search problemHi again,
I was able to run the ‘SHOW TABLE STATUS’ on both servers, so I guess that is not the problem.
Forum: Plugins
In reply to: [My Calendar - Accessible Event Manager] Search problemIt 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
Forum: Plugins
In reply to: [My Calendar - Accessible Event Manager] Search problemFor 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.36and 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.36there 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