johnnyh62 Posted January 16, 2017 Share Posted January 16, 2017 [TABLE=border: 0, cellpadding: 0, cellspacing: 0] [TR] [TD]Issue:[/TD] [/TR] [TR] [TD]I have been unable to install McCodes V2 due to an error during the setup. Please see details below: Attempting DB connection... A non-critical error has occurred. Page execution will continue. Below are the details: PHP Deprecation Notice: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead (8192) Line executed: /home/bloodcode/public_html/class/class_db_mysql.php:82 ... Successful. Writing game config file... Write Config... ... file written. Writing base database schema... Installer Error A critical error has occurred, and installation has stopped. Below are the details: 1101: BLOB/TEXT column 'fp_text' can't have a default value Action taken: Attempted to execute query: CREATE TABLE IF NOT EXISTS `forum_posts` ( `fp_id` int(11) NOT NULL auto_increment, `fp_topic_id` int(11) NOT NULL default '0', `fp_forum_id` int(11) NOT NULL default '0', `fp_poster_id` int(11) NOT NULL default '0', `fp_poster_name` text NOT NULL, `fp_time` int(11) NOT NULL default '0', `fp_subject` varchar(255) NOT NULL default '', `fp_text` text NOT NULL default '', `fp_editor_id` int(11) NOT NULL default '0', `fp_editor_name` text NOT NULL, `fp_editor_time` int(11) NOT NULL default '0', `fp_edit_count` int(11) NOT NULL default '0', PRIMARY KEY (`fp_id`)) ENGINE=MyISAM ; Context at error time: Array ( [0] => Array ( [file] => /home/bloodcode/public_html/installer.php [line] => 463 [function] => query [class] => database [type] => -> [args] => Array ( [0] => CREATE TABLE IF NOT EXISTS `forum_posts` ( `fp_id` int(11) NOT NULL auto_increment, `fp_topic_id` int(11) NOT NULL default '0', `fp_forum_id` int(11) NOT NULL default '0', `fp_poster_id` int(11) NOT NULL default '0', `fp_poster_name` text NOT NULL, `fp_time` int(11) NOT NULL default '0', `fp_subject` varchar(255) NOT NULL default '', `fp_text` text NOT NULL default '', `fp_editor_id` int(11) NOT NULL default '0', `fp_editor_name` text NOT NULL, `fp_editor_time` int(11) NOT NULL default '0', `fp_edit_count` int(11) NOT NULL default '0', PRIMARY KEY (`fp_id`)) ENGINE=MyISAM ; ) ) [1] => Array ( [file] => /home/bloodcode/public_html/installer.php [line] => 46 [function] => install [args] => Array ( ) ) ) It keeps coming up with a critical installer error. Please assist ASAP.[/TD] [/TR] [/TABLE] [TABLE=border: 0, cellpadding: 4, cellspacing: 0] [TR] [TD]---------------- When I try using mySQLi Enhanced instead I get the errors below: Installer Error A critical error has occurred, and installation has stopped. Below are the details: 1101: BLOB/TEXT column 'fp_text' can't have a default value Action taken: Attempted to execute query: CREATE TABLE IF NOT EXISTS `forum_posts` ( `fp_id` int(11) NOT NULL auto_increment, `fp_topic_id` int(11) NOT NULL default '0', `fp_forum_id` int(11) NOT NULL default '0', `fp_poster_id` int(11) NOT NULL default '0', `fp_poster_name` text NOT NULL, `fp_time` int(11) NOT NULL default '0', `fp_subject` varchar(255) NOT NULL default '', `fp_text` text NOT NULL default '', `fp_editor_id` int(11) NOT NULL default '0', `fp_editor_name` text NOT NULL, `fp_editor_time` int(11) NOT NULL default '0', `fp_edit_count` int(11) NOT NULL default '0', PRIMARY KEY (`fp_id`)) ENGINE=MyISAM ; Context at error time: Array ( [0] => Array ( [file] => /home/bloodcode/public_html/installer.php [line] => 463 [function] => query [class] => database [type] => -> [args] => Array ( [0] => CREATE TABLE IF NOT EXISTS `forum_posts` ( `fp_id` int(11) NOT NULL auto_increment, `fp_topic_id` int(11) NOT NULL default '0', `fp_forum_id` int(11) NOT NULL default '0', `fp_poster_id` int(11) NOT NULL default '0', `fp_poster_name` text NOT NULL, `fp_time` int(11) NOT NULL default '0', `fp_subject` varchar(255) NOT NULL default '', `fp_text` text NOT NULL default '', `fp_editor_id` int(11) NOT NULL default '0', `fp_editor_name` text NOT NULL, `fp_editor_time` int(11) NOT NULL default '0', `fp_edit_count` int(11) NOT NULL default '0', PRIMARY KEY (`fp_id`)) ENGINE=MyISAM ; ) ) [1] => Array ( [file] => /home/bloodcode/public_html/installer.php [line] => 46 [function] => install [args] => Array ( ) ) ) Tried many things, and I keep getting different errors. No matter how hard I try, it just does not run the database part properly. I paid $100 for this and I'm well annoyed. MC Codes say they provide support for 30 days, I haven't heard back from them yet and its been half a damn day. Please help out guys. [/TD] [/TR] [/TABLE] Quote Link to comment Share on other sites More sharing options...
AdamHull Posted January 16, 2017 Share Posted January 16, 2017 Your php version is to high, you will need to revert to php 5.4(think it's around that number), if you are on a shared hosting platform you may have to contact your hosting provider to lower this for you Quote Link to comment Share on other sites More sharing options...
johnnyh62 Posted January 16, 2017 Author Share Posted January 16, 2017 thanks for the suggestion, any ideas about how the GoDaddy hosting platform works if we want to revert? Quote Link to comment Share on other sites More sharing options...
AdamHull Posted January 16, 2017 Share Posted January 16, 2017 just ring or chat to them and explain you need to revert back to php5.4 for a website you need to run Quote Link to comment Share on other sites More sharing options...
Coly010 Posted January 17, 2017 Share Posted January 17, 2017 Whilst mysql extension is deprecated in higher versions of PHP, it's not preventing your script running. It's saying there is an error trying to set a default value to a TEXT column in the database. BLOB/TEXT columns cannot take a default value: http://dev.mysql.com/doc/refman/5.7/en/blob.html The SQL needs to be changed to allow for this. 1 Quote Link to comment Share on other sites More sharing options...
johnnyh62 Posted January 17, 2017 Author Share Posted January 17, 2017 Ok I've sorted the installer issue out, now the cronjobs are refusing to run. I've set them up as /usr/bin/php /home/u837966832/public_html/cron_fivemins.php b9b092387ab8d81b14d27e4efaaf763b - They're just not running for some reason. Is there a way around this guys? Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted February 14, 2017 Share Posted February 14, 2017 The code is outdated and outmoded. You need to update the code yourself or find/hire someone who will do that for you. Your DB errors are due to the fact that the dbdata.sql is coded incorrectly - attempting to set default values on blob/text columns (can't do it). At least switch to MySQLi, if you're not willing/able to do anything else - you can do this is config.php, simply change "mysql" to "mysqli" Quote Link to comment Share on other sites More sharing options...
SHAD Posted March 17, 2019 Share Posted March 17, 2019 I've just installed it with PHP 7.3 and MySQLi environment and it hasn't really thrown up any errors. Download the latest version from the mccodes website. 2 Quote Link to comment Share on other sites More sharing options...
Guest Posted March 18, 2019 Share Posted March 18, 2019 2 hours ago, SHAD said: I've just installed it with PHP 7.3 and MySQLi environment and it hasn't really thrown up any errors. Download the latest version from the mccodes website. This was from 2017 buddy. Quote Link to comment Share on other sites More sharing options...
SHAD Posted March 18, 2019 Share Posted March 18, 2019 (edited) Lol. It completely skipped me that this place has been offline. Edited March 18, 2019 by SHAD Typo Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted March 18, 2019 Share Posted March 18, 2019 (edited) It is quite old but I would say forgive it. I don’t know exactly when MWG went down but as a matter of fact just for the hell of it I spun up a new instance of MCC and ran into the same thing. MySQL doesn’t allow for this anymore but reading the docs it appears you can circumvent it by finding text NOT NULL DEFAULT '' and replacing with text NOT NULL DEFAULT ('') Edited March 18, 2019 by KyleMassacre 2 Quote Link to comment Share on other sites More sharing options...
Dave Posted March 18, 2019 Share Posted March 18, 2019 7 hours ago, Ian said: This was from 2017 buddy. As most of the content on here is old it’s fine for people to respond to older threads. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.