Class 'mysqli' not found?

[Tarzan]

I've experienced a strange error the last weeks.
When I try to use the mysqli class in a cron job (located outside of the public_html folder) I get an error message.

First, the log file says
"PHP: Error parsing /usr/local/lib/php.ini on line 786"
then, later where I try to instantiate a mysqli object an error
"Fatal error: Class 'mysqli' not found in /home/tarzan/public_html/(database class I use).php on line X" where X = the line where I use "new mysqli".

The strange thing is that I works perfectly when I use the database class on the public web page.
Does anyone know what the problem is or have any idea of what I can do? It seems like I've had it since around 7th of April so it has been working before...

[misson]

The PHP processor used for cron jobs is the command line PHP processor, which is separate from that used by Apache. It's possible that the cli PHP wasn't built with the mysqli extension. You can run a cron job making use of extension_loaded get_loaded_extensions to check this.

[vv.bbcc19]

I think you need to use MySQLi Prepared Statements
If you need further Information,follow This

I've experienced a strange error the last weeks.
When I try to use the mysqli class in a cron job (located outside of the public_html folder) I get an error message.

First, the log file says
"PHP: Error parsing /usr/local/lib/php.ini on line 786"
then, later where I try to instantiate a mysqli object an error
"Fatal error: Class 'mysqli' not found in /home/tarzan/public_html/(database class I use).php on line X" where X = the line where I use "new mysqli".

The strange thing is that I works perfectly when I use the database class on the public web page.
Does anyone know what the problem is or have any idea of what I can do? It seems like I've had it since around 7th of April so it has been working before...

[Tarzan]

mission:
That sounds reasonable. Thanks! They did some configuration and didn't include mysqli in the command line php. I'm thinking of actually writting my "own" mysqli class for the cron job, with the methods I need. Not nice but at least a workaround until a better solution comes along

vv.bbcc19:
I can't unfortunatly see how prepared statements would help me? I followed the link you gave me and read about it. It still seems that you need to start off by creating a mysqli object tho', and that's where my code fails in the cron job.

[misson]

If you're not unafraid of coding and PDO is available, I'd recommend using it instead of mysqli. It's supposed to replace mysqli, and is a little nicer to use, due to some additional features (such as supporting the Traversable interface, prepared statement results don't need to be bound, and it supports keyword parameters in addition to positional parameters in prepared statements).

[Tarzan]

Haven't heard about that one, thanks for the tip!
I'm actually thinking that the error is something bigger. I've noticed a few other things:
- I'm not able to use the "mb_strtoupper" function.
- No GD library seems to be loaded (e.g., can't use "imagecreate" as before).

So I suspect that "PHP: Error parsing /usr/local/lib/php.ini on line 786" has something to do with it. But I guess I can't edit the php.ini file myself can I? I've posted in the support forum, but still no response at all there...

[misson]

That is indeed a worrisome error. I'll escalate the other thread so an admin will take notice. If you haven't tried it yet, this is something that might be good to bring to IRC.

[Tarzan]

Thanks man! That's probably the thing that's been bugging me the whole time.

I saw you closed the thread, so they'll probably contact me when they're done, right?

[misson]

Escalating automatically closes the thread. You'll get a response from an admin in the support section of the X10 control panel.

[Tarzan]

Since this is the newest thread in this forum (otherwise I hate bumping) and others may be interested I might as well ask here:
Do you know how long it normally takes to get an answer on a low priority escalation?
It's been a week now since you escelated my thread without any reply.