I recently grabbed the Alpha Version of ELMS from the site mentioned in your notes. However, upon installing the 'profile' for ELMS, I get the following errors:

---
[Fri Nov 19 13:25:35 2010] [error] [client 204.185.42.2] PHP Warning: Table 'elms_data.elms_access' doesn't exist\nquery: SELECT 1 FROM elms_access WHERE type = 'host' AND LOWER('204.185.42.2') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /usr/local/www/data/elms/includes/database.mysqli.inc on line 128, referer: http://minion.spg.more.net/elms/install.php?locale=&profile=dump
[Fri Nov 19 13:25:35 2010] [error] [client 204.185.42.2] PHP Warning: Table 'elms_data.elms_users' doesn't exist\nquery: SELECT u.*, s.* FROM elms_users u INNER JOIN elms_sessions s ON u.uid = s.uid WHERE s.sid = '7flnrodmmao70v1ks299tc1533' in /usr/local/www/data/elms/includes/database.mysqli.inc on line 128, referer: http://minion.spg.more.net/elms/install.php?locale=&profile=dump
[Fri Nov 19 13:25:35 2010] [error] [client 204.185.42.2] PHP Warning: Table 'elms_data.elms_cache' doesn't exist\nquery: SELECT data, created, headers, expire, serialized FROM elms_cache WHERE cid = 'variables' in /usr/local/www/data/elms/includes/database.mysqli.inc on line 128, referer: http://minion.spg.more.net/elms/install.php?locale=&profile=dump
[Fri Nov 19 13:25:35 2010] [error] [client 204.185.42.2] PHP Warning: Table 'elms_data.elms_variable' doesn't exist\nquery: SELECT * FROM elms_variable in /usr/local/www/data/elms/includes/database.mysqli.inc on line 128, referer: http://minion.spg.more.net/elms/install.php?locale=&profile=dump
[Fri Nov 19 13:25:35 2010] [error] [client 204.185.42.2] PHP Notice: Undefined variable: variables in /usr/local/www/data/elms/includes/bootstrap.inc on line 558, referer: http://minion.spg.more.net/elms/install.php?locale=&profile=dump
[Fri Nov 19 13:25:35 2010] [error] [client 204.185.42.2] PHP Warning: Table 'elms_data.elms_cache' doesn't exist\nquery: UPDATE elms_cache SET data = '', created = 1290194735, expire = 0, headers = '', serialized = 0 WHERE cid = 'variables' in /usr/local/www/data/elms/includes/database.mysqli.inc on line 128, referer: http://minion.spg.more.net/elms/install.php?locale=&profile=dump
[Fri Nov 19 13:25:35 2010] [error] [client 204.185.42.2] PHP Notice: Undefined variable: variables in /usr/local/www/data/elms/includes/bootstrap.inc on line 565, referer: http://minion.spg.more.net/elms/install.php?locale=&profile=dump
[Fri Nov 19 13:25:35 2010] [error] [client 204.185.42.2] PHP Warning: Table 'elms_data.elms_system' doesn't exist\nquery: SELECT name, filename, throttle FROM elms_system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /usr/local/www/data/elms/includes/database.mysqli.inc on line 128, referer: http://minion.spg.more.net/elms/install.php?locale=&profile=dump
[Fri Nov 19 13:25:35 2010] [error] [client 204.185.42.2] PHP Warning: Table 'elms_data.elms_url_alias' doesn't exist\nquery: SELECT COUNT(pid) FROM elms_url_alias in /usr/local/www/data/elms/includes/database.mysqli.inc on line 128, referer: http://minion.spg.more.net/elms/install.php?locale=&profile=dump
---

Using the normal Drupal installation, everything appears to work fine. I just wanted to see what the proposed 'profile' installation actually looked like however.

Thanks,
Jason Cameron

Comments

cameronjb’s picture

PS: This is a brand new installation with a clean database. I have no idea why the profile would not be able to find these database tables.

cameronjb’s picture

Priority: Critical » Minor

