|
|
Re: 2.5 RC1b - Fatal Error after the installion [message #10116 is a reply to message #10076] |
Tue, 20 May 2003 15:14 |
|
stevie
Messages: 35 Registered: May 2003 Location: Boston area, USA
Karma: 0
|
Member |
|
|
Hmmm, I'm trying to install 2.5RC1b (FUDforum21_20030516) also, and I'm also getting a fatal error.
I went through all 5 of the installation steps ok, and then I deleted install.php.
When I go to http//MYDOMAIN.com/fud/ I get the following message:
Fatal error: SQL Error has occurred,
please contact the administrator of the forum
and have them review the forum's SQL query
log in /home/MYDOMAIN/public_html/fud/index.php
on line 56
Any ideas? -Steve
[Updated on: Tue, 20 May 2003 19:12] Report message to a moderator
|
|
|
|
|
|
Re: 2.5 RC1b - Fatal Error after the installion [message #10136 is a reply to message #10133] |
Tue, 20 May 2003 18:46 |
|
stevie
Messages: 35 Registered: May 2003 Location: Boston area, USA
Karma: 0
|
Member |
|
|
I don't think so, that's the problem!
Either address I go to:
http://www.MYDOMAIN.com/fud/ or
http://www.MYDOMAIN.com/fud/index.php?t=login&adm=1
I get the same result:
Fatal error: SQL Error has occurred,
please contact the administrator of the forum
and have them review the forum's SQL query
log in /home/MYDOMAIN/public_html/fud/index.php
on line 56
The 5-step install went fine, but I've never been able to log into the forum. I'm not sure what SQL error there is, but I can see by looking at the sql admin app that 25 or so tables were created, so the install.php app was able to successfully talk to the sql server.
Is there some "backdoor" I can use to get to the FUDforum page that will allow me to un-protect the folders? Or just some simple php script? I'm curious to see that error log! Thanks. -Steve
[Updated on: Tue, 20 May 2003 19:12] Report message to a moderator
|
|
|
Re: 2.5 RC1b - Fatal Error after the installion [message #10137 is a reply to message #10136] |
Tue, 20 May 2003 18:52 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
You could try to login via the admin login panel at:
http://www.MYDOMAIN.com/fud/adm/
If that does not work, here is what you need to do.
Create (inside the directory where you've installed the forum) and run the following PHP script:
<?php include "GLOBALS.php"; readfile($GLOBALS['DATA_DIR'] . 'errors/sql_errors'); ?>
It should output the error strings.
FUDforum Core Developer
|
|
|
|
|
|
Re: 2.5 RC1b - Fatal Error after the installion [message #10142 is a reply to message #10141] |
Tue, 20 May 2003 19:49 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Normally you view messages through the error viewer and for sake of easy parsing the messages are base64 encoded.
The error is very interesting, it appears that your user account does not have permission to set LOCKs on tables. This is not a FUDforum problem, but rather something you need to ask your system admin to do for you. You need to have them give you permission to set LOCKs on your tables.
FUDforum Core Developer
|
|
|
|
Re: 2.5 RC1b - Fatal Error after the installion [message #10145 is a reply to message #10144] |
Tue, 20 May 2003 21:17 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Most webhosters who support MySQL grant locking priveleges because without the ability to create table locks you cannot ensure data integrity. Especially when you can have multiple requests to the database occur in the same instance.
FUDforum Core Developer
|
|
|
|
Re: 2.5 RC1b - Fatal Error after the installion [message #10147 is a reply to message #10146] |
Wed, 21 May 2003 01:10 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Table locking is for neither security nor speed. It basically prevents having 1 application writing data and the other trying to read the same data. Without locks this causes undefined behaviour. I am guessing your ISP had bad experience with dead locks (unreleased lock) because of some badly written code. So they came up with a 'solution' it being disabling of locking priveleges.
FUDforum Core Developer
|
|
|
|
|
Re: 2.5 RC1b - Fatal Error after the installion [message #10158 is a reply to message #10153] |
Wed, 21 May 2003 13:12 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
FUDforum has been using table locks since the first release. When possible to avoid table locks they are not used, however in a number of instances when data is inserted they are unavoidable and therefor are used.
FUDforum Core Developer
|
|
|