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 #45 on Tue 28 Jan 2003 12:29 AM (UTC)
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.
Top

Posted by Nick Gammon   Australia  (23,165 posts)  Bio   Forum Administrator
Date Reply #46 on Tue 28 Jan 2003 04:57 AM (UTC)
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
Top

Posted by Kris   USA  (198 posts)  Bio
Date Reply #47 on Tue 28 Jan 2003 06:16 PM (UTC)
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. :)
Top

Posted by Kris   USA  (198 posts)  Bio
Date Reply #48 on Tue 28 Jan 2003 08:31 PM (UTC)
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.
Top

Posted by Nick Gammon   Australia  (23,165 posts)  Bio   Forum Administrator
Date Reply #49 on Tue 28 Jan 2003 08:44 PM (UTC)

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
Top

Posted by Kris   USA  (198 posts)  Bio
Date Reply #50 on Wed 29 Jan 2003 12:15 AM (UTC)
Message
Oh lol my bad; I was thinking in hours. It's working now hehe :)
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.


173,995 views.

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

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.