Title: Stack trace errors with 4.4.2 and PHP 7.0.0 Last modified: August 31, 2016 --- # Stack trace errors with 4.4.2 and PHP 7.0.0 * [Mark Flint](https://wordpress.org/support/users/beaueventsmark/) * (@beaueventsmark) * [10 years, 3 months ago](https://wordpress.org/support/topic/stack-trace-errors-with-442-and-php-700/) * A simple [abase] SQL Select page was working perfectly on WP 4.1 and PHP 5.4. Upgraded to latest Abase 2.5.1, WP 4.4.1 and PHP 7.0.0 and now the [abase] code throws errors into the WP log and produces no output on the web page. The WP log points the finger at abase.php line 619, which appears to be the mysql_connect() call, and abase.php line 61, `$abase_output = bus311tabledisplay_function(0,$ incomingfrompost,$content);` * No changes were made to the site. It uses Suffusion theme. Single database and table. Due to the blank output on the page, I have been forced to temporarily remove it from the site. * I realise this is an untested combination at this time, so for other users this is a heads-up awareness of problems ahead. My decision to upgrade was initiated by 1&1, my hosting company, as they will soon be charging premium support fees for back releases of PHP. * Please, is it possible to prioritise the testing of this latest combination of WP platform and PHP versions? Thanks. * The unchanged [abase] code for the page is: `[abase sql="SELECT CONCAT('','',` Botanical name`,'') AS`Botanical name`,`Common name`,`Description`,`Jan`,`Feb`,` Mar`,`Apr`,`May`,`Jun`,`Jul`,`Aug`,`Sep`,`Oct`,`Nov`,`Dec`FROM flowers WHERE flowers.Colour='Black' "]` * The WP log shows ——————— * ``` Stack trace: #0 /homepages/3/d478243850/htdocs/public/wp-content/plugins/abase/abase.php(61): bus311tabledisplay_function(0, Array, '') #1 /homepages/3/d478243850/htdocs/public/wp-includes/shortcodes.php(326): abase_handler(Array, '', 'abase') #2 [internal function]: do_shortcode_tag(Array) #3 /homepages/3/d478243850/htdocs/public/wp-includes/shortcodes.php(223): preg_replace_callback('/\\[(\\[?)(abase)...', 'do_shortcode_ta...', '

Click the Bo...') #4 /homepages/3/d478243850/htdocs/public/wp-includes/plugin.php(235): do_shortcode('

Click the Bo...') #5 /homepages/3/d478243850/htdocs/public/wp-includes/post-template.php(230): apply_filters('the_content', '

