Project

General

Profile

Actions

Bug #16846

closed

Onvolledige database en sql-fout

Added by Nieveen over 17 years ago. Updated about 17 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
-
Target version:
-
Start date:
2007-01-09
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.0
PHP Version:
4
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Probleem is eerder beschreven in 0004752.
Geüpdated, database compare enz. Geen succes.
SQL foutenrapport gemaakt.
Zie bijage

Hoe verwijder ik overigens de sql bug tracer?
(issue imported from #M4760)


Files

Nieveen.htm (12 KB) Nieveen.htm Administrator Admin, 2007-01-09 21:13

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #15975: missing create database rights bring up ugly error pageClosedChris topher2006-04-07

Actions
Actions #1

Updated by Oliver Hader over 17 years ago

Please post your bug-report in english!
Could you additionally point out, what database management system you're running and at what version?

Actions #2

Updated by Nieveen over 17 years ago

Sorry.
The problem seems to have two dimensions.
1. The problem with the incorrect MYSql statement.
See the fist report
2. The problem with the missing tables in the SQL-database.
I tryed to update or renew the database with the staments in de All
Setting from the Tupe3-menu. It d'nt work.
I attatched second document about both issue.

Actions #3

Updated by Nieveen over 17 years ago

I removed already the sql bug tracer.

Actions #4

Updated by Oliver Hader over 17 years ago

Hm...
1) I don't think, that there's a general problem on MySQL queries.
2) For this one, I suppose that your database has some restrictions:

In your attached "Nieveen.htm" file if found:
delete command denied to user: '' for table 'fe_sessions'

Could it be possible that your database user is only allowed to select table data and has no rights to write manipulations (update, delete, create, drop, etc.) to the database? Could you please check this on your host?

Actions #5

Updated by Nieveen over 17 years ago

I asked the provider (Vuurwerk).
There are no ristrictions concerning the use of the database.
Earlier I had Joomla (Mambo) running on the same server.
There were no problems wiht the database.
Off course this program is deleted completly.

Mayby,
I had installed Type3 ealier two times.
By deleting this from the www directory always the directory temp_ is remaining and not-removable.
I renamed this direcory.

Actions #6

Updated by Nieveen over 17 years ago

Mayby the old database containing Joomla has to be cleaned first.
But I dont know how.
It does not work in Typo3.

Actions #7

Updated by Nieveen over 17 years ago

I have installed AdminMySql.
Everything seems in order accept the installing the Admin tables.
The socket off the MySql database can not be entered.

It looks like the same problem has installing Typo3.
Somehow the tables are not installed.
I replaced class.t3lid._db.php by a beter file and I have read the file with the MySql reporter. It containing all nessasery tables.
When I read the tables with the Typo3-tools there are a lot of tables who are not included in the class.t3lid_db.php file.
So, there are old tables left from the earlier Joomla installation.
I also tried with putty.exe and the bash commands, but that's a whole new world.
I am out off options now.

Actions #8

Updated by Oliver Hader over 17 years ago

Nieveen gave me access to the install tool and I could determine the versions of the used software:

PHP Version: 4.4.4
MySQL-API Version: 3.23.49

Maybe the elderly MySQL-API Version could be problem for TYPO3 4.0.x.
What are the accurate requirements accordant to DBMS for TYPO3?

Actions #9

Updated by Oliver Hader over 17 years ago

The problem was a MySQL setting depending on table/database access and no bug of general TYPO3 concern.
Result: Installing TYPO3 4.0.4 works with MySQL 3.23.49

Actions

Also available in: Atom PDF