My Install

After install, I could not get my menu to display correctly, I am getting errors like crazy from the lib/menu.php file:

Code: Select all


Notice: Undefined index: enus in /homepages/25/d115395929/htdocs/LM-WOW/Roster/lib/menu.php on line 98

Notice: Undefined index: enus in /homepages/25/d115395929/htdocs/LM-WOW/Roster/lib/menu.php on line 102

Notice: Undefined index: enus in /homepages/25/d115395929/htdocs/LM-WOW/Roster/lib/menu.php on line 103

Notice: Undefined index: enus in /homepages/25/d115395929/htdocs/LM-WOW/Roster/lib/menu.php on line 104

Notice: Undefined index: enus in /homepages/25/d115395929/htdocs/LM-WOW/Roster/lib/menu.php on line 105


From looking at the file, I found that the *prefix* that you define during install isn't applied in this file:

Code: Select all


$result_menu = $wowdb->query("SELECT * FROM `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = $guildId AND ".$roster_conf['alt_location']." NOT LIKE '%".$roster_conf['alt_type']."%'") or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__);
    $num_non_alts = $wowdb->num_rows($result_menu);

    $result_menu = $wowdb->query("SELECT * FROM `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = $guildId AND ".$roster_conf['alt_location']." LIKE '%".$roster_conf['alt_type']."%'") or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__);
    $num_alts = $wowdb->num_rows($result_menu);

    $result_menu = $wowdb->query("SELECT * from `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = $guildId AND `level` = 60") or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__);
    $num_lvl_60 = $wowdb->num_rows($result_menu);

    $result_menu = $wowdb->query("SELECT * from `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = $guildId AND `level` > 49 and `level` < 60") or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__);
    $num_lvl_50_59 = $wowdb->num_rows($result_menu);

    $result_menu = $wowdb->query("SELECT * from `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = $guildId AND `level` > 39 and `level` < 50") or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__);
    $num_lvl_40_49 = $wowdb->num_rows($result_menu);

    $result_menu = $wowdb->query("SELECT * from `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = $guildId AND `level` > 29 and `level` < 40") or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__);
    $num_lvl_30_39 = $wowdb->num_rows($result_menu);

    $result_menu = $wowdb->query("SELECT * from `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = $guildId AND `level` > 0 and `level` < 30") or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__);
    $num_lvl_1_29 = $wowdb->num_rows($result_menu);

    $result_avg = $wowdb->fetch_array($wowdb->query("SELECT AVG(level) FROM `".ROSTER_MEMBERSTABLE."` WHERE guild_id=$guildId")) or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__);
 

.ROSTER_MEMBERSTABLE is called with a query, but what if my table is LM_MEMBERSTABLE because I used my own prefix?

It causes the whole menu to be off, shouldn't that be the variable that is set to the *prefix* during the install?

Maybe this doesn't make any sense to anyone but me....

Green

ROSTER_MEMBERSTABLE is a defined constant in php
It is set with the current $dbprefix."members"

And I bet you are getting those notices in rosterdiag correct?
They will go away when you upload data to your roster

Yes, I'm getting the errors in the Diag.

My guild data has been uploaded.....
Here
Still broke....

Green

You sure you've got ALL files uploaded to your webserver? I've never seen anything like you current situation, eg. all menu buttons have no text in them except Siggen, text strings missing in other places..

it's almost like you're missing the localization files or something.

Whoa... looks like you've changed the case of the localization file - enus.php != enUS.php

Fix that and I think you might see a big improvement!

This is probably the case, I'm running a Unix server, so it is CaSe SeNsAtIvE.

After looking at the Diag, it tells me I'm missing the localization files... I uploaded the package and unzipped it, didn't change anything..... weird...

I'll check on this once I get home, thanks for your help.

Green

Maybe your unzipper on your server is converting case
Fix this or try unzipping, then uploading

Nope, I just downloaded the current package to my desktop and unzipped it, they are caps.....

deDE
enUS

Maybe someone should fix this and replace the download, the files are capitalized in the package.

Green

They are supposed to be like that
enUS.php
deDE.php

Those are correct case

Well, the Diag is looking for:

enus is missing
dede is missing

So maybe something went wack in DB entries....

Not sure.....

The thing is I installed the package three times to make sure I was doing it correctly and it acted this way all three times....

I uploaded the ZIP files and then unzipped them on the server, so I'm not missing any files.....

Found it!!

Appearently my ZIP process on the Unix server lower cases all files as a default setting, it also messed up the two image files that have upper case in them.

I will change the file names once I get home and I'm sure it will pop right back as it should be.

I'm curious though... I have never had this issue prior to now.... must have just got lucky that they were all lower case prior to unzipping...

So the Diag tells me I'm missing the uppercase files and then it tells me I have another error for addition files that are all lower case.... lol

zanix you were absolutely right!!

Thanks again for the help!!
Green

Got home, renamed them and I'm good to go!

Thanks again!!
Green