PokerOffice Users Forum  

Go Back   PokerOffice Users Forum > PokerOffice > FAQ
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Closed Thread

 

LinkBack Thread Tools Search this Thread Display Modes
Old 2005-03-23, 09:13   #1 (permalink)
PokerOffice Support
Support Team
 
PokerOffice Support's Avatar
 
Join Date: May 2007
Location: St Julian's, Malta
Posts: 5,145
Default I get the "Database Conversion Failed!" message when trying to change to MySQL

This can happen for two different reasons. You can tell which by looking at the preceding error message.

1. If the message said: "Invalid authorization specification, message from server: "Access denied for user 'root'@'localhost' (using password: NO)"
You have configured the database to use a specific password, this is against the very important step 4 in the instructions. You should however be able to fix this manually by following the steps below:
A. Open up a command prompt.
B. Change directory to MySQLs bin-folder.
If you installed MySQL in "C:\Program Files\MySQL" enter "cd C:\Program Files\MySQL\MySQL Server 4.1\bin" and press enter.
C. Type the command "mysql --user=root --password"
D. You will be prompted for your password, type the password you used when you configured MySQL, then press enter. (If you don't remember your password you have to uninstall and then reinstall MySQL)
E. Type the command "SET PASSWORD = PASSWORD('');" and hit enter.
F. Restart PokerOffice and try the conversion again.

2. If the message said: "Database conversion failed! Database does already exist on MySQL server."
You already have a database called "pokeroffice" on your MySQL server. This can happen if you have reinstalled PokerOffice but not MySQL. You can fix this by manually editing the settings file: "../pokeroffice/settings/mysql.conf". Open up the file in a text editor and do the following:
A. Delete all text that might already be in the file.
B. Enter the text: "true" then hit enter, creating a new line.
C. On the second line enter the correct path to where MySQL is installed, E.g. "C:\Program Files\MySQL\MySQL Server 4.1"
D. Save the file and restart PokerOffice.
PokerOffice Support is offline  
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +2. The time now is 07:21.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.0.0