Register forum user name Search FAQ

Gammon Forum

Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the password reset link.

Due to spam on this forum, all posts now need moderator approval.

 Entire forum ➜ Forum software ➜ Installation ➜ Table Not Specified
Table Not Specified

It is now over 60 days since the last post. This thread is closed.     Refresh page

Pages: 1  2  3 4  

Posted by Kris   USA  (198 posts)  Bio
Date Reply #30 on Sat 18 Jan 2003 09:39 PM (UTC)
Message
Ok that clears up a bit of the mystery with that anyways. How would I go about fixing forum_url to point to "http://www.aethiamud.org/fom1/forum2b/forum"? Right now it seems to be pointing to "C:\program files\webserver\server\apache\apache2\htdocs\fom1\forum2b\forum" instead, or just a relative '/' which makes it assume the hdd location instead of the url location.

How would I fix this?
Top
Posted by Nick Gammon   Australia  (23,165 posts)  Bio   Forum Administrator
Date Reply #31 on Sat 18 Jan 2003 10:41 PM (UTC)

Amended on Sat 18 Jan 2003 10:42 PM (UTC) by Nick Gammon

Message
You change that entry in the control table. Once we fix the problem with updating database records in general that should be easy. As for your other problem it would help if I could reproduce it, which I'll try to do when I get back from holidays, but meanwhile, try this. Currently in the common.php file is the following code, commented out:


reset ($HTTP_GET_VARS);
while (list ($name, $value) = each ($HTTP_GET_VARS))
    $HTTP_GET_VARS [$name] = addslashes ($HTTP_GET_VARS [$name]);

reset ($HTTP_POST_VARS);
while (list ($name, $value) = each ($HTTP_POST_VARS))
    $HTTP_POST_VARS [$name] = addslashes ($HTTP_POST_VARS [$name]);

reset ($HTTP_COOKIE_VARS);
while (list ($name, $value) = each ($HTTP_COOKIE_VARS))
    $HTTP_COOKIE_VARS [$name] = addslashes ($HTTP_COOKIE_VARS [$name]);

extract ($HTTP_GET_VARS, EXTR_OVERWRITE);
extract ($HTTP_POST_VARS, EXTR_OVERWRITE);
extract ($HTTP_COOKIE_VARS, EXTR_OVERWRITE);


What might work would be to do a variation of that to get the data from the _REQUEST variable into normal variables. Edit the line in common.php that reads:


import_request_variables ("GPC");


and replace it with:


reset ($_REQUEST);
while (list ($name, $value) = each ($_REQUEST))
    $_REQUEST [$name] = addslashes ($_REQUEST [$name]);

extract ($_REQUEST, EXTR_OVERWRITE);
$HTTP_GET_VARS = $_REQUEST;
$HTTP_POST_VARS = $_REQUEST;


I haven't tested that, but it might work. :)
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #32 on Sun 19 Jan 2003 02:56 AM (UTC)
Message
Hmm had no effect. The links are still pointing to files at C:/ instead of aethiamud.org/
Top
Posted by Meerclar   USA  (733 posts)  Bio
Date Reply #33 on Sun 19 Jan 2003 03:30 AM (UTC)
Message
I'll admit my general lack of knowledge on this one, but would it be possible to alias C:\ to the mudroot and trick the forum code into looking at the proper directory?
Meerclar - Lord of Cats
Coder, Builder, and Tormenter of Mortals
Stormbringer: Rebirth
storm-bringer.org:4500
www.storm-bringer.org
Top
Posted by Nick Gammon   Australia  (23,165 posts)  Bio   Forum Administrator
Date Reply #34 on Sun 19 Jan 2003 05:13 AM (UTC)
Message
I am doubting you are successfully changing the control record, as that should work. Please use the "execute SQL command" link, or some other method, to execute this SQL statement, and post the result or at least the entry for forum_url.

SELECT * FROM control ORDER BY item
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #35 on Sun 19 Jan 2003 10:19 PM (UTC)
Message
I can't use the "execute sql command" link. Like I said, it has absolutely no effect; the url the link points to is:

file:///C:/program files/webserver/server/Apache/Apache2/htdocs/fom1/forum2b/forum/admin/executesql.php

That's the problem. I tried editing common.php manually by replacing that line you stated with that chunk of code, but it had no effect.
Top
Posted by Nick Gammon   Australia  (23,165 posts)  Bio   Forum Administrator
Date Reply #36 on Mon 20 Jan 2003 08:51 PM (UTC)
Message
Something is odd here. For one thing, HTTP_POST_VARS should now have stuff in. Those debug lines should confirm that. The problem with the link being wrong in the control record will be why the hyperlinks don't work.

