Elgg Installation Support :: Blog

I have already made my posting in the Moodle.org site and wanted to make it known in the ELGG (sorry, Eduspaces) site as well that you can indeed install the Moodle/ELGG e-portfolio block for ELGG v0.7 and have it work in Moodle versions 1.7.x and 1.8.

Our production server is running Moodle 1.7+ and will be upgraded to 1.7.2 in the near future.  Our test server is running Moodle 1.8 and with the help of the particpants in this forum, I found all the answers and files I needed to make the e-portfolio block work.  This is very exciting for us, as our teachers (especially in the Arts Dept) are using the portfolio feature to show off the students artwork, almost like a virtual gallery.

Good luck to all who use this integration feature and I hope this helps! 

I'd like to run elgg in Polish :)

Can you tell me what I should do?

Regards,

Greg 

If you downloaded Elgg 0.7 RC1 before this post was made, you'll need to replace /lib/db/mysql.sql with this version. Unfortunately a typo made it into the release, causing some database errors on install.

I have now corrected the release, so if you haven't downloaded it yet, all should be well :)

(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 

Click here for a mod_rewrite primer. The #1 cause of Elgg installation problems is mod_rewrite, which is a part of Apache rather than Elgg. Hopefully this page should help you with any issues you might have. I'll also roll this URL into the INSTALL file for the next Elgg release.

Is there a way to set default friends and default communities for all newly registered members?  It would be nice to include the system admin and all my help communities automatically on new accounts.  This is done here with Ben as a friend.

Can someone point me to directions on how to do this?

I reported the instruction confusion in the features community, but thought I would post my error here:

Friendly URLs do not work on my installation.  There are confused instructions as to where the friendly URL actually is here on ellg.net and on all installs.  On the Account settings page, it says friendly URL is located:

http://elgg.net/home/[yourfriendlyname]/ (this is correct on elgg.net)

But on the submission results page, you get a message that says:

http://elgg.net/~[yourfriendlyname]/ (this is incorrect on elgg.net)

On my installation, neither of these works and both result in a 404.

This is a weird one.  I updated to the latest SVN to hopefully clear up some issues I was having with .673.  Happy to report that it did.  I also love the new look and features.  One issue that remains, it was there when I added the friend icons to the sidebar in .673, is that the friends icons in the sidebar show the wrong person.  Icons everywhere else show up associated properly, but the sidebar images show different people than they should.

Anyone else see this?  Any ideas how to correct?

I have some questions I haven't been able to find answers to by searching this site.  One regarding getting translations to work or removing the option to change languages is the next entry below this one.  Here are some others from a newbie to elgg.

My site is:  http://doggybloggy.com

White page when saving template in _elggadmin/ 

1.  when logging into the admin area, I can see the templates, but when I click save, I get a white page and my changes to the default templates are not saved.  I thought this might be a permissions issue but I tried changing permissions on those files to no effect.  I'm just making changes offline and FTP'ing, which is easier, but maybe the error impacts other functions.

Icons for file uploads don't display and link to picture display results in white page: 

2.  I can upload icons that display but uploads to the file folders do not display.  photos show blank box but are uploaded successfully to the /data folder I have outside my root.  I assume this is a mod_rewrite issue. http://doggybloggy.com/Sassyspace/files/ Clicking on the image or file leads to a blank page.  Interestingly, files other than pictures (ex. text) upload and can be downloaded, though icon doesn't display.  Pictures on the other hand cannot be accessed at all.

How to modify english language definitions: 

3.  Where are the english language files in elgg?  I want to change some of the links around the site, like "resources" which is not appropriate for my userbase.

How to change default icon display size: 

4.  How does one change the default size of the icons that show up by blog posts and in the "me" box?  I'd like to make these a little bigger. 

Tag cloud formatting issue in IE: 

5.  Any ideas why the tag cloud page displays strangely in IE but normally in Firefox?  By strangely, i mean the spacing between the lines is not set in IE at the largest font size in the cloud on that line and thus the lines run over each other.  This is default .673 out of the box.  http://doggybloggy.com/search/tags.php on IE. 

Thanks for any and all assistance.  This system is excellent.

Hi there.  I'm so glad I found this wonderful software.  I did a fresh install on http://doggybloggy.com and receive the following error when I change languages:

 Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /home/doggyblo/public_html/lib/php-getttext/gettext.php on line 252

Very new to elgg so sorry if this is a newbie questions, like maybe gettext isn't enabled on my server.  I searched here and couldn't find it.