Error In Form Submission after upgrading to PHP 7.0

3 posts by 2 authors in: Forums > CMS Builder
Last Post: April 15, 2019   (RSS)

By nmsinc - April 15, 2019

I have several forms that are outside the CMS which are used to create new users. Upon upgrading the PHP to 7.0 these forms produce an error in the "insert" code!

The error is as follows:    UNCAUGHT_EXCEPTION: Call to undefined function mysql_query()

I have included the insert code line we use:    mysql_query("INSERT INTO `{$TABLE_PREFIX}accounts` SET

Any help would be appreciated very much!

nmsinc

By gkornbluth - April 15, 2019

Hi nmsinc,

Try this instead, it might work for you:

mysqli()->query(mysql_escapef("INSERT INTO {$TABLE_PREFIX}accounts SET

Daniel Loewe also reminded me in a similar situation that there's a Legacy MySQL Scanner plugin, which can be found in any recent CMSB installation (v3.12 or later). This should let you know if that's indeed the case, and also give some idea about what needs to be replaced if it's something custom like this.

best,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php