TheDani

fixed it.: Rename or drop old table, and then new sql with the same old data:

ALTER TABLE wp_comments AUTO_INCREMENT = 1;

CREATE TABLE wp_comments (
comment_ID bigint(20) UNSIGNED NOT NULL,
comment_post_ID bigint(20) UNSIGNED NOT NULL DEFAULT 0,
comment_author tinytext NOT NULL,
comment_author_email varchar(100) NOT NULL DEFAULT '',
comment_author_url varchar(200) NOT NULL DEFAULT '',
comment_author_IP varchar(100) NOT NULL DEFAULT '',
comment_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
comment_date_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
comment_content text NOT NULL,
comment_karma int(11) NOT NULL DEFAULT 0,
comment_approved varchar(20) NOT NULL DEFAULT '1',
comment_agent varchar(255) NOT NULL DEFAULT '',
comment_type varchar(20) NOT NULL DEFAULT 'comment',
comment_parent bigint(20) UNSIGNED NOT NULL DEFAULT 0,
user_id bigint(20) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES (...) 
//probably you can avoid comment_ID

ALTER TABLE wp_comments
  ADD KEY comment_post_id (comment_post_ID),
  ADD KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
  ADD KEY comment_date_gmt (comment_date_gmt),
  ADD KEY comment_parent (comment_parent),
  ADD KEY comment_author_email (comment_author_email(10));
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

I had LiteSpeed Cache with CDN: QUIC.cloud CDN Setup on -> Action -> Reset CDN Setup. But all of the plugin is deactivated now including Litespeed.

I had plugin with e.g. yoast and other plugins, but deleted it long time ago. On table on phpmyadmin, have dilemma where I can delete table on plugin safely (e.g. wp_yoast, wp_delete_safely) or crash (e.g. wp_not_delete) when it could have been integrated with WP or deactivated plugins. So I don’t mess with the tables now.

On hostinger, I have “Clear cache” with “Caching Plugin”, “Hostinger CDN (if applicable)” and “Server side cache”. And /.cache is empty.

Where is “cache-busting”? Have tried these two:
/wp-admin/edit-comments.php?ver=1 but is the same as /wp-admin/edit-comments.php
/wp-admin/edit-comments.php?comment_status=moderated&ver=1 but is the same as /wp-admin/edit-comments.php?comment_status=moderated

input: DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);
output: 0 rows deleted. (Query took 0.0002 seconds.)

Pending (3) on /wp-admin/edit-comments.php?comment_status=moderated is still “No comments awaiting moderation.”

See the picture:

[url=https://ibb.co/6stQCBb][img]https://i.ibb.co/SvmSCr0/wp-comments-2.jpg[/img][/url]
[url=https://nb.imgbb.com/]fast image share[/url]

I have read stackexchange, but it fails on A_I and repair table:

On wp_comments.comment_ID, I want to check A_I (Auto_Increment) the same as stackexchange:
output: “Query error: 1062 – ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry ’23’ for key ‘PRIMARY'”

So I want to see wp_comments.comment_ID with number 23:
input: SELECT * FROM wp_comments WHERE comment_ID=23; //and =’23’;
output: “MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 seconds.)”

repair table wp_comments; //with InnoDB utf8mb4_unicode_ci
output: “Your SQL query has been executed successfully. / The storage engine for the table doesn’t support repair”

see the picture:

I’ve tested it with basic emoji ala “??” with the cell top and left (1 row and 1 column). And tested it with both Basic Text and Basic Custom HTML. No matter what I use, it was either large size emoji or similar to “□”.

Finally done it now:
[wptb id=1234567]

style.css: 

#wptb-table-id-1234567 img.emoji {
	height: 15px;
}

Solved from Wongjn

'meta_query' => array(
	array(
	'key' => $dob,
	'value'   => "^\d{4}-$datemonth",			
	'compare' => 'REGEXP',
	)
),

Custom HTML > Insert HTML
before save:
Hello ??, ??

after save + F5:
Hello ?, 慄

I have converted the database to enginee InnoDB and collation utf8mb4_unicode_520_ci
SHOW TABLE STATUS;

Using “Custom HTML” under WP Table Builder, here is the correct symbol/image on the backside (click the pic):

