[solved (hopefully)] error creating tables

[solved (hopefully)] error creating tables

Postby wudu on Tue Aug 23, 2011 12:14 pm

Hi,
on step3 I get the following error:
There was an error creating the tables in the database. Please make sure that the user chosen to connect to the database has enough permissions to create tables.

Error creating table articles: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, modification_date TIMESTAMP(14) NOT NULL, user_id ' at line 3
Error creating table articles_categories: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, in_main_page TINYINT(1) NOT NULL DEFAULT 1, parent_id' at line 6
Error creating table articles_comments: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, user_id INTEGER(10) DEFAULT 0, user_email ' at line 7
Error creating table articles_notifications: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Error creating table blogs: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, last_update_date TIMESTAMP(14) NOT NULL, num_posts ' at line 11
Error creating table mylinks: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, properties TEXT NOT NULL, PRIMARY ' at line 9
Error creating table mylinks_categories: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, properties TEXT NOT NULL, num_links ' at line 5
Error creating table permissions: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8
Error creating table referers: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), PRIMARY KEY (id) ) TYPE=MyISAM' at line 7
Error creating table users: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), PRIMARY KEY (id) ) TYPE=MyISAM' at line 12
Error creating table users_permissions: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Table tmp_users_permissions created successfully.
Error creating table config: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6
Error creating table filtered_content: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM' at line 6
Error creating table host_blocking_rules: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, blog_id INTEGER(10) NOT NULL DEFAULT 0, block_ty' at line 4
Error creating table gallery_resources: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, flags INTEGER(10) DEFAULT 0, resource_type ' at line 6
Error creating table gallery_albums: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, properties TEXT NOT NULL, show_album ' at line 8
Error creating table bayesian_filter_info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Error creating table bayesian_tokens: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
Error creating table article_categories_link: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 5
Error creating table custom_fields_definition: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), searchable TINYINT(1) DEFAULT 1, hidden TI' at line 8
Error creating table custom_fields_values: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
Error creating table articles_text: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error creating table phpbb2_users: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error creating table blog_categories: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error creating table global_articles_categories: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10


I found that newer mysql versions (>5.0) need ENGINE=MyISAM instead of TYPE=MyISAM. After changing that in dbschemas.properties.php I get this errors:
There was an error creating the tables in the database. Please make sure that the user chosen to connect to the database has enough permissions to create tables.

Error creating table articles: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, modification_date TIMESTAMP(14) NOT NULL, user_id ' at line 3
Error creating table articles_categories: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, in_main_page TINYINT(1) NOT NULL DEFAULT 1, parent_id' at line 6
Error creating table articles_comments: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, user_id INTEGER(10) DEFAULT 0, user_email ' at line 7
Table articles_notifications created successfully.
Error creating table blogs: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, last_update_date TIMESTAMP(14) NOT NULL, num_posts ' at line 11
Error creating table mylinks: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, properties TEXT NOT NULL, PRIMARY ' at line 9
Error creating table mylinks_categories: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, properties TEXT NOT NULL, num_links ' at line 5
Table permissions created successfully.
Error creating table referers: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), PRIMARY KEY (id) ) ENGINE=MyISAM' at line 7
Error creating table users: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), PRIMARY KEY (id) ) ENGINE=MyISAM' at line 12
Table users_permissions created successfully.
Error creating table tmp_users_permissions: Table 'tmp_users_permissions' already exists
Table config created successfully.
Error creating table filtered_content: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM' at line 6
Error creating table host_blocking_rules: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, blog_id INTEGER(10) NOT NULL DEFAULT 0, block_ty' at line 4
Error creating table gallery_resources: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, flags INTEGER(10) DEFAULT 0, resource_type ' at line 6
Error creating table gallery_albums: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, properties TEXT NOT NULL, show_album ' at line 8
Table bayesian_filter_info created successfully.
Table bayesian_tokens created successfully.
Table article_categories_link created successfully.
Error creating table custom_fields_definition: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), searchable TINYINT(1) DEFAULT 1, hidden TI' at line 8
Table custom_fields_values created successfully.
Table articles_text created successfully.
Table phpbb2_users created successfully.
Table blog_categories created successfully.
Table global_articles_categories created successfully.


