TinyPortal

Development => Feedback => Bugs/Errors => Topic started by: Swampy on April 04, 2010, 03:10:44 AM

Title: Error Found
Post by: Swampy on April 04, 2010, 03:10:44 AM
Not sure if others have seen this. When inserting into an html block the following occurs:


<p><a href="http://www.tvgrapevine.com/index.php?option=com_content&amp;view=article&amp;id=6307:the-bachelorette-dressed-to-wed&amp;catid=170:the-bachelorette-ali-fedotowsky&amp;Itemid=161" target="_blank">THE
BACHELORETTE: DRESSED TO WED</a></p>
<p><a href="http://www.tvgrapevine.com/index.php?option=com_content&amp;view=article&amp;id=6308:jamie-olivers-food-revolution-ambassadors-of-change&amp;catid=179:jamie-olivers-food-revolution&amp;Itemid=161" target="_blank">Jamie Oliver's Food Revolution: Ambassadors of Change</a>
</p>


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 's Food Revolution: Ambassadors of Change

' WHERE id = 27' at line 1
File: /home/tvgrapev/public_html/smf/Sources/TPortalAdmin.php
Line: 2362
Title: Re: Error Found
Post by: Xarcell on April 04, 2010, 03:52:02 AM
It's funny.

Your using HTML and BBC code, but receiving a php error.

:D
Title: Re: Error Found
Post by: Xarcell on April 04, 2010, 03:52:47 AM
Can you post what your trying to paste into an HTML article? So I can debug & test?
Title: Re: Error Found
Post by: Swampy on April 04, 2010, 05:25:22 AM
below is what was pasted into the html box in code mode.  Then I exited code mode, it looked good so I clicked save and the error above happened.

Quote<p><a href="http://www.tvgrapevine.com/index.php?option=com_content&amp;view=article&amp;id=6307:the-bachelorette-dressed-to-wed&amp;catid=170:the-bachelorette-ali-fedotowsky&amp;Itemid=161" target="_blank">THE
BACHELORETTE: DRESSED TO WED[/url]</p>
<p><a href="http://www.tvgrapevine.com/index.php?option=com_content&amp;view=article&amp;id=6308:jamie-olivers-food-revolution-ambassadors-of-change&amp;catid=179:jamie-olivers-food-revolution&amp;Itemid=161" target="_blank">Jamie Oliver's Food Revolution: Ambassadors of Change[/url]
</p>
Title: Re: Error Found
Post by: Xarcell on April 04, 2010, 07:32:18 AM
Quote from: swampy on April 04, 2010, 05:25:22 AM
below is what was pasted into the html box in code mode.  Then I exited code mode, it looked good so I clicked save and the error above happened.

Quote<p><a href="http://www.tvgrapevine.com/index.php?option=com_content&amp;view=article&amp;id=6307:the-bachelorette-dressed-to-wed&amp;catid=170:the-bachelorette-ali-fedotowsky&amp;Itemid=161" target="_blank">THE
BACHELORETTE: DRESSED TO WED[/url]</p>
<p><a href="http://www.tvgrapevine.com/index.php?option=com_content&amp;view=article&amp;id=6308:jamie-olivers-food-revolution-ambassadors-of-change&amp;catid=179:jamie-olivers-food-revolution&amp;Itemid=161" target="_blank">Jamie Oliver's Food Revolution: Ambassadors of Change[/url]
</p>

That code isn't right though.

Try This:

<p><a href="http://www.tvgrapevine.com/index.php?option=com_content&amp;view=article&amp;id=6307:the-bachelorette-dressed-to-wed&amp;catid=170:the-bachelorette-ali-fedotowsky&amp;Itemid=161" target="_blank">THE
BACHELORETTE: DRESSED TO WED</a></p>
<p><a href="http://www.tvgrapevine.com/index.php?option=com_content&amp;view=article&amp;id=6308:jamie-olivers-food-revolution-ambassadors-of-change&amp;catid=179:jamie-olivers-food-revolution&amp;Itemid=161" target="_blank">Jamie Oliver's Food Revolution: Ambassadors of Change</a>
</p>


You can't mix HTML with BBC closing tags.

Title: Re: Error Found
Post by: Swampy on April 04, 2010, 12:16:02 PM
that code produces this error

Quote<p><a href="http://www.tvgrapevine.com/index.php?option=com_content&amp;view=article&amp;id=6307:the-bachelorette-dressed-to-wed&amp;catid=170:the-bachelorette-ali-fedotowsky&amp;Itemid=161" target="_blank">THE
BACHELORETTE: DRESSED TO WED</a></p>
<p><a href="http://www.tvgrapevine.com/index.php?option=com_content&amp;view=article&amp;id=6308:jamie-olivers-food-revolution-ambassadors-of-change&amp;catid=179:jamie-olivers-food-revolution&amp;Itemid=161" target="_blank">Jamie Oliver's Food Revolution: Ambassadors of Change</a>
</p>

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 's Food Revolution: Ambassadors of Change

' WHERE id = 27' at line 1
File: /home/tvgrapev/public_html/smf/Sources/TPortalAdmin.php
Line: 2362
Title: Re: Error Found
Post by: G6Cad on April 04, 2010, 01:01:47 PM
Itemid=161" target="_blank">THE
BACHELORETTE: DRESSED TO WED[/url]</p>


You see the  [  / url ] code in there ?   you still have a mixed html and bbc code there < / url > is what it should be, please try that and see if it render correctly
Title: Re: Error Found
Post by: Swampy on April 04, 2010, 01:16:27 PM
Quote from: G6 on April 04, 2010, 01:01:47 PM
Itemid=161" target="_blank">THE
BACHELORETTE: DRESSED TO WED[/url]</p>


You see the  [  / url ] code in there ?   you still have a mixed html and bbc code there < / url > is what it should be, please try that and see if it render correctly

Don't have a clue where that is coming from, but these 3 screem captures is exactly what I am doing to generate the error

Title: Re: Error Found
Post by: G6Cad on April 04, 2010, 01:29:01 PM
Seems to be abug there or something, i will let Bloc know about it so he can check it out.
Title: Re: Error Found
Post by: Renegd98 on April 04, 2010, 01:36:02 PM
I can confirm that I also get and error when using that code in and html block. After entering it into the html code block and before saving it displays correctly (after removing the[url] tags) but fails on save.