Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 2022-11-01 19:05:52

ironmangary
Member
From: United States
Registered: 2022-10-13
Posts: 36

Re: smd_query: txp tags in queries

Yeah, I’m positive. I created the “aid” field to match the ID field in the ‘textpattern’ table.

mysql> describe wma_matches;
+--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| aid          | int(11)      | NO   |     | NULL    |       |
<snip>

Hmm, I’m seeing that adminer created the table wma_matches as latin1_swedish_ci and using InnoDB, whereas the other default tp tables are utf8mb4_unicode_ci using MyISAM. However, wma_salaries is also Latin1/Innodb…

EDIT: added bc. for code formatting.

Offline

#14 2022-11-01 19:23:34

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,437
Website GitHub

Re: smd_query: txp tags in queries

Collation mismatches between tables might explain it, but if both your custom tables are the same type and it works in one and not the other, well, I’m out of ideas. Sorry.

If anything comes to me I’ll post an update. In the meantime, let’s shrug and pretend it’s all okay if it’s working as you expect now!


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#15 2022-11-01 20:05:49

ironmangary
Member
From: United States
Registered: 2022-10-13
Posts: 36

Re: smd_query: txp tags in queries

I’m all for that. Thanks for all your help.

Offline

Board footer

Powered by FluxBB