Login error

[baylifefaith]

Don't ask me how this happened but, I have installed this on two servers. My first server worked good, www.coolfreepagees.com but I hate their banners so I went to www.trupod.co.uk and setitup there. I used safe mode, and install went well, but when I try to login I get this error --->  

Code Select Expand

2: Supplied argument is not a valid MySQL result resource
(/data/members/free/tripod/uk/b/a/y/baylifefaith/htdocs/php/html/forum/Sources/MessageIndex.php ln 39)


Thanks in advance,
Daniel

[azmodie]

i had same problem on that server i think i chhanged this line and seems to work now !!

Code Select Expand

$facesdir = "BASE_DIR.yabbse/YaBBImages/avatars";
now i just need to sort session problem !

[baylifefaith]

Thanks for the help,
But I still get this error!!! I then was told to put echo after mysql query by Jeff, I did and it gave me this error


Error: You have an error in your SQL syntax near '%3baction && b.ID_CAT=c.ID_CAT)' at line 1


with the same one above--->

2: Supplied argument is not a valid MySQL result resource
(/data/members/free/tripod/uk/b/a/y/baylifefaith/htdocs/php/html/forum/Sources/MessageIndex.php ln 39)

Can someone please help, is it my server, because I got it to work on my other one??

[japheth]

Well, I know what the source of the error is, but I can't figure out how to fix it either.

For some reason, it's appending %3b when I click login on my forum

So this is what it's displaying in the address bar after I click Login

http://membres.lycos.fr/japheth/forum/index.php?board=%3baction=login2

But if I manually change it to this

http://membres.lycos.fr/japheth/forum/index.php?board=;action=login2;

It works fine, except it says I should fill in a username because I just typed it in.

Where would I fix this %3b appendage that seems to be happening?

[Savage Messiah]

I have an account with Multimania as well (lycos.fr) and after they screwed around with their servers for a week, My board has been rendered disfunctional due to the appending of a "%3b" for every ";".

My main concern is, if lycos.fr has PHP and MySQL support, then how is ANYONE'S database/php setup supposed to run when their servers are interpreting semicolons as "%3b"

[baylifefaith]

Thanks guys, I will give this a try. I don't know if ya may want this but, this site here ->
http://www.coolfreepages.com

its a great server, only problem, is that it uses a gay banner  

But hopefully a good server will soon come out

[japheth]

Ah, finally fixed it.

You have to go into your Settings.php file and change the following:

Code Select Expand

$boardurl = "http://membres.lycos.fr/yourusername/forum";
$boarddir = "../forum";
$sourcedir = "../forum/Sources";
$facesdir = "../forum/YaBBImages/avatars";
$facesurl = "http://membres.lycos.fr/yourusername/forum/YaBBImages/avatars";
$imagesdir = "http://membres.lycos.fr/yourusername/forum/YaBBImages";
$ubbcjspath = "http://membres.lycos.fr/yourusername/forum/ubbc.js";
$faderpath = "http://membres.lycos.fr/yourusername/forum/fader.js";
$helpfile = "http://membres.lycos.fr/yourusername/forum/YaBBHelp/index.html";

Where yourusername=the user name you signed up with

and forum=the name of the directory where you installed YaBBSE.

[Savage Messiah]

Thanks Japh, I'll try that and see if it works. Maybe that was the cause of the %3b's being put in for semicolons, because the links weren't being treated as valid MySQL arguments due to the fact that the board directory values had to be updated.....

[baylifefaith]

Didn't work for me

$boardurl = "http://membres.lycos.fr/yourusername/forum";
$boarddir = "../forum";
$sourcedir = "../forum/Sources";
$facesdir = "../forum/YaBBImages/avatars";
$facesurl = "http://membres.lycos.fr/yourusername/forum/YaBBImages/avatars";
$imagesdir = "http://membres.lycos.fr/yourusername/forum/YaBBImages";
$ubbcjspath = "http://membres.lycos.fr/yourusername/forum/ubbc.js";
$faderpath = "http://membres.lycos.fr/yourusername/forum/fader.js";
$helpfile = "http://membres.lycos.fr/yourusername/forum/YaBBHelp/index.html";

[baylifefaith]

This is what I added and I still got the same error-->

Code Select Expand

$boardurl = "http://members.tripod.co.uk/faithforum/forum";
$boarddir = "../forum";
$sourcedir = "../forum/Sources";
$facesdir = "../forum/YaBBImages/avatars";
$facesurl = "http://members.tripod.co.uk/faithforum/forum/YaBBImages/avatars";
$imagesdir = "http://members.tripod.co.uk/faithforum/forum/YaBBImages";
$ubbcjspath = "http://members.tripod.co.uk/faithforum/forum/ubbc.js";
$faderpath = "http://members.tripod.co.uk/faithforum/forum/fader.js";
$helpfile = "http://members.tripod.co.uk/faithforum/forum/YaBBHelp/index.html";

I did what you did, was there any ting esle you did or changed to get this to work
Thanks



this is the same error it gives me everytime I click, login, register, or try to login---->>

Code Select Expand

Error: You have an error in your SQL syntax near '%3baction && b.ID_CAT=c.ID_CAT)' at line 1



2: Supplied argument is not a valid MySQL result resource
(/data/members/free/tripod/uk/b/a/y/baylifefaith/htdocs/php/html/forum/Sources/MessageIndex.php ln 39)


Thanks

[japheth]

Oh, it could be the fact that you are on Tripod.  This probably will only work for people who are on Multimania/Lycos.

Try this instead.

Code Select Expand

$boardurl = "http://membres.lycos.fr/yourusername/forum";
$boarddir = ".";
$sourcedir = "./Sources";
$facesdir = "./YaBBImages/avatars";
$facesurl = "http://membres.lycos.fr/yourusername/forum/YaBBImages/avatars";
$imagesdir = "http://membres.lycos.fr/yourusername/forum/YaBBImages";
$ubbcjspath = "http://membres.lycos.fr/yourusername/forum/ubbc.js";
$faderpath = "http://membres.lycos.fr/yourusername/forum/fader.js";
$helpfile = "http://membres.lycos.fr/yourusername/forum/YaBBHelp/index.html";

The reason you need two dots with multimania, is because you have to go up to the root directory of your account for some reason.  Putting what I've shown you here for tripod may work.

[Xplorador]

in lycos.fr

########## Database Info ##########
$db_name = "Username_db";
$db_user = "username_fr";
$db_passwd = "you passs";
$db_server = "localhost";

[baylifefaith]

Thanks for the help,
But I already tried those ways, and I still get the error. I stuck it on my other host and it worked great though. But thanks for the help. If any one does have tripod and figures a way to fix this, please let me know.
Thanks,
~Daniel~

[AndrewH]

Oops, just realised that I had to register again...

Daniel, have you resolved that problem you had yet?
'Cause I have a board running on Tripod UK, and I'm not getting that error. Let me know, I'll try to help.

By the way, I do have a couple other small issues trying to run YaBB SE on Tripod UK...

[baylifefaith]

Im still getting this error, I installed it on my other crappy free server but it has pop up banners. it worked on that server too. but it wont work on the tripod uk, I have the same error. Any Help??
Thanks
Daniel