markchicobaby’s blog

One example of how to create a new Joomla user using just SQL in LQM.

The example in the LQM forum post isn’t really correct because it only checks the name field, which isn’t part of the jos_users table primary key.  In fact the only part of the primary key is the ID field, which is kind of useless.  I guess the question then is “what is the natural key”?  I’d say the keys to really check for are username, and email address.

In the next part of this article I show the SQL I used to create a user and confirm it will create correctly without errors.

Continue reading »

If you have an MQE with 3 queries:
Query 1 checks for records that exist
Query 2 inserts new records
Query 3 selects new (and old) records for display

You MUST set expect=”no” on the first query. Otherwise LQM uses it in place of Query3.

I use a tool called LQM (Logos Query Manager).

Its not a bad tool but unfortunately there are many undocumented features. I’ve given up trying to convince the creator to do a better job of the documentation.

I’m going to start a wiki of all the undocumented stuff I’ve found. Unfortunately it will only help about ten people worldwide I think.

So the first fix:
- When using the MQE feature of LQM 3.02 you need to ensure cache is set to at least 1. See this forum post for more details:
LQM Fix for MQE inserts multiple records