| Re: Moving whole website to a different server |
Tue, 12 February 2008 14:07 |
|
|
Thanks.
I changed the GLOBALS.php references to be symlinks in the wforum directory and in the wforum/adm directory, and I changed the /usr/local/forumdata/scr directory to be 777.
However I got essentially the same messages, as follows:
Notice: Only variable references should be returned by reference in /usr/local/forumdata/include/theme/default/db.inc on line 211
Notice: Only variable references should be returned by reference in /usr/local/forumdata/include/theme/default/db.inc on line 207
Warning: copy(/usr/local/forumdata/src/db.inc.t) [function.copy]: failed to open stream: Permission denied in /usr/local/forumdata/include/compiler.inc on line 506
Warning: fopen(/usr/local/forumdata/include/theme/default/security.inc) [function.fopen]: failed to open stream: Permission denied in /usr/local/forumdata/include/compiler.inc on line 367
Couldn't write to /usr/local/forumdata/include/theme/default/security.inc
The theme rebuild appears to stop at this point. Do I need broader permissions on the folders mentioned above?
I'm wondering if the temporary domain name might be causing a problem (because of the security mention).
Since some of my permissions were not set correctly, is there some documentation showing what all the permissions should be?
|
|
|
|
| Re: Moving whole website to a different server |
Wed, 13 February 2008 19:16 |
|
|
I changed the msg_1 file from 775 to 666, and the messages folder to 777, but I still get stopped in exactly the same place, with exactly the same messages, talking about line 506 and line 367 in compiler.inc.
I notice that on our older/current account, the forumdata folder is 711 and most of the folders within are 777. I tried changing the comparable folders to 777, but still no change in symptoms.
I had been using FTP to work with my older account. Since the new one requires SSH for certain functions, I went to the old account and learned that the true path to "see" the forumdata folder with SSH is /usr/home/rpi/usr/local/forumdata. On the new server, the path appears to be /usr/local/forumdata. I don't think this is relevant because the GLOBALS.php file did not use the longer path.
Should I be matching the permissions on the "old" (running) system? The control panel comes up nicely on the new system, but it does stop with the same four messages when I attempt to rebuild the theme.
|
|
|
|
| Re: Moving whole website to a different server |
Thu, 14 February 2008 14:16 |
|
|
I found that the Global directory was not in the right place for my problem above. It was some how pointing to another account. Make Sure FUDform folder is in the right place (in the accoutn home folder) and that all symbolic links point to it. Once we got this straight and permisions set right, the forum worked properly.
|
|
| Re: Moving whole website to a different server |
Thu, 14 February 2008 16:13 |
|
|
Thanks so much. the theme rebuild appears to have completed normally.
Question: I notice that on the old/existing account installation the permissions are pretty restricted compared to the 666, for example. Should I go over the new system and attempt to set permissions the way the old one is set up?
Also, I am still getting a bunch of warnings and notices such as this one:
Notice: Only variable references should be returned by reference in /usr/local/forumdata/include/theme/default/db.inc on line 211
I assume there is a setting that suppresses them from displaying, but I have not found it if it exists.
NOW, I must have moved from the frying pan right into the fire. I just clicked on my first topic link on the forum home page, and I get this message:
Notice: Only variable references should be returned by reference in /usr/local/apache2/htdocs/wforum/index.php on line 214
Notice: Only variable references should be returned by reference in /usr/local/apache2/htdocs/wforum/index.php on line 214
UNABLE TO WRITE TO SQL LOG FILE
(/usr/local/apache2/htdocs/wforum/index.php:121
/usr/local/apache2/htdocs/wforum/theme/default/thread.php:475
/usr/local/apache2/htdocs/wforum/theme/default/thread.php:496
/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
|
|
| Re: Moving whole website to a different server |
Sun, 17 February 2008 12:22 |
|
|
|
If you put the " CASE WHEN 1200338472 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END" expression inside brackets does the query run properly?
|
|
|
|
|
|
| Re: Moving whole website to a different server |
Wed, 20 February 2008 17:29 |
|
|
I modified the query to have square brackets where requested. Running the query manually from the command line generates the same message, saying that there is an error in the SQL syntax.
mysql version 5.0.45
|
|
| Re: Moving whole website to a different server |
Wed, 20 February 2008 22:00 |
|
|
Oops.
I had a tech support fellow change the php.ini file so as to suppress all the notices and warnings that were occurring, and then I went to show him the SQL error, and the darn thing worked instead of giving me the error. I was able to look up an actual message. I had been playing around with the ssh mysql interface just a little bit, but only to display databases and tables. I will push the forum software a bit harder, but assuming it works, I assume I will backup the board data on the old site, download it, upload it to the new site, and "restore" it somehow so that it wipes out the data that is currently in place which is a few weeks old now.
|
|
|
|
| Re: Moving whole website to a different server |
Thu, 21 February 2008 13:31 |
|
|
I do not understand what is happening. When I attempt to access posts on the forum, it seems to be working perfectly (and for no apparent reason). When I attempt to run the query manually, I get the following, both with "reads" and with "_reads" — It looks like it doesn't like the way the command is broken up on several lines.
mysql> SELECT f.id, f.name, c.name, c.id, CASE WHEN 1200338472 < m.post_stamp AND (fr.last_view I -> S NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS reads FROM fud261_fc_view v INNER JOI
-> N 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 'I
S NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS
reads FROM fud261_' at line 1
---------------------------------
and when I type it in at the command line instead of pasting, I get:
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 1
mysql>
Why is the forum working?
|
|
| Re: Moving whole website to a different server |
Thu, 21 February 2008 14:26 |
|
|
|
The mysql manual for 5.0.45 does not seem to show a list of language differences from prior releases. It does show a CASE function as well as a CASE statement. I don't know the difference, except that the CASE statement requires an END CASE while the function can do with just an END. Can it be wanting to interpret the CASE function as a statement?
|
|
| Re: Moving whole website to a different server |
Fri, 22 February 2008 16:17 |
|
|
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?
|
|
|
|
| Re: Moving whole website to a different server |
Sun, 24 February 2008 16:50 |
|
|
Yes I have tried the query with square brackets [ ] around the CASE statement. It returns the same error message with or without the brackets, In other words, it never has worked when done as a stand-alone query. But then why does the forum function correctly sometimes? Is there a place in one of the modules where I might attempt to modify some code to add the square brackets?
Here is the excerpted query with the square brackets in place:
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 '[CASE WHEN 1200338472 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp >' at line 1
For what it is worth, I seem to be unable to hang the forum as an unlogged in viewer. Once I login, I am unable to access any posts, or topics.
I attempted to look up the syntax in the mysql manual for version 5.0, and I see no syntax issue in the function itself. The manual (for the second version) reads:
CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END
The first version returns the result where value=compare_value. The second version returns the result for the first condition that is true. If there was no matching result value, the result after ELSE is returned, or NULL if there is no ELSE part.
mysql> SELECT CASE 1 WHEN 1 THEN 'one'
-> WHEN 2 THEN 'two' ELSE 'more' END;
-> 'one'
mysql> SELECT CASE WHEN 1>0 THEN 'true' ELSE 'false' END;
-> 'true'
mysql> SELECT CASE BINARY 'B'
-> WHEN 'a' THEN 1 WHEN 'b' THEN 2 END;
-> NULL
The default return type of a CASE expression is the compatible aggregated type of all return values, but also depends on the context in which it is used. If used in a string context, the result is returned as a string. If used in a numeric context, then the result is returned as a decimal, real, or integer value.
Note
The syntax of the CASE expression shown here differs slightly from that of the SQL CASE statement described in Section 17.2.10.2, “CASE Statement”, for use inside stored routines. The CASE statement cannot have an ELSE NULL clause, and it is terminated with END CASE instead of END.
|
|
| Re: Moving whole website to a different server |
Mon, 25 February 2008 18:41 |
|
|
The syntax error may have more to do with the AS that follows the CASE expression thsn it does with the CASE expression.
I have been looking for syntax changes, and I found the following note about JOINS via google. Can it be part of the trouble? Here is the note:
Beginning with MySQL 5.0.12, natural joins and joins with USING, including outer join variants, are processed according to the SQL:2003 standard. The goal was to align the syntax and semantics of MySQL with respect to NATURAL JOIN and JOIN ... USING according to SQL:2003. However, these changes in join processing can result in different output columns for some joins. Also, some queries that appeared to work correctly in older versions must be rewritten to comply with the standard.
|
|
|
|
| Re: Moving whole website to a different server |
Mon, 25 February 2008 20:06 |
|
|
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
|
|
| Re: Moving whole website to a different server |
Tue, 26 February 2008 18:58 |
|
|
Ok, the problem the "reads" it seems newer version of MySQL consider this to be a keyword causing the query to fail.
I tried looking for the query inside existing version of the forum but cannot find it.
|
|
| Re: Moving whole website to a different server |
Tue, 26 February 2008 20:21 |
|
|
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?
|
|
| Re: Moving whole website to a different server |
Wed, 27 February 2008 18:34 |
|
|
I tried looking through the code files (having no idea where to really start looking, and I do not find the exact query anywhere — by eye. I did not look for it with a search function.
I did find a couple dozen CASE functions, but all but two or three of them already have enclosing parentheses around them. (attach.inc.t, forumsel.inc.t, and index.php.t need parens)
I did not see any reference to "reads." Can you give me a hierarchy of forum files, or maybe just tell me where to look first, second, etc.? Would I start with the include folder? Or with a template folder? If I do make a code change, what do I do to make it "live" — or does that depend on where the change occurs?
|
|
|
|
| Re: Moving whole website to a different server |
Wed, 27 February 2008 19:40 |
|
|
I believe I have found the query: It is in my forumdata/include/theme/default/forumsel.inc. Here is the operative section, with th e CASE info on line 1:
$c = uq('SELECT f.id, f.name, c.name, c.id, CASE WHEN '.$GLOBALS['usr']->last_read.' < 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
'.($mod ? '' : 'LEFT JOIN fud261_mod mm ON mm.user_id='._uid.' AND mm.forum_id=f.id INNER JOIN fud261_group_cache g1 ON g1.resource_id=f.id AND g1.user_id=2147483647 LEFT JOIN fud261_group_cache g2 ON g2.resource_id=f.id AND g2.user_id='._uid).'
LEFT JOIN fud261_forum_read fr ON fr.forum_id=f.id AND fr.user_id='._uid.'
'.($mod ? '' : ' WHERE mm.id IS NOT NULL OR ((CASE WHEN g2.id IS NULL THEN g1.group_cache_opt ELSE g2.group_cache_opt END) & 1) > 0').'
ORDER BY v.id');
Should I change it? If I do, what do I do then. I still have no idea about "reads".
|
|
|
|
| Re: Moving whole website to a different server |
Mon, 03 March 2008 15:09 |
|
|
Thank you so much! You are a genius as well as a kind person! I changed the attach.inc.t, forumsel.inc.t, and index.php.t files to bracket CASE function references, and I changed the one "reads" to "_reads" and then I rebuilt the theme again and the forum seems to be up and running.
|
|
| Re: Moving whole website to a different server |
Fri, 07 March 2008 18:03 |
|
|
I seem to be having another problem in moving the forum from one site to another. Can you tell me what is going on and what to do about it? Can it have anything to do with having mysql as the database name on the old site, but rpimysql as the databasename on the new site?
On the old site, I went to the administrative control panel and dumped a backup of the active forum. I left the box checked so the output would be compressed.
I downloaded the dump file to my desktop, then uploaded it on the new site and put it in the same folder where I got it.
On the new site, I went to the control panel and selected "Import Data" and a small green gauge came on the bottom of the screen. It speedily got to about 50% but then hung there. I did it twice. One of the times I went home and left it overnite. In the morning, I had a browser error. In looking at the forum, The home page was updated with counts, etc., but on all of the forums there are no messages. Even though several of the forums show multiple "pages" of messages, they all say there are no messages in this forum. The apache log shows:
[Fri Mar 07 21:39:27 2008] [error] [client 66.249.67.54] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:wjb@rpinet.com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /usr/local/apache2/htdocs/wforum/index.php on line 49
The last two errors in the forum sql error file were:
[Fri Mar 7 22:15:00 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZGV4LnBocDoxMTY8YnIgLz4KL3V zci9sb2NhbC9hcGFjaGUyL2h0ZG9jcy93Zm9ydW0vaW5kZXgucGhwOjM0MjxiciAvPgovdXNyL2 xvY2FsL2FwYWNoZTIvaHRkb2NzL3dmb3J1bS90aGVtZS9kZWZhdWx0L2luZGV4LnBocDo5OTxic iAvPgovdXNyL2xvY2FsL2FwYWNoZTIvaHRkb2NzL3dmb3J1bS9pbmRleC5waHA6MTE0NTxiciAv PgopIDEwNjQ6IFlvdSBoYXZlIGFuIGVycm9yIGluIHlvdXIgU1FMIHN5bnRheDsgY2hlY2sgdGh lIG1hbnVhbCB0aGF0IGNvcnJlc3BvbmRzIHRvIHlvdXIgTXlTUUwgc2VydmVyIHZlcnNpb24gZm 9yIHRoZSByaWdodCBzeW50YXggdG8gdXNlIG5lYXIgJycgYXQgbGluZSAxPGJyIC8+ClF1ZXJ5O iBVUERBVEUgZnVkMjYxX3NlcyBTRVQgc3lzX2lkPSc4MWNmOTZkZDhhMzZhNjBlNDNkMGYwZDVi ZWZmOGY3ZicsIGZvcnVtX2lkPTAsIHRpbWVfc2VjPTEyMDQ5MjgxMDAsIGFjdGlvbj0nQnJvd3N pbmcgdGhlICZsdDthIGhyZWY9XCZxdW90O2luZGV4LnBocD90PWluZGV4XCZxdW90OyZndDtmb3 J1bSBsaXN0Jmx0Oy9hJmd0OycsIHJldHVybnRvPScnIFdIRVJFIGlkPTxiciAvPgpTZXJ2ZXIgV mVyc2lvbjogNS4wLjQ1PGJyIC8+CltSZWZlcnJpbmcgUGFnZV0gaHR0cDovLzE5OC4xMDYuMjku NS88YnIgLz4K
[Fri Mar 7 22:23:41 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZGV4LnBocDoxMTY8YnIgLz4KL3V zci9sb2NhbC9hcGFjaGUyL2h0ZG9jcy93Zm9ydW0vaW5kZXgucGhwOjM2ODxiciAvPgovdXNyL2 xvY2FsL2ZvcnVtZGF0YS9pbmNsdWRlL3RoZW1lL2RlZmF1bHQvZXJyLmluYzo2MzxiciAvPgovd XNyL2xvY2FsL2FwYWNoZTIvaHRkb2NzL3dmb3J1bS90aGVtZS9kZWZhdWx0L3JlcG9ydC5waHA6 MTI4PGJyIC8+Ci91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZGV4LnBocDoxMTQ 1PGJyIC8+CikgMTA2NDogWW91IGhhdmUgYW4gZXJyb3IgaW4geW91ciBTUUwgc3ludGF4OyBjaG VjayB0aGUgbWFudWFsIHRoYXQgY29ycmVzcG9uZHMgdG8geW91ciBNeVNRTCBzZXJ2ZXIgdmVyc 2lvbiBmb3IgdGhlIHJpZ2h0IHN5bnRheCB0byB1c2UgbmVhciAnJyBhdCBsaW5lIDE8YnIgLz4K UXVlcnk6IFVQREFURSBmdWQyNjFfc2VzIFNFVCBkYXRhPSdzOjEyNzpcJnF1b3Q7Jmx0O2ZpZWx kc2V0Jmd0OyZsdDtsZWdlbmQmZ3Q7RVJST1I6IFlvdSBhcmUgbm90IGxvZ2dlZC1pbiZsdDsvbG VnZW5kJmd0O1RvIGFjY2VzcyB0aGlzIHBhZ2UgeW91IG11c3QgYmUgYSBtZW1iZXIgb2YgdGhpc yBmb3J1bS4mbHQ7L2ZpZWxkc2V0Jmd0OyZsdDticiAvJmd0O1wmcXVvdDs7JywgcmV0dXJudG89 J3Q9cmVwb3J0JmFtcDttc2dfaWQ9MTc5NDUmYW1wO3JpZD0wJmFtcDtTPTYxMzRjZjBlNzQ0MzI yZGYxN2EyMWFmMTNiNmVhNmRhJyBXSEVSRSBpZD08YnIgLz4KU2VydmVyIFZlcnNpb246IDUuMC 40NTxiciAvPgpbUmVmZXJyaW5nIFBhZ2VdIHVua25vd248YnIgLz4K
The last line in the forum access log is:
[Fri Mar 7 22:32:23 GMT 2008] W0Vycm9yXSBJbnZhbGlkIElucHV0PGJyIC8+W01lc3NhZ2UgU2VudCB0byBVc2VyXSBZb3UgaGF 2ZSBmb2xsb3dlZCBhbiBpbnZhbGlkIGxpbmsuIFBsZWFzZSBub3RpZnkgdGhlIDxhIGhyZWY9Im 1haWx0bzp3amJAcnBpbmV0LmNvbSI+d2VibWFzdGVyPC9hPiBob3cgeW91IGdvdCBoZXJlLjxic iAvPltVc2VyIElQXSA2Ni4yNDkuNjcuNTQ8YnIgLz5bUmVxdWVzdGVkIFVSTF0gaHR0cDovL3Jw aXZwcy5zZWN1cmVzaXRlcy5uZXQvd2ZvcnVtL2luZGV4LnBocD90PXRyZWUmdGg9MzEwNiZyaWQ 9MCZTPWE5NDhkZTU5MDk0NjUyOWE2Y2NiZDkwMzRiZWY1YzBiPGJyIC8+
|
|
|
|
| Re: Moving whole website to a different server |
Mon, 10 March 2008 12:42 |
|
|
|
Thanks for the response. No. I see no function on the control panel to clear the session table. Would I do it from the mysql command line? What would the syntax be?
|
|
|
|
| Re: Moving whole website to a different server |
Tue, 11 March 2008 14:33 |
|
|
Thank you.
when I first looked at it, the fud261_ses table contained over 2000 "entries". After deleting the entries once, the import hung again. Looking at that table again, it had over 300 entries, so I deleted them again and imported again.
There was no change in the operation after doing this. The import still essentially halts at about half way, and afterwards there are no messages in any of the forums.
However, I seem to have bolluxed things up, somehow, because now when I get the adm login screen it does not recognize my admin username/password. Also, it appears I may have interrupted the rebuilding of a theme, because the control panel (before I got excluded from viewing it) contained a long list of warnings, on through all the various languages, of which the first few were:
WARNING: couldn't create '/usr/local/forumdata//include/GLOBALS_HELP'
WARNING: couldn't create '/usr/local/forumdata//include/adm.inc'
WARNING: couldn't create '/usr/local/forumdata//include/cat.inc'
WARNING: couldn't create '/usr/local/forumdata//include/core.inc'
WARNING: couldn't create '/usr/local/forumdata//include/customtags.inc'
WARNING: couldn't create '/usr/local/forumdata//include/email_filter.inc'
WARNING: couldn't create '/usr/local/forumdata//include/email_msg_format.inc'
WARNING: couldn't create '/usr/local/forumdata//include/ext.inc'
WARNING: couldn't create '/usr/local/forumdata//include/forum_adm.inc'
WARNING: couldn't create '/usr/local/forumdata//include/glob.inc'
WARNING: couldn't create '/usr/local/forumdata//include/groups_adm.inc'
WARNING: couldn't create '/usr/local/forumdata//include/ipfilter.inc'
WARNING: couldn't create '/usr/local/forumdata//include/login_filter.inc'
The forumdata/errors/sql_errors file contained:
[Tue Mar 11 17:42:04 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
[Tue Mar 11 17:44:38 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
[Tue Mar 11 17:44:50 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
[Tue Mar 11 17:45:00 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
[Tue Mar 11 18:02:40 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
[Tue Mar 11 18:05:44 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
Finally, the apache log contained several of the following messages (along with a lot of warnings and notices):
[Tue Mar 11 17:42:04 2008] [error] [client 66.249.73.18] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:wjb@rpinet.com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /usr/local/apache2/htdocs/wforum/index.php on line 49
[Tue Mar 11 17:45:00 2008] [error] [client 66.249.73.18] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:wjb@rpinet.com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /usr/local/apache2/htdocs/wforum/index.php on line 49
I do not understand these latter message at all.
It looks like the only thing I can do is repeat moving the forum from the beginning. using all the info in this thread as a guide. Is that my best course?
|
|
|
|
| Re: Moving whole website to a different server |
Fri, 14 March 2008 20:04 |
|
|
Repeating the move from one host to another:
I dumped my mysql database and copied the folders and data to my new system. I went through this very thread and made all the permissions canges and all the code changes that were appropriate, and I made symlinks to the GLOBALS.php file in my wforum and wforum/adm directories. Darned if I didn't end up with the same initial problem as I had before. The php "require" function appears to be having trouble with GLOBALS.php.
I did one other thing, perhaps it matters. I transferred all the files from my initial document root at /usr/local/apache2/htdocs to a different document root at /home/rpivps/www/rpinet.com. This is the folder the production website will work out of. I believe I changed the appache config file accordingly and all of my other web pages work. I did put the forumdata folder in the same place where it was.
The following message was generated lots of times while the symlinks were in place:
[Fri Mar 14 23:19:14 2008] [error] [client 66.249.73.18] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required './GLOBALS.php' (include_path='.:') in /home/rpivps/www/rpinet.com/wforum/index.php on line 13
So, figuring that the symlinks were not working, I removed them and put a physical copy of GLOBALS.php in both places. That, at least changed my error log message slightly to:
[Fri Mar 14 23:28:09 2008] [error] [client 71.6.3.234] PHP Fatal error: Unknown: Failed opening required '/home/rpivps/www/rpinet.com/wforum/adm/index.php' (include_path='.:') in Unknown on line 0
[Fri Mar 14 23:28:42 2008] [error] [client 71.6.3.234] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required './GLOBALS.php' (include_path='.:') in /home/rpivps/www/rpinet.com/wforum/index.php on line 13
The actual GLOBALS.php file is owned by rpivps (my userid). Root is listed as the symlink owner. Can that have something to do with the problem?
|
|
|
|
|
|
|
|
| Re: Moving whole website to a different server |
Mon, 17 March 2008 19:48 |
|
|
Thanks for the reply.
Yes, I am using the same login from the original install.
I tried a second and third userid, after testing out the passwords on the "old" installation, and upon putting the same info into the login panel, I generated this message on the login screen above the login box in red letters:
Only administrators with proper access credentials can login via this control panel
The above message stays on the screen if I use another non-administrator id, but when I go back to the administrator id, theh red message disappears. It seems to know that it is an administrator, but won't complete the login.
Somehow, I don't think the system is correctly getting access to all of the table data. I say this because I have manually selected the first hundred or so records from my fud261_users table, and my administrator login is the second one in the table (after Anonymous Coward whose password is 1). The table appears to be in good order, with the password field reading a consistent number of gibberish characters for all the entries.
Another possible clue: a Google "bot" is repeatedly generating "Fatal Error" messages (along with some Notice messages) in the log file that say:
[Mon Mar 17 23:34:41 2008] [error] [client 66.249.73.71] PHP Notice: Only variable references should be returned by reference in /home/rpivps/www/rpinet.com/wforum/index.php on line 214
[Mon Mar 17 23:34:41 2008] [error] [client 66.249.73.71] PHP Notice: Only variable references should be returned by reference in /home/rpivps/www/rpinet.com/wforum/index.php on line 214
[Mon Mar 17 23:34:41 2008] [error] [client 66.249.73.71] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/rpivps/www/rpinet.com/wforum/theme/default/index.php' (include_path='.:') in /home/rpivps/www/rpinet.com/wforum/index.php on line 1145
Can I override the password in the table somehow?
Or is there still some lurking permissions issue blocking access?
|
|
|
|
| Re: Moving whole website to a different server |
Tue, 18 March 2008 16:17 |
|
|
Users_opt field value for administrator is 5405687
But now my situation has changed slightly. I found a messages file in /usr/local/forumdata/thm/default/tmpl which had only 600 permissions. After changing it to 666, my administrator screen did finally show up!
However, I don't think the theme rebuild worked because it generated the following message:
Missing Message entry custom_avatar_queue inside i18n/english/msg
Plus, the forum home page won't display.
I found a msg file at /usr/local/forumdata/thm/default/i18n/english, and I tried peeking at it with vi. It does appear to have a line in it which has the string - custom_avatar_queue followed by some space and then Custom Avatar Queue. Can you tell me what is going on? And what to do?
|
|
Calendar
Search
Help
Members
Control Panel
Logout [ CommonCrawl [Bot] ]
Home