[wp-hackers] Access custom table using global wpdb not working

[David F. Carr]

As far as I know, custom table names are not automatically populated in the
$wpdb object (never worked when I tried it). I usually do something like
$custom_tablename = $wpdb->prefix.'custom_tablename' and then use that
variable in my sql.

You're saying this used to work. Is it a plugin of your design? Could there
have been something in the plugin code (now changed or deleted) that added
an additional property to the $wpdb object?


On Tue, Dec 27, 2016 at 1:17 PM, Chris Hearn <chris.hearn01 at ntlworld.com>
wrote:

> Hi,
> Just recently a custom plugin on my site stopped working properly (after
> several years).
> The following line that fails is simply getting a count from a custom
> (non-wp) table.
>
> global $wpdb;
> ...
> $num = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->custom_tablename"); //
> result is null because it appears that $wpdb->custom_tablename is also null.
>
> $num_wpUsers = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->users"); //
> this works as expected!
>
> If there some change that only allows "standard" wordpress table names now?
>
> Thanks for any help!
> Chris
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>