Bloke

AB51MN50.jpg
should come before AB51MN100.jpg second in the list.

No I was given the file names as they are and now I need to order them. At one time I did find leading spaces in the file names but they have been removed.

My site is not live unfortunately. I have tried so many things so I will post the current list of actual list of files I am getting. See file AB51MN50.jpg is where is goes out of order.

AB51HPS70.gif
AB51MN100.jpg
AB51MN100.gif
AB51MN175 w.jpg
AB51MN175 w.gif
AB51MN175 w.jpg
AB51MN175 w.gif
AB51MN175 w.jpg
AB51MN175 w.gif
AB51MN175.jpg
AB51MN175.gif
AB51MN175eue.jpg
AB51MN175eue.gif
AB51MN50.jpg
AB51MN50.gif
AB51MN70.jpg
AB51MN70.gif
AB51PS150.jpg
AB51PS150.gif

ABC123AB.gif
ABC123AB.jpg

should appear before

CAD435FG.gif
CAD435FG.jpg

No that didn’t work. The upper/lowercase isn’t an issue. Its the combination of letters, numbers, and spaces.

I have tried the following queries:

$query = “SELECT * FROM files WHERE prod_id = ‘”. $this->curProduct .”‘ ORDER BY LENGTH”;
$query = “SELECT * FROM files WHERE prod_id = ‘$this->curProduct’ ORDER BY CAST(file_name as unsigned), file_name asc”;
$query = “SELECT * FROM files WHERE prod_id = ‘$this->curProduct’ ORDER BY LENGTH(file_name), file_name asc”;
$query = “SELECT * FROM files WHERE prod_id = ‘$this->curProduct’ ORDER BY CAST(file_name as signed), file_name ASC”;
$query = “SELECT * FROM files WHERE prod_id = ‘$this->curProduct’ ORDER BY CAST(file_name as alphanumeric) ASC”;
$query = “SELECT * FROM files WHERE prod_id = ‘”. $this->curProduct .”‘ ORDER BY LENGTH(alphanumeric)”;

CAD435FG.gif
CAD435FG.jpg
DCG567CD.gif
DCG567CD.jpg
EFG324DF.gif
EFG324DF.gif
FG LMN WST.gif
FG LMN WST.gif
ABC123AB.gif
ABC123AB.jpg

No matter how I sort it it will put most of it in order like this except ABC123AB.gif, ABC123AB.jpg which should be at the top. I did have some files in the database that had a space in the first position. I cleaned that up but still not working.

Ok I fixed it. I just panicked. I had a old htaccess file in there before I was using wordpress. Then I replaced it and I got that error. I copied the htaccess file from another install and all is well.

You’re right I forgot that I had downloaded that theme. Makes sense to me now.

I was both surprised and glad they caught it. But in the email they said its my responsibility to keep all the plugins and files up to date. But the “basic” theme was not in the update.

Got it fixed thanks to the developer of the plug in. Recently Facebook changed the start_time and end_time as a sting causing the issue. Read about it here.
https://developers.facebook.com/bugs/415058451869226?browse=search_4ff978394ed3a2560050216

I did a manual install and followed the instructions. Yes I know about changing core files. Sometimes as a developer you have to tweak new core files such as wp-settings.php if they are causing issues. Example is this line of code. on line 35

// Set default timezone in PHP 5.
if ( function_exists( 'date_default_timezone_set' ) )
	date_default_timezone_set( 'UTC' );

This really has me puzzled. The plug in code never changed. The developer sent me the exact file he is using and the dates and times are correct on his end. The person posting the events on Facebook are in the same city as me. Just recently someone brought it to my attention the times were off.

Yes I am aware of that date. But the format of the time and date in WordPress settings didn’t change that. All it does is display January 1970 in different ways. He hasn’t changed the code either.

I am in USA Ny time zone. I checked my WordPress settings. My event says 11:33 on the plugin but on Facebook it is 11:00 am -2:00 pm. Also it shows 11:33-11:33 1969 Is there a fix for this? I can’t edit it since its off by 13 minutes and 43 years.