Starting from scratch with MySQL forum

[Julie]

Okay, okay, so after yesterday's nightmare, I'm determined to make this work. I had no luck in the a.m., but learned some stuff since then. I had no luck with Matt's script for a message board, so I'm back to square one.

Now, before I get ahead of myself here, I went in and created a MySQL database called coon-xmb. I created a user called coon-coon. Now...... when I upload all of this pre-written stuff, WHERE do I upload it to? Can I just name any folder within the file manage, or do I need to put it in the cgi-bin? Is there a place within the advanced pages that I need to put it all?

I'm gonna do this before I die, I swear it!

[nsr81]

If you want to setup XMB, then you don't need any specific directory/folder. Since It's PHP, it'll run anywhere on your site. and your database name and username contain an underscore "_" not a minus sign "-".

Here is the whole procedure as I understood it from the readme file:

1. Unzip the xmbv<version>.zip, you should have the following folders and files after unzipping.
[list=1]
docs - folder
images - folder
lang - folder
templates - folders
config.php
cp.php
cp2.php
forumdisplay.php
functions.php
header.php
index.php
install.php
member.php
misc.php
misc2.php
post.php
settings.php
tools.php
topicadmin.php
[/list=1]

2. Open config.php in notepad. change the information to these setting:
$dbname = "coon_xmb";
$dbuser = "coon_coon";
$dbpw = " your password here";
$dbhost = "localhost";
$tablepre = "xmb_";

save the file.

3. Now upload everything into any folder using an ftp client. make sure the four folders and their contents are uploaded as well. For sake of this example we can assume that you uploaded it in "xmb" folder.

4. Now CHMOD settings.php to 766. Check your ftp client's help file for that. Almost all ftp clients support that feature. if you can't do it from ftp, try doing from the CPanel.

5. Now you have to run the install script. type in this URL: http://www.justjuliedogart.com/xmb/install.php. Replace xmb with the folder name you uploaded your files to.

6. Register yourself as a user on your forum, which will make you the admin too.

7. Visit the control panel (the link will be visible once your logged in) and change stuff


I hope there is no more confusion, but if you still need help let me know I'll install xmb on my site and walk you through it again.

nsr81.

[Julie]

Thank you for your reply. I did exactly as you said and I STILL get this message:

Access denied for user: 'coon_coon@localhost' to database 'coon_xmb'

I did NOTHING else within the Advanced.html page except create a database called coon_xmb and a user called coon_coon. Was there something else I was supposed to do within the Advanced.html page of the cpanel?

Also, I did not FTP -- I uploaded everything manually from the file manager at cpanel. I created folders that are named exactly as they were sent to me and put the proper files within those. I changed the config.php file to reflect my database name & user name and uploaded it. I changed the settings.php file to 766.

When I go to: www.abtcc.com/xmb/install.php I get:

Access denied for user: 'coon_coon@localhost' to database 'coon_xmb'

Any further ideas?

[nsr81]

Did you add the user coon_coon to the database coon_xmb.

[Julie]

Oh man, oh man, oh man!!!!!! I did create a user and a database, but FORGOT to add the user TO the database!!! You're a genius. A GENIUS, I tell you!!!

Thank you thank you thank you!!!! Install successful. Now I've got to figure the rest of this stuff out. Yippeee!!!!!

Thanks sooooo sooooooooo much.

Julie
:D

[Julie]

It works for me, but maybe others will have problems:

http://www.abtcc.com/xmb/

I'm now trying to figure out the tables. Again, thank you so very much!!! :D :D :D :D

[reuben]

Looks like you've got it :D

[nsr81]

Way to go Julie.

So far so good, I didn't encounter any problems.

I'm just glad that it worked out good. :cool:


nsr81.

[bene]

Thought this may be the best place to ask this question
Followed NSR81's directions XMB installed beautifully

Setup a forum and click on technical support it andr ecieve the following error

You have an error in your SQL syntax near ' ORDER BY topped DESC,lastpostd DESC LIMIT 0, 30' at line 1

the board is installed at

http://support.aunics.com/forum/

Any suggestions greatly recieved.

I know f**** all about mySQL excuse my language

[bene]

BTW could you tell me what time it is over in the states at the moment please

eastern time
Thanks

[nsr81]

7:19 AM 9/24/2001,

I'm going to school now, let you know what can I do when I come back about your error. In the mean time, blosterboy should also have some usefull info about XMB

