Commision Junction link problem
 

I don't know how but i did make a mistake during the commision junction photopost link insert process. Instead of the direct link, i've added the "java script code" to the CJ Url section in the Admin CP of photopost.

And i can not change it anymore. I did everything but, its not working.

Below you can find the screenshot of the problem.

Can someone please let me learn how i can solve this problem ?

Regards

You need to clear that html out of the field say in phpmyadmin database viewer in most hosting panels using the sql box and the query above. You can only enter the link not html

When i enter below querry :
i get below error message :

Retry the query I posted I altered it a little

I entered the new queery but still have problems.

Something is definately weird on your site mysql just view the actual setting in the settings table with your mysql viewer and remove that errand html in the setting field of setting 70