SQL error in ie7
I'm testing my email config with some queries, got a sql error
Problem has been recordedIssue 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:
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 1Comments
Rod![]() 52 posts | Btw, the same post in firefox 2.0.0.6 is a-ok. |
| Bernard from nearby-an-airport Associate, 6796 posts | 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![]() 52 posts | Exactly. Only with non-authenticated users, and only on ie7 (that I've tried). |
| Bernard from nearby-an-airport Associate, 6796 posts | 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![]() 52 posts |
Bernard: No rush. I'm happy to refer my users to firefox
|
Rate this page
Posted by Rod on Sep. 2 2007, (popular)
