ionize CMS forum

porga

Ion Tester

From: Croatia

Registered: 2010-07-16

Posts: 164

Function sql_regcase() is deprecated

Hi there,

after insallation i get this error in admin/content/media manager

Deprecated: Function sql_regcase() is deprecated in C:\wamp\www\ionize\themes\admin\javascript\tinymce\jscripts\tiny_mce\plugins\tinybrowser\fns_tinybrowser.php on line 358

Deprecated: Function sql_regcase() is deprecated in C:\wamp\www\ionize\themes\admin\javascript\tinymce\jscripts\tiny_mce\plugins\tinybrowser\fns_tinybrowser.php on line 387

Deprecated: Function sql_regcase() is deprecated in C:\wamp\www\ionize\themes\admin\javascript\tinymce\jscripts\tiny_mce\plugins\tinybrowser\fns_tinybrowser.php on line 387

using localhost@WAMP Windows 7
PHP: 5.3.0
APACHE:2.2.11    rewrite_module on
MYSQL: 5.1.36

Posting this here because it is "out of the box" error (after install).

Kink

Ion Tester

From: France

Registered: 2010-06-04

Posts: 301

Re: Function sql_regcase() is deprecated

Be quiet Porga, i have the same error with the same system like you, and in production, the errors are off, ignore them.
It's because of PHP 5.3.0, it seems.

porga

Ion Tester

From: Croatia

Registered: 2010-07-16

Posts: 164

Re: Function sql_regcase() is deprecated

is this because Tinymce?

Why not use CKEditor instead?

I tried to install php 5.2.11 and login to ionize, but then I get:

Fatal error: Call to undefined function mcrypt_encrypt() in C:\wamp\www\ionize\application\libraries\access\Access.php  on line 1089

Last edited by porga (2010-07-16 10:07:01)

Kink

Ion Tester

From: France

Registered: 2010-06-04

Posts: 301

Re: Function sql_regcase() is deprecated

You version of PHP has a problem, cause mcrypt_encrypt() exist since PHP 4.0.2

Porga, sincerely, you can still work with PHP 5.3.0, ignore message with "Function deprecated", it's just an alert. I know it's not very very beautiful, but your online version of you site will not show these errors.

Michel-Ange

Ionize Core Team

From: Paris, France

Registered: 2010-03-22

Posts: 713

Website

Re: Function sql_regcase() is deprecated

Porga,

We're using tinyMCE because it integrates lovely with tinyBrowser and also with MCE ImageManager, which is not provided in the Open Source version because licenced, but the integration of it is OK with ionize.

Concerning mcrypt, we will try to use only the CI lib, but it is not secured enough if the mcrypt lib isn't available (CI lib use mcrypt if it is installed and a poor encryption alternative of not...)

---

Inspiration & Innovation : Websites by Partikule, Agence Web Paris

cnrdzn

Member

From: Turkey

Registered: 2010-11-13

Posts: 2

Re: Function sql_regcase() is deprecated

find
sql_regcase($filetype)

replace
$filetype

jyo

Member

From: Rouen, France

Registered: 2011-01-24

Posts: 5

Re: Function sql_regcase() is deprecated

You can too:
1- add the following code at the beginnig of .../Ionize/themes/admin/javascript/tinymce/jscripts/tiny_mce/plugins/tinybrowser/fns_tinybrowser.php:

function mb_sql_regcase($string,$encoding='auto'){
  $max=mb_strlen($string,$encoding);
  $ret='';
  for ($i = 0; $i < $max; $i++) {
    $char=mb_substr($string,$i,1,$encoding);
    $up=mb_strtoupper($char,$encoding);
    $low=mb_strtolower($char,$encoding);
    $ret.=($up!=$low)?'['.$up.$low.']' : $char;
  }
  return $ret;
}

2-replace the 2 occurences of sql_regcase by mb_sql_regcase in the same file

It works!

---

Old programmer, but Ionize Newbee ;)