Page MenuHomePhabricator

Incorrect integer value: '' for column 'af_hidden'
Closed, ResolvedPublic

Description

A database query error has occurred. This may indicate a bug in the software.

Query:
REPLACE INTO `abuse_filter` (af_pattern,af_enabled,af_hidden,af_global,af_throttled,af_public_comments,af_comments,af_group,af_deleted,af_actions,af_timestamp,af_user,af_user_text,af_id) VALUES ('my filter','1','','','','my description','','flow','','disallow','20140527132708','1','Mlitn',NULL)
Function: AbuseFilterViewEdit::show
Error: 1366 Incorrect integer value: '' for column 'af_hidden' at row 1 (127.0.0.1)

Backtrace:

#0 includes/db/Database.php(1129): DatabaseBase->reportQueryError('Incorrect integ...', 1366, 'REPLACE INTO `a...', 'AbuseFilterView...', false)
#1 includes/db/Database.php(2727): DatabaseBase->query('REPLACE INTO `a...', 'AbuseFilterView...')
#2 includes/db/DatabaseMysqlBase.php(427): DatabaseBase->nativeReplace('abuse_filter', Array, 'AbuseFilterView...')
#3 extensions/AbuseFilter/Views/AbuseFilterViewEdit.php(159): DatabaseMysqlBase->replace('abuse_filter', Array, Array, 'AbuseFilterView...')
#4 extensions/AbuseFilter/special/SpecialAbuseFilter.php(116): AbuseFilterViewEdit->show()
#5 includes/specialpage/SpecialPage.php(379): SpecialAbuseFilter->execute('new')
#6 includes/specialpage/SpecialPageFactory.php(510): SpecialPage->run('new')
#7 includes/Wiki.php(288): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#8 includes/Wiki.php(599): MediaWiki->performRequest()
#9 includes/Wiki.php(451): MediaWiki->main()
#10 index.php(46): MediaWiki->run()
#11 wiki.phtml(3): include_once('/...')
#12 {main}


Version: unspecified
Severity: normal

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 3:26 AM
bzimport added a project: AbuseFilter.
bzimport set Reference to bz65807.
bzimport added a subscriber: Unknown Object (MLST).

Change 135762 had a related patch set uploaded by Matthias Mullie:
(bug 65807) Fix for tinyint(1)'s not accepting ''

https://gerrit.wikimedia.org/r/135762

Change 135762 had a related patch set uploaded (by Nikerabbit):
Fix for tinyint(1)'s not accepting ''

https://gerrit.wikimedia.org/r/135762

Change 135762 merged by jenkins-bot:
Fix for tinyint(1)'s not accepting ''

https://gerrit.wikimedia.org/r/135762

Nikerabbit closed this task as Resolved.Jan 29 2016, 2:01 PM
Nikerabbit claimed this task.