Joomla database driver mysqli

The Joomla! Forum™

PHP Warning: mysqli::stat(): Couldn’t fetch mysqli

Moderator: ooffick

PHP Warning: mysqli::stat(): Couldn’t fetch mysqli

Post by juanm_la22 » Wed Mar 22, 2017 12:44 pm

Hi guys, before start i must to say that im not sure if this is a bug or something wrong on my production server’s configuration, but i am trying to figure it out.

The thing is that i am getting this warnings all the time on my php’s error log:

[Wed Mar 22 13:31:35.159883 2017] [:error] [pid 10447] [client 163.172.65.66:27900] PHP Warning: mysqli::stat(): Couldn’t fetch mysqli in /home/www/todoboda.com/libraries/joomla/database/driver/mysqli.php on line 219
[Wed Mar 22 13:31:35.159913 2017] [:error] [pid 10447] [client 163.172.65.66:27900] PHP Warning: mysqli_close(): Couldn’t fetch mysqli in /home/www/todoboda.com/libraries/joomla/database/driver/mysqli.php on line 226

Always appears on that pair from line 219 and 226, and always on that order. Most of the time appears when something from Jomsocial is executed , but not always.

What i am not sure is why this is appearing on logs. The most noisy thing is that this not happen on my testing server (a vm with same OS (debian jessie) and same php and mysql versions).

Something that is freaking out me is Jomsocial. Sorry to the fans, but i think that jomsocial’s developers did a lot of bad things. like their own cache if system’s cache is enable. I have a lot of problems with that.

Well i hope someone can throw some light on this.

Thanks in advance and as always, sorry for my poor english.
Juan Manuel

Источник

The Joomla! Forum™

Database Error: Unable to load Database Driver: mysqli

Database Error: Unable to load Database Driver: mysqli

Post by viktorleon » Wed Nov 25, 2015 1:32 am

Basic Environment :: wrote: Joomla! Instance :: Joomla! 3.4.5-Stable (Ember) 22-October-2015
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only ( 444 ) | Owner: solunetu (uid: 1/gid: 1) | Group: solunetu (gid: 1) | Valid For: 3.4
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 0 | .htaccess/web.config: No | GZip: 0 | Cache: 0 | FTP Layer: 0 | SSL: 0 | Error Reporting: maximum | Site Debug: 0 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | Database Credentials Present: Yes

Host Configuration :: OS: Linux | OS Version: 2.6.32-573.3.1.el6.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: /home/solunetu/public_html/myafterschool | System TMP Writable: Yes

PHP Configuration :: Version: 5.4.22 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 32759 | Log Errors To: error_log | Last Known Error: 20th November 2015 20:35:12. | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 50M | Max. POST Size: 10M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 128M

MySQL Configuration :: Version: 5.5.46-cll (Client:5.5.46) | Host: —protected— ( —protected— ) | Collation: latin1_swedish_ci ( Character Set: latin1) | Database Size: 51.01 MiB | #of Tables: 114

Detailed Environment :: wrote: PHP Extensions :: Core (5.4.22) | date (5.4.22) | ereg () | libxml () | openssl () | pcre () | sqlite3 (0.7) | zlib (2.0) | bcmath () | calendar () | ctype () | curl () | dom (20031129) | hash (1.0) | filter (0.11.0) | ftp () | gd () | gettext () | SPL (0.2) | iconv () | session () | json (1.2.1) | mbstring () | mcrypt () | standard (5.4.22) | mysql (1.0) | mysqli (0.1) | mysqlnd (mysqlnd 5.0.10 — 20111026 — $Id: e707c415db32080b3752b232487a435ee0372157 $) | Phar (2.0.1) | posix () | pspell () | Reflection ($Id: c4a7c554f00da47fe9cff384d18c532a1a959dff $) | imap () | SimpleXML (0.1) | soap () | sockets () | exif (1.4 $Id$) | tidy (2.0) | tokenizer (0.1) | wddx () | xml () | xmlreader (0.1) | xmlrpc (0.51) | xmlwriter (0.1) | xsl (0.1) | zip (1.11.0) | cgi-fcgi () | PDO (1.0.4dev) | pdo_sqlite (1.0.1) | pdo_mysql (1.0.2) | ionCube Loader () | Zend Guard Loader () | Zend Engine (2.4.0) |
Potential Missing Extensions :: suhosin |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No