[url=https://ibb.co/rGQP9dW][img]https://i.ibb.co/zhmcd6k/wp-table-bs-correct-02.jpg[/img][/url]

And on frontside is unfortunately error symbol/image (click the pic):

[url=https://ibb.co/GdxyNLr][img]https://i.ibb.co/4Fmz3G0/wp-table-bs-error-02.jpg[/img][/url]

Can you help me more?

I’ve modified and experimented with the codes but it’s not working yet with birthdays. See examples here:

index.php:

$sports = array(
	["football", "dmy", "dob", "Happy birthday, ... other fotball ..."],
	["icehockey", "dmy", "dob", "Happy birthday, ... other icehockey ..."],
	["wrestling", "dmy", "dob", "Happy birthday, ... other wrestling ..."],
	["tennis", "dmy", "dob", "Happy birthday, ... other tennis ..."],
	["archery", "dmy", "dob", "Happy birthday, ... other archery ..."],
);

$current_date = new DateTime();
$datemonth = $current_date->format("d M"); //now is "18 Apr"

foreach ($sports as list($sport, $dmy, $dob, $message)) {

	$args = array(
		'post_type' => $sport, //Four values foreach() sports CPT 
		'post_status' => 'publish, private',
		'limit'	=> '-1',
		'type' => 'DATE',

		
		//method 1
		//->find()
		/*
		I readen the manual, and supposed it was the easiet way to find the birthdays, but have some problems with it. It is replace fetch() (only find), or before (find, fetch) or after (fetch, find)? how can I search for the birthday (bod) in find()?
				
		$args->find( ['post_type' => 'football, icehockey, wrestling, tennis, archery', 'limit' => '-1']) and date and month, is it method 2, 3, 4 or something else with date?
		
		Using "Example #2" on the docs. this method is wrong after the end $args:
		- $sports = pods( $sports )->find( $args ); //error
		- $sport = pods( $sport )->find( $args ); //result of four values of 5 sports CPT, no birthday
		- $dob = pods( $dob )->find( $args ); //1 result, no birthday
		*/
		

		//method 2				
		'where' => "DATE_FORMAT(CAST(dob.meta_value AS date), '%d %b') = $datemonth",


		//method 3
		/*
		'meta_query' => array(
			array(
			'key' => 'dob',
			'value' => '$datemonth', 
			'meta_type' => 'DATE',
			)
		), */


		//method 4
		/*
		'date_query' => array(
			array(
			'day' => $current_date->format("d"),
			'month' => $current_date->format("M"),
			)
		), */


	); //end $args	

	echo "<pre>get_posts:";print_r(get_posts($args));echo "</pre>";
	//have various results with method 1-4. No result on birthday.


	/* later:
	if ( 0 < $sport->total() ) {
	...
	} 
	... set_transient() and get_transient() ... */

} // end foreach

Same here. Can you show us the options with Pods Admin >Edit Pods > (label name) > More Fields > (textfield)?> Edit Field > Field Details > Field Type and Plain Paragraph Text Options ?

Thank you (probably).
So click on a ceil, Text Options -> Link Font Color: #1e73be and enter. Or Custom HTML withtest1 <a >click the link</a>.

Hey again. Yes, the link color automatically changes to visited link. And further: I just marked the cell, not clicked it.

See the 30 seconds video here: https://emalm.com/?v=J60Cp

• This reply was modified 1 year, 3 months ago by TheDani.

So that is “Remove Original Image Backups” is only on “.bk.”, correct?
How can I replaced also from the .jpg/gif/bmp/png/etc to .webp ? Alternatively I have to manually delete all of the the files, /public_html/wp-content/uploads/20XX/XX on FTP.

Have tried also with this:
Auto Request Cron=off
Auto Pull Cron=on
Optimize Original Images=on
Remove Original Backups=on
Optimize Losslessly=off
Preserve EXIF/XMP data=on
Image WebP Replacement=on
WebP For Extra srcset=off
WordPress Image Quality Control=82

In the end, I have a lot of space is just wasted for I can’t use many of the image files, so therefore I want to delete many of the MB/GB.

• This reply was modified 1 year, 9 months ago by TheDani.
• This reply was modified 1 year, 9 months ago by TheDani.

for example, first I uploaded 1 image file (something.jpg) and then I finished with 20+ image files:

something.bk.jpg
something.jpg
something-54×150.bk.jpg
something-54×150.jpg
something-100×100.bk.jpg
something-100×100.jpg
something-100×100.jpg.webp
something-108×300.bk.jpg
something-108×300.jpg
something-200×120.bk.jpg
something-200×120.jpg
something-200×120.jpg.webp
something-200×300.bk.jpg
something-200×300.jpg
something-350×120.bk.jpg
something-350×120.jpg
something-350×120.jpg.webp
something-360×240.bk.jpg
something-360×240.jpg
something-367×1024.bk.jpg
something-367×1024.jpg
something-430×685.bk.jpg
something-430×685.jpg
something-430×685.jpg.webp

I have clicked “Delete all backups of the original images->Remove Original Image Backups”, but still there are a lot of original images are still there.

define( ‘WP_DEBUG_LOG’, true ) is a detour/a bit long way to see the it (cd folder on errors, choose between “Reopen local file” or “Discard local file…”, read the log, fix it, cd folder again on normal folder, some minutes later I have to cd folder on errors again, choose between “Reopen local file” or “Discard local file…”, read the log again, fix it, cd folder again on normal folder again, and so on on filezilla), but thank you for Debug Bar.

• This reply was modified 2 years, 6 months ago by TheDani.

I had the similar.

PHP 8.1:
https://www.wmtips.com/tools/info/s/artauctiondatabase.thebaerfaxt.com/auction-database

Degrade it to PHP 7.4, restored from previous website, and now it works again. Eventually contact with GoDaddy support.