ATutor

Learning Management Tools


  1. Home



Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


Table ATconfig creation failed



  • 2009-08-04 13:44:49

    Table ATconfig creation failed

    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.


  • 2009-08-04 14:05:14

    Re: Table AT_config creation failed.

    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.


  • 2009-08-04 14:18:33

    Re: Table AT_config creation failed.

    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


  • 2009-08-04 15:37:35

    Update: Table AT_config creation failed.

    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


  • 2009-08-04 15:38:31

    Re: Update: Table AT_config creation failed.

    2 more error files


  • 2009-08-04 15:39:00

    Re: Update: Table AT_config creation failed.

    one more file


  • 2009-08-04 15:40:17

    Re: Update: Table AT_config creation failed.

    Did you change browsers?


  • 2009-08-04 16:39:16

    Re: Update: Table AT_config creation failed.

    Browsers were changed - used FF latest release


  • 2009-08-04 17:29:21

    Re: Update: Table AT_config creation failed.

    The error log suggests it's quitting when it can't find mbstring. Get mbstring working as harris suggests, and try again.

    http://www.atutor.ca/view/7/18244/1.html


  • 2009-08-05 15:11:32

    Re: Update: Table AT_config creation failed.

    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


  • 2009-08-17 15:56:20

    Re: Update: Table AT_config creation failed.

    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.


  • 2009-08-23 13:02:48

    Re: Update: Table AT_config creation failed.

    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


  • 2009-08-23 13:50:26

    Re: Update: Table AT_config creation failed.

    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;

    [/php]


    To

    [php]


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

    [/php]


    removing "default ''"


  • 2009-08-23 15:59:33

    Re: Update: Table AT_config creation failed.

    It solved the problem (at least for me). Thanks