 Can't view topic name in EGW [message #25895] |
Fri, 24 June 2005 10:36  |
Borman
Messages: 2
Registered: June 2005
Location: Kiev
Karma: 0
|
Junior Member |
|
|
when i RUN Forum Consistency i have this error...
help please to correct this problem
Rebuilding Topic Views
(f:\projekt_files\fudforum\3814588639\include\theme\default\db.inc:105
f:\projekt_files\fudforum\3814588639\include\theme\default\th_adm.inc:110
f:\home\domain.com\www\egroupware\fudforum\3814588639\adm\consist.php:433
) 1062: Duplicate entry '5-2147483645-0' for key 1
Query: INSERT INTO phpgw_fud_thread_view (thread_id,forum_id,page,tmp) SELECT phpgw_fud_thread.id, phpgw_fud_thread.forum_id, 2147483645, CASE WHEN thread_opt>=2 AND (phpgw_fud_msg.post_stamp+phpgw_fud_thread.orderexpiry>1119608910 OR phpgw_fud_thread.orderexpiry=0) THEN 4294967294 ELSE phpgw_fud_thread.last_post_date END AS sort_order_fld FROM phpgw_fud_thread INNER JOIN phpgw_fud_msg ON phpgw_fud_thread.root_msg_id=phpgw_fud_msg.id WHERE forum_id=5 AND phpgw_fud_msg.apr=1 ORDER BY sort_order_fld DESC, phpgw_fud_thread.last_post_id DESC
Server Version: 4.1.10a-nt
[Referring Page] http://domain.com/egroupware/fudforum/3814588639/adm/consist.php?
[Updated on: Fri, 24 June 2005 13:19] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Can't view topic name in EGW [message #27287 is a reply to message #26082] |
Fri, 02 September 2005 22:01  |
BrianC
Messages: 1
Registered: September 2005
Karma: 0
|
Junior Member |
|
|
Was this problem ever resolved?
I have the same problem of not seeing topics and get the same error on consistency check. In addition, when trying to create topics after the first one I get:
(/var/www/htdocs/egroupware/fudforum/3814588639/index.php:131
/var/www/htdocs/egroupware/fudforum/3814588639/theme/default/post.php:2805
/var/www/htdocs/egroupware/fudforum/3814588639/theme/default/post.php:1668
/var/www/htdocs/egroupware/fudforum/3814588639/theme/default/post.php:3751
/var/www/htdocs/egroupware/fudforum/3814588639/index.php:412
) 1062: Duplicate entry '4-2147483645-0' for key 1
Query: INSERT INTO phpgw_fud_thread_view (thread_id,forum_id,page,tmp) SELECT phpgw_fud_thread.id, phpgw_fud_thread.forum_id, 2147483645, CASE WHEN thread_opt>=2 AND (phpgw_fud_msg.post_stamp+phpgw_fud_thread.orderexpiry>1125675632 OR phpgw_fud_thread.orderexpiry=0) THEN 4294967294 ELSE phpgw_fud_thread.last_post_date END AS sort_order_fld FROM phpgw_fud_thread INNER JOIN phpgw_fud_msg ON phpgw_fud_thread.root_msg_id=phpgw_fud_msg.id WHERE forum_id=4 AND phpgw_fud_msg.apr=1 ORDER BY sort_order_fld DESC, phpgw_fud_thread.last_post_id DESC
Server Version: 4.0.24
[Referring Page] http://localhost/egroupware/fudforum/3814588639/index.php?t=post&frm_ id=4&
although it does seem to add the topic.
Any help would be appreciated, Thanks.
[Updated on: Fri, 02 September 2005 22:01] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]