| View previous topic :: View next topic |
| Author |
Message |
ginge Site Admin
Joined: 14 Jan 2006 Posts: 1028 Location: Manchester, UK
|
Posted: Thu Mar 29, 2007 5:45 pm Post subject: |
|
|
Mike,
You can do it in plesk or the command line. Plesk would probably be more convenient.
Cliff,
Yeah, just noticed some of these too. A quick DB query shows over 117 affected posts and sigs. I think another DB query should fix this, but I want to run a lengthy backup first
Barry _________________ http://www.headfuzz.co.uk/
http://www.robotfuzz.co.uk/ |
|
| Back to top |
|
 |
mpthompson
Joined: 02 Jan 2006 Posts: 650 Location: San Carlos, CA
|
|
| Back to top |
|
 |
mpthompson
Joined: 02 Jan 2006 Posts: 650 Location: San Carlos, CA
|
Posted: Thu Mar 29, 2007 6:06 pm Post subject: |
|
|
The timezone for the server has been set to GMT. It now reports:
# date
Thu Mar 29 18:04:36 GMT 2007
at the time of this posting.
Does GMT sound like the best timezone for everyone given that we have people from all over the world?
-Mike |
|
| Back to top |
|
 |
ginge Site Admin
Joined: 14 Jan 2006 Posts: 1028 Location: Manchester, UK
|
Posted: Thu Mar 29, 2007 6:33 pm Post subject: |
|
|
Mike, GMT sounds good. Anything else could get confusing.
| Code: |
UPDATE phpbb_posts_text SET post_text = replace(post_text,"\\"","\"");
Affected rows: 117 (Query took 0.0060 sec)
|
I cant see any bad things that happened with this, so I am guessing it is fixed. A quick verification look good. Only one problem I see are user sigs. There were 0 affected rows when I ran the script. As this only affects a few people can I request you all check your sigs.
I am not so sure how to fix the posts by user error. I will look deeper into that issue.
Barry _________________ http://www.headfuzz.co.uk/
http://www.robotfuzz.co.uk/ |
|
| Back to top |
|
 |
ginge Site Admin
Joined: 14 Jan 2006 Posts: 1028 Location: Manchester, UK
|
Posted: Thu Mar 29, 2007 6:47 pm Post subject: |
|
|
| cliff wrote: | User profile, find all posts by user:
General Error |
I have this fixed up too. It turns out I missed a field when I did the db upgrade. _________________ http://www.headfuzz.co.uk/
http://www.robotfuzz.co.uk/ |
|
| Back to top |
|
 |
ginge Site Admin
Joined: 14 Jan 2006 Posts: 1028 Location: Manchester, UK
|
|
| Back to top |
|
 |
Cliff
Joined: 23 Jan 2007 Posts: 150 Location: Saratoga, CA
|
Posted: Tue May 08, 2007 5:07 am Post subject: |
|
|
Barry,
I don't know if you have noticed, but it seem that Latex is not playing nice here.
Cliff |
|
| Back to top |
|
 |
mpthompson
Joined: 02 Jan 2006 Posts: 650 Location: San Carlos, CA
|
Posted: Tue May 08, 2007 4:55 pm Post subject: |
|
|
Thanks Cliff. I think that Barry and I had forgotten that Latex was installed on the old site and that page didn't survive the translation. I'll need to look into this.
-Mike |
|
| Back to top |
|
 |
ginge Site Admin
Joined: 14 Jan 2006 Posts: 1028 Location: Manchester, UK
|
Posted: Tue May 08, 2007 5:05 pm Post subject: |
|
|
Hi Mike/Cliff/All
I am having a little trouble with LaTeX. It is installed, and so are the support packages. The LaTeX docs are a little sketchy, and I am way out of my depth on this one. Any ideas people?
Barry _________________ http://www.headfuzz.co.uk/
http://www.robotfuzz.co.uk/ |
|
| Back to top |
|
 |
mpthompson
Joined: 02 Jan 2006 Posts: 650 Location: San Carlos, CA
|
Posted: Tue May 08, 2007 5:15 pm Post subject: |
|
|
I would be out of my depth with Latex as well. This was installed as a request from Stefan and somehow Andy got it working within the Windows NT environment on the old site. I'll look through my old emails to see if they exchanged instructions on the installation.
-Mike |
|
| Back to top |
|
 |
ginge Site Admin
Joined: 14 Jan 2006 Posts: 1028 Location: Manchester, UK
|
|
| Back to top |
|
 |
ginge Site Admin
Joined: 14 Jan 2006 Posts: 1028 Location: Manchester, UK
|
|
| Back to top |
|
 |
mpthompson
Joined: 02 Jan 2006 Posts: 650 Location: San Carlos, CA
|
Posted: Tue May 08, 2007 5:47 pm Post subject: |
|
|
Terrific. Thanks. I wasn't finding anything in my past email that would have helped.
-Mike |
|
| Back to top |
|
 |
Cliff
Joined: 23 Jan 2007 Posts: 150 Location: Saratoga, CA
|
Posted: Mon May 21, 2007 12:49 pm Post subject: |
|
|
This is a test.
There has not been a post in the last 4 days - I'm just trying to figure out whether the forum is broke or if everybody died.
Cliff |
|
| Back to top |
|
 |
ginge Site Admin
Joined: 14 Jan 2006 Posts: 1028 Location: Manchester, UK
|
|
| Back to top |
|
 |
|