I think this is a mysql version issue.
My mysql version is 5.5.15
Unfortunately I am no mysql-guru and I can't use a older mysql version due to a forum installation.

I hope there is someone out there who can help me.
Thanks in advance.
Last edited by wudu on Wed Aug 24, 2011 8:24 am, edited 1 time in total.
wudu
 
Posts: 4
Joined: Tue Aug 23, 2011 11:46 am
LifeType Version: 1.2.11

Re: error creating tables

Postby wudu on Wed Aug 24, 2011 4:09 am

In every line with an error the script tries to create a field dor a date.
As data type it tries to use T? (every error line contains T(14)).
I created all kinds of fields in webmin and there's no datatype shortened with T.
So I tried all with () in it and so I can install lifetype but the date is schown wrong on posts.
What data type uses lifetime for all the date fields?
wudu
 
Posts: 4
Joined: Tue Aug 23, 2011 11:46 am
LifeType Version: 1.2.11

Re: error creating tables

Postby wudu on Wed Aug 24, 2011 8:24 am

I tried INT before but not BIGINT. I think INT doesn't work because of the algebraic sign position.
Dates are shown correctly with BIGINT(14). I don't know if this is correct, pehaps anyone could tell me.

Thats my new dbschemas.properties.php, perhaps it helps someone in the future:
Code: Select all
<?php

$Tables["articles"]["schema"] = "
  id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
  date BIGINT(14) NOTNULL,
  modification_date BIGINT(14) NOTNULL,
  user_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  status I(5) NOTNULL DEFAULT 1,
  num_reads I(10) DEFAULT '0',
  properties TEXT NOTNULL DEFAULT '',
  slug C(255) NOTNULL DEFAULT '',
  num_comments I(10) NOTNULL DEFAULT '0',
  num_nonspam_comments I(10) NOTNULL DEFAULT '0',
  num_trackbacks I(10) NOTNULL DEFAULT '0',
  num_nonspam_trackbacks I(10) NOTNULL DEFAULT '0',
  global_category_id I(10) NOTNULL DEFAULT '0',
  in_summary_page I1(1) NOTNULL DEFAULT '1',
  INDEX num_reads (num_reads),
  INDEX user_id (user_id),
  INDEX slug (slug),
  INDEX blog_id_status_date (blog_id, status, date),
  INDEX global_category_status (global_category_id, status),
  INDEX date(date)
";
$Tables["articles"]["options"] = "ENGINE=MyISAM";

$Tables["articles_categories"]["schema"] = "
  id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
  name C(255) NOTNULL DEFAULT '',
  url C(255) NOTNULL DEFAULT '',
  blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  last_modification BIGINT(14) NOTNULL,
  in_main_page I1(1) NOTNULL DEFAULT '1',
  parent_id I(10) NOTNULL DEFAULT '0',
  description TEXT NOTNULL DEFAULT '',
  properties TEXT NOTNULL DEFAULT '',
  mangled_name C(255) NOTNULL DEFAULT '',
  num_articles I(10) NOTNULL DEFAULT 0,
  num_published_articles I(10) NOTNULL DEFAULT 0
  INDEX parent_id (parent_id),
  INDEX blog_id (blog_id),
  INDEX mangled_name (mangled_name)
";
$Tables["articles_categories"]["options"] = "ENGINE=MyISAM";


