arete7

Hi,

Can I ask how this is resolved, the last update did not resolve this for me.

Hi,

I’m reviewing this plugin for our network site.

Can you post how this was resolved please, as I’ve tried this and it kills the network admin site.

Thanks.

Hi,

You can, just append a ‘%’ at the end of your field/column that you are searching.
eg [abase form="1,search" table="employees" columns="first_name%,last_name%$Search Employees" elements="first_name,last_name"]
This will match ‘Bob’ in Bobby.

More complex LIKE searches need a little more defining.
eg [abase form="1,search" table="employees" columns="first_name!'text '=%first_name%,last_name!'text '=%last_name%$Search Employees" elements="first_name,last_name"]
What this is doing is defining the input form type and telling the form surrogate to compare to, being itself.
So the search LIKE is omnidirectional, ie ‘ob’ will match bobby, obby, snobby, etc….

HTH
Paul

• This reply was modified 8 years, 3 months ago by arete7.

Hi,

See https://www.ads-software.com/support/topic/csv-upload-do-not-work/

Hi,

Ok, after much looking reading and trying, I’ve resorted to changing LOAD DATA LOCAL INFILE to LOAD DATA INFILE and adding secure-file-priv = “” to my.cnf and GRANT FILE ON *.* TO ‘your_db_user’@’localhost’;.

As there is much controversy about php 5.5 upwards having some issues(bug possibly) that breaks LOAD DATA LOCAL INFILE(see https://stackoverflow.com/questions/13016797/load-data-local-infile-fails-from-php-to-mysql-on-amazon-rds to test this).

After making the about 3 changes, the upload was successful.

HOTH.

Paul.

Hi,

MySQL needs extra config, see https://dev.mysql.com/doc/refman/5.5/en/load-data-local.html

Typically you may need to edit your my.cnf file and add

[client]
loose-local-infile=1

Please read docs before just enabling this as it does have security implications.

Thx
Paul.

Hi,

I’m having the same problem. Bug maybe?

Thx.
Paul.

Update, MySQL issue
WordPress database error The used command is not allowed with this MySQL version for query LOAD DATA LOCAL INFILE

# mysql -V
mysql Ver 14.14 Distrib 5.5.53

• This reply was modified 8 years, 3 months ago by arete7.
• This reply was modified 8 years, 3 months ago by arete7.

Shortcodes don’t seem to work, widget does however.
Also the reCaptcha option box doesn’t show.

Jess did you find how to do this?

Jeff Farthing, Can you reply please?

Found it,
https://docs.thememylogin.com/ has shortcodes for show_log_link, show_reg_link and show_pass_link

• This reply was modified 8 years, 4 months ago by arete7.