Ravens Who Is Where Block error

Posted: Mon Jun 28, 2004 6:09 pm

Raven:

I downloaded and installed your program Ravens Who Is Where Block .
I edited the 2 files index.pho and modules.php but when i tried getting into my site i received the following error:

MySQL said: You have an error in your SQL syntax near 'memory' at line 1

Any ideas?

Joe

www.porcupinepc.com/nuke

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

PM'ing me and posting too? Evil or Very Mad

Posted: Mon Jun 28, 2004 7:28 pm

sorry

Joe

Posted: Mon Jun 28, 2004 7:41 pm

New Member Joined: Jun 29, 2004 Posts: 5

When I enable the Who-is-Where block I cant enter in Your Accout module..

phpnuke 7.0 with nsnya stuff.

New Member Joined: Jun 28, 2004 Posts: 6

I'm Lost again Sad

I'm running 7.3 and I installed the Who Is Where by the readme, and my table was created successfully without having to do it manually through phpmyadmin, but when I click on the module I get a white page with only this:
////////////////////////////////
Guest(s) Online
3 guest(s)

3 User(s) Online
Ledahas
Downloads
zyfer
News
Lost
Who Is Where

( sec. refresh)

Fatal error: Call to a member function on a non-object in /home/bbvhurk/public_html/dragonswhisper/mainfile.php on line 614
//////////////////////////////////

Also, the block is missing. It's uploaded there, but in the block administration, it doesn't show for me to activate it. Any help would be appreciated, I'm still a php noob Shocked

but I'm doing my best.
RavensScripts

Posted: Sat Sep 04, 2004 5:48 pm

It sounds like you have not installed it correctly. Reread the installation instructions and make sure that you have done exactly as instructed. There are 2 places that you have to add the include statement to. Then, make sure that all files got ftp'd. The module should not be activated at all, only the block.

Posted: Sun Sep 05, 2004 1:23 pm

I did it exactly as the readme states, and then twice more just to be sure Crying or Very sad

I still have my inactive module, all the files in their proper place, the 2 files edited with Zend studio and uploaded one at a time as stated. But no block to be found on the site, although i see that the folder and file are right there when i log in with my ftp client. The installation is quite easy, so I'm not sure what the hangup is... Are there any other mods it's not compatable with? Or themes? Thanks in advance for any help you can offer Very Happy

Posted: Sun Sep 05, 2004 1:27 pm

Are you saying the block is not in the list of drop-down blocks that you have to manually add? By the way, what is line 614 in your mainfile.php?

Posted: Sun Sep 05, 2004 1:53 pm

Yes, the block is not listed. Sad

Here is a 614 and the code surrounding it from mainfile.php

608 function cookiedecode($user) {
609 global $cookie, $prefix, $db, $user_prefix;
610 $user = base64_decode($user);
611 $cookie = explode(":", $user);
612 $sql = "SELECT user_password FROM ".$user_prefix."_users WHERE
613 username='$cookie[1]'";
614 $result = $db->sql_query($sql);
615 $row = $db->sql_fetchrow($result);
616 $pass = $row[user_password];
617 if ($cookie[2] == $pass && $pass != "") {
618 return $cookie;
619 } else {
620 unset($user);
621 unset($cookie);
622 }

Client Joined: Apr 10, 2004 Posts: 649 Location: UK

Shouldn't this be between line 610 and line 611?

Quote:

$user = addslashes($user);
$user = htmlentities($user, ENT_QUOTES);

Please don't put that in your mainfile until someone's checked it, because my mainfile may be different to yours. And I'm no expert.

Posted: Sun Sep 05, 2004 2:56 pm

No Idea, I never messed with my mainfile, unless a mod directed me to do so... and I haven't touched this area for sure.

Posted: Wed Sep 08, 2004 7:27 pm

Anyone else have this problem before? or any ideas?

Posted: Wed Sep 08, 2004 7:32 pm

Please turn $SQL_DEBUG on in includes/sql_layer.php

$sql_debug = 0;
to
$sql_debug = 1;

and try it. You will see all kind of messages on your screen but what you are looking for is an sql warning or error. Look for the messages around that line 614 error and post them back.

Posted: Thu Sep 09, 2004 4:26 pm

Hmmm I did that yet I don't see any messages on the site. Please excuse my noobishness but where should I be looking for these warnings/errors?