CMS Dreams
custom modules for DragonFly CMS

Movie Clip error

Free Modules for the DragonFly CMS
Reply to topicReply to topic Printer Friendly Page
Forum FAQSearchView unanswered posts

Movie Clip error

Post Posted: Thu Mar 04, 2010 8:39 pm

Help please!
I have installed
Dragonfly CMS Version 9.2.1
mClip © cmsdreams.co.uk 2.1.4
Apache/2.2.14 (Win32) PHP/5.3.1
PHP Version 5.3.1
MySQL Version 5.1.44-community (client: mysqlnd 5.0.5-dev - 081106 - $Revision: 289630 $). Using UTF8

And I keep getting the following error by mail:

On /index.php?name=Movie&cid=1
While executing query "
CREATE TABLE IF NOT EXISTS cms_mod_comment (
comment INT(11) NOT NULL auto_increment,
parent INT(11) NOT NULL default '0',
cmodule VARCHAR(100) NOT NULL default '',
cpage INT(11) NOT NULL default '0',
ckey1 INT(11) NOT NULL default '0',
ckey2 INT(11) NOT NULL default '0',
cuser INT(11) NOT NULL default '0',
ctime INT(11) NOT NULL default '0',
ctext TEXT NOT NULL default '',
clink VARCHAR(255) NOT NULL default '',
cip VARCHAR(20) NOT NULL default '',
cdel TINYINT(1) NOT NULL default '0',
PRIMARY KEY (comment),
KEY cmodule (cmodule,cpage,ckey1,ckey2)
)"

the following error occured: BLOB/TEXT column 'ctext' can't have a default value

In: C:\www\mydomain\home\includes\classes\comment.php on line: 181

What to do?
Brgds. Leon

ITkaos
Newbie
Newbie
 

Movie Clip error

Post Posted: Fri Mar 05, 2010 10:53 am

In the file /includes/classes/comment.php you have a block of code (lines 162 - 183) that looks like this :-

Code:
    // check the comment table exists
    if (!defined('CMT_TABLE')) {
      $sql = "
        CREATE TABLE IF NOT EXISTS ".$this->CMT_TABLE." (
          comment INT(11)       NOT NULL auto_increment,
          parent  INT(11)       NOT NULL default '0',
          cmodule VARCHAR(100)  NOT NULL default '',
          cpage   INT(11)       NOT NULL default '0',
          ckey1   INT(11)       NOT NULL default '0',
          ckey2   INT(11)       NOT NULL default '0',
          cuser   INT(11)       NOT NULL default '0',
          ctime   INT(11)       NOT NULL default '0',
          ctext   TEXT          NOT NULL default '',
          clink   VARCHAR(255)  NOT NULL default '',
          cip     VARCHAR(20)   NOT NULL default '',
          cdel    TINYINT(1)    NOT NULL default '0',
          PRIMARY KEY  (comment),
          KEY cmodule (cmodule,cpage,ckey1,ckey2)
        )";
      $db->sql_query($sql);
      define('CMT_TABLE',true);
    }

Change it to this :-

Code:
    // check the comment table exists
    if (!defined('CMT_TABLE')) {
      $sql = "
        CREATE TABLE IF NOT EXISTS ".$this->CMT_TABLE." (
          comment INT(11)       NOT NULL auto_increment,
          parent  INT(11)       NOT NULL default '0',
          cmodule VARCHAR(100)  NOT NULL default '',
          cpage   INT(11)       NOT NULL default '0',
          ckey1   INT(11)       NOT NULL default '0',
          ckey2   INT(11)       NOT NULL default '0',
          cuser   INT(11)       NOT NULL default '0',
          ctime   INT(11)       NOT NULL default '0',
          ctext   TEXT          NOT NULL,
          clink   VARCHAR(255)  NOT NULL default '',
          cip     VARCHAR(20)   NOT NULL default '',
          cdel    TINYINT(1)    NOT NULL default '0',
          PRIMARY KEY  (comment),
          KEY cmodule (cmodule,cpage,ckey1,ckey2)
        )";
      $db->sql_query($sql);
      define('CMT_TABLE',true);
    }

That should cure this particular error. However, please note mClip (and DF 9.2.1 for that matter) were not written with MySQL 5.x in mind, you might come across other incompatibilities as well.

mark
Site Admin
Site Admin
 

Re: Movie Clip error

Post Posted: Sun Mar 07, 2010 12:14 pm

Hi Mark

Thanks a lot that did it.
At the moment it seems to run just fine so I will give it a try with the versions of PHP and MySQL I run Smile

Brgds. Leon

ITkaos
Newbie
Newbie
 
Page 1 of 1



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum