pauhana

No, I am not debugging my site. And by “error still showing” I mean that at the top of the dashboard, the error is still showing:

[You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 16]
CREATE TABLE svs_bpspro_mscan ( mscan_id bigint(20) NOT NULL auto_increment, mscan_status varchar(8) NOT NULL default ”, mscan_type varchar(16) NOT NULL default ”, mscan_path text NOT NULL, mscan_pattern text NOT NULL, mscan_skipped varchar(7) NOT NULL default ”, mscan_ignored varchar(6) NOT NULL default ”, mscan_db_table varchar(64) NOT NULL default ”, mscan_db_column varchar(64) NOT NULL default ”, mscan_db_pkid text NOT NULL, mscan_time datetime NOT NULL default ‘0000-00-00 00:00:00’, PRIMARY KEY (mscan_id), UNIQUE KEY id (mscan_id) ) COLLATE

Ok. Changed the DB_CHARSET to UTF8 and ran “Reset MScan”. No difference, the error still showing. Anything else I should try?

By the way, I am running under ClassicPress…

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

Sorry, where is the Reset MScan button exactly?

Thanks for the help. (The charset being used was not utf8; hopefully that change will resolve things…).

Sorry, a bit of confusion.

In Peter’s video, the Data Project page appears as follows:
https://ibb.co/FHMLt4g

My Data Project page appears as follows:
https://ibb.co/wwSQyXh

Have I done something to cause the discrepancy?

Exactly what I was looking for.

Thanks so much for pointing me in the right direction! Much appreciated…

Thank you Peter.

I ended up having so much trouble trying to get a date interpreted properly, I ended up just storing it as a string. Not optimal, but good enough.

Thanks again for the help.

Oh, and as to your second question, the query builder shows the date values to be zeroed out; the date column shows as “0000-00-00 00:00:00”.

Here’s a snippet of my code:

      $today = strtotime('today PST');
      if ($today !== false) {
        //DBG $page_text .= 'Today is [' . date("Y-m-d", $today) . ']</br>';
        $db_columns = array('svs_seed_order_date' => $today,
                            'svs_seed_order_member_id' => $user_id,
                            'svs_seed_order_set_id' => $new_seed_set_id);
        $wpdb->insert('svs_seed_order', $db_columns, array('%d', '%d','%d'));
      } else {
        $msg = "Internal error: Problem determining today's date.";
      }

As I say, the value stored has been confirmed to be fine.

Please let me know if there is a better way to go about storing the date…

Sorry, wrong graphic.

Date format output (WordPress format) is given as “F j, Y”.

Still unclear.

Here is a screenshot of my current settings for dates:
https://ibb.co/GnmbXsg

My date has been confirmed correct, but shows up within the Data Explorer as
“November 30, -0001 12:00 am”. Given the date output setting, I was expecting
“April 11, 2022”.

Where am I going wrong?

Thanks for the help!

Thanks Peter. I adjusted per your suggestion, and everything now looks good…

Yes, it appears to be working now. Don’t know why it wasn’t working for me earlier, but I love it when issues resolve themselves!

Thanks much…

Hey Peter.

Yes, you had advised me to revert to the older menu in order to get the new project button to show. (Remember, there is a problem with that due to my making use of Classic Press, so use of the older menu is the workaround).

I will follow your instructions and bounce between the settings as needed.

Thanks much!

Everything looking good. The one thing not working: I have a photo associated with each row, and can’t seem to get that info to show up. Is that possible to do? (Should I use Image URL instead of Image?)

Thanks again.

Thank you Peter. Your snippet, an inner join in the query, and an add_shortcode were just what I needed to get me going.

Thank you Charles. I’m new to views and still making my way thru documentation. Much appreciated.