| Author |
Message |
Ebbo
Joined: 13 Apr 2006
Posts: 6
|
 Posted: 13 Apr 2006 - 5:30 pm Post subject:
 Solved: No entry in be_users iss created
|
 |
|
I've installed Typo3 4.0 on a fresh Win2003, Apache 2, PHP 5 and MySQL Server.
The install (including IM,....) works without errors.
MySQL works fine (Tables are created, the Dump in static_template iss loaded)
BUT *did you think everything is fine? =)*
There iss no user/group being created in my Database.
I tried to add the User manually over the Install Tool under DB Analyzer, he says that the User is created, but there is nothing my be_users table.
I've installed Typo3 4.0 several times, didn't work.
Sessions are working.
I don't know any further and i hope s.o. might help me.
Greetings Ebbo
Last edited by Ebbo on 25 Apr 2006 - 12:04 pm; edited 1 time in total |
|
|
Back to top
|
|
|
moob
Joined: 11 Oct 2005
Posts: 132
|
| Posted: 13 Apr 2006 - 5:37 pm Post subject:
|
|
|
did you check the database-specific privileges in mysql?
moob |
|
|
Back to top
|
|
|
|
Ebbo
Joined: 13 Apr 2006
Posts: 6
|
| Posted: 13 Apr 2006 - 5:40 pm Post subject:
|
|
|
| i created alle tables with the same privileges |
|
|
Back to top
|
|
|
|
moob
Joined: 11 Oct 2005
Posts: 132
|
| Posted: 13 Apr 2006 - 5:46 pm Post subject:
|
|
|
and create "admin" user doesn't work? |
|
|
Back to top
|
|
|
|
Ebbo
Joined: 13 Apr 2006
Posts: 6
|
| Posted: 18 Apr 2006 - 12:32 pm Post subject:
|
|
|
| I did it several times, didn't work... |
|
|
Back to top
|
|
|
|
Ebbo
Joined: 13 Apr 2006
Posts: 6
|
| Posted: 18 Apr 2006 - 1:29 pm Post subject:
|
|
|
Is it possible that I've got a wrong MySQL version?
I'm using MySQL 5.019
Should I try an Older Version of MySQL? |
|
|
Back to top
|
|
|
|
johnnyl
Joined: 20 Apr 2006
Posts: 3
|
| Posted: 24 Apr 2006 - 3:40 am Post subject:
|
|
|
i'm having the same problem... did you get a fix ebbo?
my config is:
win xp sp2
php442, apache sapi dll module
apache 2.0.55 server
mysql 5.0.20
typo 3 v4.0, dummy package + source package... symlinked properly with winbolic
Install tool says everything is good... Tables all look good... DB user has full privledges... It says an admin is created in the database tools section of the install tool, yet both phpmyadmin and mysql administrator show no entry being added... consequently I can't get into the back end...
johnny |
|
|
Back to top
|
|
|
|
Ebbo
Joined: 13 Apr 2006
Posts: 6
|
| Posted: 24 Apr 2006 - 8:43 am Post subject:
|
|
|
no sorry
i still do not get an admin account.
i will try to install another version of mysql this week, but i don't think that it'll help me any further.
 |
|
|
Back to top
|
|
|
|
johnnyl
Joined: 20 Apr 2006
Posts: 3
|
| Posted: 24 Apr 2006 - 6:49 pm Post subject:
|
|
|
Ebbo et. al.,
Here is the solution:
- This bug is reported under:
http://bugs.typo3.org/view.php?id=2059
It has been found that the newer versions of mysql use a stricter query format (default windows installation is "strict mode") and is rejecting some of the typo3 queries/inserts as a result. To fix this, you can add the following line to the my.ini configuration file of mysql:
sql-mode="MYSQL40"
OR add the following line to the [setDBinit] configuration key in the install tool under the "All configuration" menu option:
SET SESSION sql_mode='MYSQL40'
...
You may need to restart your mysql server. Then, your "create admin user" tool will work and you will be able to log in to the backend.
Hooray!
For more information, see:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
Johnny |
|
|
Back to top
|
|
|
|
Ebbo
Joined: 13 Apr 2006
Posts: 6
|
| Posted: 25 Apr 2006 - 12:04 pm Post subject:
|
|
|
THANKS ALOT!!!!
It worked. |
|
|
Back to top
|
|
|
|
johnnyl
Joined: 20 Apr 2006
Posts: 3
|
| Posted: 26 Apr 2006 - 10:22 pm Post subject:
|
|
|
| Welcome! |
|
|
Back to top
|
|
|
|
|