| Will not show Category [message #4897] |
Mon, 12 August 2002 23:30  |
 |
esm2002
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
upgraded to FUDforum 2.3.0RC1 ( as shown in System Configuration )
| Quote: |
Done: Checking Approvals
Updating counts for topics
threads updated
Updating forums
Updating topic counts for forums
Forum: Announcements
Query Failed: SELECT count(*) FROM fud2_thread RIGHT JOIN fud2_msg ON fud2_msg.thread_id=fud2_thread.id WHERE fud2_thread.forum_id=2
Reason: You have an error in your SQL syntax near 'ON fud2_msg.thread_id=fud2_thread.id WHERE fud2_thread.forum_id=2' at line 1
From: /home/acct351/public_html/fudforum/br/adm/consist.php
Server Version: 3.23.22-beta
|
ALSO, the category with the most msgs has two pages of msgs but will not show any messages...
Actually, I think maybe the problem is the last 4 or 5 posted msgs. When I try to bring them up when looking at their last post int their profile, I get the above messages. The ones prior to that all seem to come up just fine.
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
[Updated on: Tue, 13 August 2002 00:53] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Will not show Category [message #4927 is a reply to message #4924] |
Tue, 13 August 2002 19:46  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
No, the bug was fixed in latest CVS, meaning that it is not yet in any release downloadable from this site.
FUDforum Core Developer
|
|
|
|
| Re: Will not show Category [message #5011 is a reply to message #4927] |
Thu, 15 August 2002 21:11 |
|
esm2002
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
is the fix in the FUDforum 2.3.0RC2 update zip?
Still cannont see any messages in the category that has the bad messages. Now I get the following during the consistency check:
| Quote: |
Forum: All Other
thread count:1
post count:1
Updating post counts
finished forum counts
Checking topic notification entries against users
OK
Checking topic notification entries against topics
OK
Checking forum notification entries against users
OK
Checking forum notification entries against forums
OK
Updating Topic Last_Post_Id Field
Done: Updating Topic Last_Post_Id Field
Updating Forum Last_Post_Id Field
Done: Updating Forum Last_Post_Id Field
Checking email notification entries against topics
OK
Checking topic votes against topics
OK
Checking topic votes against users
OK
Rebuilding Topic Views
Query Failed: INSERT INTO fud2_thread_view (thread_id,forum_id,page,tmp) SELECT fud2_thread.id, fud2_thread.forum_id, 4294967294, CASE WHEN is_sticky='Y' AND (fud2_msg.post_stamp+fud2_thread.orderexpiry>1029450383 OR fud2_thread.orderexpiry=0) THEN 4294967294 ELSE fud2_thread.last_post_date END AS sort_order_fld FROM fud2_thread INNER JOIN fud2_msg ON fud2_thread.root_msg_id=fud2_msg.id WHERE forum_id=2 AND fud2_msg.approved='Y' ORDER BY sort_order_fld DESC, fud2_thread.last_post_id DESC
Reason: Unknown column 'tmp' in 'field list'
From: /home/acct351/public_html/fudforum/br/adm/consist.php
Server Version: 3.23.22-beta
|
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
|
|
|
|
| Re: Will not show Category [message #5012 is a reply to message #5011] |
Thu, 15 August 2002 21:42 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
run a query:
show fields from fud2_thread_view; and reply with the output
FUDforum Core Developer
|
|
|
|
| Re: Will not show Category [message #5013 is a reply to message #5012] |
Thu, 15 August 2002 22:57 |
|
esm2002
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
Database acct351 - table fud2_thread_view running on localhost
SQL-query
SQL-query : [Edit]
SHOW COLUMNS FROM fud2_thread_view
Field Type Null Key Default Extra Privileges
forum_id int(10) unsigned PRI 0 select,insert,update,references
page int(10) unsigned PRI 0 select,insert,update,references
thread_id int(10) unsigned 0 select,insert,update,references
pos int(10) unsigned PRI 0 select,insert,update,references
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
|
|
|
|
| Re: Will not show Category [message #5014 is a reply to message #5013] |
Thu, 15 August 2002 23:57 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
It would appear you are missing a field inside this table.
You can add with the following query:
ALTER TABLE fud2_thread_view ADD tmp INT UNSIGNED;
FUDforum Core Developer
|
|
|
|
| Re: Will not show Category [message #5015 is a reply to message #5014] |
Fri, 16 August 2002 00:16 |
|
esm2002
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
Your SQL-query has been executed successfully
SQL-query :
ALTER TABLE fud2_thread_view ADD tmp INT UNSIGNED
well, we got a little further along:
Rebuild File Extension Filter
Done: Rebuilding File Extension Filter
Rebuilding users' last post ids
Done: Rebuilding users' last post ids
Rebuilding group cache
Query Failed: UPDATE fud2_group_members SET up_VIEW='Y',up_POST='N',up_REPLY='N',up_EDIT='N',up_DEL='N',up_STICKY='N',u p_POLL='N',up_FILE='N',up_VOTE='N',up_RATE='N',up_SPLIT='N',up_LOCK='N',up_ MOVE='N',up_SML='N',up_IMG='N',up_VISIBLE='N' WHERE id=7
Reason: Unknown column 'up_VISIBLE' in 'field list'
From: /home/acct351/public_html/fudforum/br/adm/consist.php
Server Version: 3.23.22-beta
SQL-query
SQL-query : [Edit]
show columns from fud2_group_members
Field Type Null Key Default Extra Privileges
id int(10) unsigned PRI NULL auto_increment select,insert,update,references
user_id int(10) unsigned MUL 0 select,insert,update,references
group_id int(10) unsigned MUL 0 select,insert,update,references
group_leader enum('Y','N') N select,insert,update,references
approved enum('Y','N') Y select,insert,update,references
up_VIEW enum('Y','N') N select,insert,update,references
up_POST enum('Y','N') N select,insert,update,references
up_REPLY enum('Y','N') N select,insert,update,references
up_EDIT enum('Y','N') N select,insert,update,references
up_DEL enum('Y','N') N select,insert,update,references
up_STICKY enum('Y','N') N select,insert,update,references
up_POLL enum('Y','N') N select,insert,update,references
up_FILE enum('Y','N') N select,insert,update,references
up_VOTE enum('Y','N') N select,insert,update,references
up_RATE enum('Y','N') N select,insert,update,references
up_SPLIT enum('Y','N') N select,insert,update,references
up_LOCK enum('Y','N') N select,insert,update,references
up_MOVE enum('Y','N') N select,insert,update,references
up_SML enum('Y','N') N select,insert,update,references
up_IMG enum('Y','N') N select,insert,update,references
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Will not show Category [message #5106 is a reply to message #5075] |
Tue, 20 August 2002 21:41 |
|
esm2002
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
here's the output| Quote: |
ALTER TABLE DROP hidden;
ALTER TABLE DROP hidden;
ALTER TABLE fud2_group_members ADD up_VISIBLE ENUM ('Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE fud2_groups CHANGE p_VIEW p_READ ENUM ('I', 'Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE fud2_group_members CHANGE up_VIEW up_READ ENUM ('Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE DROP style;
ALTER TABLE DROP creation_date;
UPDATE fud2_group_members SET user_id=2147483647 WHERE user_id=4294967295;
UPDATE fud2_group_cache SET user_id=2147483647 WHERE user_id=4294967295;
ALTER TABLE fud2_thread ADD INDEX(is_sticky,orderexpiry);
Query Failed: # copyright : (C) 2001,2002 Advanced Internet Designs Inc. # email : forum(at)prohost(dot)org # # $Id: fud_mlist.tbl,v 1.1 2002/07/24 12:47:18 hackie Exp $ # # This program is free software
Reason: Query was empty
From: /home/acct351/public_html/fudforum/br/query3.php
Server Version: 3.23.22-beta
|
Still not showing messages
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
|
|
|
|
|
|
| Re: Will not show Category [message #5161 is a reply to message #5160] |
Thu, 22 August 2002 16:16 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I should have an upgrade script ready for you as soon as 2.3.0 stable is released tommorow (i hope).
I am planning to rewrite the SQL upgrade code for the next release and that should solve the problem you are seeing.
FUDforum Core Developer
|
|
|
|
|
|
| Re: Will not show Category [message #5289 is a reply to message #5161] |
Mon, 26 August 2002 15:23 |
|
esm2002
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
ran the upgrade script to 2.3.0
this error is showing| Quote: |
Rebuild File Extension Filter
Done: Rebuilding File Extension Filter
Rebuilding users' last post ids
Done: Rebuilding users' last post ids
Rebuilding group cache
Query Failed: UPDATE fud2_group_members SET up_VIEW='Y',up_POST='N',up_REPLY='N',up_EDIT='N',up_DEL='N',up_STICKY='N',u p_POLL='N',up_FILE='N',up_VOTE='N',up_RATE='N',up_SPLIT='N',up_LOCK='N',up_ MOVE='N',up_SML='N',up_IMG='N',up_VISIBLE='N' WHERE id=7
Reason: Unknown column 'up_VISIBLE' in 'field list'
From: /home/acct351/public_html/fudforum/br/adm/consist.php
Server Version: 3.23.22-beta
|
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
|
|
|
|
| Re: Will not show Category [message #5290 is a reply to message #5289] |
Mon, 26 August 2002 15:46 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Yeah, that is still the old problem, as I've said in my previous messages to you I'll send you an upgrade script from next release, which actually checks which MySQL upgrades are missing and apply them.
That one should be able to resolve the problem you are seeing.
FUDforum Core Developer
|
|
|
|
|
|
|
|
| Re: Will not show Category [message #5315 is a reply to message #5314] |
Tue, 27 August 2002 12:56 |
|
esm2002
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
| Quote: |
ALTER TABLE DROP hidden;
ALTER TABLE DROP hidden;
ALTER TABLE fud2_group_members ADD up_VISIBLE ENUM ('Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE fud2_groups CHANGE p_VIEW p_READ ENUM ('I', 'Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE fud2_group_members CHANGE up_VIEW up_READ ENUM ('Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE DROP style;
ALTER TABLE DROP creation_date;
UPDATE fud2_group_members SET user_id=2147483647 WHERE user_id=4294967295;
UPDATE fud2_group_cache SET user_id=2147483647 WHERE user_id=4294967295;
ALTER TABLE fud2_thread ADD INDEX(is_sticky,orderexpiry);
CREATE TABLE fud2_mlist ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, forum_id INT NOT NULL, name VARCHAR(255) NOT NULL, mlist_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'N', allow_frm_post ENUM('Y', 'N') NOT NULL DEFAULT 'N', frm_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'Y', allow_mlist_attch ENUM('Y', 'N') NOT NULL DEFAULT 'Y', allow_mlist_html ENUM('Y', 'N') NOT NULL DEFAULT 'N', complex_reply_match ENUM('Y', 'N') NOT NULL DEFAULT 'N', subject_regex_haystack TEXT, subject_regex_needle TEXT, body_regex_haystack TEXT, body_regex_needle TEXT, index(forum_id) ) ;
CREATE TABLE fud2_nntp ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, forum_id INT NOT NULL, nntp_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'N', allow_frm_post ENUM('Y', 'N') NOT NULL DEFAULT 'N', frm_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'Y', allow_nntp_attch ENUM('Y', 'N') NOT NULL DEFAULT 'Y', complex_reply_match ENUM('Y', 'N') NOT NULL DEFAULT 'N', server VARCHAR(255) NOT NULL, newsgroup VARCHAR(255) NOT NULL, port INT NOT NULL, timeout INT NOT NULL, auth ENUM('NONE', 'ORIGINAL', 'SIMPLE') NOT NULL DEFAULT 'NONE', login VARCHAR(255), pass VARCHAR(255), index(forum_id) ) ;
|
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
|
|
|
|
|
|
| Re: Will not show Category [message #5319 is a reply to message #5317] |
Tue, 27 August 2002 13:39 |
|
esm2002
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
this query produced a blank screen. The consistency checker ran with no errors.
But it still won't show the messages in the category view.
If I go to the members view and start looking at the last posts, I get the following error ( but it stops about the day I did the upgrade on August 2 - msgs before that show up fine )| Quote: |
Query Failed: SELECT fud2_msg.id AS msg_id, fud2_thread_view.pos, fud2_thread.id, fud2_msg.subject FROM fud2_thread_view INNER JOIN fud2_thread ON fud2_thread_view.thread_id=fud2_thread.id INNER JOIN fud2_msg ON fud2_thread.root_msg_id=fud2_msg.id WHERE fud2_thread_view.forum_id=3 AND fud2_thread_view.page= AND fud2_thread_view.pos IN (-1, 1) ORDER BY pos
Reason: You have an error in your SQL syntax near 'AND fud2_thread_view.pos IN (-1, 1) ORDER BY pos' at line 15
From: /home/acct351/public_html/fudforum/br/index.php
Server Version: 3.23.22-beta
|
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
[Updated on: Tue, 27 August 2002 16:51] Report message to a moderator |
|
|
|
| Re: Will not show Category [message #5320 is a reply to message #5319] |
Tue, 27 August 2002 13:48 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
| esm2002 wrote on Tue, 27 August 2002 09:39 |
this query produced a blank screen. The consistency checker ran with no errors.
|
Good, it means that your MySQL table structure is correct now.
On which page you are getting this error (url)?
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
| Re: Will not show Category [message #5341 is a reply to message #5336] |
Wed, 28 August 2002 11:57 |
|
esm2002
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
As a follow-up, when I am not logged in as a registered user, I cannot see any of the forums. If I go to the members listing screen and click on a member, I get the following error.| Quote: |
Query Failed: SELECT count(*) FROM fud2_poll INNER JOIN fud2_msg ON fud2_poll.id=fud2_msg.poll_id INNER JOIN fud2_thread ON fud2_thread.id=fud2_msg.thread_id INNER JOIN fud2_forum ON fud2_thread.forum_id=fud2_forum.id WHERE fud2_poll.owner=111 AND fud2_thread.forum_id IN () AND fud2_thread.locked='N' AND fud2_msg.approved='Y' AND fud2_forum.cat_id!=0
Reason: You have an error in your SQL syntax near ') AND fud2_thread.locked='N' AND fud2_msg.approved='Y' AND fud2_forum.cat_id!=0' at line 8
From: /home/acct351/public_html/fudforum/br/index.php
Server Version: 3.23.22-beta
|
Maybe looking back at the sequence of things will help. If I sign in and go to the members listing screen and click on a member, I can click on any member without error. On August 2 a member named deshka registerd and made a post to the message board. That post can be read without error from the members board. On August 2, since I was scheduled to be home for the coming week, I decided to upgrade from 1.98 to 2.2.4RC3. there was a problem and we got things working by Aug 6, as I recollect. I registered as Wilbur Post just to test but did not post a message. A couple of other new members resgisted that day. On Aug 7 barbee registered as a new member and posted two messages. When I am in the members listing and click on the link to her last post, I get the following error| Quote: |
Query Failed: SELECT fud2_msg.id AS msg_id, fud2_thread_view.pos, fud2_thread.id, fud2_msg.subject FROM fud2_thread_view INNER JOIN fud2_thread ON fud2_thread_view.thread_id=fud2_thread.id INNER JOIN fud2_msg ON fud2_thread.root_msg_id=fud2_msg.id WHERE fud2_thread_view.forum_id=3 AND fud2_thread_view.page= AND fud2_thread_view.pos IN (-1, 1) ORDER BY pos
Reason: You have an error in your SQL syntax near 'AND fud2_thread_view.pos IN (-1, 1) ORDER BY pos' at line 15
From: /home/acct351/public_html/fudforum/br/index.php
Server Version: 3.23.22-beta
|
One last thing. When I sign in as the Admin, I can see the message boards. When I sign in as a regular member, Wilbur Post, I cannot see any of the forums. But I can go to the members board and view any msgs before August 3 ( see above ). I can also view the unread posts - see attached. Strangely, I see one of barbee's msg but cannot see her other message ( see wp01.jpg and wp01a.jpg ). I tried clicking on the [more unread messages] link but nothing showed up ( see wp02.jpg ).
Could it be that one of barbee's msg has become "corrupted" and thus causing the problems? Since I can view msgs before her just fine, but not after, and including, her msg, it would seem the program is OK. Maybe not all of the problem but mabye a start.
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
|
|
|
|
| Re: Will not show Category [message #5343 is a reply to message #5341] |
Wed, 28 August 2002 12:49 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Thank you for the detailed report. Hopefuly all of the information you've provided will help me to find this bug and solve it.
FUDforum Core Developer
|
|
|
|
| Re: Will not show Category [message #5346 is a reply to message #5343] |
Wed, 28 August 2002 14:49 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The other problem is 'more interesting' it is actually the result of your host (?) using a very old version of MySQL which has a bug with INSERT SELECT syntax, causing only the last row instead of all rows to be inserted. Consult with your provider and see if they would be willing to upgrade the MySQL.
To give you some idea of how old your MySQL is, your current version is 3.23.22-beta, while the current stable release is 2.23.52, that's 30 bug revisions old.
FUDforum Core Developer
|
|
|
|
|
|
| Re: Will not show Category [message #5348 is a reply to message #5347] |
Wed, 28 August 2002 16:49 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The current problem is not a result of FUDforum, so re-installing won't help the issue. The problem you experiencing is the result of a bug in the MySQL server you are using.
P.S.
Despite the Apache team claiming that Apache 2 is stable, some of the more popular modules such as PHP, mod_ssl, mod_perl as several other still do not work 'stably' under Apache 2. As far as PHP is concerned stable support for Apache 2 probably will not be avaliable from another half a year and event hat is an optimistic outlook on the situation.
So, waiting for Apache 2 is NOT a good idea at all.
FUDforum Core Developer
|
|
|
|
|
|
|
|
| Re: Will not show Category [message #6562 is a reply to message #5349] |
Wed, 16 October 2002 22:24 |
|
esm2002
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
I am still getting this same error from late august.
I do not have any custom themes installed but I did add a table to the header and footer. I removed them and compared the remaining code to a working forum: the remaining code was the same. So the code was as it came "out the box" But that did not correct the problem.
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
[Updated on: Thu, 17 October 2002 00:55] Report message to a moderator |
|
|
|
| Re: Will not show Category [message #6588 is a reply to message #6562] |
Thu, 17 October 2002 21:31 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
You mentioned in another thread some problems went away after 2.3.2 upgrade, is this problem still present or did it go away as well?
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]