Ok this is my first post here. I've read through forums and I've tried some self-learning and I just can't figure this out.

I had wowroster running perfectly on my old box, so I know how to use it. Then something bad happened to the box and I have a new one.

fine.

I tried installing it on the new server and at first and I got a message saying that MySQL server and client were too old. They were version 4.0.15. I tried installing wowroster anyways and I ran into a few issues and the main issue was the "It took 0 seconds to parse" when I tried to upload the lua file. I tried all sorts of work-arounds that I found here on the forums relating to "Taking 0 seconds to parse" before I gave up and said OK time to upgrade MySQL. So I opened up a ticket and asked the server administrators to go ahead and upgrade that... they sent me a message back saying they did.

I go to install now and it says:

"MySQL client and server versions 4.1.0 or higher and MyISAM table support are required for Roster.

You are running

* server version - 5.0.19-standard
* client version - 4.0.15"

Although they DID upgrade the server version, the client is still on 4.0.15. I tried to install and again when I went to "Upload" a I got the Took 0 seconds to parse error.

My question is this... is 4.0.15 confirmed to not work? I Know it says you need 4.1.x or better. Is 4.0.15 the reason why I would get the ridiculous Parse in 0 seconds error?

In any case, I sent an email back to the webhost saying "You have upgraded the server but not the mysql client" and they sent something along the lines of "What do you mean?"

I am not extremely linux\FreeBSD savvy... Is there anybody here that knows what I can email them so that they would correctly upgrade the client as well? Maybe my verbage was not accurate or correct enough.

Please let me know if you have any questions!

ALSO - How important is the GD Module in all this? Is it easy to install? Is that something I can ask the server administrator to do?

Here is the output from the GD status screen:

"PHP Info
View phpinfo()
PHP Version: Using: 4.3.10 Required: 4.3.0+
MySQL Module: Available: Yes Required: Yes
GD Module: Available: No - More Info Required: Optional"

Thank you in advance!!!!!

The two problems are unrelated. MySQL under 4.1 will cause trouble with some queries in roster. The 0 second problem is usually caused by safe mode.

Safe mode >.<?

that sounds.... simple... how do you ensure that safe mode is not causing this 0 second issue to occur?

I went ahead with another install attempt using this:

* server version - 5.0.19-standard
* client version - 4.0.15

And here is the Diag screen:





Also, something that is worrisome:

At the bottom of the Diag screen is a critical error on /roster/lib/ for wowdb.php:

"wowdb.php 603 < 609 2007/02/01 07:37 > 2007/02/01 02:20 zanix != zeryl MD5 String does NOT match"

When I click on the Get Update Package button, regardless of whether I get the tarball or the zip file, the file that I download is corrupt, and complains about some end-of-file appearing too early.. point is, while it does let me successfully download the file, I can't open it.

Here is that screen:



Any ideas on this?

Again sorry for bothering you all but I have tried and tried and am sick of failing and I just need some external help. Desperate!!

Thanks in advance!!!

That same file is available here
http://www.wowroster.net/Downloads/c=7.html

GD is installed by the server admin

And as for the parsed in 0.0 seconds error, try this
http://www.wowroster.net/Forums/viewtopic/t=2860.html

Zanix thanks for your response.

I appreciate you sending me the link to that file! That cleared that roster/lib/ critical error!

Regarding the 0 second parse, I have actually visited that link you sent before and did try it, but it didn't work.

I tried it again just now and there is POSSIBLY some progress...

"Parsing files

* Error while parsing CharacterProfiler after 0.02 seconds"

So it lasts for 2 hundredths of a second now.

What do you suggest?
Thanks again!

I just tried to upload again and I'm getting:

"Parsing files

* Error while parsing CharacterProfiler after 0 seconds" again.


Here is what the changed section of my update.php looks like. I chose the name of 'new' as the directory name:

Code: Select all

            if( $roster_conf['authenticated_user'] )
            {
               // Get start of parse time
               $parse_starttime = explode(' ', microtime() );
               $parse_starttime = $parse_starttime[1] + $parse_starttime[0];

               // Parse the lua file into a php array that we can use
               $new_lua_file = ROSTER_BASE.'new'.DIR_SEP.$file['name'];
               move_uploaded_file($file['tmp_name'],$new_lua_file);

               // Parse the lua file into a php array that we can use
               $data = ParseLuaFile( $new_lua_file,$file_type );
               
               @unlink($new_lua_file);

               // Calculate parse time

Looks ok to me...