Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#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
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