Database Error

[richie]

I have received this after inputing the code for the more portals, etc.

Database Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND t.ID_BOARD=b.ID_BOARD
AND 1
ORDER BY t.ID_FIRST_MSG DESC
LIMIT' at line 3
File: /mnt/w0900/d19/s13/b02eba95/www/digitalspot.net/Sources/TPmodules.php
Line: 1719

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.10, while your database is at version 1.1.9. The above error might possibly go away if you execute the latest version of upgrade.php.

[G6Cad]

Inputting what code to where ? More portals is what ?
Please add more info on what you have done.

[richie]

Sorry I had to leave when I had to type this.  But on topic, this post.
http://www.tinyportal.net/index.php/topic,13069.msg125356.html#msg125356
http://www.tinyportal.net/index.php/topic,13069.msg125356.html#msg125356

Then when I chose my forums, once I got to the 7th for adding it so it can come on the portal it showed the error.

[G6Cad]

In the bottom of that post JP Denis say you have to add the code i posted before her code ( the post you linked to )  Did you add the code i showed aswell ?

[richie]

Yes I did.

[JPDeni]

It would probably be best if you posted the code you used so we're all on the same page. Unfortunately, the error message doesn't help because the error is always just before the text that they give you.

[richie]

That error occurred once I was setting the portals.

Here is the code I used:
TPortalAdmin.template.php

Code Select Expand

echo '
// board 6
echo '
<select size="1" name="tp_ssiboard6"><option value="0">',$txt['tp-none-'],'</option>';
$tn=sizeof($context['TPortal']['boards']);
for($n=0 ; $n<$tn; $n++){
echo '
<option value="'.$context['TPortal']['boards'][$n]['id'].'" ' ,$context['TPortal']['boards'][$n]['id']==$context['TPortal']['SSI_board6'] ? 'selected' : '' , '>'.$context['TPortal']['boards'][$n]['name'].'</option>';
}
echo '
// board 7
echo '
<select size="1" name="tp_ssiboard7"><option value="0">',$txt['tp-none-'],'</option>';
$tn=sizeof($context['TPortal']['boards']);
for($n=0 ; $n<$tn; $n++){
echo '
<option value="'.$context['TPortal']['boards'][$n]['id'].'" ' ,$context['TPortal']['boards'][$n]['id']==$context['TPortal']['SSI_board7'] ? 'selected' : '' , '>'.$context['TPortal']['boards'][$n]['name'].'</option>';
}
echo '
// board 8
echo '
<select size="1" name="tp_ssiboard8"><option value="0">',$txt['tp-none-'],'</option>';
$tn=sizeof($context['TPortal']['boards']);
for($n=0 ; $n<$tn; $n++){
echo '
<option value="'.$context['TPortal']['boards'][$n]['id'].'" ' ,$context['TPortal']['boards'][$n]['id']==$context['TPortal']['SSI_board8'] ? 'selected' : '' , '>'.$context['TPortal']['boards'][$n]['name'].'</option>';
}
echo '
// board 9
echo '
<select size="1" name="tp_ssiboard9"><option value="0">',$txt['tp-none-'],'</option>';
$tn=sizeof($context['TPortal']['boards']);
for($n=0 ; $n<$tn; $n++){
echo '
<option value="'.$context['TPortal']['boards'][$n]['id'].'" ' ,$context['TPortal']['boards'][$n]['id']==$context['TPortal']['SSI_board9'] ? 'selected' : '' , '>'.$context['TPortal']['boards'][$n]['name'].'</option>';
}
echo '
//board 10
echo '
<select size="1" name="tp_ssiboard10"><option value="0">',$txt['tp-none-'],'</option>';
$tn=sizeof($context['TPortal']['boards']);
for($n=0 ; $n<$tn; $n++){
echo '
<option value="'.$context['TPortal']['boards'][$n]['id'].'" ' ,$context['TPortal']['boards'][$n]['id']==$context['TPortal']['SSI_board10'] ? 'selected' : '' , '>'.$context['TPortal']['boards'][$n]['name'].'</option>';
}
echo '


TPortalAdmin.php

Code Select Expand

elseif($what=='tp_ssiboard1')
{
$bo=array();
$bo[0]=$_POST['tp_ssiboard1'];
$bo[1]=$_POST['tp_ssiboard2'];
$bo[2]=$_POST['tp_ssiboard3'];
$bo[3]=$_POST['tp_ssiboard4'];
$bo[4]=$_POST['tp_ssiboard5'];
$bo[5]=$_POST['tp_ssiboard6'];
$bo[6]=$_POST['tp_ssiboard7'];
$bo[7]=$_POST['tp_ssiboard8'];
$bo[8]=$_POST['tp_ssiboard9'];
$bo[9]=$_POST['tp_ssiboard10'];


G6 Post

Code Select Expand

// divide the SSI board into 5 boards
$sib=explode(',',$context['TPortal']['SSI_board']);
for($i=0 ; $i<10 ; $i++)
{
if(isset($sib[$i]))
$context['TPortal']['SSI_board'.($i+1)]=$sib[$i];
else
$context['TPortal']['SSI_board'.($i+1)]='';
}


Now this is exactly how I put it.

So thats what I did first.  These errors comes up right after choosing forum for portals.

Front index

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND t.ID_BOARD=b.ID_BOARD
AND 1
ORDER BY t.ID_FIRST_MSG DESC
LIMIT' at line 3
File: /mnt/w0900/d19/s13/b02eba95/www/digitalspot.net/Sources/TPmodules.php
Line: 1719

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.10, while your database is at version 1.1.9. The above error might possibly go away if you execute the latest version of upgrade.php.

This is what appears on line 1719.

LIMIT $start, $limit", __FILE__, __LINE__);

Admin Panel

Table 'd60626144.modules' doesn't exist
File: /mnt/w0900/d19/s13/b02eba95/www/digitalspot.net/Sources/TPSubs.php
Line: 108

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.10, while your database is at version 1.1.9. The above error might possibly go away if you execute the latest version of upgrade.php.

This what appears on line 108.

$request =  tp_query("SELECT permissions FROM " . $tp_prefix . "modules WHERE active=1", __FILE__, __LINE__);

[G6Cad]

Link to your iste and also, please add in what SMF and TP version you use

[richie]

www.digitalspot.net

SMF v1.1.10 and the highest version of tinyportal 1084 beta 4 I think

[G6Cad]

That might be the reason for the error right there, The code from the post were for TP V0983, im not 100% sure it works with Beta4. will have to let IchBin or Deni reply to that.