I've installed the mediawiki and ran through the config process, but when I go to http://localhost:8080/mediawiki/index.php, (which is where I installed everything) I get a MediaWiki internal error. I am using PostgreSQL 9.1 on Windows 7, using an apache 2.2.20 server and php v. 5.3.8. The page suggests to run the update.php in the maintenance folder, which produces errors also, but closes before I can read them.
Below is what the index.php shows: MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT value,exptime FROM objectcache WHERE keyname = 'my_wiki:messages:en' LIMIT 1 Function: SqlBagOStuff::get Error: 1 ERROR: relation "objectcache" does not exist LINE 1: ...ECT /* SqlBagOStuff::get */ value,exptime FROM objectcach... ^ ' in C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\db\Database.php:781 Stack trace: #0 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\db\Database.php(751): DatabaseBase->reportQueryError('ERROR: relatio...', 1, 'SELECT value,e...', 'SqlBagOStuff::g...', false) #1 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\db\Database.php(1050): DatabaseBase->query('SELECT value,e...', 'SqlBagOStuff::g...') #2 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\db\Database.php(1134): DatabaseBase->select('objectcache', Array, Array, 'SqlBagOStuff::g...', Array, Array) #3 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\BagOStuff.php(267): DatabaseBase->selectRow('objectcache', Array, Array, 'SqlBagOStuff::g...') #4 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\MessageCache.php(252): SqlBagOStuff->get('my_wiki:message...') #5 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\MessageCache.php(606): MessageCache->load('en') #6 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\MessageCache.php(545): MessageCache->getMsgFromNamespace('Mainpage', 'en') #7 [internal function]: MessageCache->get('mainpage', true, true) #8 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\StubObject.php(58): call_user_func_array(Array, Array) #9 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\StubObject.php(76): StubObject->_call('get', Array) #10 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\GlobalFunctions.php(781): StubObject->__call('get', Array) #11 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\GlobalFunctions.php(781): StubObject->get('mainpage', true, true) #12 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\GlobalFunctions.php(744): wfMsgGetKey('mainpage', true, true, true) #13 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\GlobalFunctions.php(688): wfMsgReal('mainpage', Array, true, true) #14 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\Title.php(318): wfMsgForContent('mainpage') #15 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\includes\Wiki.php(122): Title::newMainPage() #16 C:\Program Files (x86)\PostgreSQL\EnterpriseDB-Apache\Php\apache\www\mediawiki\index.php(60): MediaWiki->checkInitialQueries(NULL, 'view') #17 {main}
How do I get this configured correctly. When I query the objectchache table in the database, I get 2 records, but none have the keyname = 'my_wiki:messages:en'
Any help would be greatly appreciated.
Thanks.
On Mon, Oct 17, 2011 at 12:40 PM, Bret Bailey BBAIL@menv.com wrote:
I've installed the mediawiki and ran through the config process, but when I go to http://localhost:8080/mediawiki/index.php, (which is where I installed everything) I get a MediaWiki internal error. I am using PostgreSQL 9.1 on Windows 7, using an apache 2.2.20 server and php v. 5.3.8. The page suggests to run the update.php in the maintenance folder, which produces errors also, but closes before I can read them.
Below is what the index.php shows: MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT value,exptime FROM objectcache WHERE keyname = 'my_wiki:messages:en' LIMIT 1 Function: SqlBagOStuff::get Error: 1 ERROR: relation "objectcache" does not exist LINE 1: ...ECT /* SqlBagOStuff::get */ value,exptime FROM objectcach...
If you're using an existing PG user make sure their search path is set correctly for the schema you installed mediawiki under, and/or if you had the installer create it, just double check it as well.
I changed my media wiki configuration. I am now trying to install it with mysql database. I have the everything installed, but when I go to the main page, I get the following error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "IndexPager::reallyDoQuery (LogPager)". Database returned error "1146: Table 'my_wiki.tag_summary' doesn't exist (localhost)".
When I query the mysql database, the tag_summary table is not there. How do I go about getting this data?
Thanks.
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of OQ Sent: Monday, October 17, 2011 2:08 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] PostgreSQL error
On Mon, Oct 17, 2011 at 12:40 PM, Bret Bailey BBAIL@menv.com wrote:
I've installed the mediawiki and ran through the config process, but when I go to http://localhost:8080/mediawiki/index.php, (which is where I installed everything) I get a MediaWiki internal error. I am using PostgreSQL 9.1 on Windows 7, using an apache 2.2.20 server and php v. 5.3.8. The page suggests to run the update.php in the maintenance folder, which produces errors also, but closes before I can read them.
Below is what the index.php shows: MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT value,exptime FROM objectcache WHERE keyname = 'my_wiki:messages:en' LIMIT 1 Function: SqlBagOStuff::get Error: 1 ERROR: relation "objectcache" does not exist LINE 1: ...ECT /* SqlBagOStuff::get */ value,exptime FROM objectcach...
If you're using an existing PG user make sure their search path is set correctly for the schema you installed mediawiki under, and/or if you had the installer create it, just double check it as well.
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Run the update script to see if you can create the table that way http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
On Mon, Oct 17, 2011 at 4:47 PM, Bret Bailey BBAIL@menv.com wrote:
I changed my media wiki configuration. I am now trying to install it with mysql database. I have the everything installed, but when I go to the main page, I get the following error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "IndexPager::reallyDoQuery (LogPager)". Database returned error "1146: Table 'my_wiki.tag_summary' doesn't exist (localhost)".
When I query the mysql database, the tag_summary table is not there. How do I go about getting this data?
Thanks.
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto: mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of OQ Sent: Monday, October 17, 2011 2:08 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] PostgreSQL error
On Mon, Oct 17, 2011 at 12:40 PM, Bret Bailey BBAIL@menv.com wrote:
I've installed the mediawiki and ran through the config process, but when
I go to http://localhost:8080/mediawiki/index.php, (which is where I installed everything) I get a MediaWiki internal error. I am using PostgreSQL 9.1 on Windows 7, using an apache 2.2.20 server and php v. 5.3.8. The page suggests to run the update.php in the maintenance folder, which produces errors also, but closes before I can read them.
Below is what the index.php shows: MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT value,exptime FROM objectcache WHERE keyname = 'my_wiki:messages:en' LIMIT 1 Function: SqlBagOStuff::get Error: 1 ERROR: relation "objectcache" does not exist LINE 1: ...ECT /* SqlBagOStuff::get */ value,exptime FROM objectcach...
If you're using an existing PG user make sure their search path is set correctly for the schema you installed mediawiki under, and/or if you had the installer create it, just double check it as well.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On Mon, 2011-10-17 at 16:47 -0400, Bret Bailey wrote:
I changed my media wiki configuration. I am now trying to install it with mysql database. I have the everything installed, but when I go to the main page, I get the following error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)from within function "IndexPager::reallyDoQuery (LogPager)". Database returned error "1146: Table 'my_wiki.tag_summary' doesn't exist (localhost)".
When I query the mysql database, the tag_summary table is not there. How do I go about getting this data?
Thanks.
-------------------snip------------------------ Did you do a complete new installation? With a new database created in MySQL; Or did you use the postgres database & export it to an .sql backup??? If you used an exported data base, did you run update.php command from /yourwikiname/maintenance/?? If not do so. If you used an exported data base, MY Experience is that you need to use PhpMyAdmin or some other interface to 'import the backup into your newly created MySQL database. If you are starting from a fresh install with a new basically empty database. then check to see if this is an Extension error message. You may have installed an extension that is not working properly. Disable it by commenting it out in LocalSettings.php then restart apache or what ever web server your using & check it again. Good Luck frosty
mediawiki-l@lists.wikimedia.org