[bene]

Thanks for the time:)

Any suggestions on my previous post to this thread

[Julie]

I don't know anything about MySQL, but there is a pretty good forum at XMB where you may find the answer to your technical question.

Julie :D

[nsr81]

If you haven't found a solution for your problem try this:

Verify this line in "forumdisplay.php", should be line# 116 or 117 in wordpad without wordwrap.

$querytop = mysql_query("SELECT * FROM $table_threads WHERE fid='$fid' $cusdate
ORDER BY topped $ascdesc,lastpost $ascdesc LIMIT $start_limit, $tpp") or die(mysql_error());

second if it's ok, you can put in some debugging code. The easiest one is echo statement. you can put this statement before that line of code is executed to see if your variable are properly being sent to mysql.

echo "\$table_thread = $table_thread, \$fid = $fid, \$$ascdesc = $ascdesc,
\$start_limit = $start_limit, \$tpp = $tpp";


This will dump the values of all the varibles in the query statement, which you can use to verify if the values being sent are correct.

so far that's all I can think of, if this doesn't help then you should consult XMB's own tech. support forum.

[bene]

Thank you for the time you have taken to help me with this matter it is truly appreciated.

It is great to see so many helpful persons making peoples lives a little easier.:)

So as you all know I corrected the problem by downloading the latest version of the software and is working without the previous errors.

Thank you all again

[nsr81]

You're welcome :)

[Simon]

Hi, I was wondering if you could give me a hand with setting up XMB. I get the following error upon running install.php:

Creating xmb1_attachments...No Database Selected

?? Odd. Do you know what it could be? Here is the config.php file:

<?
$dbname = "simon_xmb";
$dbuser = "simon_simon";
$dbpw = "password";
$dbhost = "localhost";
$tablepre = "xmb1_";
$pconnect = 0;
$cookiepath = ""; // "" if your installing locally
$cookiedomain = ""; // "" if your installing locally
$database = "mysql";
$plugname[1] = "";
$plugurl[1] = "";
$plugadmin[1] = "no";
?>

Thanks!

[nsr81]

From the looks of it you are using 1.5 RCX version. Right?

Anyway, I didn't download it yet, but I'm going to look into what might be wrong.

Just a silly questions. Does your config.php file has &lt;? and ?&gt; in proper places. :)

[Simon]

Hmm... what do you mean by "in the proper places?"

I'm not too familiar with PHP. What is there proper place? Are they misplaced in the script above?

It seems to be executing. It looks like it has trouble accessing the DB, but I don't know what the problem is.

[nsr81]

you have to have &lt;? at the very top and ?&gt; at the very bottom. Since the top one is missing, I thought you might have a screw up in config file.

Seems like their own board is also having troubles. and they are running 1.5 RC4.

You might wanna try an older version, they are much more stable than 1.5 ones.

[Simon]

Tried v1.11d
Now I get:

Access denied for user: 'simon_simon@localhost' to database 'simon_xmb'


Boy, this is REALLY aggravating me!!!

AAaaarrgghhh!
I am sure the password is right.

What the heck is going on! Grrr....

[Simon]

And also I am in PHPadmin and it tells me:

Database mysql - table user
Error
MySQL said: You don't have enough rights to be here right now!
Back

When I try to access the users menu.

[rick]

I am having the EXACT same problems :(

I posted over in General - I promise to try to remember to post here for this shhh...schtufffff... :D

[nsr81]

notify Reuben, It might be a problem with Cpanel or mysql server that you are not getting proper privilages(spelling??) for your own database.

repeat answer :D

[LoganFive]

hi, i'm wondering how i can enable my users to edit posts on an XMB 1.6 board. the XMB community boards appear to be down.

i recently installed the board and it was brought to my attention that when a user goes to edit a post, it says "Sorry, you are not permitted to view this forum"

i couldn't find anything in the admin options that had control over this.

i'm sorry if this is a silly question, but hey, i'm stumped. take pity on me.

[nsr81]

It might be PID Problem, consult this thread for more information:

http://forum.100megswebhosting.com/showthread.php?s=&threadid=3653

[LoganFive]

i appreciate your prompt response.

however, the post points to a fix on the XMB boards, which gives me a 404.

[David]

http://www.computerelated.com/forum/viewthread.php?tid=394

:)

[LoganFive]

thanks very much! i will give this a try.

UPDATE:
yes, that did the trick. many thanks.