Wrong value type sent to the database. Integer expected.

[Norbesz]

Hello everyone!
I created an article and I filled it in the introductory text part.  But if I click it it read this mistake in the future then I receive it

Wrong value type sent to the database. Integer expected. (page)

What may be the trouble?
Thanks...

[SadisticSilence]

I've noticed this happens only when you fill in the Query Title field.

If you leave that blank, your article will show up. At least until there's a fix

[tamasir]

Is this mistake at others?
Will he be repaired?
tamasir~

[IchBin]

It really helps if you guys post the info we put on the create topic page. I can't give any answers unless you provide that info. Thanks

[tamasir]

It really helps if you guys post the info we put on the create topic page. I can't give any answers unless you provide that info. Thanks

SMF version: SMF2.0
TP version: TP 1.0RC2
Default Forum Language: Hungarian
Theme name and version: Fire Rock (convert:Tinyportal-eu)
Links url Smf-Tinyportal test Site
Thanks...IchBin

[IchBin]

I need the full error guys. The line number as well so I can see what you guys are seeing...

--edit--

Actually I found it.

Find this in TPortal.php

Code Select Expand

if(is_numeric($pag))
$request = $smcFunc['db_query']('', '
SELECT id_theme FROM {db_prefix}tp_articles
WHERE id = {int:page}',
array('page' => $pag)
);
else
$request =  $smcFunc['db_query']('', '
SELECT id_theme FROM {db_prefix}tp_articles
WHERE shortname = {int:page}',
array('page' => $pag)
);

Replace with:

Code Select Expand

if(is_numeric($pag))
$request = $smcFunc['db_query']('', '
SELECT id_theme FROM {db_prefix}tp_articles
WHERE id = {int:page}',
array('page' => $pag)
);
else
$request =  $smcFunc['db_query']('', '
SELECT id_theme FROM {db_prefix}tp_articles
WHERE shortname = {string:page}',
array('page' => $pag)
);

[tamasir]

IchBinâ,,¢
The mistake a message ceased. The article appeared.
Thanks, thanks.....
tamasir~ (TinyPortal.Eu Team)

[mrph]

Yes, its working.

Thanks