I've done an error and I need help

[dimip77]

I've just done a very stupid error! I was in the settings of the SHOUTBOX, and, where I was supposed to write the limit of how many shouts have to be shown in the box, (I wanted to change from the limit of 5 shouts to be shown, to 10 shouts) instead of just writing "10", I wrote "Last 10".
After saving that change nothing works anymore in TP, neither the SMF forum works.
I cannot reach any page and anywhere I go this message gets displayed in the screen:
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 'Ultimi 10' at line 1
File: D:\Inetpub\webs\ighnobilicom\public\forum\Sources\TPortal.php
Line: 589

What can I do? Please help.
I tried to modify that TPortal.php file searching for "Last 10" but I cannot find it, so I don't know what to do to correct my stupid mistake! 
Thank's for anyone will help.
Ciao

PS. I have smf 1.1 and tp 0.9.7

[stormlrd]

Do you kinow how to access your database and how to browse and edit it? that one is gonna have to reset manually I believe.

[dimip77]

Do you kinow how to access your database and how to browse and edit it? that one is gonna have to reset manually I believe.

Quote I know how to access it, I kind of (very little) know how to browse it, I've no idea how to edit it. I know how to use html but I know nothing about MYsql.
At the most I can give someone than can help me in PM the link, the ID, and the password to acces that... Gosh I've done something really not smart this time.

[stormlrd]

No need follow these steps exactly:

cpanel --> mysql databases --> phpmyadmin --> select database you created for your forum from list on left--> Select again from the left smf_tp_settings --> select from top right browse --> scroll down to ---shoutbox_limit-- and click the pencil to edit it --->change this to 10 in the value field--->Click go/save and your done and can close out of everything and continue in your forum with out issue.

[dimip77]

Done it! Everything returned to work just fine!  :up:
Thank you soo much StormLrd !!! 

[stormlrd]

Your welcome I posted this as an issue needing a fix sense it should of checked for the text you put in.

[agridoc]

I saw that you did it. A simpler solution, just in case, for anyone else
Try
[your domain name and SMF dir]/index.php?action=tpadmin;sa=shoutbox

It probably will not open left panel (unless settings changed) so you can edit back.
It seems that you found a bug.

[stormlrd]

good idea didnt think of that lol thanks agridoc

[bloc]

I will correct this for 0.9.7 and update the package.