[Forum] image.php MySQLi errors

[MPI]

fresh install....i'm not sure whats going on...how do i fix this? (exists with database error page)

[B]Warning[/B]: mysqli_real_escape_string(): Couldn't fetch mysqli in  [B][path]/includes/class_core.php[/B] on line  [B]1429[/B]

[B]Warning[/B]:  mysqli_real_escape_string(): Couldn't fetch mysqli in  [B][path]/includes/class_core.php[/B] on line  [B]1429[/B]

[B]Warning[/B]: mysqli_query(): Couldn't  fetch mysqli in [B][path]/includes/class_core.php[/B] on line  [B]1391[/B]

[B]Warning[/B]: mysqli_error(): Couldn't  fetch mysqli in [B][path]/includes/class_core.php[/B] on line  [B]1025[/B]

[B]Warning[/B]: mysqli_errno(): Couldn't  fetch mysqli in [B][path]/includes/class_core.php[/B] on line  [B]1043[/B]

[B]Warning[/B]: mysqli_query(): Couldn't  fetch mysqli in [B][path]/includes/class_core.php[/B] on line  [B]1391[/B]

[B]Warning[/B]: mysqli_error(): Couldn't  fetch mysqli in [B][path]/includes/class_core.php[/B] on line  [B]1025[/B]

[B]Warning[/B]: mysqli_errno(): Couldn't  fetch mysqli in [B][path]/includes/class_core.php[/B] on line  [B]1043[/B]

and just to clarify, the ^^ above ^^ is the EXACT error code...it logs as "[path]" and not the actual path....not sure if that's relevant

Also, got this in the mail...i'm fairly certain it's relevant to the issue at hand:

Database error in vBulletin 4.1.7:

Invalid SQL:

            SELECT text, languageid, special
            FROM phrase AS phrase
            LEFT JOIN phrasetype USING (fieldname)
            WHERE phrase.fieldname = ''
                AND varname = '' AND languageid IN (-1, 0, 0);

MySQL Error   : 
Error Number  : 
Request Date  : Saturday, November 5th 2011 @ 09:25:43 PM
Error Date    : Saturday, November 5th 2011 @ 09:25:43 PM
Script        : http:///
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database_MySQLi
MySQL Version :

other info: I have both gd AND imagemagick istalled

please advise.

[Lynne]

Try editing your includes/config.php file and setting $config['Database']['dbtype'] to 'mysql' instead of 'mysqli'.

[MPI]

since this was a fresh install I compiled php only with MySQLi, thus, changing the config.php to "mysql" outputs:

Fatal error: Call to undefined function mysql_connect() in /includes/class_core.php on line 314

[MPI]

okay....recompiled php with regular MySQL support and revised config.php appropriately.

no more php warnings


but i still want to use mysqli....how do I fix it?

is this a bug?

[MPI]

...?

[BirdOPrey5]

What page are you viewing causing the errors?

What version on PHP are you using?

[Lynne]

I use mysqli on my 4.1.7 test site. However, I use mysql on another test site, so my php is compiled with support for both. I honestly can't say if that is necessary or not.

[MPI]

4.1.7 publishing suite

What page are you viewing causing the errors?

What version on PHP are you using?

http://domain.com/forum/image.php (because captchas are not working)

php 5.3.8

I use mysqli on my 4.1.7 test site. However, I use mysql on another test site, so my php is compiled with support for both. I honestly can't say if that is necessary or not.

I'm confused by your last reply, can you please elaborate?

[George L]

okay....recompiled php with regular MySQL support and revised config.php appropriately.

no more php warnings


but i still want to use mysqli....how do I fix it?

is this a bug?

compile php with both mysql and mysqli support

[MPI]

compile php with both mysql and mysqli support

BINGO!

Fix:

'--with-mysql' '--with-libdir=lib64' '--with-mysqli' '--with-libdir=lib64'

Thanks George.