First time user, just tried to pull from a MYSQL dbase I created, this is our own data not the WP dbase (admin).  Trying to use right terms as also a new WP user.

Rendered query: SELECT * FROM C_List WHERE City = "Bridgewater" LIMIT 10
MySQL said: Table 'mobileyezusa_com.C_List' doesn't exist

When I look at the dbase, it does not contain "_com".  Where can I change this, I read the FAQ, guide, and some public tickets. Sorry for the novice question.  I tried remote connection, but that is pointing to the WP admin database and remote connection is not yet my forte.

Looking for direction/example how to grab a custom database to pull from.

OMG, wait, I was not paying attention until I sent this, I will check the SETTINGS piece I now see.

Sorry for the brain relapse.

Will get back to you, thanks!

Hmm, I believe I am in the wrong place on the app.  I did not come across this screen shot you showed.  I tried all of these, the first and last are the closest, it is the last one I used and wrote the query, but was never prompted for anything.  Perhaps my SQL was missing a vital statement to connect to other db??

I chose MYSQL query as input and the second attachment shows what I see.  Not seeing your menus, I have to have run down the wrong path, but I checked many.

Different error this time.  I managed to add the separate connection, tested perfectly, but a simple query failed with an error that did not give me any hints.

I should have received 389 rows as I did pulling right in MYSQL dbase connection.

Ok, makes sense, like 500 browsers errors, it is hard to find the cause and hoping it is not fluctuating in causes.  I ran it again with the same result.  I'm new to this setup and will take some time to gather the logs.  I found some pages on it to edit the phpconfig file.  If you have any simple recipes let me know.  Have to get back at some point to you otherwise.  Thanks for the help so far.

Got a log file setup.  Ran it again and found it.

Missing file, should I re-install?

I wrote over the DBASE, ID, and PW for obvious regular security.

The values were correct.

[03-Nov-2017 18:03:13 UTC] PHP Fatal error: Uncaught exception 'Exception' with message 'No such file or directory' in /home/ajy214/mobileyezusa.com/wp-content/plugins/wpdatatables/source/class.sql.php:49 Stack trace: #0 /home/ajy214/mobileyezusa.com/wp-content/plugins/wpdatatables/source/class.sql.php(39): PDTSql->sqlConnect() #1 /home/ajy214/mobileyezusa.com/wp-content/plugins/wpdatatables/source/class.wpdatatable.php(541): PDTSql->__construct('', 'DBASE', 'ID', 'PW', '3306') #2 /home/ajy214/mobileyezusa.com/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php(431): WPDataTable->__construct() #3 /home/ajy214/mobileyezusa.com/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php(36): WDTConfigController::tryCreateTable('mysql', 'SELECT * FROM `...') #4 /home/ajy214/mobileyezusa.com/wp-content/plugins/wpdatatables/controllers/wdt_admin_ajax_actions.php(51): WDTConfigController::saveTableConfig(Object(stdClass)) #5 [internal function]: wdtSaveTableWithColumns('') #6 /home/ajy214/mobileyezusa.com/wp-inc in /home/ajy214/mobileyezusa.com/wp-content/plugins/wpdatatables/source/class.sql.php on line 49

It works now.  Thanks a load for your help.

I re-installed it, quite possible it was using the LITE version still.

Although I would have thought not to have been able to get this far on LITE.

That or the initial install fell short.

At least it is not due to another PlugIn or WP version compatibility unless another install impacted this one and the re-install made it clean.  My money is on not getting the full version in.

Still pulls the data and I got the shortcode to work on our WP site, but it gets an AJAX error, I have the refresh set to 0 and this keeps looping the error, have to delete the table or close WP.  I found a page on this error since it throws a URL in the error msg.

Update:

 I went back to the WP page that was still loaded and getting this error loop, but somehow it stopped and the data showed up ok.  No more error.  I will check out the resolution anyhow.

Next stop is to check out the ADDONS, we need to pull the data up in a Form.  I see the ADDONS are Forms to data.  This may not be our end resolution.  Was hoping to interact with the table right from the WP page once loaded.

You are correct, that error has gone away.  I have another ticket in for the infrequent Warning msgs I get from another issue.  Mostly it is quiet and this can be closed.