Elgg Installation Support :: Blog :: error while setting up mysql tables

(mysql): CREATE TABLE `elggusers` ( `ident` int(10) unsigned NOT NULL auto_increment, `username` varchar(128) NOT NULL default '' COMMENT 'login name', `password` varchar(32) NOT NULL default '', `email` varchar(128) NOT NULL default '', `name` varchar(128) NOT NULL default '' COMMENT 'descriptive name', `icon` int(11) NOT NULL default '-1' COMMENT '-> icons.ident', `active` enum('yes','no') NOT NULL default 'yes', `alias` varchar(128) NOT NULL default '', `code` varchar(32) NOT NULL default '' COMMENT 'auth value for cookied login', `icon_quota` int(11) NOT NULL default '10' COMMENT 'number of icons', `file_quota` int(11) NOT NULL default '1000000000' COMMENT 'bytes', `template_id` int(11) NOT NULL default '-1' COMMENT '-> templates.ident', `owner` int(11) NOT NULL default '-1' COMMENT '-> users.ident, community owner', `user_type` varchar(128) NOT NULL default 'person' COMMENT 'person, community, etc', `moderation` varchar(4) NOT NULL default 'no' COMMENT 'friendship moderation setting', `last_action` int(10) unsigned NOT NULL default '0' COMMENT 'unix timestamp', `template_name` varchar(128) NOT NULL default 'Default_Template' COMMENT '-> templates.shortname' PRIMARY KEY (`ident`), KEY `username` (`username`,`password`,`name`,`active`), KEY `code` (`code`), KEY `icon` (`icon`), KEY `icon_quota` (`icon_quota`), KEY `file_quota` (`file_quota`), KEY `email` (`email`), KEY `template_id` (`template_id`), KEY `community` (`owner`), KEY `user_type` (`user_type`), KEY `moderation` (`moderation`), KEY `last_action` (`last_action`), FULLTEXT KEY `name` (`name`)) TYPE=MyISAM

1064: 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 '(`ident`), KEY `username` (`username`,`password`,`name`,`active`), KEY `code` ' at line 1

            adodb_mysql._execute(CREATE TABLE `elggusers` (  `ident` int(10) unsigned NOT NULL auto_increment,  `username` varchar(128) NOT NULL default '' COMME..., false) % line  889, file: adodb.inc.php
         adodb_mysql.execute(CREATE TABLE `elggusers` (  `ident` int(10) unsigned NOT NULL auto_increment,  `username` varchar(128) NOT NULL default '' COMME...) % line   38, file: datalib.php
      execute_sql(CREATE TABLE `elggusers` (  `ident` int(10) unsigned NOT NULL auto_increment,  `username` varchar(128) NOT NULL default '' COMME...) % line  188, file: datalib.php
   modify_database(/home/enauka/ftp/przestrzenie/lib/db/mysql.sql) % line   27, file: dbsetup.php
require_once(/home/enauka/ftp/przestrzenie/lib/dbsetup.php) % line   50, file: includes.php

Error

(mysql): INSERT INTO `elggusers` VALUES (0, 'news', '5f4dcc3b5aa765d61d8327deb882cf99', '', 'News', -1, 'yes', '', '', 10, 10000000, -1, -1, 'person', 'no', 0)

1146: Table 'enauka_3.elggusers' doesn't exist

            adodb_mysql._execute(INSERT INTO `elggusers` VALUES (0, 'news', '5f4dcc3b5aa765d61d8327deb882cf99', '', 'News', -1, 'yes', '', '', 10, 10000000, -1, ..., false) % line  889, file: adodb.inc.php
         adodb_mysql.execute(INSERT INTO `elggusers` VALUES (0, 'news', '5f4dcc3b5aa765d61d8327deb882cf99', '', 'News', -1, 'yes', '', '', 10, 10000000, -1, ...) % line   38, file: datalib.php
      execute_sql(INSERT INTO `elggusers` VALUES (0, 'news', '5f4dcc3b5aa765d61d8327deb882cf99', '', 'News', -1, 'yes', '', '', 10, 10000000, -1, ...) % line  188, file: datalib.php
   modify_database(/home/enauka/ftp/przestrzenie/lib/db/mysql.sql) % line   27, file: dbsetup.php
require_once(/home/enauka/ftp/przestrzenie/lib/dbsetup.php) % line   50, file: includes.php

Error

(mysql): SHOW TABLES

Error

Error: Main databases NOT set up successfully

What can I do to get this round?

Regards

Greg

Comments

Hi,

There's an issue in 0.7 RC1, which has just been brought to light. I'm correcting the release literally right now, but for now:

1. Empty your database.

2. Place this file in /lib/db/.

3. Load your front page again.

Database setup should now work fine.

Ben Werdmuller on Wednesday, 07 February 2007, 17:22 CET # |
THANKS! it helped :)
Regards.
Greg

Greg Szczotka on Thursday, 08 February 2007, 21:16 CET # |

Hello all

My setup went quite fine, even if i dont know if it will work that way itranslated the rewrite rules to lighttpd webserver cfg format - but thats another isssue

Here i'd like to ask for help with a database table name issue.

Having only dreated the db

I call main url of my site

most tables are fine, but these two have a prefix problem. (prefix is default: elgg)

(mysql): SELECT name FROM elggdatalists WHERE name = 'version'

1146: Table 'elgg.elggdatalists' doesn't exist

            ADOConnection._Execute(SELECT name FROM elggdatalists  WHERE name = 'version' ) % line  870, file: adodb.inc.php
         ADOConnection.Execute(SELECT name FROM elggdatalists  WHERE name = ? , Array[1]) % line 1092, file: datalib.php
      get_field(datalists, name, name, version) % line 3452, file: elgglib.php
   set_config(version, 2007070501) % line   45, file: dbsetup.php
require_once(/var/www/localhost/htdocs/elgg-0.8/lib/dbsetup.php) % line  103, file: includes.php

(mysql): SHOW COLUMNS FROM `elggdatalists`

               ADOConnection._Execute(SHOW COLUMNS FROM `elggdatalists`, false) % line  889, file: adodb.inc.php
            ADOConnection.Execute(SHOW COLUMNS FROM `elggdatalists`) % line  403, file: adodb-mysql.inc.php
         ADODB_mysql.MetaColumns(elggdatalists) % line 1296, file: datalib.php
      insert_record(datalists, Object:stdClass) % line 3457, file: elgglib.php
   set_config(version, 2007070501) % line   45, file: dbsetup.php

And pls tell me how to start a new thread. couldnt figure that out.

tia

florian

Florian Konnertz on Tuesday, 04 September 2007, 09:59 CEST # |