Issue with USARSim wiki
Fragment of a discussion from Project:Support desk
No, it's not SF's hosted solution. And old_text is indeed NOT NULL. So the question is: a) why don't you upgrade, since 1.14 is unsupported; and b) what's in backtrace?
I tried to get in touch with SourceForge about this but they redirected me to here. AFAIK there has been to update recently. Does upgrade fix the issue? I will try to produce a backtrace and post it here.
Here is the backtrace:
Start request
GET /wiki/index.php/UT3_Mod_Installation
Host: usarsim.sourceforge.net
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0) Gecko/20100101 Firefox/4.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en-us,en;q=0.5
Accept-Encoding: gzip, deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Referer: http://usarsim.sourceforge.net/wiki/index.php?title=UT3_Mod_Installation&action=submit
Cookie: __utma=191645736.296100513.1307125849.1307993773.1308072328.12; __utmz=191645736.1307125849.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); ebNewBandWidth_.sourceforge.net=325%3A1307994326116; u145394_wikidbUserID=2; u145394_wikidbUserName=Dr+steveb; __utmb=191645736.25.10.1308072328; __utmc=191645736; u145394_wikidb_session=fp43pues9pvc1oukfpvjjvmic2
If-Modified-Since: Tue, 14 Jun 2011 17:50:48 GMT
X-Forwarded-For: 129.6.32.113
X-Remote-Addr: 129.6.32.113
X-Varnish: 1674444770
Main cache: FakeMemCachedClient
Message cache: MediaWikiBagOStuff
Parser cache: MediaWikiBagOStuff
session_set_cookie_params: "0", "/", "", "", "1"
Fully initialised
Unstubbing $wgContLang on call of $wgContLang::checkTitleEncoding from WebRequest::getGPCVal
Connecting to mysql-u u145394_wikidb...
SQL: SET /* Database::open */ NAMES utf8
SQL: SET /* Database::open */ sql_mode = ''
Connected
SQL: BEGIN
SQL: SELECT /* Article::pageData */ page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_namespace = '0' AND page_title = 'UT3_Mod_Installation' LIMIT 1
SQL: SELECT /* Title::loadRestrictions */ * FROM `page_restrictions` WHERE pr_page = '185'
Unstubbing $wgOut on call of $wgOut::setSquidMaxage from MediaWiki::performAction
Unstubbing $wgUser on call of $wgUser::getOption from OutputPage::checkLastModified
Cache miss for user 2
SQL: SELECT /* User::loadFromDatabase */ * FROM `user` WHERE user_id = '2' LIMIT 1
SQL: SELECT /* User::loadGroups Dr steveb */ ug_group FROM `user_groups` WHERE ug_user = '2'
Logged in from session
OutputPage::checkLastModified: client sent If-Modified-Since: 2011-06-14T17:50:48Z
OutputPage::checkLastModified: effective Last-Modified: 2011-06-14T17:50:48Z
OutputPage::checkLastModified: NOT MODIFIED, page=2011-06-14T17:50:43Z, user=2011-06-14T17:50:48Z, epoch=2011-06-14T17:46:31Z
OutputPage::sendCacheControl: private caching; Tue, 14 Jun 2011 17:50:48 GMT **
SQL: COMMIT
SQL: BEGIN
SQL: SELECT /* Job::pop Dr steveb */ * FROM `job` WHERE job_id >= 0 ORDER BY job_id LIMIT 1
SQL: COMMIT
Request ended normally
Start request
GET /wiki/index.php?title=UT3_Mod_Installation&action=edit
Host: usarsim.sourceforge.net
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0) Gecko/20100101 Firefox/4.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en-us,en;q=0.5
Accept-Encoding: gzip, deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Referer: http://usarsim.sourceforge.net/wiki/index.php/UT3_Mod_Installation
Cookie: __utma=191645736.296100513.1307125849.1307993773.1308072328.12; __utmz=191645736.1307125849.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); ebNewBandWidth_.sourceforge.net=325%3A1307994326116; u145394_wikidbUserID=2; u145394_wikidbUserName=Dr+steveb; __utmb=191645736.25.10.1308072328; __utmc=191645736; u145394_wikidb_session=fp43pues9pvc1oukfpvjjvmic2
X-Forwarded-For: 129.6.32.113
X-Remote-Addr: 129.6.32.113
X-Varnish: 1674444912
Main cache: FakeMemCachedClient
Message cache: MediaWikiBagOStuff
Parser cache: MediaWikiBagOStuff
session_set_cookie_params: "0", "/", "", "", "1"
Fully initialised
Unstubbing $wgContLang on call of $wgContLang::checkTitleEncoding from WebRequest::getGPCVal
Unstubbing $wgUser on call of $wgUser::getOption from MediaWiki::performAction
Cache miss for user 2
Connecting to mysql-u u145394_wikidb...
SQL: SET /* Database::open */ NAMES utf8
SQL: SET /* Database::open */ sql_mode = ''
Connected
SQL: BEGIN
SQL: SELECT /* User::loadFromDatabase */ * FROM `user` WHERE user_id = '2' LIMIT 1
SQL: SELECT /* User::loadGroups Dr steveb */ ug_group FROM `user_groups` WHERE ug_user = '2'
Logged in from session
EditPage::edit: enter
Unstubbing $wgOut on call of $wgOut::setArticleFlag from EditPage::edit
EditPage::importFormData: Not a posted form.
SQL: SELECT /* Title::getCascadeProtectionSources Dr steveb */ pr_page,page_namespace,page_title,pr_expiry,pr_type,pr_level FROM `templatelinks`,`page_restrictions`,`page` WHERE tl_namespace = '0' AND tl_title = 'UT3_Mod_Installation' AND (tl_from=pr_page) AND pr_cascade = '1' AND (page_id=pr_page)
SQL: SELECT /* LinkCache::addLinkObj Dr steveb */ page_id,page_len,page_is_redirect FROM `page` WHERE page_namespace = '0' AND page_title = 'UT3_Mod_Installation' LIMIT 1
SQL: SELECT /* Title::loadRestrictions Dr steveb */ * FROM `page_restrictions` WHERE pr_page = '185'
SQL: SELECT /* Title::loadRestrictionsFromRow Dr steveb */ page_restrictions FROM `page` WHERE page_id = '185' LIMIT 1
User::isBlockedFrom: enter
User::isBlockedFrom: asking isBlocked()
User::isBlocked: enter
User::getBlockedStatus: checking...
IP: 172.29.30.66
Block::load: '', '2', 1
SQL: SELECT /* Block::load Dr steveb */ * FROM `ipblocks` WHERE ipb_user = '2'
Unstubbing $wgMessageCache on call of $wgMessageCache::get from wfMsgGetKey
Connecting to mysql-u u145394_wikidb...
SQL: SET /* Database::open Dr steveb */ NAMES utf8
SQL: SET /* Database::open Dr steveb */ sql_mode = ''
Connected
SQL: SELECT /* MediaWikiBagOStuff::_doquery Dr steveb */ value,exptime FROM `objectcache` WHERE keyname='u145394_wikidb:messages:en'
MessageCache::load: Loading en... got from global cache
Language::loadLocalisation(): got localisation for en from source
SQL: SELECT /* Revision::fetchFromConds Dr steveb */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest FROM `page`,`revision` WHERE (page_id=rev_page) AND rev_page = '185' AND page_id = '185' AND (rev_id=page_latest) LIMIT 1
Unstubbing $wgLang on call of $wgLang::getCode from wfGetLangObj
SQL: SELECT /* Article::pageData Dr steveb */ page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_namespace = '0' AND page_title = 'UT3_Mod_Installation' LIMIT 1
SQL: SELECT /* Revision::fetchFromConds Dr steveb */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest FROM `page`,`revision` WHERE (page_id=rev_page) AND rev_id = '1254' LIMIT 1
SQL: SELECT /* Revision::loadText Dr steveb */ old_text,old_flags FROM `text` WHERE old_id = '1234' LIMIT 1
Class SkinMonobook not found; skipped loadingUnstubbing $wgParser on call of $wgParser::firstCallInit from MessageCache::transform
SQL: SELECT /* Title::getCascadeProtectionSources Dr steveb */ pr_expiry FROM `templatelinks`,`page_restrictions` WHERE tl_namespace = '0' AND tl_title = 'UT3_Mod_Installation' AND (tl_from=pr_page) AND pr_cascade = '1'
SQL: SELECT /* WatchedItem::isWatched Dr steveb */ 1 FROM `watchlist` WHERE wl_user = '2' AND wl_namespace = '0' AND wl_title = 'UT3_Mod_Installation'
SQL: SELECT /* Article::getUsedTemplates Dr steveb */ tl_namespace,tl_title FROM `templatelinks` WHERE tl_from = '185'
SQL: SELECT /* Article::getHiddenCategories Dr steveb */ cl_to FROM `categorylinks`,`page_props`,`page` WHERE cl_from = '185' AND (pp_page=page_id) AND pp_propname = 'hiddencat' AND page_namespace = '14' AND (page_title=cl_to)
SQL: SELECT /* Title::isDeleted Dr steveb */ COUNT(*) FROM `archive` WHERE ar_namespace = '0' AND ar_title = 'UT3_Mod_Installation' LIMIT 1
SQL: SELECT /* Title::isDeleted Dr steveb */ COUNT(*) FROM `archive` WHERE ar_namespace = '0' AND ar_title = 'UT3_Mod_Installation' LIMIT 1
SQL: SELECT /* LinkHolderArray::replaceInternal Dr steveb */ page_id, page_namespace, page_title, page_is_redirect, page_len FROM `page` WHERE (page_namespace=4 AND page_title IN('Copyrights'))
SQL: COMMIT
SQL: BEGIN
SQL: SELECT /* LinkBatch::doQuery Dr steveb */ page_id, page_namespace, page_title, page_len, page_is_redirect FROM `page` WHERE (page_namespace=2 AND page_title='Dr_steveb') OR (page_namespace=3 AND page_title='Dr_steveb') OR (page_namespace=1 AND page_title='UT3_Mod_Installation')
SQL: SELECT /* User::checkNewtalk Dr steveb */ user_id FROM `user_newtalk` WHERE user_id = '2' LIMIT 1
OutputPage::sendCacheControl: private caching; **
SQL: SELECT /* Job::pop Dr steveb */ * FROM `job` WHERE job_id >= 0 ORDER BY job_id LIMIT 1
SQL: COMMIT
Request ended normally
POST /wiki/index.php?title=UT3_Mod_Installation&action=submit
Host: usarsim.sourceforge.net
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0) Gecko/20100101 Firefox/4.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en-us,en;q=0.5
Accept-Encoding: gzip, deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Referer: http://usarsim.sourceforge.net/wiki/index.php?title=UT3_Mod_Installation&action=edit
Cookie: __utma=191645736.296100513.1307125849.1307993773.1308072328.12; __utmz=191645736.1307125849.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); ebNewBandWidth_.sourceforge.net=325%3A1307994326116; u145394_wikidbUserID=2; u145394_wikidbUserName=Dr+steveb; __utmb=191645736.25.10.1308072328; __utmc=191645736; u145394_wikidb_session=fp43pues9pvc1oukfpvjjvmic2
Content-Type: multipart/form-data; boundary=---------------------------288361637310536
Content-Length: 2882
X-Forwarded-For: 129.6.32.113
X-Remote-Addr: 129.6.32.113
X-Varnish: 1946814653
Main cache: FakeMemCachedClient
Message cache: MediaWikiBagOStuff
Parser cache: MediaWikiBagOStuff
session_set_cookie_params: "0", "/", "", "", "1"
Fully initialised
Unstubbing $wgContLang on call of $wgContLang::checkTitleEncoding from WebRequest::getGPCVal
EditPage::edit: enter
Unstubbing $wgOut on call of $wgOut::setArticleFlag from EditPage::edit
Unstubbing $wgLang on call of $wgLang::truncate from EditPage::importFormData
Unstubbing $wgUser on call of $wgUser::getOption from StubUserLang::_newObject
Cache miss for user 2
Connecting to mysql-u u145394_wikidb...
SQL: SET /* Database::open */ NAMES utf8
SQL: SET /* Database::open */ sql_mode = ''
Connected
SQL: BEGIN
SQL: SELECT /* User::loadFromDatabase */ * FROM `user` WHERE user_id = '2' LIMIT 1
SQL: SELECT /* User::loadGroups Dr steveb */ ug_group FROM `user_groups` WHERE ug_user = '2'
Logged in from session
EditPage::importFormData: Passed token check.
SQL: SELECT /* Title::getCascadeProtectionSources Dr steveb */ pr_page,page_namespace,page_title,pr_expiry,pr_type,pr_level FROM `templatelinks`,`page_restrictions`,`page` WHERE tl_namespace = '0' AND tl_title = 'UT3_Mod_Installation' AND (tl_from=pr_page) AND pr_cascade = '1' AND (page_id=pr_page)
SQL: SELECT /* LinkCache::addLinkObj Dr steveb */ page_id,page_len,page_is_redirect FROM `page` WHERE page_namespace = '0' AND page_title = 'UT3_Mod_Installation' LIMIT 1
SQL: SELECT /* Title::loadRestrictions Dr steveb */ * FROM `page_restrictions` WHERE pr_page = '185'
SQL: SELECT /* Title::loadRestrictionsFromRow Dr steveb */ page_restrictions FROM `page` WHERE page_id = '185' LIMIT 1
User::isBlockedFrom: enter
User::isBlockedFrom: asking isBlocked()
User::isBlocked: enter
User::getBlockedStatus: checking...
IP: 172.29.30.70
Block::load: '', '2', 1
SQL: SELECT /* Block::load Dr steveb */ * FROM `ipblocks` WHERE ipb_user = '2'
Unstubbing $wgMessageCache on call of $wgMessageCache::get from wfMsgGetKey
Connecting to mysql-u u145394_wikidb...
SQL: SET /* Database::open Dr steveb */ NAMES utf8
SQL: SET /* Database::open Dr steveb */ sql_mode = ''
Connected
SQL: SELECT /* MediaWikiBagOStuff::_doquery Dr steveb */ value,exptime FROM `objectcache` WHERE keyname='u145394_wikidb:messages:en'
MessageCache::load: Loading en... got from global cache
Language::loadLocalisation(): got localisation for en from source
User::isBlockedFrom: enter
User::isBlockedFrom: asking isBlocked()
User::isBlocked: enter
User::getBlockedStatus: already loaded.
SQL: SELECT /* Title::isDeleted Dr steveb */ COUNT(*) FROM `archive` WHERE ar_namespace = '0' AND ar_title = 'UT3_Mod_Installation' LIMIT 1
SQL: SELECT /* LinkCache::addLinkObj Dr steveb */ page_id,page_len,page_is_redirect FROM `page` WHERE page_namespace = '0' AND page_title = 'UT3_Mod_Installation' LIMIT 1 FOR UPDATE
SQL: SELECT /* Revision::fetchFromConds Dr steveb */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest FROM `page`,`revision` WHERE (page_id=rev_page) AND rev_page = '185' AND page_id = '185' AND (rev_id=page_latest) LIMIT 1
timestamp: 20110614175043, edittime: 20110614175043
EditPage::editForm getting section ''
SQL: SELECT /* EditPage::userWasLastToEdit Dr steveb */ rev_user FROM `revision` WHERE rev_page = '185' AND (rev_timestamp > '20110614175043') ORDER BY rev_timestamp ASC LIMIT 50
EditPage::editForm Suppressing edit conflict, same user.
SQL: SELECT /* Article::pageData Dr steveb */ page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_namespace = '0' AND page_title = 'UT3_Mod_Installation' LIMIT 1
SQL: SELECT /* Revision::fetchFromConds Dr steveb */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest FROM `page`,`revision` WHERE (page_id=rev_page) AND rev_id = '1254' LIMIT 1
SQL: SELECT /* Revision::loadText Dr steveb */ old_text,old_flags FROM `text` WHERE old_id = '1234' LIMIT 1
Use of Article::updateArticle is deprecated. Called from EditPage::internalAttemptSave in /home/project-web/usarsim/htdocs/wiki/includes/EditPage.php at line 1011
SQL: SELECT /* Article::pageData Dr steveb */ page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_id = '185' LIMIT 1
Unstubbing $wgParser on call of $wgParser::preSaveTransform from Article::preSaveTransform
Class SkinMonobook not found; skipped loadingSQL: BEGIN
SQL: INSERT /* Revision::insertOn Dr steveb */ INTO `text` (old_id,old_text,old_flags) VALUES (NULL,NULL,'utf-8')
SQL ERROR: Column 'old_text' cannot be null (mysql-u)
SQL: SELECT /* LinkBatch::doQuery Dr steveb */ page_id, page_namespace, page_title, page_len, page_is_redirect FROM `page` WHERE (page_namespace=2 AND page_title='Dr_steveb') OR (page_namespace=3 AND page_title='Dr_steveb') OR (page_namespace=1 AND page_title='UT3_Mod_Installation')
SQL: SELECT /* User::checkNewtalk Dr steveb */ user_id FROM `user_newtalk` WHERE user_id = '2' LIMIT 1
SQL: SELECT /* WatchedItem::isWatched Dr steveb */ 1 FROM `watchlist` WHERE wl_user = '2' AND wl_namespace = '0' AND wl_title = 'UT3_Mod_Installation'
OutputPage::sendCacheControl: no caching **
Behzad
