DROP FUNCTION IF EXISTS fn_getCleanURLStr; Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corruptedCREATE FUNCTION fn_getCleanURLStr( str CHAR(255) ) RETURNS CHAR(255) BEGIN DECLARE i, len SMALLINT DEFAULT 1; DECLARE ret CHAR(255) DEFAULT ''; DECLARE c CHAR(1); SET len = CHAR_LENGTH( str ); REPEAT BEGIN SET c = MID( str, i, 1 ); IF c REGEXP '[[:alnum:]]' OR c = '-' THEN SET ret=CONCAT(ret,c); END IF; SET i = i + 1; END; UNTIL i > len END REPEAT; RETURN ret; END; Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corruptedSELECT * from `blog` WHERE fn_getCleanURLStr(REPLACE(`blogName`,' ','-')) = REPLACE("Blog-Details"," ","-") Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted Blog-Details | Saskatchewan Mining Association | Mines in Saskatchewan | Regina
DROP FUNCTION IF EXISTS fn_getCleanURLStr; Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corruptedCREATE FUNCTION fn_getCleanURLStr( str CHAR(255) ) RETURNS CHAR(255) BEGIN DECLARE i, len SMALLINT DEFAULT 1; DECLARE ret CHAR(255) DEFAULT ''; DECLARE c CHAR(1); SET len = CHAR_LENGTH( str ); REPEAT BEGIN SET c = MID( str, i, 1 ); IF c REGEXP '[[:alnum:]]' OR c = '-' THEN SET ret=CONCAT(ret,c); END IF; SET i = i + 1; END; UNTIL i > len END REPEAT; RETURN ret; END; Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corruptedSELECT * from `blog` WHERE fn_getCleanURLStr(REPLACE(`blogName`,' ','-')) = REPLACE("Blog-Details"," ","-") Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted

Voice of Saskatchewan
Mining and Exploration

Member Login

Media & News

Potash Saskatchewan

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameItems.php on line 6

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameItems.php on line 50

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameItems.php on line 111

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameItems.php on line 559
No results found.

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameItems.php on line 574

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameEffectStorage.php on line 10

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameItems.php on line 6

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameItems.php on line 50

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameItems.php on line 111

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameItems.php on line 559
No results found.

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /srv/www/vhosts/sma/public/moduleFrame/moduleFrameItems.php on line 574