$Tables["articles_comments"]["schema"] = "
  id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
  article_id I(10) UNSIGNED NOTNULL DEFAULT 0,
  blog_id I(10) UNSIGNED NOTNULL DEFAULT 0,
  topic TEXT NOTNULL,
  text X,
  date BIGINT(14) NOTNULL,
  user_id I(10) DEFAULT '0',
  user_email C(255) DEFAULT '',
  user_url C(255) DEFAULT '',
  user_name C(255) NOTNULL DEFAULT Anonymous,
  parent_id I(10) UNSIGNED DEFAULT '0',
  client_ip varchar(15) DEFAULT 0.0.0.0,
  send_notification I1(1) DEFAULT '0',
  status I1(2) DEFAULT '1',
  spam_rate float DEFAULT '0',
  properties TEXT NOTNULL DEFAULT '',
  normalized_text TEXT NOTNULL DEFAULT '',
  normalized_topic TEXT NOTNULL DEFAULT '',
  type I(3) NOTNULL DEFAULT '1',
  INDEX parent_id (parent_id),
  INDEX article_id_blog_id(article_id,blog_id),
  INDEX article_id_type(article_id,type), 
  INDEX blog_id_type(blog_id,type),
  FULLTEXT normalized_fields (normalized_text,normalized_topic),
  FULLTEXT normalized_text (normalized_text),
  FULLTEXT normalized_topic (normalized_topic)
";
$Tables["articles_comments"]["options"] = "ENGINE=MyISAM";

$Tables["articles_notifications"]["schema"] = "
  id I(10) NOTNULL AUTOINCREMENT PRIMARY,
  blog_id I(10) NOTNULL DEFAULT '0',
  user_id I(10) NOTNULL DEFAULT '0',
  article_id I(10) NOTNULL DEFAULT '0',
  INDEX article_id (article_id),
  INDEX user_id (user_id),
  INDEX blog_id (blog_id)
";
$Tables["articles_notifications"]["options"] = "ENGINE=MyISAM";

$Tables["blogs"]["schema"] = "
  id I(10) UNSIGNED NOTNULL AUTOINCREMENT INDEX PRIMARY,
  blog varchar(50) NOTNULL DEFAULT '',
  owner_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  blog_category_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  about X,
  settings TEXT NOTNULL,
  mangled_blog varchar(50) NOTNULL DEFAULT '',
  status I(4) NOTNULL DEFAULT '1',
  show_in_summary I(4) NOTNULL DEFAULT '1',
  create_date BIGINT(14) NOTNULL,
  last_update_date BIGINT(14) NOTNULL,
  num_posts I(10) NOTNULL DEFAULT '0',
  num_comments I(10) NOTNULL DEFAULT '0',
  num_trackbacks I(10) NOTNULL DEFAULT '0',
  custom_domain C(50),
  INDEX owner_id (owner_id),
  INDEX mangled_blog (mangled_blog),
  INDEX blog_category_id(blog_category_id),
  INDEX custom_domain(custom_domain),
  INDEX create_date(create_date)
";
$Tables["blogs"]["options"] = "ENGINE=MyISAM";

$Tables["mylinks"]["schema"] = "
  id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
  category_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  url C(255) NOTNULL DEFAULT '',
  name varchar(100) DEFAULT '',
  description TEXT NOTNULL,
  blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  rss_feed C(255) NOTNULL DEFAULT '',
  date BIGINT(14) NOTNULL,
  properties TEXT NOTNULL DEFAULT '',
  INDEX blog_id (blog_id),
  INDEX category_id (category_id)
";
$Tables["mylinks"]["options"] = "ENGINE=MyISAM";

$Tables["mylinks_categories"]["schema"] = "
  id I(10) NOTNULL AUTOINCREMENT PRIMARY,
  name varchar(100) NOTNULL DEFAULT '',
  blog_id I(10) NOTNULL DEFAULT '0',
  last_modification BIGINT(14) NOTNULL,
  properties TEXT NOTNULL DEFAULT '',
  num_links I(10) NOTNULL DEFAULT '0',
  INDEX blog_id (blog_id)
