Cannot understand why this not work

[BulliM]

Can anyone explain, why this works:

PHP Code:

$info = vB::getDbAssertor()->getRow('user', array("userid" => $row['userid']), false, 'username'); 


and this not:

PHP Code:

$info = vB::getDbAssertor()->getRow('anothertableindatabase', array("userid" => $row['userid']), false, 'username'); 


nor:

PHP Code:

$info = vB::getDbAssertor()->getRow('vBForum:anothertableindatabase', array("userid" => $row['userid']), false, 'username'); 


nor:

PHP Code:

$info = vB::getDbAssertor()->getRow('realdatabasename:anothertableindatabase', array("userid" => $row['userid']), false, 'username'); 


Going crazy with vB5 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[noypiscripter]

What table did you specify? Not all tables have a column named "userid".

[BulliM]

Originally Posted by noypiscripter

What table did you specify? Not all tables have a column named "userid".

My table has. userid is the primary key in an added table (same database!). Different is, the searched column wasn't username but user_name. Surely I used that, too. Still cannot understand, why this won't work.

[noypiscripter]

What is the SQL error? You would get an email with the SQL error if you've added your email in the dbtechnicalemail (or something like that) in the core config.

[BulliM]

Originally Posted by noypiscripter

What is the SQL error? You would get an email with the SQL error if you've added your email in the dbtechnicalemail (or something like that) in the core config.

I get no email, because development server has no access to email services.

I get "That action could not be completed. Please try again, and if this occurs again please contact the system administrator and tell them how you got this message. "

This works:

PHP Code:

<?php
global $vbulletin;
$pageuser = 1 // Row exists
$result = $vbulletin->db->query_read('SELECT * FROM database.tablename WHERE userid ='.$pageuser);
$row = $vbulletin->db->fetch_array($result);

[noypiscripter]

Enable debug mode in the root config and core config to see the error stack trace.

[BulliM]

Originally Posted by noypiscripter

Enable debug mode in the root config and core config to see the error stack trace.

Result:

Debug: Error
<b>API Error</b><br><b>Error:</b> invalid_query_definition_x<br><b>Args:</b><br><pre style="font-family:Lucida Console,Monaco5,monospace;font-size:small;overflow:auto;border:1px solid #CCC;">array ( 0 =&gt; 'tablename', )</pre>
occurred in file /var/www/xxxxxxx.xx/core/vb/db/query.php on line 298
Trace

    Function getQuery in file /var/www/xxxxxx.xx/core/vb/db/assertor.php line 225

--------------- Added [DATE]1549284087[/DATE] at [TIME]1549284087[/TIME] ---------------

I know now, why this not work. User delicjous helps me to found out. My table was not defined in querydefs.php. Since it is defined in, I get no errors anymore by using function getDbAssertor().

How should anyone know this?