Here are two graphics that result from your query, in order:
We’ve looked at our old database and see that the “Special Rank” functionality seems new.
Our programmer asks, ” What value of key (rank) do we need to have?”
Thanks
just gets odder and odder… dont worry about the key, looks fine…
the real issue is the second piece of data you output with
ashow($memberRanks);
it shows NULL, which should be fine… right before that is a check
if (empty($sfglobals[‘special_rank’]) || empty($memberRanks)) return $userRanks;
which should find the same variable empty and just abort… and php does treat NULL as a condition for empty… so a bit confused…
perhaps something going awry with the NULL value which is actually in mysql coming over to php (maybe converted to string vs php null??)… will have to do some research… but oddly, its been like this forever and not sure why its only affecting you… can see in many databases we test with the exact same values…
In fact, I can change it for my user in the db to mysql null and I cannot make the same error occur…
so for the user in question, can you look in your mysql db… table sfmembers, column special_ranks and tell me what you have… do this for the user_id that is seeing the error in the admin…
so does this happen for all users in the admin? or just your particular wp admin?
We’re checking on your last request now.
We’re experiencing identical symptoms on both our instances, the operating site and our test site. When we step back a generation on SP, the symptoms go away.
okay let us know please…
are the operating site and test site on the same server?
No. They are completely separate server locations, in different countries. Operational site is on GoDaddy.
so while awaiting feedback from your coder, you might ask him why
if (empty($sfglobals[‘special_rank’]) || empty($memberRanks)) return $userRanks;
is not catching the $memberRanks == NULL condition…
just to make sure, you might paste the entire code of the function sp_get_user_special_ranks() where the error is occurring… only a dozen lines and would like to make sure the file is what expected..
also, have you upgraded to 5.1.2 yet?
It probably has no relevance but perhaps you could also tell us what version of php you are using.
I’m having difficulty getting my coder to pay attention to this, but the issue is starting to interfere with our business. The warnings are all over the back end of our Admin, proving very irritating to customers who want to post on our Forum as well as to Admin types trying to navigate.
Can you recommend someone I can hire to get this fixed… now?
Thanks!
If you want to send us (yellow swordfish and mr papa) a temp wp admin account with sp admin capabilities and ftp access, we can take a closer look at what is going on… certainly can patch the code to remove the warning… might need phpmyadmin access in order to look at the db too… it just doesnt make sense given the data you have supplied since the exact condition is checked for two lines before the message you are seeing… if that works, please send the info via pm here…
I will do this today. I am traveling, so it will take several hours to happen, but it will.
Thank you.
so have the credentials… but bit confused what I am looking for… this is the warning on admin pages, right?
but I dont see any with the account you gave us… looks clean…
Here are five screenshots with associated URLs.
This is what all three of our Admins see, using 2 windows and one Mac machine , all from different locations.
Our registered users making Forum comments or comments on Customer Review pages are seeing presumably the same thing. We can’t determine whether more casual users are seeing the same thing sometimes or never.
I dont see any screenshots… have you logged in with the user credentials you sent us? I dont see them with it…