I have seen many threads about mysql issues. My issue is the same as a lot of the others, i have mysql 4.0.x and needless to say, i get:
settings.php: line[132]
Could not connect to database "roster"
MySQL said:
1044: Access denied for user: 'wowchar@%' to database 'roster'
i sent a help request to godaddy and got-
"Unfortunately, we are currently running MySQL - 4.0.27 on our shared hosting accounts. At this time we do not have a estimated time on when we will be upgrading the MySQL version. If you would like to upgrade it yourself, you will need a Virtual Dedicated or Dedicated server."
Which means- "spend a lot more money and you can do whatever you want"
I am pretty sure i already know the answer to this... but for the sake of other people who are locked into godaddys hosting for whatever reason, i'll ask it anyway...
is there any work around? is there any possibility or hope to making wowroster work using gogdaddy?

*edit*
forgot to mention that you guys rock! You are a real asset to the WoW community:)

There are a few places in Roster that use mysql 4.1 commands
I don't know where they are or if changing them would break anything because I do not develop on mysql 4.0 (I use 5.x)

What are you paying for that grade of hosting?

I just installed roster on my account at http://page-zone.com and it went pretty smooth. A basic account is $5/month. (Not sure if that will do what you want. I upgraded to the reseller account to get more domains and more storage.)

You can see my roster here:

http://sewingwitch.com/imajia/roster/

I need to upgrade roster from 1.7.2 to 1.7.3.

From the roster diag I can see that I'm running:

Apache/1.3.37 (Unix)
mod_auth_passthrough/1.8
mod_log_bytes/1.2
mod_bwlimited/1.4
FrontPage/5.0.2.2635.SR1.2
mod_ssl/2.8.28
OpenSSL/0.9.7a
PHP-CGI/0.1b
MySQL 4.1.21-standard
PHP 5.0.5
GD 2.0.28 compatible (bundled)

I had to tweak the upload_max_filesize setting to 8M using a .htaccess file.

The weird thing is that i'm on GoDaddy as well and WoWRoster has always been working fine. And yes, I'm on 1.7.3...

What versions does your diagnostic report? Perhaps you're on a different physical host that has a different version loaded.

Thanks for the repsponse:)

PHP Version: Using: 4.3.11 Required: 4.3.0+
MySQL Module: Available: Yes Required: Yes
GD Module: Available: Yes Required: Optional

server version - 4.0.27-max-log
client version - 3.23.49

Is this my problem? Any suggestions on how to fix it?

People tout that SQL is a standard, but I remain skeptical when it's so easy to get incompatible with different servers. (And SQL is only the language. It doesn't say anything about how the statements get in and out of the server, another big opportunity for vendors to break compatibility.)

Is there any move to create a well-supported subset of SQL that every server supports, so that any usage outside that subset can be easily identified and documented?

Ok, rant over. Back to your regularly scheduled programming.

I'm with GoDaddy as well. Diagnostic says:

OS Linux
Server Software Apache
MySQL Version 4.0.27-max-log
PHP Version 4.3.11
PHP API Type cgi-fcgi
safe_mode Off
open_basedir Off
allow_url_fopen On
file_uploads On
upload_max_filesize 20M

I have no problems at all with WowRoster 1.7.3.

Access denied for user: 'wowchar@%' to database 'roster'

Sounds like a permission issue... Or maybe the characters at the end are invalid.

Also, check your mysql host in the install. I left it on localhost the first time and got a similar error. Godaddy uses a remote server for sql, wil show the info on the mysql manager window for the database you are using.

i checked the db login credentials and even created a new db just to triple check it. when i ran the diagnostics,i could not get the roasterdiag_sql to run at all.
rorsterdiag_sql-
Fatal error: Call to a member function on a non-object in /home/content/y/a/m/*username*/html/forum/roster/rosterdiag_sql.php on line 56
rosterdiag-
settings.php: line[132]
Could not connect to database "wowRoster"
MySQL said:
1044: Access denied for user: 'Roster@%' to database 'wowRoster'

I started from scratch again paying attention to permissions, but didn't see anything that didn't look right. im a little lost and possibly over my head here:(

rosterdiag_sql.php is not used in Roster anymore

yamahammer wrote:i checked the db login credentials and even created a new db just to triple check it. when i ran the diagnostics,i could not get the roasterdiag_sql to run at all.
rorsterdiag_sql-
Fatal error: Call to a member function on a non-object in /home/content/y/a/m/*username*/html/forum/roster/rosterdiag_sql.php on line 56
rosterdiag-
settings.php: line[132]
Could not connect to database "wowRoster"
MySQL said:
1044: Access denied for user: 'Roster@%' to database 'wowRoster'

I started from scratch again paying attention to permissions, but didn't see anything that didn't look right. im a little lost and possibly over my head here:(

I'm assuming that the username is actually Roster@% as printed above. Try this. Instead of making a username with funky characters at the end to distinguish it from the dozen other roster type usernames, put the distinguishing marks at the beginning. For example, if your login for webhosting was jkibbles (don't bother trying it, people, that ain't the login for my db ) make the username jkibbles_roster. Try running it that way, and see if it works. If not, contact me thru the board and I'll try giving you a hand. What I do know is that we are running the exact same version of mysql, and wowroster is giving me no problems on my server.

The @% is not part of the username. What is actually given is user@host. % is a wildcard meaning 'any character, any number of times', like * in DOS/Windows.

I'm on GoDaddy shared hosting and after a nice talk with the techs, (you catch more flies with sugar), I have access to 4.0, 4.1 and 5.0 MySQL db's.

If you are with GoDaddy and need to create a 4.1 or 5.0 db (you can mix and match them).
1. Logon to Hosting Manger
2. Goto MySQL Admin
3. Click on the Create Database Button
Here comes the trick
4. Modify that URL by adding the following ?mysql4150=TRUE
your url should look something like this
https://somehost.someserverfarm.net/MyS ... l4150=TRUE
5. You will now have a create database screen with the option for 4.1 or 5.0

Enjoy!!!

Oh that's some sweet trick. Thanks for sharing!