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

[Chris Hearn]

HI David,

I am changing my code to do as you suggested. But yes, I am saying that 
the $wpdb->custom_tablename used to work!

I am going through the code, because its a long time since I wrote it!

Thanks for your reply

Chris


On 27/12/2016 18:27, David F. Carr wrote:
> 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
>>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus