MyBB Source

laeresh · 04-27-2010 11:32 PM

For some reason it does not insert the message into the DB.

I get this error on the page where it says "Comment added" and because it refreshes quickly it's hard for me to take a screen.

Here is the error though.

Code:

The following warnings occurred:

Warning [2] mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'www-data'@'localhost' (using password: NO) - Line: 27 - File: gb.php PHP 5.3.2 (Linux)

File     Line     Function

[PHP]           errorHandler->error

/gb.php     27     mysql_real_escape_string

Warning [2] mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established - Line: 27 - File: gb.php PHP 5.3.2 (Linux)

File     Line     Function

[PHP]           errorHandler->error

/gb.php     27     mysql_real_escape_string

The weird thing is, is that it indicates for an error when connecting to the sql with the wrong username and pass, but i don't see the problem here because it uses the config connection right ?

Hope anyone can help me out, best regards, Robin.

***Nickman*** · 04-29-2010 12:35 AM

You probably don't use MySQL as your database type right?

laeresh · 04-29-2010 01:43 AM

I use MySQLi since i heard it's faster.
( Haven't had any problems before, database seems the same, only performance issues vary ).
I did read somewhere MySQLi had some different functions, but i never thought it could pose a problem.
Perhaps a little naggy but if you are going to fix this, could you please give a little comment about what you did, then i could solve this and similar issues in the future by myself, and i'd also learn from it that way ^^.

Disturbed · 04-30-2010 12:49 AM

You need to use the mybb escape syntax, not mysql one..

laeresh · 04-30-2010 02:03 AM

Can you provide it please ?
For i do not know what the mybb escape syntax is.

coder · 04-30-2010 11:34 PM

Im just about to install this , is there problems with it ?

laeresh · 05-01-2010 01:17 AM

If you use anything other than MySQL, yes.

laeresh · 05-02-2010 07:17 PM

Anyone ?

Disturbed · Yesterday 05:13 PM

(05-02-2010 07:17 PM)laeresh Wrote: Anyone ?

Sorry for late reply..

Replace in gb.php

PHP Code:

$comment=mysql_real_escape_string($mybb->input['comment']); 

with

PHP Code:

$comment=$db->escape_string($mybb->input['comment']); 

laeresh · Yesterday 08:14 PM

That fixed it, thanks

Threaded Mode \| Linear Mode User guestbook problem
Author	Message