FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » FUDforum Installation Issues » Number of fields needed for mySQL table
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Number of fields needed for mySQL table [message #6796] Thu, 24 October 2002 19:44 Go to next message
paulholman   United Kingdom
Messages: 15
Registered: October 2002
Karma: 0
Junior Member
Title says it all.

When setting up a mySQL table for FUD forum to use I need to know how many fields it needs. This doesn't seem to be documented anywhere.

Thanks in advance.

Paul

Report message to a moderator

Re: Number of fields needed for mySQL table [message #6797 is a reply to message #6796] Thu, 24 October 2002 20:09 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Why would you be manually creating a FUDforum's MySQL table? The installer does it automatically.

FUDforum Core Developer

Report message to a moderator

Re: Number of fields needed for mySQL table [message #6816 is a reply to message #6797] Fri, 25 October 2002 07:16 Go to previous messageGo to next message
paulholman   United Kingdom
Messages: 15
Registered: October 2002
Karma: 0
Junior Member
> Why would you be manually creating a FUDforum's MySQL table?
> The installer does it automatically

Probably because at the top of the second installation page it says "It is recommended you create a separate database for the forum."

Without a premade database I get the error
"Failed to create table fud_users.tbl (DROP TABLE IF EXISTS fud23_users), SQL Reason: No Database Selected"
on the database field of the second page of the installer script.

Sorry, but I can't find anything in the manual about this. It apperas to need a premade mySQL database, but my server needs to know how many fields the database will need.

Thanks

Paul

Report message to a moderator

Re: Number of fields needed for mySQL table [message #6826 is a reply to message #6816] Fri, 25 October 2002 12:47 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Please take no offence, but you clearly are not aware of what you are doing. The forum asks for a database where the forum's tables can be stored. Creation of a database, unless you got one already is done via a single SIMPLE command in MySQL:
CREATE DATABASE database_name;


FUDforum Core Developer

Report message to a moderator

Re: Number of fields needed for mySQL table [message #6871 is a reply to message #6826] Sun, 27 October 2002 12:16 Go to previous messageGo to next message
paulholman   United Kingdom
Messages: 15
Registered: October 2002
Karma: 0
Junior Member
Quote:

Please take no offence, but you clearly are not aware of what you are doing.


Close to the truth Wink
Whilst I have many years experience managing on-line forums and discussion groups, it's the first time I've tried to get my "hands dirty" setting up a complete system on a virtual server myself.

Setting up software like this isn't too easy for those of us who aren't "code warriors" and much of the documentation on PHP, mySQL and FUD assumes a fair degree of code knowledge.

I finally found the information I needed buried in the support pages for my hosting company and everything is now running OK. It appears that once the hurdles of configuration are past, it's all pretty straight forward.

Ta

Paul Holman

Report message to a moderator

Re: Number of fields needed for mySQL table [message #6943 is a reply to message #6796] Tue, 29 October 2002 16:55 Go to previous messageGo to next message
Stilly is currently offline  Stilly   Germany
Messages: 3
Registered: October 2002
Karma: 0
Junior Member
Hi all,

maybe I´am not aware of what I´am doing too, but I have a pretty similar question.

My provider services include a MySQL Database. This Database has a Name. When installing the forum it´s asked for the name of the database where the forum data will be stored.

When I fill in the name of the data base, which is provided and then press the "Continue Button" I get the same error message:

"Failed to create table fud_users.tbl (DROP TABLE IF EXISTS fud23_users), SQL Reason: No Database Selected"

So whats wrong? Is it possible to install the forum on this premade data base or will I need a new one?

Thanks.....

Stilly

Report message to a moderator

Re: Number of fields needed for mySQL table [message #6944 is a reply to message #6943] Tue, 29 October 2002 17:07 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
This error most likely means that the forum was unable to select the database you've specified, that or you did not specify a database name.

FUDforum Core Developer

Report message to a moderator

Re: Number of fields needed for mySQL table [message #6947 is a reply to message #6944] Tue, 29 October 2002 17:16 Go to previous messageGo to next message
Stilly is currently offline  Stilly   Germany
Messages: 3
Registered: October 2002
Karma: 0
Junior Member
Yes, I defined a data base name. Should be the right one...
What else?

host, user and password is no problem, but name of data base brings the error.

(the name of the data base is the same as the user name? Could that cause the problem?)

Report message to a moderator

Re: Number of fields needed for mySQL table [message #6956 is a reply to message #6947] Tue, 29 October 2002 19:26 Go to previous messageGo to next message
zapal   Poland
Messages: 68
Registered: October 2002
Location: Poland
Karma: 0
Member
When I was installing fud on my localhost I had similar troubles (as a database server I put 127.0.0.1). It complained it could'nt connect to server or couldn't login or couldn't select database (all of those messages appeared).

When I put mysql unix socket as a server it went ok.

Report message to a moderator

Re: Number of fields needed for mySQL table [message #6957 is a reply to message #6956] Tue, 29 October 2002 19:35 Go to previous messageGo to next message
Stilly is currently offline  Stilly   Germany
Messages: 3
Registered: October 2002
Karma: 0
Junior Member
How do I get this UNIX Socket?

Report message to a moderator

Re: Number of fields needed for mySQL table [message #6958 is a reply to message #6957] Tue, 29 October 2002 19:55 Go to previous message
zapal   Poland
Messages: 68
Registered: October 2002
Location: Poland
Karma: 0
Member
Just type in database server:
:/path/to/file

In Debian the path should be /var/run/mysqld/mysqld.sock (as a default value for Mysql).

Check your database configuration to ensure correct paths.

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Version indicates 2.3.3 after upgrading to 2.3.4
Next Topic: e-mailing woes
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 20:37:49 GMT 2024

Total time taken to generate the page: 0.02656 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software