[Home] [Downloads] [Search] [Help/forum]

Gammon Software Solutions forum

See www.mushclient.com/spam for dealing with forum spam. Please read the MUSHclient FAQ!

[Folder]  Entire forum
-> [Folder]  Forum software
. -> [Folder]  Installation
. . -> [Subject]  Table Not Specified
Home  |  Users  |  Search  |  FAQ
Username:
Register forum user name
Password:
Forgotten password?
(New message)
Subject: Table Not Specified
Name:
Your forum user name.
Register forum user name
Password:
Your forum password.
Forgotten password?
Message:
Message to be posted (in English, please).
Forum codes:
Check this if your message uses 'forum codes' or templates (auto-detected for new posts).
Forum codes Templates

Save this message ...

Subject review (reverse sequence)

Pages: 1  2 3  4  

Posted by Kris   USA  (198 posts)  [Biography] bio
Date Wed 29 Jan 2003 12:15 AM (UTC)  [ quote  ]
Message
Oh lol my bad; I was thinking in hours. It's working now hehe :)
--Kris
[Go to top] top
Posted by Nick Gammon   Australia  (18,800 posts)  [Biography] bio   Forum Administrator
Date Tue 28 Jan 2003 08:44 PM (UTC)  [ quote  ]

Amended on Wed 29 Jan 2003 02:00 AM (UTC) by Nick Gammon

Message
You are not 8 minutes east of London - I shouldn't think. Try multiplying by 60 to get hours.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by Kris   USA  (198 posts)  [Biography] bio
Date Tue 28 Jan 2003 08:31 PM (UTC)  [ quote  ]
Message
There is one minor thing I can't seem to figure out. I left minuteswest set to 0, and it was tagging things in UTC. I want it to be in Pacific time, so I changed minuteswest to -8. However, it had absolutely no effect. It seems that regardless of the minuteswest value, the posts I made are still showing up in UTC.
--Kris
[Go to top] top
Posted by Kris   USA  (198 posts)  [Biography] bio
Date Tue 28 Jan 2003 06:16 PM (UTC)  [ quote  ]
Message
Yup that worked. When I tried the second one, it beeped at me and gave the error "ERROR 1060: Duplicate column name 'unlimited_post_length'". I'm guessing that just means that entry was already there.... So yah it's working now. :)
--Kris
[Go to top] top
Posted by Nick Gammon   Australia  (18,800 posts)  [Biography] bio   Forum Administrator
Date Tue 28 Jan 2003 04:57 AM (UTC)  [ quote  ]
Message
Hmm - looks like I overlooked that one.

Use mysql command-line (or the Execute SQL feature) to do these two commands:

alter table bbuser add htmlpost tinyint;

alter table bbuser add unlimited_post_length tinyint;
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by Kris   USA  (198 posts)  [Biography] bio
Date Tue 28 Jan 2003 12:29 AM (UTC)  [ quote  ]
Message
When I downloaded the new version, I put it in a seperate directory and created a seperate database name for it. When I imported it, I imported from the sql of the new version.
--Kris
[Go to top] top
Posted by Nick Gammon   Australia  (18,800 posts)  [Biography] bio   Forum Administrator
Date Tue 28 Jan 2003 12:23 AM (UTC)  [ quote  ]
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
[Go to top] top
Posted by Kris   USA  (198 posts)  [Biography] bio
Date Mon 27 Jan 2003 10:23 PM (UTC)  [ quote  ]
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?
--Kris
[Go to top] top
Posted by Nick Gammon   Australia  (18,800 posts)  [Biography] bio   Forum Administrator
Date Mon 27 Jan 2003 09:06 PM (UTC)  [ quote  ]
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
[Go to top] top
Posted by Kris   USA  (198 posts)  [Biography] bio
Date Mon 27 Jan 2003 08:35 PM (UTC)  [ quote  ]
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 :)
--Kris
[Go to top] top
Posted by Nick Gammon   Australia  (18,800 posts)  [Biography] bio   Forum Administrator
Date Sun 26 Jan 2003 10:36 PM (UTC)  [ quote  ]

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
[Go to top] top
Posted by Kris   USA  (198 posts)  [Biography] bio
Date Sun 26 Jan 2003 03:44 AM (UTC)  [ quote  ]
Message
Here's the entry for forum_url:

item | contents | id

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

--Kris
[Go to top] top
Posted by Nick Gammon   Australia  (18,800 posts)  [Biography] bio   Forum Administrator
Date Sat 25 Jan 2003 10:25 PM (UTC)  [ quote  ]
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
[Go to top] top
Posted by Kris   USA  (198 posts)  [Biography] bio
Date Sat 25 Jan 2003 02:03 AM (UTC)  [ quote  ]
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?
--Kris
[Go to top] top
Posted by Nick Gammon   Australia  (18,800 posts)  [Biography] bio   Forum Administrator
Date Mon 20 Jan 2003 08:51 PM (UTC)  [ quote  ]
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
[Go to top] 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.

16,042 views.

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

[Reply to this subject]  Reply to this subject   [New subject]  Start a new subject   [Refresh] Refresh page

Go to topic:           Search the forum

[Go to top] top

[Home]

Written by Nick Gammon - 5K

Comments to: Gammon Software support
[RH click to get RSS URL] Forum RSS feed ( http://www.gammon.com.au/rss/forum.xml )

[Best viewed with any browser - 2K]    [Internet Contents Rating Association (ICRA) - 2K]    [Web site powered by FutureQuest.Net]