Date index for Apr 2004


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Database tables not created and session.save_path problems



Hello, 

I tried installing Achievo 1.0.4, and have some problems with the database
installation. The installation (setup.php) seems to work fine, but when I
create a security profile and thus is about to assign access rights to it I
get the following error messages: 

error: [+00.03863s] Table 'achievo_1_0.access' doesn't exist (errno: 1146)
error: [+00.03872s] Invalid SQL: SELECT * FROM access WHERE entity='1'
error: [+00.04684s] Table 'achievo_1_0.access' doesn't exist (errno: 1146)
error: [+00.04690s] Invalid SQL: SELECT DISTINCT node, action FROM access
WHERE entity IN ('-1')

For some reason the access table is not created by setup.php. When I
realized what the problem was I tried dropping the database and reinstall
it, but it did not help. I then tried giving the database user all
privileges, dropping and reinstalling, but the result was the same. Can I
create the access table manually? If so, what should the contents be? 

I have also encountered the problem mentioned in section 1.2 of the FAQ "(No
such file or directory
...\achievo-1.0.4\atk\session\class.atksessionmanager.inc (line 17))",
although session.save_path points to the correct directory and as far as I
can determine the webserver does have read and write access to the
directory. (Is there any way to actually test this?) It seems to me Achievo
tries to "... open(/tmp\sess_e67...", but the session.save_path I?ve set in
php.ini is not /tmp but a Windows directory. Any ideas? 

I am using Apache 2.0.49, PHP 4.3.5 and MySQL 4.0.18 on Windows XP. 

            Regards, 

                        Helena

P.S. According to the list archives it seems there were similar database
problems with the pre-1.0 versions of Achievo, but the solutions do not seem
to apply. 


http://www.achievo.org/lists achievo.org - ©1999-2002 ibuildings.nl BV