Skip to main content Help Control Panel

Login   A+   A-

Community «   Discussion forum «   Bug tracker «  

SQL error in ie7

avatarMorison, Rodney -- on Sep. 2 2007
I'm testing my email config with some queries, got a sql error
Problem has been recorded

Issue description

Running yacs 7.6.3, fresh install (not upgraded), IE 7.0.5730.11

I configured yacs for email, smtp: localhost. When I try to submit a query.php form (anon surfer, not logged in, http://morison.biz/technotes/query.php) I get the following sql error:

INSERT INTO `yacs_articles` SET nick_name='',behaviors='',extra='',icon_url='',thumbnail_url='',rank=10000,meta='',options='',trailer='',active='Y',active_set='Y',anchor='section:20',anchor_type=SUBSTRING_INDEX('section:20', ':', 1),anchor_id=SUBSTRING_INDEX('section:20', ':', -1),home_panel='main',title='test4',source='',introduction='',description='test4 1.2.3',language='',locked='N',overlay='',overlay_id='',tags='',hits=0,create_name='test4', create_id='', create_address='testy@morison.org', create_date='2007-09-02 18:53:16',edit_name='test4', edit_id='', edit_address='testy@morison.org', edit_action='article:create', edit_date='2007-09-02 18:53:16',publish_name='test4', publish_id=, publish_address='testy@morison.org', publish_date='2007-09-02 18:53:16',handle='09d1aac86ccd3cd179a97e76a8c4b976'
1064: 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 ' publish_address='testy@morison.org', publish_date='2007-09-02 18:53:16',handle=' at line 1

Comments

Rod
avatar
52 posts

on Sep. 2 2007


Btw, the same post in firefox 2.0.0.6 is a-ok.
Bernard
avatar
from nearby-an-airport
Associate, 6796 posts

on Sep. 2 2007


Well, that's may be a tricky bug. According to the source code, this can happen on submission from non-authenticated users. Is this in line with what you have experimented?
Rod
avatar
52 posts

on Sep. 2 2007


Exactly. Only with non-authenticated users, and only on ie7 (that I've tried).
Bernard
avatar
from nearby-an-airport
Associate, 6796 posts

on Sep. 2 2007


Ok, that will be fixed in YACS 7.9, due shortly. Let me know if you wish to get some workaround in the mean time.
Rod
avatar
52 posts

inspired from Bernard on Sep. 2 2007


Bernard: No rush. I'm happy to refer my users to firefox

Rate this page
Posted by Rod on Sep. 2 2007, (popular)