";
$Tables["mylinks_categories"]["options"] = "ENGINE=MyISAM";

$Tables["permissions"]["schema"] = "
  id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
  permission varchar(25) NOTNULL DEFAULT '',
  description varchar(100) NOTNULL DEFAULT '',
  admin_only I(1) NOTNULL DEFAULT '1',
  core_perm I(1) NOTNULL DEFAULT '1'
";
$Tables["permissions"]["options"] = "ENGINE=MyISAM";

$Tables["referers"]["schema"] = "
  id I(10) NOTNULL AUTOINCREMENT PRIMARY,
  url TEXT NOTNULL,
  article_id I(10) NOTNULL DEFAULT '0',
  blog_id I(10) NOTNULL DEFAULT '0',
  hits I(10) DEFAULT '1',
  last_date BIGINT(14),
  INDEX article_id (article_id),
  INDEX blog_id_article_id (blog_id, article_id)
";
$Tables["referers"]["options"] = "ENGINE=MyISAM";

$Tables["users"]["schema"] = "
  id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
  user varchar(15) NOTNULL DEFAULT '',
  password varchar(32) NOTNULL DEFAULT '',
  email C(255) NOTNULL DEFAULT '',
  full_name C(255) NOTNULL DEFAULT '',
  about X,
  properties TEXT NOTNULL DEFAULT '',
  status I(4) NOTNULL DEFAULT 1,
  resource_picture_id I(10) NOTNULL DEFAULT 0,
  site_admin I(10) NOTNULL DEFAULT '0',
  last_login BIGINT(14),
  UNIQUE user (user)
";
$Tables["users"]["options"] = "ENGINE=MyISAM";

$Tables["users_permissions"]["schema"] = "
  id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
  user_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  permission_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  INDEX blog_id (blog_id),
  INDEX user_id_permission_id (user_id,permission_id)
";
$Tables["users_permissions"]["options"] = "ENGINE=MyISAM";

//
// temporary table only used during the upgrade process, will be dropped at the end of it
//
$Tables["tmp_users_permissions"]["schema"] = "
  id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
  user_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  permission_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  INDEX blog_id (blog_id),
  INDEX user_id_permission_id (user_id,permission_id)
";
$Tables["users_permissions"]["options"] = "ENGINE=MyISAM";

$Tables["config"]["schema"] = "
   config_key C(255) NOTNULL DEFAULT '' PRIMARY,
   config_value TEXT NOTNULL,
   value_type I(3) DEFAULT '0'
";
$Tables["config"]["options"] = "ENGINE=MyISAM";

$Tables["filtered_content"]["schema"] = "
   id I(10) NOTNULL AUTOINCREMENT PRIMARY,
   reg_exp X,
   blog_id I(10) NOTNULL DEFAULT '0',
   reason X,
   date BIGINT(14) NOTNULL,
   INDEX blog_id (blog_id)
";
$Tables["filtered_content"]["options"] = "ENGINE=MyISAM";

$Tables["host_blocking_rules"]["schema"] = "
   id I(10) NOTNULL AUTOINCREMENT PRIMARY,
   reason X,
   date BIGINT(14) NOTNULL,
   blog_id I(10) NOTNULL DEFAULT '0',
   block_type I(1) DEFAULT '1',
   list_type I(1) DEFAULT '1',
   mask I(2) DEFAULT '0',
   host varchar(15) DEFAULT '0.0.0.0',
   INDEX block_type (block_type),
   INDEX blog_id_block_type(blog_id, block_type)
";
$Tables["host_blocking_rules"]["options"] = "ENGINE=MyISAM";