Folder Permissions :: wrote: Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) |

Elevated Permissions (First 10) :: attachments/ ( 775 ) |

Extensions Discovered :: wrote: Components :: SITE :: WF_DIRECTIONALITY_TITLE (2.5.11) | WF_CHARMAP_TITLE (2.5.11) | WF_LAYER_TITLE (2.5.11) | WF_HR_TITLE (2.5.11) | WF_TABLE_TITLE (2.5.11) | WF_FULLSCREEN_TITLE (2.5.11) | WF_INLINEPOPUPS_TITLE (2.5.11) | WF_FONTCOLOR_TITLE (2.5.11) | WF_FONTSIZESELECT_TITLE (2.5.11) | WF_PREVIEW_TITLE (2.5.11) | WF_LISTS_TITLE (2.5.11) | WF_CLIPBOARD_TITLE (2.5.11) | WF_VISUALCHARS_TITLE (2.5.11) | WF_TEXTCASE_TITLE (2.5.11) | WF_BROWSER_TITLE (2.5.11) | WF_CONTEXTMENU_TITLE (2.5.11) | WF_FONTSELECT_TITLE (2.5.11) | WF_IMGMANAGER_TITLE (2.5.11) | WF_SEARCHREPLACE_TITLE (2.5.11) | WF_NONBREAKING_TITLE (2.5.11) | WF_XHTMLXTRAS_TITLE (2.5.11) | WF_VISUALBLOCKS_TITLE (2.5.11) | WF_STYLE_TITLE (2.5.11) | WF_PRINT_TITLE (2.5.11) | WF_MEDIA_TITLE (2.5.11) | WF_FORMATSELECT_TITLE (2.5.11) | WF_AUTOSAVE_TITLE (2.5.11) | WF_LINK_TITLE (2.5.11) | WF_ARTICLE_TITLE (2.5.11) | WF_SOURCE_TITLE (2.5.11) | WF_KITCHENSINK_TITLE (2.5.11) | WF_SPELLCHECKER_TITLE (2.5.11) | WF_ANCHOR_TITLE (2.5.11) | WF_CLEANUP_TITLE (2.5.11) | WF_STYLESELECT_TITLE (2.5.11) | WF_FILESYSTEM_JOOMLA_TITLE (2.5.11) | WF_LINKS_JOOMLALINKS_TITLE (2.5.11) | WF_POPUPS_WINDOW_TITLE (2.5.11) | WF_POPUPS_JCEMEDIABOX_TITLE (2.5.11) | WF_MEDIAPLAYER_JCEPLAYER_TITLE (2.5.11) | WF_LINK_SEARCH_TITLE (2.5.11) | WF_AGGREGATOR_VINE_TITLE (2.5.11) | WF_AGGREGATOR_[youtube]_TITLE (2.5.11) | WF_AGGREGATOR_DAILYMOTION_TITL (2.5.11) | WF_AGGREGATOR_VIMEO_TITLE (2.5.11) | com_mailto (3.0.0) | com_wrapper (3.0.0) |
Components :: ADMIN :: com_categories (3.0.0) | com_cpanel (3.0.0) | com_finder (3.0.0) | com_config (3.0.0) | com_templates (3.0.0) | com_content (3.0.0) | com_search (3.0.0) | com_installer (3.0.0) | com_admin (3.0.0) | com_weblinks (3.4.1) | Unknown (-) | JCE (2.5.11) | com_menus (3.0.0) | com_attachments (3.2.3) | com_modules (3.0.0) | com_joomlaupdate (3.0.0) | com_checkin (3.0.0) | com_ajax (3.2.0) | com_users (3.0.0) | com_postinstall (3.2.0) | com_tags (3.1.0) | com_languages (3.0.0) | com_newsfeeds (3.0.0) | com_messages (3.0.0) | COM_ARRAUSERMIGRATE (4.0.15) | com_banners (3.0.0) | com_cache (3.0.0) | com_plugins (3.0.0) | com_redirect (3.0.0) | System — Redirect On Login (3.0.0) | User — Redirect On Login (3.0.0) | COM_REDIRECTONLOGIN (3.5.0) | com_rsform (1.50.21) | Unknown (-) | Unknown (-) | BreezingForms (1.8.5 Stable ) | com_media (3.0.0) | com_login (3.0.0) | com_contenthistory (3.2.0) |

Modules :: SITE :: S5 Vertical Accordion (3.0.0) | mod_whosonline (3.0.0) | S5 Register (3.0.0) | mod_menu (3.0.0) | mod_related_items (3.0.0) | mod_search (3.0.0) | mod_wrapper (3.0.0) | mod_users_latest (3.0.0) | mod_login (3.0.0) | mod_tags_popular (3.1.0) | mod_tags_similar (3.1.0) | mod_articles_popular (3.0.0) | mod_random_image (3.0.0) | S5 Accordion Menu (2.1.0) | mod_articles_latest (3.0.0) | mod_articles_archive (3.0.0) | mod_articles_category (3.0.0) | mod_finder (3.0.0) | mod_footer (3.0.0) | mod_breadcrumbs (3.0.0) | mod_syndicate (3.0.0) | S5 Tab Show (2.0.0) | mod_feed (3.0.0) | mod_articles_news (3.0.0) | S5 Map It with Google (1.6) | mod_weblinks (3.4.1) | mod_articles_categories (3.0.0) | mod_stats (3.0.0) | mod_banners (3.0.0) | S5 Image and Content Fader v3 (3.2.0) | mod_custom (3.0.0) | mod_languages (3.0.0) | S5 Box (5.0.0) |
Modules :: ADMIN :: mod_latest (3.0.0) | mod_multilangstatus (3.0.0) | mod_menu (3.0.0) | mod_status (3.0.0) | mod_toolbar (3.0.0) | mod_logged (3.0.0) | mod_version (3.0.0) | mod_login (3.0.0) | mod_quickicon (3.0.0) | mod_submenu (3.0.0) | mod_title (3.0.0) | mod_popular (3.0.0) | mod_stats_admin (3.0.0) | mod_feed (3.0.0) | mod_custom (3.0.0) |

Источник

Joomla! API

• Methods
  • __call
  • __construct
  • __destruct
  • __get
  • connect
  • connected
  • convertUtf8mb4QueryToUtf8
  • decodeBinary
  • disconnect
  • dropTable
  • escape
  • execute
  • getAffectedRows
  • getCollation
  • getConnection
  • getConnectionCollation
  • getConnectors
  • getCount
  • getDateFormat
  • getExporter
  • getImporter
  • getInstance
  • getIterator
  • getMinimum
  • getName
  • getNullDate
  • getNumRows
  • getPrefix
  • getQuery
  • getServerType
  • getTableColumns
  • getTableCreate
  • getTableKeys
  • getTableList
  • getVersion
  • hasUtfSupport
  • insertid
  • insertObject
  • isMinimumVersion
  • isSupported
  • ‘row_value’].»> loadAssoc
  • ‘row_value’]. The array of rows can optionally be keyed by a field name, but defaults to a sequential numeric array.»> loadAssocList
  • $offset field in each row of the result set from the database query.»> loadColumn
  • loadObject
  • loadObjectList
  • loadResult
  • $row[0] , etc.»> loadRow
  • loadRowList
  • lockTable
  • log
  • q
  • qn
  • quote
  • quoteBinary
  • quoteName
  • renameTable
  • $prefix with the string held is the tablePrefix class variable.»> replacePrefix
  • select
  • setDebug
  • setLogger
  • setQuery
  • setUtf
  • splitSql
  • transactionCommit
  • transactionRollback
  • transactionStart
  • truncateTable
  • unlockTables
  • updateObject
• В» Protected
  • executeUnpreparedQuery
  • fetchArray
  • fetchAssoc
  • fetchObject
  • freeResult
  • getDatabase
  • quoteNameStr
  • quoteNameString
• В» Private
• Constants

