I'm moving a wiki from one of my systems to 1and1.com. A number of people have successfully installed Mediawiki there, so it's possible.
1) I uploaded and untarred Mediawiki 1.9.3.
2) I created .htaccess in the top-level wiki directory containing the line: AddType x-mapp-php5 .php (added because 1and1 uses PHP4 by default)
4) Clicking on http://mydomain.com/mywiki/config
* PHP 5.2.1 installed * Found database drivers for: MySQL * PHP server API is cgi; using ugly URLs (index.php?title=Page_Title) * Have XML / Latin1-UTF-8 conversion support. * PHP's memory_limit is 40M. If this is too low, installation may fail! * Have zlib support; enabling output compression. * Couldn't find Turck MMCache, eAccelerator or APC. Object caching functions cannot be used. * GNU diff3 not found. * Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. * Installation directory: /homepages/123/d123456/htdocs/fbwiki * Script URI path: /fbwiki * Environment checked. You can install MediaWiki.
Filling in the fields and clicking on 'Install Mediawiki!' results in:
Generating configuration file... # Database type: MySQL # Loading class: DatabaseMysql # Attempting to connect to database server as dbo123456...success. # Connected to 4.0.27-standard-log # Database db123456 exists # There are already MediaWiki tables in this database. Checking if updates are needed...
[...]
Deleting old default messages...A database query syntax error has occurred. The last attempted database query was: "(SQL query hidden)" from within function "RecentChange::save". MySQL returned error "1048: Column 'rc_id' cannot be null (db123.perfora.net)"
The MySQL database was exported from a machine running MySQL 5.0.18 using the command:
mysqldump -u root -pxxxx --compatible=mysql40 wikidb > dumpfile.sql
The '--compatible=mysql40' argument is necessary because 1and1 uses MySQL 4.x
Any hints on fixing this error would be appreciated. 1and1 has phpMyAdmin installed, and I can also interact with the database via MySQL commands from the shell command line.
Thanks,
-rex
You can choose to use MySQL 5 as well, when creating a new db. When I was on 1&1 (albeit UK; same I guess) I just created a new wiki so I don't know about im/exporting. When I moved to hostgator.com after six awful months with 1&1, hostgator transferred and imported everything for me, free. Not that that helps with your situation...
On 24/04/07, rex rex@nosyntax.com wrote:
I'm moving a wiki from one of my systems to 1and1.com. A number of people have successfully installed Mediawiki there, so it's possible.
I uploaded and untarred Mediawiki 1.9.3.
I created .htaccess in the top-level wiki directory containing the line: AddType x-mapp-php5 .php (added because 1and1 uses PHP4 by default)
Clicking on http://mydomain.com/mywiki/config
- PHP 5.2.1 installed
- Found database drivers for: MySQL
- PHP server API is cgi; using ugly URLs (index.php?title=Page_Title)
- Have XML / Latin1-UTF-8 conversion support.
- PHP's memory_limit is 40M. If this is too low, installation may fail!
- Have zlib support; enabling output compression.
- Couldn't find Turck MMCache, eAccelerator or APC. Object caching
functions cannot be used. * GNU diff3 not found. * Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. * Installation directory: /homepages/123/d123456/htdocs/fbwiki * Script URI path: /fbwiki * Environment checked. You can install MediaWiki.
Filling in the fields and clicking on 'Install Mediawiki!' results in:
Generating configuration file... # Database type: MySQL # Loading class: DatabaseMysql # Attempting to connect to database server as dbo123456...success. # Connected to 4.0.27-standard-log # Database db123456 exists # There are already MediaWiki tables in this database. Checking if updates are needed...
[...]
Deleting old default messages...A database query syntax error has occurred. The last attempted database query was: "(SQL query hidden)" from within function "RecentChange::save". MySQL returned error "1048: Column 'rc_id' cannot be null (db123.perfora.net)"
The MySQL database was exported from a machine running MySQL 5.0.18 using the command:
mysqldump -u root -pxxxx --compatible=mysql40 wikidb > dumpfile.sql
The '--compatible=mysql40' argument is necessary because 1and1 uses MySQL 4.x
Any hints on fixing this error would be appreciated. 1and1 has phpMyAdmin installed, and I can also interact with the database via MySQL commands from the shell command line.
Thanks,
-rex
"We are too soon old, and too late smart."
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
rex rex@nosyntax.com [2007-04-24 10:34]:
The MySQL database was exported from a machine running MySQL 5.0.18 using the command:
mysqldump -u root -pxxxx --compatible=mysql40 wikidb > dumpfile.sql
The '--compatible=mysql40' argument is necessary because 1and1 uses MySQL 4.x
Any hints on fixing this error would be appreciated. 1and1 has phpMyAdmin installed, and I can also interact with the database via MySQL commands from the shell command line.
The solution was to upgrade the local instance of Mediawiki to 1.9.3 following the instructions at:
http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.9
and then use mysqldump to export the database again. After FTPing it to the host, importing it to a new database, and running the Mediawiki install again, it works -- except images. Using Krusader to mirror the local images directory tree to the new host wiki images directory fixed that problem.
-rex
mediawiki-l@lists.wikimedia.org