Phorum

[Justin]

I downloaded Phorum ( www.phorum.org (http://www.phorum.org) ), and I really want to get this thing working. However, I am totally lost with the MySQL stuff... I can login just fine, and I played around a bit with MySQL, but I can't seem to get Phorum to access it. You can see the errors at www.vdj.net/phorum/index.php3 (http://www.vdj.net/phorum/index.php3) . I set the variables for username, server name, and password, but it asks for a table name as well... and the readme file is shorter than this post http://www.aota.net/ubb/frown.gif

Basically I need to learn MySQL, and I figured Phorum would be a fun way to do it since I love php - I figured I'd have more fun customizing this than the UBB http://www.aota.net/ubb/smile.gif

I hate when I get stumped like this....

<edit>
Ok, now the errors are different because I chmod'd the forum.ini file to 700... don't want the password out there like that... obviously php does not work like cgi with UID, huh? I'm gonna need to move that file under the www root then.
</edit>

------------
Justin Nelson
FutureQuest Technical Something or other

[This message has been edited by Justin (edited 03-24-99).]

[Del]

(thinking, uh oh)

I think you have to create a new table first (via telnet), and name it whatever you want. Then tell the phorum setup what the table name is. For the life of me I can't remember what the database name is though, is it something like username or xdom?

I'm really looking forward to the mySQL and PHP books coming out (not as much as I'm anxious about Star Wars though!)

Del

I'm back in town. Nevada had better weather than So. California does... Idaho had better weather than So. California does... Utah had better weather than So. California does... Logged 1700 miles on the Honda, I did 1400-1500 of em... Time for sleep... And, there were only five emails awaiting in my box when I got home! (Two were spam tho)

[Justin]

I guarantee Indiana doesn't have better weather than southern California http://www.aota.net/ubb/smile.gif

User name is xdomain, server is localhost, that much I know. I can log in to mysql using my password.

I know I need to create a table, I just have no clue what to do with it. I typed the create table command, the prompt changed, I typed ? and got a tiny bit of help, but beyond that I'm still quite lost.

There is a file called forum.sql included that is supposed to make a table for phorum (although the readme swears the file has a different name), and I'm assuming it's like a batch file or a make file type of thing - so I tried to manually type the commands contained in it (I don't know how to make MySQL run the script thing).

I think I'm heading over to the MySQL docs to see what I can dig up http://www.aota.net/ubb/smile.gif That's what I should have done in the first place http://www.aota.net/ubb/smile.gif

------------
Justin Nelson
-- Off to RTFM --

[Justin]

Ok, it's my turn: WOOO HOOO!!!!

Ok, I manually created the table, called it forum, went to the browser and guess what? WORKS PERFECT (almost)! Now for some customizing!

I was actually thinking of modifying the UBB to use a MySQL database... nah, forget that idea http://www.aota.net/ubb/smile.gif I'll just make Phorum kick total butt http://www.aota.net/ubb/smile.gif

I did this with a little help from http://www.devshed.com/resource/advanced/mysql/ - nice beginner's tutorial on MySQL.

Justin

[Justin]

Wow - I love php already, and now I am really liking MySQL a LOT http://www.aota.net/ubb/smile.gif Put the two together - lookout! I really like this. I've been making tables for the heck of it. Now if only I could find something useful to make out of the two...

I'm already going to rewrite my Perl mailing list script in php/mysql, just for fun/experience, but I want to do something useful with it. My site is really not big enough to justify a search engine. I could make one anyway, just to play around. I don't know. I just want to do something with this new found technology http://www.aota.net/ubb/smile.gif I didn't think it could really be this easy!

Much nicer than flat text files, that's for sure http://www.aota.net/ubb/smile.gif Oh, well, off to find some ideas http://www.aota.net/ubb/biggrin.gif


------------------
Justin Nelson
FutureQuest Tech Support