Support > cpg1.5 install

MySQL Error

<< < (2/3) > >>

Αndré:
Please open sql/schema.sql, find

--- Code: ---#
# Table structure for table CPG_categorymap
#
CREATE TABLE IF NOT EXISTS `CPG_categorymap` (
  cid int(11) NOT NULL,
  group_id int(11) NOT NULL,
  PRIMARY KEY  (cid,group_id)
) ENGINE=MyISAM COMMENT='Holds the categories where groups can create albums';
# --------------------------------------------------------
--- End code ---
and replace with

--- Code: ---#
# Table structure for table CPG_categorymap
#
CREATE TABLE IF NOT EXISTS `CPG_categorymap` (
  cid int(11) NOT NULL,
  group_id int(11) NOT NULL,
  PRIMARY KEY  (cid,group_id)
) TYPE=MyISAM COMMENT='Holds the categories where groups can create albums';
# --------------------------------------------------------
--- End code ---
and check if the installer still stops while creating that table.

BradInOKC:
Thank you!!!  I had to edit another string in the same way at


--- Quote ---SQL syntax near 'ENGINE=MyISAM COMMENT='Stores EXIF data from individual pics''
--- End quote ---


I changed "ENGINE" to "TYPE" in that location too, and it installed all the way.  Thank you very very much!

Brad

Αndré:
@devs: should we change all queries to use TYPE instead of ENGINE. I didn't find any useful information about the difference and MySQL versions.

@BradInOKC: please help us to improve Coppermine and post your MySQL version. Thank you.

Nibbler:
The older TYPE option was synonymous with ENGINE. TYPE  has been deprecated since MySQL 4.0 but is still supported for backward compatibility in MySQL 5.1 (excepting MySQL 5.1.7). Since MySQL 5.1.8, it produces a warning. It is removed in MySQL 5.5. You should not use TYPE in any new applications, and you should immediately begin conversion of existing applications to use ENGINE  instead. (See Section C.1.45, “Changes in MySQL 5.1.8 (Not released)”.)

(http://dev.mysql.com/doc/refman/5.1/en/create-table.html)

However

The ENGINE and TYPE  options specify the storage engine for the table. ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the preferred option name as of those versions, and TYPE has become deprecated. TYPE is supported throughout the 4.x series, but likely will be removed in the future.

(http://dev.mysql.com/doc/refman/4.1/en/create-table.html)

So, we should switch from TYPE to ENGINE but we also need to bump the minimum MySQL version requirement.

Joachim Müller:
Fine by me to have the minimum requirements for cpg1.5.x raised a bit as far as the mysql database is concerned.

mySQL 4.1.2 would then be the minimum if I understand this right?

Navigation

[0] Message Index

[#] Next page

[*] Previous page