MySQLi Database Driver

Methods

__call

Magic method to provide method alias support for quote() and quoteName().

Arguments

string The called method.

array The array of arguments passed to the method.

Response

mixed The aliased method’s return value or null.

__construct

Arguments

array List of options used to configure the connection

__destruct

__get

Magic method to access properties of the database driver.

1.4.0 This is a B/C proxy since $this->name was previously public

Arguments

string The name of the property.

Response

mixed A value if the property name is valid, null otherwise.

connect

Connects to the database if needed.

connected

Determines if the connection to the server is active.

Response

boolean True if connected to the database engine.

convertUtf8mb4QueryToUtf8

Automatically downgrade a CREATE TABLE or ALTER TABLE query from utf8mb4 (UTF-8 Multibyte) to plain utf8.

Used when the server doesn’t support UTF-8 Multibyte.

Arguments

string The query to convert

Response

string The converted query

decodeBinary

Replace special placeholder representing binary field with the original string.

Arguments

string|resource Encoded string or resource.

Response

string The original string.

disconnect

Disconnects the database.

dropTable

Drops a table from the database.

Arguments

string The name of the database table to drop.

boolean Optionally specify that the table must exist before it is dropped.

Response

\Joomla\Database\DatabaseDriver Returns this object to support chaining.

escape

Escapes a string for usage in an SQL statement.

Arguments

string The string to be escaped.

boolean Optional parameter to provide extra escaping.

Response

string The escaped string.

execute

Execute the SQL statement.

Response

resource|boolean A database cursor resource on success, boolean false on failure.

executeUnpreparedQuery

Internal method to execute queries which cannot be run as prepared statements.

Arguments

string SQL statement to execute.

Response

fetchArray

Method to fetch a row from the result set cursor as an array.

Arguments

mixed The optional result set cursor from which to fetch the row.

Response

mixed Either the next row from the result set or false if there are no more rows.

fetchAssoc

Method to fetch a row from the result set cursor as an associative array.

Arguments

mixed The optional result set cursor from which to fetch the row.

Response

mixed Either the next row from the result set or false if there are no more rows.

fetchObject

Method to fetch a row from the result set cursor as an object.

Arguments

mixed The optional result set cursor from which to fetch the row.

string The class name to use for the returned row object.

Response

mixed Either the next row from the result set or false if there are no more rows.

freeResult

Method to free up the memory used for the result set.

Arguments

mixed The optional result set cursor from which to fetch the row.

getAffectedRows

Get the number of affected rows for the previous executed SQL statement.

Response

integer The number of affected rows.

getCollation

Method to get the database collation in use by sampling a text field of a table in the database.

Response

string|boolean The collation in use by the database or boolean false if not supported.

getConnection

Method that provides access to the underlying database connection. Useful for when you need to call a proprietary method such as PostgreSQL’s lo_* methods.

Response

resource The underlying database connection resource.

getConnectionCollation

Method to get the database connection collation, as reported by the driver.

If the connector doesn’t support reporting this value please return an empty string.

Response

getConnectors

Get a list of available database connectors. The list will only be populated with connectors that both the class exists and the static test method returns true. This gives us the ability to have a multitude of connector classes that are self-aware as to whether or not they are able to be used on a given system.

Response

array An array of available database connectors.

getCount

Get the total number of SQL statements executed by the database driver.

Response

getDatabase

Gets the name of the database used by this conneciton.

Response

getDateFormat

Returns a PHP date() function compliant date format for the database driver.

Response

string The format string.

getExporter

Gets an exporter class object.

Response

getImporter

Gets an importer class object.

Response

getInstance

Method to return a DatabaseDriver instance based on the given options.

There are three global options and then the rest are specific to the database driver. The ‘driver’ option defines which DatabaseDriver class is used for the connection — the default is ‘mysqli’. The ‘database’ option determines which database is to be used for the connection. The ‘select’ option determines whether the connector should automatically select the chosen database.

Instances are unique to the given options and new objects are only created when a unique options array is passed into the method. This ensures that we don’t end up with unnecessary database connection resources.

Arguments

array Parameters to be passed to the database driver.

Источник