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 #40409 is a reply to message #40408]

Wed, 27 February 2008 01:21

WilliamBurns

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

Karma:

Senior Member

OK, although I don't know what the word "reads" is doing in the query (is it a variable or a keyword of some sort?), I was able to verify in the manual that both "READ" and "READS" are reserved words in mysql 5.0. Now that I have learned how to do a manual SELECT, I was able to change "reads" to "_reads" and the query appears to work, at least in terms of syntax:

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_i
d
-> LEFT JOIN fud261_forum_read fr ON fr.forum_id=f.id AND fr.user_id=2 ORDER BY v.id;
+----+--------------------------------------+------------------------------ -----+----+-----
---+
| id | name | name | id | _rea
ds |
+----+--------------------------------------+------------------------------ -----+----+-----
---+
| 12 | Current Books, Articles, Films, etc. | Religion and Ministry Discussions | 3 |
1 |
| 22 | Whole-Community Catechesis | Religion and Ministry Discussions | 3 |
0 |
| 19 | Current ML Issue | Religion and Ministry Discussions | 3 |
0 |
| 15 | Environment & Art | Religion and Ministry Discussions | 3 |
0 |
| 17 | Liturgical Music | Religion and Ministry Discussions | 3 |
1 |
| 16 | Liturgy and Liturgical Ministry | Religion and Ministry Discussions | 3 |
1 |
| 8 | Pastoral Ministry/Social Justice | Religion and Ministry Discussions | 3 |
0 |
| 14 | RCIA and Catechesis | Religion and Ministry Discussions | 3 |
0 |
+----+--------------------------------------+------------------------------ -----+----+-----
---+
8 rows in set (0.22 sec)
-----------------------------------------------------------

Just generally, what should I do? Can I search through the php looking for "reads" and changing it to "_reads"? What about "read"? Can you tell me what the word "reads" means in the query we have been working with?

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: Sat Sep 14 22:22:13 GMT 2024

Total time taken to generate the page: 0.06699 seconds