If you have mySQL operating you should have mysql client program. You can use that to do the "select" I suggested and even change things from the mysql client. Have you tried using it?
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #37 on Sat 25 Jan 2003 02:03 AM (UTC)
Message
This is the Windows version of Mysql. Not quite what you mean by "select". There's a bunch of files, but basically the only 2 I actually know what to do with are mysql.exe and winmysqladmin.exe. Is 'select' a parameter of mysql.exe or something? The 'winmysqladmin.exe' is pretty useless; I was able to create the forum database, but I had to shell into DOS and use the manual command-line call to mysql.exe to actually import the data.

Do ya know the equivalent of what you're talking about with the Windows version?
Top
Posted by Nick Gammon   Australia  (23,165 posts)  Bio   Forum Administrator
Date Reply #38 on Sat 25 Jan 2003 10:25 PM (UTC)
Message
If you have a mysql.exe then that should be the mySQL client program. You would start it up something like this:


 mysql -ukris -pswordfish forum
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.53

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


The above should connect you to database "forum" for user "kris" password "swordfish".

Then do the select:


mysql>  SELECT * FROM control ORDER BY item; 
+---------------------------+----------+----+
| item                      | contents | id |
+---------------------------+----------+----+
| allow_deletes             | 1        |  6 |
| allow_edits               | 1        |  5 |
| allow_messages            | 1        | 25 |
| allow_notification        | 1        | 24 |
| allow_posts               | 1        |  4 |
| allow_registrations       | 1        |  7 |
| amend_post_date           | 0        | 18 |
| extended_dates            | 1        | 29 |
| forum_version             | 1        | 23 |
| minuteswest               | 0        | 31 |
| post_under_different_name | 0        | 20 |
+---------------------------+----------+----+


You should see more entries than this, but this is the general idea.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #39 on Sun 26 Jan 2003 03:44 AM (UTC)
Message
Here's the entry for forum_url:

item | contents | id

forum_url | http://www.your_site.com/forum | 15

Top
Posted by Nick Gammon   Australia  (23,165 posts)  Bio   Forum Administrator
Date Reply #40 on Sun 26 Jan 2003 10:36 PM (UTC)

Amended on Sun 26 Jan 2003 10:37 PM (UTC) by Nick Gammon

Message
The directory for those links is $ADMIN_DIRECTORY, which is configured in general_config.php, like this:


// where the admin stuff is (relative to the web browser)

$ADMIN_DIRECTORY = "/admin/";


I did a grep to find references to it ...


executesqlfile.php:<h1>Execute SQL commands in a file</h1>
index.php:    hLink ("Execute SQL command", $ADMIN_DIRECTORY . "executesql.php");
index.php:    hLink ("Execute SQL file", $ADMIN_DIRECTORY . "executesqlfile.php");
logon.php:    hLink ("Execute SQL command", $ADMIN_DIRECTORY . "executesql.php");
logon.php:    hLink ("Execute SQL file", $ADMIN_DIRECTORY . "executesqlfile.php");


I suspect all this is related to the _REQUEST issue, as it would appear that $ADMIN_DIRECTORY is not being processed - or have you set it to something else?

Put it another way, what is the line for $ADMIN_DIRECTORY in your general_config.php exactly?
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #41 on Mon 27 Jan 2003 08:35 PM (UTC)
Message
That's what it was. With 'admin directory', like the others, I had it pointing at the C:\ location of the directory instead of the http location or relative location. With the others (like 'include directory' for example) only the direct C:\ location would work; I assumed the same for the admin one as well.

Now changing it seems to be working fine (finally!). :)


If all goes well, I'll post a detailed subject with Windows-specific installation instructions, since there are a few very notable differences hehe. Thanks fer the help; I'll let ya know if I run into another brick wall :)
Top
Posted by Nick Gammon   Australia  (23,165 posts)  Bio   Forum Administrator
Date Reply #42 on Mon 27 Jan 2003 09:06 PM (UTC)
Message
The comment above "(relative to the web browser)" meant that the entry was supposed to be where your web browser looked for it, not what the location on disk was.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #43 on Mon 27 Jan 2003 10:23 PM (UTC)
Message
Ahh i c. Everything seems to be working ok now, 'cept I have run into 1 bug. When attempting to change my user profile, I click 'save', and this error comes up:

Forum user details
There is a problem ...
Update failed: Unknown column 'htmlpost' in 'field list'



I'm assuming that's from the "Post in HTML?" field? What should I do to fix that?
Top
Posted by Nick Gammon   Australia  (23,165 posts)  Bio   Forum Administrator
Date Reply #44 on Tue 28 Jan 2003 12:23 AM (UTC)
Message
Did you re-import the database when you got the updated version? I went through and added the extra fields to the tables that the up-to-date version requires, at least I thought I did. :)

Use mysql to "drop database forum" and then re-import as per the installation instructions. Hope you haven't changed much so far.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.

174,018 views.

This is page 3, subject is 4 pages long:  [Previous page]  1  2  3 4  [Next page]

It is now over 60 days since the last post. This thread is closed.     Refresh page

Go to topic:           Search the forum

[Go to top] top

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.

Home