A little debugging: Your profile apparently does not take kindly to the database 'prefix' that can be set in the Drupal installation. You may want to take a look into that, as I got it to work without a prefix.

btopro’s picture

Priority: Minor » Normal
Status: Active » Postponed

correct, the current version won't work with prefixing. It's using an incorrect way of making sustainable distros (large reason why it's alpha1) based on a technique mentioned by lullabot. Did this to get something out the door for discussion, future builds (at least once out of alpha) won't have this issue.

johnflyersmith’s picture

Component: Code » User interface

I had no trouble installing. However, after leaving to Assignment Studio, it goes to syllabus and no other page. I can delete the database and reinstall to get back to square one. I have tryed activating just the modules to use Assignment Studio with no luck. Any sugestions?

btopro’s picture

do you have a screenshot of this behavior? the open studio does alter the theme / primary menu so you have to hit back to course. but u should still be able to get to the rest of the site

johnflyersmith’s picture

StatusFileSize
new426.32 KB

Thanks, This is the screen shot. Hitting back goes to 'webpage has expired'. The fact that it changes theme / primary menu sujest to me that I have missed something in setup.

btopro’s picture

that page looks correct to me, you're saying that it doesn't do anything after the fact? is this on apache or IIS cause it's untested on IIS

johnflyersmith’s picture

apache on win7 ( is what they want me to use on my dev machine. So I know win7 ) the production machine is SUSE Linux. Do clean URLs need to be active?

btopro’s picture

ahhh, install profile most likely has clean URLs turned on by default; there's a good chance that's it or a big part of it

johnflyersmith’s picture

I've just added the rewrite mod to apache, it works. I will reinstall and try again.

johnflyersmith’s picture

Clean URLs fixed the Problem. Thanks for your time and help.

btopro’s picture

Status: Postponed » Fixed

excellent, I'll add it to the documentation

johnflyersmith’s picture

Status: Needs work » Active

Hi,

One more problem, Creating rubric has no title field and needs one to save. I can't seem to even find a clue on google.

attached is a pic of screen and after save screen.

btopro’s picture

Status: Fixed » Needs work

don't see a picture. Rubrics were kind of included as an afterthought in this distribution. We use them in courses in full production but there are no plans to bundle this in the distribution at this time

johnflyersmith’s picture

Status: Active » Needs work
StatusFileSize
new42.4 KB

Update: it seems to be in the Chamfer theme, I changed themes and every thing shows. Also this seems to be more of a Drupal bug, as I searched for missing fields (genericly) and found other modules have the same problem.

I'm trying to resend pic.

btopro’s picture

Interesting, what browser are you using?

johnflyersmith’s picture

IE 8, I wll try others.

btopro’s picture

Version: 5.x-1.x-dev » 6.x-1.0-alpha3
Status: Needs work » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

petermayerla’s picture

Assigned: Unassigned » petermayerla
Category: bug » support
Status: Closed (fixed) » Active
StatusFileSize
new155.89 KB
new317.63 KB

Hello, I get the following message when I try to install ELMS from Alpha-1

Failed to create a test table on your MySQL database server with the command CREATE TABLE drupal_install_test (id int NULL). MySQL reports the following message: Table 'drupal_install_test' already exists.
Are you sure the configured username has the necessary MySQL permissions to create tables in the database?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.

Before this message came I got a timeout message and after refreshing the browser I got the message that the content in the database already exists.

Can I just say drop table in the database?

Thanks,
Peter

btopro’s picture

Version: 6.x-1.0-alpha3 » 6.x-1.0-alpha4

Did you try upgrading from Alpha 1 to alpha 4? There are no upgrade paths currently for elms distributions as they are point releases. You need to install the distribution in a fresh location with a fresh database. Alpha 1 2 and 3 are not supported, once we move into a beta release we'll be able to support upgrades between versions but as there are significant platform changes between versions right now there is no way of doing this.

btopro’s picture

Version: 6.x-1.0-alpha4 » 6.x-1.0-alpha5
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.