 'fud_forum_install_test_table' query doesn't success [message #25939] |
Sun, 26 June 2005 09:41  |
|
|
Hi!
I'm new to Fud, new to php, and won't learn it now, but I wan't to use this forum on my website. But I have a problem during the installation: After step2, i get the message:
FATAL ERROR: your MySQL account does not have permissions to create temporary tables.
Enable this functionality and restart the script.
And why?
I don't use the SQL database of my hosting server. I have an SQL database on freesql.org. I can login into it (and that's all, because as I wrote upper, I don't know php, so I don't know phpmyAdmin). The FUDforum can access to the database, I think (because if I type the wrong password, It displays an other warning massage), but cannot make the temporary tables.
And now, the big Question  :
How to set (via phpmyAdmin or whatever) the freesql MySQL table to work together with fud?
Additional infos:
Host:www.freesql.org
User: -----
Password: -----
Database: -----
FUDforum SQL Table Prefix: fud26_ <- this isn't my idea, that says the FUD.
If cannot answer, I suggest to make an example SQL database on freesql.org, with public password, and login name, and so on.
And after all, sorry for my bad english (I'm Hungarian) 
|
|
|
|
| Re: 'fud_forum_install_test_table' query doesn't success [message #25954 is a reply to message #25939] |
Mon, 27 June 2005 14:08  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
This is a permissions issue. During 2nd part of the installer the forum checks whether or not your database has the necessary permissions for the forum to work. One of those permissions is the ability to create temporary tables, which your account lacks.
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
 Re: 'fud_forum_install_test_table' query doesn't success [message #26035 is a reply to message #25966] |
Sat, 02 July 2005 12:29 |
|
|
Hey, I've still the same problem.
You wrote "Wait till the next release (will be available tomorrow), it will not require temporary tables". Now I have this new version but the error massage won't disappear:
FATAL ERROR: your MySQL account does not have permissions to create temporary tables.
Enable this functionality and restart the script.
So, how can I set up the sql base via phpMyAdmin?
|
|
|
|
|
|
|
|
 Re: 'fud_forum_install_test_table' query doesn't success [message #26046 is a reply to message #25939] |
Sat, 02 July 2005 19:53 |
|
|
Still having problem...
NOW, I tried the 14rc2 ending archive (now I'm sure). In step 2 I type in the data's of the freesql.org host, and clicked the next button:
Invalid DB Type.
it said. But I went back. What am I seeing? Wrong password. I typed in the good password, but the same : Inalyd DB type. The other version (2.6.13) it displayed an other message, when I typed in a wrong parameter. Now it's just saying, that the database is invalid.
I registered in for hotsql.com (other free sql hosting service), and I get the same errmsg. What is the next step? (It's really annoying, because on 15 July a forum MUST work on my website... And I'm still beliving fud is the best choice for us.)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
I'll be waiting, thank you! 
]