Jump to content
MakeWebGames

installer.php issue HELP!


johnnyh62
 Share

Recommended Posts

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

  • 4 weeks later...

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"

Link to comment
Share on other sites

  • 2 years later...
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.

Link to comment
Share on other sites

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 by KyleMassacre
  • Like 2
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...