I received this error when upgrading from 1.3.11 to 1.4.5:
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 "Parser::replaceLinkHolders". MySQL returned error "1072: Key column 'name_title_timestamp' doesn't exist in table (localhost)".
At first the upgrade would not even complete until I did this manually:
alter table image add primary key (img_name);
- Ken
Ken Garland wrote:
I received this error when upgrading from 1.3.11 to 1.4.5:
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 "Parser::replaceLinkHolders". MySQL returned error "1072: Key column 'name_title_timestamp' doesn't exist in table (localhost)".
Can you please outline your exact upgrade procedure?
In particular, did you run the command-line update.php or web-based config/index.php installer to apply database schema updates? Did you save the output from this step?
At first the upgrade would not even complete until I did this manually:
alter table image add primary key (img_name);
-- brion vibber (brion @ pobox.com)
I ran the web installer. It stopped saying there was a problem trying to alter the public key, so i did this command into mysql manually:
alter table image add primary key (img_name);
Then went back to web installer and it worked. Copied LocalSettings.php to root and got the website with the error I pasted.
I did not save the output from the configuration installer.
Brion Vibber wrote:
Ken Garland wrote:
I received this error when upgrading from 1.3.11 to 1.4.5:
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 "Parser::replaceLinkHolders". MySQL returned error "1072: Key column 'name_title_timestamp' doesn't exist in table (localhost)".
Can you please outline your exact upgrade procedure?
In particular, did you run the command-line update.php or web-based config/index.php installer to apply database schema updates? Did you save the output from this step?
At first the upgrade would not even complete until I did this manually:
alter table image add primary key (img_name);
-- brion vibber (brion @ pobox.com)
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
MediaWiki 1.3.11 installation
Wiki is configured.
Already configured... return to the wiki http://sysadmin/mediawiki/index.php
I click on 'return to the wiki' and just get this:
Not Found
The requested URL /mediawiki/index.php/Main_Page was not found on this server.
index.php does exist where it is supposed to:
/var/www/html/mediawiki/index.php
Ken Garland wrote:
Not Found
The requested URL /mediawiki/index.php/Main_Page was not found on this server.
Your web server configuration or PHP configuration is broken such that PATH_INFO urls don't work.
Change $wgArticlePath to 'ugly url' style in LocalSettings.php.
-- brion vibber (brion @ pobox.com)
now my LocalSettings.php looks like this:
## If using PHP as a CGI module, use the ugly URLs #$wgArticlePath = "$wgScript/$1"; $wgArticlePath = "$wgScript?title=$1";
I still get the same Not Found message while using either option.
Brion Vibber wrote:
Ken Garland wrote:
Not Found
The requested URL /mediawiki/index.php/Main_Page was not found on this server.
Your web server configuration or PHP configuration is broken such that PATH_INFO urls don't work.
Change $wgArticlePath to 'ugly url' style in LocalSettings.php.
-- brion vibber (brion @ pobox.com)
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Ken Garland wrote:
now my LocalSettings.php looks like this:
## If using PHP as a CGI module, use the ugly URLs #$wgArticlePath = "$wgScript/$1"; $wgArticlePath = "$wgScript?title=$1";
I still get the same Not Found message while using either option.
What, exactly, do you get it on?
Please provide exact URLs and extracts from your web server's error log.
-- brion vibber (brion @ pobox.com)
mediawiki-l@lists.wikimedia.org