$Tables["gallery_resources"]["schema"] = "
   id I(10) NOTNULL AUTOINCREMENT PRIMARY,
   owner_id I(10) NOTNULL DEFAULT '0',
   album_id I(10) NOTNULL DEFAULT '0',
   description X,
   date BIGINT(14) NOTNULL,
   flags I(10) DEFAULT '0',
   resource_type I(3) DEFAULT NULL,
   file_path C(255) DEFAULT '',
   file_name C(255) DEFAULT '',
   file_size I(20) NOTNULL DEFAULT 0,
   metadata X,
   thumbnail_format varchar(4) NOTNULL DEFAULT 'same',
   normalized_description TEXT NOTNULL DEFAULT '',
   properties TEXT NOTNULL DEFAULT '',
   INDEX owner_id (owner_id),
   INDEX file_name (file_name),
   INDEX album_id_owner_id (album_id, owner_id),
   INDEX resource_type (resource_type),
   FULLTEXT normalized_description (normalized_description)
";
$Tables["gallery_resources"]["options"] = "ENGINE=MyISAM";

$Tables["gallery_albums"]["schema"] = "
   id I(10) NOTNULL AUTOINCREMENT PRIMARY,
   owner_id I(10) NOTNULL DEFAULT '0',
   description TEXT NOTNULL,
   name C(255) NOTNULL DEFAULT '',
   flags I(10) NOTNULL DEFAULT '0',
   parent_id I(10) NOTNULL DEFAULT '0',
   date BIGINT(14) NOTNULL,
   properties TEXT NOTNULL DEFAULT '',
   show_album I1(1) DEFAULT 1,
   normalized_description TEXT NOTNULL DEFAULT '',
   normalized_name C(255) NOTNULL DEFAULT '',
   mangled_name C(255) NOTNULL DEFAULT '',
   num_resources I(10) NOTNULL DEFAULT '0',
   num_children I(10) NOTNULL DEFAULT '0',
   INDEX parent_id (parent_id),
   INDEX mangled_name (mangled_name),
   INDEX owner_id_mangled_name (owner_id, mangled_name),
   FULLTEXT normalized_name (normalized_name),
   FULLTEXT normalized_description (normalized_description),
   FULLTEXT normalized_fields (normalized_name, normalized_description)
";
$Tables["gallery_albums"]["options"] = "ENGINE=MyISAM";

$Tables["bayesian_filter_info"]["schema"] = "
   id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
   blog_id I(10) UNSIGNED DEFAULT NULL,
   total_spam I(10) UNSIGNED DEFAULT NULL,
   total_nonspam I(10) UNSIGNED DEFAULT NULL,
   INDEX blog_id (blog_id)
";
$Tables["bayesian_filter_info"]["options"] = "ENGINE=MyISAM";

$Tables["bayesian_tokens"]["schema"] = "
   id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
   blog_id I(10) UNSIGNED DEFAULT NULL,
   token char(100) DEFAULT NULL,
   spam_occurrences I(10) UNSIGNED DEFAULT NULL,
   nonspam_occurrences I(10) UNSIGNED DEFAULT NULL,
   prob F DEFAULT NULL,
   INDEX blog_id (blog_id),
   INDEX token (token)
";
$Tables["bayesian_tokens"]["options"] = "ENGINE=MyISAM";

$Tables["article_categories_link"]["schema"] = "
   article_id I(10) NOTNULL PRIMARY,
   category_id I(10) NOTNULL PRIMARY
";
$Tables["article_categories_link"]["options"] = "ENGINE=MyISAM";

$Tables["custom_fields_definition"]["schema"] = "
   id I(10) NOTNULL AUTOINCREMENT PRIMARY,
   field_name C(255) NOTNULL DEFAULT '' PRIMARY,
   field_description TEXT NOTNULL,
   field_type I(2) NOTNULL DEFAULT '1',
   field_values TEXT NOTNULL DEFAULT '',
   blog_id I(10) NOTNULL DEFAULT '0',
   date BIGINT(14),
   searchable I1(1) DEFAULT 1,
   hidden I1(1) DEFAULT 1,
   INDEX blog_id (blog_id)
