installer.php issue HELP!

[johnnyh62]

[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]

[AdamHull]

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

[johnnyh62]

thanks for the suggestion, any ideas about how the GoDaddy hosting platform works if we want to revert?

[AdamHull]

just ring or chat to them and explain you need to revert back to php5.4 for a website you need to run

[Coly010]

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.

[johnnyh62]

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?

[Magictallguy]

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"

[SHAD]

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.

[Guest]

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.

[SHAD]

Lol. It completely skipped me that this place has been offline.

Edited March 18, 2019 by SHAD
Typo

[KyleMassacre]

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

[Dave]

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.