FUDforum: How To » Moving whole website to a different server

Home » FUDforum » How To » Moving whole website to a different server

Show: Today's Messages :: Polls :: Message Navigator

Re: Moving whole website to a different server [message #40382 is a reply to message #40381]

Fri, 22 February 2008 21:17

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma:

Senior Member

OK, the messages seem to work ok, but when I go to login as administrator I get:
UNABLE TO WRITE TO SQL LOG FILE
(/usr/local/apache2/htdocs/wforum/index.php:121
/usr/local/apache2/htdocs/wforum/theme/default/msg.php:1091
/usr/local/apache2/htdocs/wforum/theme/default/msg.php:1112
/usr/local/apache2/htdocs/wforum/index.php:1145
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reads FROM fud261_fc_view v INNER JOIN fud261_forum f ON f.id=v.f INNER' at line 1
Query: SELECT f.id, f.name, c.name, c.id, CASE WHEN 1200338472 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS reads FROM fud261_fc_view v INNER JOIN fud261_forum f ON f.id=v.f INNER JOIN fud261_cat c ON c.id=v.c LEFT JOIN fud261_msg m ON m.id=f.last_post_id LEFT JOIN fud261_forum_read fr ON fr.forum_id=f.id AND fr.user_id=2 ORDER BY v.id
Server Version: 5.0.45

The system appears to let me login, and it appears to run ok afterwards, but I'm still getting this message which looks identical to the earlier ones.

In chasing this with site support people, we did not find it happening after the one occurrance. I was able to login without messages, and everything seems to work perfectly. This seems to be a situational or occasional thing, somehow. In just trying to access a post, it happened again. It seems to happen randomly. When it does happen, the user is surely baffled as to what to do. Any thoughts?

[Updated on: Fri, 22 February 2008 22:33]

Report message to a moderator

[Message index]

		Moving whole website to a different server By: WilliamBurns on Mon, 04 February 2008 20:56
		Re: Moving whole website to a different server By: Ilia on Mon, 04 February 2008 21:14
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 06 February 2008 01:28
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 06 February 2008 18:27
		Re: Moving whole website to a different server By: Ilia on Thu, 07 February 2008 01:46
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 07 February 2008 22:03
		Re: Moving whole website to a different server By: Ilia on Sun, 10 February 2008 14:29
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 11 February 2008 18:11
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 11 February 2008 18:20
		Re: Moving whole website to a different server By: Ilia on Mon, 11 February 2008 18:25
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 12 February 2008 00:14
		Re: Moving whole website to a different server By: Ilia on Tue, 12 February 2008 17:49
		Re: Moving whole website to a different server By: sallen812 on Tue, 12 February 2008 17:57
		Re: Moving whole website to a different server By: sallen812 on Tue, 12 February 2008 18:00
		Re: Moving whole website to a different server By: Ilia on Wed, 13 February 2008 20:40
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 14 February 2008 00:16
		Re: Moving whole website to a different server By: Ilia on Thu, 14 February 2008 17:56
		Re: Moving whole website to a different server By: sallen812 on Thu, 14 February 2008 19:16
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 14 February 2008 21:13
		Re: Moving whole website to a different server By: Ilia on Sun, 17 February 2008 17:22
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 19 February 2008 21:11
		Re: Moving whole website to a different server By: Ilia on Wed, 20 February 2008 03:05
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 20 February 2008 22:29
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 21 February 2008 03:00
		Re: Moving whole website to a different server By: Ilia on Thu, 21 February 2008 13:41
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 21 February 2008 18:31
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 21 February 2008 19:26
		Re: Moving whole website to a different server By: WilliamBurns on Fri, 22 February 2008 21:17
		Re: Moving whole website to a different server By: Ilia on Sun, 24 February 2008 15:57
		Re: Moving whole website to a different server By: WilliamBurns on Sun, 24 February 2008 21:50
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 25 February 2008 23:41
		Re: Moving whole website to a different server By: Ilia on Tue, 26 February 2008 00:06
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 26 February 2008 01:06
		Re: Moving whole website to a different server By: Ilia on Tue, 26 February 2008 23:58
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 27 February 2008 01:21
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 27 February 2008 23:34
		Re: Moving whole website to a different server By: Ilia on Thu, 28 February 2008 00:23
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 28 February 2008 00:40
		Re: Moving whole website to a different server By: Ilia on Fri, 29 February 2008 01:21
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 12 February 2008 19:07
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 03 March 2008 20:09
		Re: Moving whole website to a different server By: WilliamBurns on Fri, 07 March 2008 23:03
		Re: Moving whole website to a different server By: Ilia on Sun, 09 March 2008 17:34
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 10 March 2008 16:42
		Re: Moving whole website to a different server By: Ilia on Mon, 10 March 2008 23:25
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 11 March 2008 18:33
		Re: Moving whole website to a different server By: Ilia on Wed, 12 March 2008 17:37
		Re: Moving whole website to a different server By: WilliamBurns on Sat, 15 March 2008 00:04
		Re: Moving whole website to a different server By: Ilia on Mon, 17 March 2008 03:39
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 17 March 2008 18:14
		Re: Moving whole website to a different server By: Ilia on Mon, 17 March 2008 22:35
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 17 March 2008 23:48
		Re: Moving whole website to a different server By: Ilia on Tue, 18 March 2008 18:13
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 18 March 2008 20:17
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 19 March 2008 19:15
		Re: Moving whole website to a different server By: Ilia on Thu, 20 March 2008 00:11
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 24 March 2008 17:36
		Re: Moving whole website to a different server By: Ilia on Mon, 24 March 2008 18:09
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 24 March 2008 20:46
		Re: Moving whole website to a different server By: Ilia on Tue, 25 March 2008 20:19
		Re: Moving whole website to a different server By: WilliamBurns on Fri, 28 March 2008 19:22
		Re: Moving whole website to a different server By: Ilia on Sun, 30 March 2008 14:43
		Re: Moving whole website to a different server By: WilliamBurns on Sun, 30 March 2008 19:38
		Re: Moving whole website to a different server By: voisardf on Wed, 02 April 2008 19:50

Previous Topic:	disable poll
Next Topic:	query string for subject/body

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:32:35 GMT 2024

Total time taken to generate the page: 0.07059 seconds