UtopiaSoftware Forums

Full Version: [Bug report] Database error on revert to original template
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Using the "revert to original" link for the news_newsbit_commentslink template outputs the following error:

Code:
Database error in Utopia News Pro:

Invalid SQL Query: UPDATE `unp_template` SET template='<a onClick='open("{$unpurl}/comments.php?action=list&amp;newsid={$newsid}","View","width=550, height=580, top=20,left=20,scrollbars=yes, status=no, toolbar=no, menubar=no")' href="javascript:void(0)"><font face="verdana, arial, helvetica" color="{$postdatetext}" size="1"><strong>Comments:</strong> {$comments}</font></a>&nbsp;<a onClick='open("{$unpurl}/comments.php?action=post&amp;newsid={$newsid}","Post","width=550, height=580, top=20,left=20,scrollbars=yes, status=no, toolbar=no, menubar=no")' href="javascript:void(0)"><font face="verdana, arial, helvetica" color="{$postdatetext}" size="1">(Add Comment)</font></a>' WHERE id='2'
MySQL 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 'open("{$unpurl}/comments.php?action=list&amp;newsid={$newsid}","View","width=550' at line 1

MySQL Error Number: 1064

Date: April 4, 2008 01:57 AM
Script: /news/templates.php?action=revert&tempid=2&verify=1
Reference URL's