| |
| | |

CodersClub

 Forgot password?
 Register
Search
View: 4712|Reply: 4
Collapse the left

What is this?

[Copy link]

 China

Post time: 2017-07-29 11:06
| Show all posts |Read mode
When I install I got this
run_sql_error
  • SQL:CREATE TABLE pre_common_member_grouppm ( uid int(11) unsigned NOT NULL DEFAULT '0', gpmid int(11) unsigned NOT NULL AUTO_INCREMENT, `status` tinyint(1) NOT NULL DEFAULT '0', dateline int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (uid,gpmid)) ENGINE=MYISAM DEFAULT CHARSET=utf8
    Error:Incorrect table definition; there can be only one auto column and it must be defined as a key
    Errno:1075


run_sql_error
  • SQL:CREATE TABLE pre_forum_post ( pid int(11) unsigned NOT NULL, fid int(11) unsigned NOT NULL DEFAULT '0', tid int(11) unsigned NOT NULL DEFAULT '0', `first` tinyint(1) NOT NULL DEFAULT '0', author varchar(255) NOT NULL DEFAULT '', authorid int(11) unsigned NOT NULL DEFAULT '0', `subject` varchar(255) NOT NULL DEFAULT '', dateline int(11) unsigned NOT NULL DEFAULT '0', message mediumtext NOT NULL, useip varchar(15) NOT NULL DEFAULT '', `port` smallint(6) unsigned NOT NULL DEFAULT '0', invisible tinyint(1) NOT NULL DEFAULT '0', anonymous tinyint(1) NOT NULL DEFAULT '0', usesig tinyint(1) NOT NULL DEFAULT '0', htmlon tinyint(1) NOT NULL DEFAULT '0', bbcodeoff tinyint(1) NOT NULL DEFAULT '0', smileyoff tinyint(1) NOT NULL DEFAULT '0', parseurloff tinyint(1) NOT NULL DEFAULT '0', attachment tinyint(1) NOT NULL DEFAULT '0', rate int(11) NOT NULL DEFAULT '0', ratetimes int(11) unsigned NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', tags varchar(255) NOT NULL DEFAULT '0', `comment` tinyint(1) NOT NULL DEFAULT '0', replycredit int(11) NOT NULL DEFAULT '0', position int(11) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (tid,position), UNIQUE KEY pid (pid), KEY fid (fid), KEY authorid (authorid,invisible), KEY dateline (dateline), KEY invisible (invisible), KEY displayorder (tid,invisible,dateline), KEY `first` (tid,`first`)) ENGINE=MYISAM DEFAULT CHARSET=utf8
    Error:Incorrect table definition; there can be only one auto column and it must be defined as a key
    Errno:1075



 Russia

Post time: 2017-07-30 12:42
| Show all posts
If your MySQL version > 4.1
then you have to write
    "ENGINE=MyISAM"
else
    "TYPE=MyISAM"

change this lines corresponding your MySQL version.

 Russia

Post time: 2017-07-30 14:17
| Show all posts
I discovered the problem at my computer.
It is NOT required to make any changes into SQL files!
Because of the engine is doing it by itself automatically.

@Alpha, please report your system environment!

 China

 Author| Post time: 2017-08-01 06:21
| Show all posts
this is the information

This post contains more resources

You have to Login for download or view attachment(s). No Account? Register

x

 Russia

Post time: 2017-08-01 07:59
| Show all posts
"PHP version Unknown"
It is strange!

Some people said that "Free website plan" at freehosing.com is not compatible with Discuz.
You have to log in before you can reply Login | Register

Points Rules

Archive|Mobile|Dark room|CodersClub

Top.Mail.Ru
Top.Mail.Ru

2024-11-22 00:04 GMT+3 , Processed in 0.057725 sec., 9 queries .

Powered by Discuz! X3.4 Release 20230520

© 2001-2024 Discuz! Team.

MultiLingual version, Rev. 4301, © codersclub.org

Quick Reply To Top Return to the list