Jump to ContentJump to Navigation/Login
` ` ` ` ` `

Login
[Register]

Subscribe to Updates

Occasional ATutor release updates


Services

Members Online

No Members Logged In

(9 guests in past 15 min.)

Web Accessibility Course

Access Understanding Web Accessibility to learn about accessibility, or Register to take the course for FREE.

IMS Certified

IMS Global Certified

Home > Forums > ATutor Support > Table AT config creation failed.

Support Forums

ATutor Support

Table AT_config creation failed.


You must be signed-in to post.

AuthorSubject
  Page: 1
tarheelgeek

Avatar for tarheelgeek
Subject: Table AT_config creation failed.Quote this post in your reply
Operating system ATutor is installed on - XP SP3
ATutor version -1.6.3
Patch #s applied -none
PHP version - 5.2
MySQL version - 5.0
Webserver & version - Apache 2.2
Copies of error messages - Table AT_config creation failed.

Changes to default settings - none - can't install
Web browser being used -

I am doing new install and can't get past Database setup.

I get all created except for Table AT_config creation failed.
Posted: 2009-08-04 13:44:49
greg

Avatar for greg
Subject: Re: Table AT_config creation failed.Quote this post in your reply
We've heard this one a few times. It seems to occurs on some systems using IE7, though not others.

You best bet is to try a different browser. We recommend a current FireFox, though IE8 seems to be fine as well.

Also be aware there have been issues with downloads from Sourceforge. You might try a fresh download. Then reinstall with FF.
Posted: 2009-08-04 14:05:14
tarheelgeek

Avatar for tarheelgeek
Subject: Re: Table AT_config creation failed.Quote this post in your reply
Thank you Greg, you have been a patient champ with me today.

I appreciate it.

I'll try those things and let you know.

Tarheelgeek
Posted: 2009-08-04 14:18:33
tarheelgeek

Avatar for tarheelgeek
errors.txt 		Subject: Update: Table AT_config creation failed.Quote this post in your reply
Update:

I redownloaded distribution and reinstalled.

I have attaced some error files so you can see if anything is unusual.

Still cannot create AT_config table

tarheelgeek
Posted: 2009-08-04 15:37:35
tarheelgeek

Avatar for tarheelgeek
error.log

Attachment: error.log 		Subject: Re: Update: Table AT_config creation failed.Quote this post in your reply
2 more error files
Posted: 2009-08-04 15:38:31
tarheelgeek

Avatar for tarheelgeek
access.log

Attachment: access.log 		Subject: Re: Update: Table AT_config creation failed.Quote this post in your reply
one more file
Posted: 2009-08-04 15:39:00
greg

Avatar for greg
Subject: Re: Update: Table AT_config creation failed.Quote this post in your reply
Did you change browsers?
Posted: 2009-08-04 15:40:17
tarheelgeek

Avatar for tarheelgeek
Subject: Re: Update: Table AT_config creation failed.Quote this post in your reply
Browsers were changed - used FF latest release
Posted: 2009-08-04 16:39:16
greg

Avatar for greg
Subject: Re: Update: Table AT_config creation failed.Quote this post in your reply
The error log suggests it's quitting when it can't find mbstring. Get mbstring working as harris suggests, and try again.

www.atutor.ca/view/7/18244/1.html
Posted: 2009-08-04 17:29:21
tarheelgeek

Avatar for tarheelgeek
Subject: Re: Update: Table AT_config creation failed.Quote this post in your reply
Operating system ATutor is installed on - XP SP3
ATutor version -1.6.3
Patch #s applied -none
PHP version - 5.2.10
MySQL version - 5.0.51a
Webserver & version - Apache 2.2.8
Copies of error messages - Table AT_config creation failed.

Got the mbstrings issue resolved and tried a clean install and I still get:

Error
Table AT_config creation failed.

I have tried multiple downloads and installs - fixed anything I thought might get in the way but nothing has worked.

Any ideas????

Tarheelgeek
Posted: 2009-08-05 15:11:32
greg

Avatar for greg
Subject: Re: Update: Table AT_config creation failed.Quote this post in your reply
It could be a windows thing. Though we haven't been able to reproduce this problem ourselves on a windows system. Linux generally provide a better environment for running PHP applications. If you have one at your disposal, I'd suggest using it.

Does installer create the other tables prior to the config table?

As a last resort you could try running the install/db/atutor_schema.sql file manually at the command prompt or perhaps an app like phpMyAdmin.

You can also take another look at the server's error log and see if it tells you any more.
Posted: 2009-08-17 15:56:20
NineteenHockey
Subject: Re: Update: Table AT_config creation failed.Quote this post in your reply
Hello. Maybe that helps. I can't create AT_config table too. And when I tried to do that manually using a query from atutor_schema.sql I got this:

mysql> CREATE TABLE `config` ( `name` CHAR( 30 ) NOT NULL default '', `value`
TEXT NOT NULL default '', PRIMARY KEY ( `name` )) TYPE = MYISAM;

ERROR 1101 (42000): BLOB/TEXT column 'value' can't have a default value

I'm using Windows XP and MySQL version 5.0.67-community-nt
Posted: 2009-08-23 13:02:48
greg

Avatar for greg
Subject: Re: Update: Table AT_config creation failed.Quote this post in your reply
Before you install, edit the install/db/atutor_schema.sql file:

change



<?php


CREATE TABLE `config` (
  `name` CHAR( 30 ) NOT NULL default '',
  `value` TEXT NOT NULL,
  PRIMARY KEY ( `name` )
) TYPE = MYISAM;
?>


To


<?php


CREATE TABLE `config` (
  `name` CHAR( 30 ) NOT NULL,
  `value` TEXT NOT NULL,
  PRIMARY KEY ( `name` )
) TYPE = MYISAM;
?>


removing "default ''"
Posted: 2009-08-23 13:50:26
NineteenHockey
Subject: Re: Update: Table AT_config creation failed.Quote this post in your reply
It solved the problem (at least for me). Thanks
Posted: 2009-08-23 15:59:33
 Page: 1

You must be signed-in to post.