Bug #16846
closed
Onvolledige database en sql-fout
Added by Nieveen almost 18 years ago.
Updated over 17 years ago.
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
Please post your bug-report in english!
Could you additionally point out, what database management system you're running and at what version?
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.
I removed already the sql bug tracer.
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: 'digikantoor@us05asd2.hosting.vuurwerk.net' 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?
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.
Mayby the old database containing Joomla has to be cleaned first.
But I dont know how.
It does not work in Typo3.
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.
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?
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
Also available in: Atom
PDF