Wappler refusing to write sql custom query of table varchar columns in utf8mb4_general_ci

Wappler General Bugs
#1

Thanks for reporting an issue! Spend 60 seconds reading this…

  1. Before reporting, make sure you have the latest version of Wappler.
  2. Make sure you have searched the forum first for similar issues being reported
  3. If it is a general web related issue - do a Google Search first
  4. Issue tracker is only for bugs and feature requests, in English only.
  5. Learn how to report bugs effectively

======== TEMPLATE BUG FORM ========

Wappler Version :2.4.3
Operating System :Mac Catalina

Expected behavior

I should be able to Select variables from a msql table for a custom query with no regard as to whether data is int, text, varchar and see all of the variables picked up from row to row

…YOUR TEXT HERE …

Actual behavior

What actually happens?

Wherever the mysql field is in the recommended utf8mb4_general_ci collation type the text data ought so be picked up such as Dienstag or Factory Hotel Münster

However in Wappler it doesn’t create a normal sql query.
As a result the data does not show in my table view, the DATA is only the Table Column name over and over.

Here are 2 views of what I see–only in the varchars set up as utf8mb4_general_ci

does Wappler refuse to pick them up and construct the column names in the sql query properly.

44
Screenshot 2019-12-11 at 22.10.44.png1906×942 99.9 KB

52
Screenshot 2019-12-11 at 22.09.52.png1520×1020 64.5 KB

…YOUR TEXT HERE …

#2

I see you are using spaces in your database column names. That’s a really bad idea. Please try replacing the spaces with underscores _ and try building your query and page again.

#3

Yes, you’re Correct, of course!
I always make mysql columns with lowercase & no spaces or using an underscore _ to join two parts together.

Wappler came across the first table the Client sent with Excel naming.

I’ve reworked it to my normal sql values –

SELECT event_id, eventdate, eventday, eventhotel, eventcity, eventseats, eventqueue FROM drk_hotels

I’ll rerun Wappler now.

Thank you, Teodor!

1 Like