";
$Tables["custom_fields_definition"]["options"] = "ENGINE=MyISAM";

$Tables["custom_fields_values"]["schema"] = "
   id I(10) NOTNULL AUTOINCREMENT PRIMARY,
   field_id I(10) NOTNULL DEFAULT '0',
   field_value TEXT NOTNULL,
   normalized_value TEXT NOTNULL,
   blog_id I(10) DEFAULT NULL,
   article_id I(10) DEFAULT NULL,
   FULLTEXT normalized_value (normalized_value),
   INDEX article_id (article_id),
   INDEX field_id (field_id),
   INDEX blog_id_article_id (blog_id, article_id)
";
$Tables["custom_fields_values"]["options"] = "ENGINE=MyISAM";

$Tables["articles_text"]["schema"] = "
   id I(10) NOTNULL AUTOINCREMENT PRIMARY,
   article_id I(10) NOTNULL DEFAULT 0,
   text TEXT NOTNULL DEFAULT '',
   topic TEXT NOTNULL DEFAULT '',
   normalized_text TEXT NOTNULL DEFAULT '',
   normalized_topic TEXT NOTNULL DEFAULT '',
   mangled_topic TEXT NOTNULL,
   INDEX article_id (article_id),
   FULLTEXT normalized_text (normalized_text),
   FULLTEXT normalized_topic (normalized_topic),
   FULLTEXT normalized_fields (normalized_text, normalized_topic)
";
$Tables["articles_text"]["options"] = "ENGINE=MyISAM";
   
$Tables["phpbb2_users"]["schema"] = "
   id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
   phpbb_id I(10) UNSIGNED NOTNULL,
   full_name C(255) NOTNULL DEFAULT '',
   about X,
   properties TEXT NOTNULL DEFAULT '',
   resource_picture_id I(10) NOTNULL DEFAULT 0,
   status I(10) NOTNULL DEFAULT 0,
   UNIQUE phpbb_id(phpbb_id)
";
$Tables["phpbb2_users"]["options"] = "ENGINE=MyISAM";
   
$Tables["blog_categories"]["schema"] = "
   id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
   name C(255) NOTNULL DEFAULT '',
   description C(255) NOTNULL DEFAULT '',
   mangled_name C(255) NOTNULL DEFAULT '',
   properties TEXT NOTNULL DEFAULT '',
   num_blogs I(10) NOTNULL DEFAULT '0',
   num_active_blogs I(10) NOTNULL DEFAULT '0',
   INDEX mangled_name(mangled_name)
";
$Tables["blog_categories"]["options"] = "ENGINE=MyISAM";
   
$Tables["global_articles_categories"]["schema"] = "
   id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
   name C(255) NOTNULL DEFAULT '',
   description C(255) NOTNULL DEFAULT '',
   mangled_name C(255) NOTNULL DEFAULT '',
   properties TEXT NOTNULL DEFAULT '',
   num_articles I(10) NOTNULL DEFAULT '0',
   num_active_articles I(10) NOTNULL DEFAULT '0',
   INDEX mangled_name(mangled_name)
";
$Tables["global_articles_categories"]["options"] = "ENGINE=MyISAM";

?>
wudu
 
Posts: 4
Joined: Tue Aug 23, 2011 11:46 am
LifeType Version: 1.2.11

Re: [solved (hopefully)] error creating tables

Postby jondaley on Fri Sep 02, 2011 11:39 am

Hrm, that doesn't sound good. I run mysql 5.1 for my own blog, though I need to get around to upgrading things; I got behind a while back, and never got around to going to the next distribution version.

BIGINT doesn't sound like the one you want - there must be a new data type that is appropriate for timestamps.
jondaley
Lifetype Expert
 
Posts: 6169
Joined: Thu May 20, 2004 6:19 pm
Location: Pittsburgh, PA, USA
LifeType Version: 1.2.11 devel branch


Return to Configuration and Installation

cron