gasbandit
Forum Replies Created
-
Forum: Installing WordPress
In reply to: Time zone refuses to changeThanks vkaryl, that helped me find the problem. The problem was, apparently, that the setup did not create the entry for gmt_offset in the wp_options table, and the administration tool doesn’t create it if it is missing.
So the solution, for others who may have the same problem as me, such as piR, is that you have to insert a new record manually on the database server. We use a php mysql admin package to do it so it was pretty straightforward. The fields should go something like:
option_id: whatever the highest item in your table is, +1 (must be unique)
blog_id: same as all the other records in the table, probably 0 unless you have more than one blog running in this database
option_can_overwrite: Y
option_type: 1
option_value: (your offset here, but whatever number you put here you can then successfully change it later in the administration)
option_width: 20
option_height: 8
description: (blank)
admin_level: 1
autoload: YEntering a new record with the above information fixed my blog.
Forum: Installing WordPress
In reply to: Time zone refuses to changeI can’t figure out why this doesn’t work, and it is very soon going to become a make-or-break issue, as I would rather use wordpress for a company website we are authoring now, but if we cannot automatically display posts in local time, I may be forced to find different blog software, because the people who will be making submissions are semi-computer-illiterate and cannot very well be taught to adjust the date on every submission they make.
I’ve dug through the Database and can’t even find the place where the offset would be stored for me to change it manually… has anyone who has this working on mysql 4 got an idea of where to find the database entry for this offset?
Forum: Installing WordPress
In reply to: Time zone refuses to changeI don’t see a checkbox like that on the options menu… there IS one under the advanced editing options during writing a post, but I wish there was another way other than cranking back the time by 5 hours on every post.
Forum: Installing WordPress
In reply to: Time zone refuses to changeBoth… the times set in Admin/Manage and on the blog itself are both in UTC… when writing new posts, the time defaults to the current UTC time. When I try and change the time zone under options/general, it doesn’t seem to do anything, as the field won’t retain any information and nothing actually gets entered (and there’s not even a field on any table for it) in the MySQL database.
What might be helpful is if I could find the location of the process referred to as the_time() in wordpress, then I could manually set the offset in the formula… but I’m having trouble finding that.
Really, I wish there was an option just to have the time default to current time at the server rather than try to go by GMT. I’m not even sure where it is getting the time from.
Forum: Installing WordPress
In reply to: Installation “hangs” in step 2Ok, I figured it out… wasn’t anything anybody else ran into either… my webserver does not have sendmail enabled, so every time wordpress tried to send an e-mail, it would just hang there and never get resolved.
Forum: Installing WordPress
In reply to: Installation “hangs” in step 2Host is my own box on a localized network, for testing for right now. Running Windows NT 4.0, Apache webserver, PHP and MySQL (versions are all above those required by WordPress).
Now, admittedly, it might be a smidge underpowered as it’s only a P200…