Skip to main content Help Control Panel

 

English «   Bug tracker «  

SQL error in ie7

Morison, Rodney -- on Sep. 2 2007

I'm testing my email config with some queries, got a sql error

WorkflowSupport request
StatusProblem has been recorded
  • Submission on Sep. 2 2007 by Rod
OwnerMorison, Rodney
Progress0%
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


Morison, Rodney
52 posts

on Sep. 2 2007


Btw, the same post in firefox 2.0.0.6 is a-ok.

Bernard Paquesfrom nearby-an-airport
Associate, 8407 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?

Morison, Rodney
52 posts

on Sep. 2 2007


Exactly. Only with non-authenticated users, and only on ie7 (that I've tried).

Bernard Paquesfrom nearby-an-airport
Associate, 8407 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.

Morison, Rodney
52 posts

inspired from Bernard on Sep. 2 2007


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