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 #40399 is a reply to message #40398]

Tue, 26 February 2008 01:06

WilliamBurns

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

Karma:

Senior Member

I know I am too wordy, but your message might be too brief!
I don't understand the reference to JOIN syntax being common.

I repeated the manual SELECT command using parentheses around the CASE function. I got this response:

mysql> 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;
ERROR 1064 (42000): 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 JOIN fud' at line 3

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: Mon Nov 25 21:02:48 GMT 2024

Total time taken to generate the page: 0.03962 seconds