Problem with lib/menu.php after install

Theme, template, layout, or image issues

Problem with lib/menu.php after install

Postby Greenoaf » Sun Sep 10, 2006 3:17 pm

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
Last edited by Greenoaf on Sun Sep 10, 2006 3:32 pm, edited 2 times in total.
User avatar
Greenoaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Wed Sep 06, 2006 10:07 pm

Problem with lib/menu.php after install

Postby zanix » Sun Sep 10, 2006 3:24 pm

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
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Problem with lib/menu.php after install

Postby Greenoaf » Sun Sep 10, 2006 3:33 pm

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

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

Green
Last edited by Greenoaf on Sun Sep 10, 2006 3:35 pm, edited 1 time in total.
User avatar
Greenoaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Wed Sep 06, 2006 10:07 pm

Problem with lib/menu.php after install

Postby AnthonyB » Sun Sep 10, 2006 4:02 pm

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.
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Problem with lib/menu.php after install

Postby AnthonyB » Sun Sep 10, 2006 4:06 pm

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!
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: Problem with lib/menu.php after install

Postby Greenoaf » Sun Sep 10, 2006 4:26 pm

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
User avatar
Greenoaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Wed Sep 06, 2006 10:07 pm

Problem with lib/menu.php after install

Postby zanix » Sun Sep 10, 2006 4:32 pm

Maybe your unzipper on your server is converting case
Fix this or try unzipping, then uploading
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Problem with lib/menu.php after install

Postby Greenoaf » Sun Sep 10, 2006 4:37 pm

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
User avatar
Greenoaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Wed Sep 06, 2006 10:07 pm

Problem with lib/menu.php after install

Postby zanix » Sun Sep 10, 2006 4:53 pm

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

Those are correct case
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Problem with lib/menu.php after install

Postby Greenoaf » Sun Sep 10, 2006 5:06 pm

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.....
User avatar
Greenoaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Wed Sep 06, 2006 10:07 pm

Re: Problem with lib/menu.php after install

Postby Greenoaf » Sun Sep 10, 2006 5:08 pm

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
Last edited by Greenoaf on Sun Sep 10, 2006 5:11 pm, edited 1 time in total.
User avatar
Greenoaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Wed Sep 06, 2006 10:07 pm

Re: Problem with lib/menu.php after install

Postby Greenoaf » Sun Sep 10, 2006 11:43 pm

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

Thanks again!!
Green
User avatar
Greenoaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Wed Sep 06, 2006 10:07 pm


Return to Appearance

Who is online

Users browsing this forum: No registered users and 0 guests

cron