FUDforum: FUDforum 3.0+ » does a database schema of fudforum exist ?

Home » FUDforum Development » FUDforum 3.0+ » does a database schema of fudforum exist ? (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator

does a database schema of fudforum exist ? [message #25896]

Fri, 24 June 2005 11:45

matthieu_phpmv

Messages: 44
Registered: November 2004

Karma: 0

Member

Hello,

I'm looking for a database schema of the fudforum database.
Something which looks like http://www.naviworld.com/document/NaviTools_ER_Navision/NaviToolsER%20DBDes igner%20Business%20Analytics%20v1.0.png

That would be great if you have this (it's done by using the great free (open source) software DBDesigner).

Thank you for answer
Matthieu

Report message to a moderator

Re: does a database schema of fudforum exist ? [message #25900 is a reply to message #25896]

Fri, 24 June 2005 13:15

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The SQL structure defention can be found inside the sql/ directory, but there are not pretty charts. That said column that associate tables have fairly descriptive names, so this is not a big issue.

FUDforum Core Developer

Report message to a moderator

Re: does a database schema of fudforum exist ? [message #25912 is a reply to message #25900]

Fri, 24 June 2005 16:47

matthieu_phpmv

Messages: 44
Registered: November 2004

Karma: 0

Member

Ok thank you
2 questions :
- i can't access the files in /sql/ directory because of chmod too restrictive. What can I do ?

- on http://www.phpmyvisites.net/forums/ there's a big issue : the table _ses has been destroyed, I don't know how.

"Erreur

requ�te SQL:

SHOW KEYS FROM `forumsfud_ses` ;

MySQL a r�pondu:Documentation
#1016 - Can't open file: 'forumsfud_ses.MYD'. (errno: 145) "

What can I do to create this table ? Because I can't find its definition somewhere ?

Thanks for help

Report message to a moderator

Re: does a database schema of fudforum exist ? [message #25913 is a reply to message #25912]

Fri, 24 June 2005 17:27

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You can access the schema from web cvs, you can also trying using the REPAIR command to fix the table.

FUDforum Core Developer

Report message to a moderator

Re: does a database schema of fudforum exist ? [message #25924 is a reply to message #25913]

Fri, 24 June 2005 20:23

matthieu_phpmv

Messages: 44
Registered: November 2004

Karma: 0

Member

hello

THANK YOU VERY VERY MUCH ilia, for this very quick and efficient answer Smile

http://www.phpmyvisites.net/forums/

it works great Smile

But WHY did this table break ? The error message was clearly that the file .myi wasn't found... incredible isn't it ? (it was the only table to be broke).

What usage is this table for ?
Thanks

Report message to a moderator

Re: does a database schema of fudforum exist ? [message #25925 is a reply to message #25900]

Fri, 24 June 2005 20:26

matthieu_phpmv

Messages: 44
Registered: November 2004

Karma: 0

Member

Ilia wrote on Fri, 24 June 2005 15:15

The SQL structure defention can be found inside the sql/ directory, but there are not pretty charts. That said column that associate tables have fairly descriptive names, so this is not a big issue.

well this is not a *big* issue but I think this is an issue, for someone who whants to have a quick overview of the dabatase working.

This would be just very fast for us understand the working of all these tables Smile

Thank you for considering this advice Wink

Report message to a moderator

Re: does a database schema of fudforum exist ? [message #25926 is a reply to message #25924]

Fri, 24 June 2005 21:15

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Sometimes MySQL due to an unclead shutdown or a process crash corrupts a table, if the "crash" occurs while a write operation in happening in many cases you get table corruption.

FUDforum Core Developer

Report message to a moderator