Click the Bo...') #6 /homepages/3/d478243850/htdocs/public/wp-content/themes/suffusion/post-formats/content.php(30): the_content('Continue readin...') #7 /homepages/3/d478243850/htdocs/public/wp-includes/template.php(564): require('/homepages/3/d4...') #8 /homepages/3/d478243850/htdocs/public/wp-includes/template.php(521): load_template('/homepages/3/d4...', false) #9 /homepages/3/d478243850/htdocs/public/wp-includes/general-template.php(171): locate_template(Array, true, false) #10 /homepages/3/d478243850/htdocs/public/wp-content/themes/suffusion/functions/actions.php(717): get_template_part('post-formats/co...', 'standard') #11 /homepages/3/d478243850/htdocs/public/wp-includes/plugin.php(525): suffusion_excerpt_or_content('') #12 /homepages/3/d478243850/htdocs/public/wp-content/themes/suffusion/functions/actions.php(42): do_action('suffusion_conte...') #13 /homepages/3/d478243850/htdocs/public/wp-content/themes/suffusion/page.php(30): suffusion_content() #14 /homepages/3/d478243850/htdocs/public/wp-includes/template-loader.php(89): include('/homepages/3/d4...') #15 /homepages/3/d478243850/htdocs/public/wp-blog-header.php(16): require_once('/homepages/3/d4...') #16 /homepages/3/d478243850/htdocs/public/index.php(17): require('/homepages/3/d4...') #17 {main} thrown in /homepages/3/d478243850/htdocs/public/wp-content/plugins/abase/abase.php on line 619 ``` * ——————————- * [https://wordpress.org/plugins/abase/](https://wordpress.org/plugins/abase/) Viewing 3 replies - 1 through 3 (of 3 total) * Thread Starter [Mark Flint](https://wordpress.org/support/users/beaueventsmark/) * (@beaueventsmark) * [10 years, 3 months ago](https://wordpress.org/support/topic/stack-trace-errors-with-442-and-php-700/#post-7020261) * Missed this bit from the stack trace: `PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /homepages/3/d478243850/htdocs/public/ wp-content/plugins/abase/abase.php:619` * [ahero](https://wordpress.org/support/users/ahero/) * (@ahero) * [10 years, 1 month ago](https://wordpress.org/support/topic/stack-trace-errors-with-442-and-php-700/#post-7020507) * Hi Mark, * I have been working in PHP7 and can tell you mysql_ commands all need to be switched over to mysqli_ commands. * To get it to work on my end I had go manually change all the mysql_ commands over to mysqli_ commands in the abase.php file. Here are some of the changes: * 1. Text replace “mysql_” with “mysqli_” 2. locate the “$abase_conn” string and replace with the following: * line ~613: * ``` $abase_conn = mysqli_connect($sqlHost, $sqlUser, $sqlPass, $sqlDatabase) or die("".$GLOBALS['bus311mtd_page_shortcodes']."Fatal Error (".__LINE__.") - Couldn't connect to MySQL server on '$sqlHost'. This shortcode uses Database #$db_in. If this is correct, then see the Warning above. One or more of the following settings for Database #$db_in is probably not correct.

  1. Database host: '$sqlHost'.
  2. Database user: '$sqlUser'.
  3. Database user password: '$sqlPass'.."); ``` * 3. Text search each “mysqli_” and move the connection string to the beginning of the statement rather than the end: * line ~623: * ``` $sqlTables = mysqli_query($abase_conn,"SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='$sqlDatabase'") or die("".$GLOBALS['bus311mtd_page_shortcodes'].$lost_table_error."Fatal Error (".__LINE__.") " . mysqli_error() . ""); ``` * 4. Eliminate or comment out any mysqli_select_db commands * line ~616: * ``` // $db = mysqli_select_db($sqlDatabase, $abase_conn) // or die("".$GLOBALS['bus311mtd_page_shortcodes']."Fatal Error (".__LINE__.") - Couldn't select database '$sqlDatabase'." . mysqli_error() . "This shortcode uses Database #$db_in. If this is correct, then one or more of the following settings for Database #$db_in is probably not correct.
    1. Database name: '$sqlDatabase'.
    2. Database '$sqlDatabase' must be accessible by user '$sqlUser'."); ``` * To verify it works I used the following command to just display a typical wordpress table: * [abase sql=”SHOW COLUMNS FROM wp_links”] * Hope this helps! * [paulbeck](https://wordpress.org/support/users/paulbeck/) * (@paulbeck) * [9 years, 4 months ago](https://wordpress.org/support/topic/stack-trace-errors-with-442-and-php-700/#post-8654661) * Outstanding post! Apparently abase is no longer maintained. Any clue why not? It seems to be the perfect plugin for adhoc database queries. Viewing 3 replies - 1 through 3 (of 3 total) The topic ‘Stack trace errors with 4.4.2 and PHP 7.0.0’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/abase.svg) * [ABASE](https://wordpress.org/plugins/abase/) * [Frequently Asked Questions](https://wordpress.org/plugins/abase/#faq) * [Support Threads](https://wordpress.org/support/plugin/abase/) * [Active Topics](https://wordpress.org/support/plugin/abase/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/abase/unresolved/) * [Reviews](https://wordpress.org/support/plugin/abase/reviews/) ## Tags * [php](https://wordpress.org/support/topic-tag/php/) * [Stack trace](https://wordpress.org/support/topic-tag/stack-trace/) * 3 replies * 3 participants * Last reply from: [paulbeck](https://wordpress.org/support/users/paulbeck/) * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/stack-trace-errors-with-442-and-php-700/#post-8654661) * Status: not resolved