Icy Phoenix
Old Support Topics - Errors With KB And UPI2DB
Lucky [ Tue 29 Aug, 2006 17:25 ]
Post subject: Errors With KB And UPI2DB
I have this error message
- Could not delete topic reads
-
- DEBUG MODE
-
- DELETE FROM phpbb_upi2db_unread_posts WHERE topic_id IN ()
-
- Line : 846
- File : modcp.php
-
If I try to Joint two topics together clicking on the button at the bottom of topic page (see file attached)
And this other error message
- Errore Generale
-
- Could not obtain category data
-
- DEBUG MODE
-
- SQL Error : 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 ' at line 2
-
- SELECT * FROM phpbb_kb_categories WHERE category_id =
-
- Line : 180
- File : functions_kb.php
-
Lucky [ Tue 29 Aug, 2006 20:26 ]
Post subject: Re: Errors With KB And UPI2DB
Ops !
I have forgot to describe the last error message ...
It appear when I click on the KB Title from ACP / Knowledge Base / Articles.
Sorry !
KugeLSichA [ Tue 29 Aug, 2006 23:11 ]
Post subject: Re: Errors With KB And UPI2DB
this one is for Tom
Lucky [ Wed 30 Aug, 2006 13:52 ]
Post subject: Re: Errors With KB And UPI2DB
Tom ?
Tom [ Wed 30 Aug, 2006 16:35 ]
Post subject: Re: Errors With KB And UPI2DB
Tom ?
Yes?
This seems to be another bug.
I had some trouble with merge topic too, but I haven't fugured out the cause.
Lucky [ Wed 30 Aug, 2006 17:22 ]
Post subject: Re: Errors With KB And UPI2DB
You are working about the merge topic function bug or also about the KB error ?
Do you know something about the KB error ?
Mighty Gorgon [ Thu 31 Aug, 2006 01:10 ]
Post subject: Re: Errors With KB And UPI2DB
I'll check these when I have some free time...
Tom [ Thu 31 Aug, 2006 14:12 ]
Post subject: Re: Errors With KB And UPI2DB
I remember that we had this KB error, but it should have been fixed.
Are you sure your DB Update went correctly?
Lucky [ Thu 31 Aug, 2006 21:47 ]
Post subject: Re: Errors With KB And UPI2DB
The only error is the following ...
http://www.icyphoenix.com/viewtopic.php?t=174
but it seems to be not a problem ... and I remember to have KB error also with Build 049 ...
How have you fixed this error ?
Tom [ Thu 31 Aug, 2006 22:15 ]
Post subject: Re: Errors With KB And UPI2DB
How have you fixed this error ?
I don't remember.
Lucky [ Thu 31 Aug, 2006 22:22 ]
Post subject: Re: Errors With KB And UPI2DB
Any other could help me ?
KugeLSichA [ Fri 01 Sep, 2006 13:58 ]
Post subject: Re: Errors With KB And UPI2DB
The only error is the following ...
http://www.icyphoenix.com/viewtopic.php?t=174
but it seems to be not a problem ... and I remember to have KB error also with Build 049 ...
How have you fixed this error ?
hi lucky... in your link you posted the error is, that the table you want to add, allready exists...
or do you still have an other error?
cya
Lucky [ Fri 01 Sep, 2006 14:07 ]
Post subject: Re: Errors With KB And UPI2DB
no ... no ...
I know that it is not a real error and now I have not other errors ...
It was the only DB update error I had, It's the answer about Tom's question, but I know that it is not the cause ...
KugeLSichA [ Fri 01 Sep, 2006 14:13 ]
Post subject: Re: Errors With KB And UPI2DB
and now I have not other errors ...
ok so now you can enjoy XS
Lucky [ Fri 01 Sep, 2006 14:28 ]
Post subject: Re: Errors With KB And UPI2DB
Yes !
But I'm continuing to have KB error in 058 like in 049 ...
Mighty Gorgon [ Sat 02 Sep, 2006 05:25 ]
Post subject: Re: Errors With KB And UPI2DB
I've fixed the UPI2DB problem when merging topic... about KB I should need more info...
When did you get this error?
Lucky [ Sat 02 Sep, 2006 18:36 ]
Post subject: Re: Errors With KB And UPI2DB
In ACP / Knowledge Base / Articles Management and clicking on the title of one of the article's title ...
andrea75 [ Sat 02 Sep, 2006 20:02 ]
Post subject: Re: Errors With KB And UPI2DB
In ACP / Knowledge Base / Articles Management and clicking on the title of one of the article's title ...
This is not a bug... I don't have any error.
KugeLSichA [ Sat 02 Sep, 2006 23:03 ]
Post subject: Re: Errors With KB And UPI2DB
In ACP / Knowledge Base / Articles Management and clicking on the title of one of the article's title ...
This is not a bug... I don't have any error.
same here, no error in ACP
Lucky [ Sun 03 Sep, 2006 00:16 ]
Post subject: Re: Errors With KB And UPI2DB
Strange ... very strange ...
The only one reason could be a my problem with the tables ... but, what is the meaning of my KB error ?
Please help me !
Mighty Gorgon [ Sun 03 Sep, 2006 01:05 ]
Post subject: Re: Errors With KB And UPI2DB
If you don't have too many articles, you can try to drop KB tables and add them again from scratch!
Zuker [ Mon 04 Sep, 2006 04:40 ]
Post subject: Re: Errors With KB And UPI2DB
i've got the same problem when merging topics
Could not delete topic reads
DEBUG MODE
DELETE FROM phpbb_upi2db_unread_posts WHERE topic_id IN ()
Line : 846
File : modcp.php
ganesh [ Mon 04 Sep, 2006 09:25 ]
Post subject: Re: Errors With KB And UPI2DB
I confirm this error.
But topics are merged, anyway.
Lucky [ Mon 04 Sep, 2006 14:33 ]
Post subject: Re: Errors With KB And UPI2DB
I confirm this error.
But topics are merged, anyway.
Yes , me too.
Now I have KB problem to solve ... MG what do you mean about "add them again from scratch" ?
Lucky [ Mon 04 Sep, 2006 23:41 ]
Post subject: Re: Errors With KB And UPI2DB
Another problem with KB.
If I try to use "Optimization Tables" function in ACP / Knowledge Base I will not receive a reply ... a ACP page empty ...
andrea75 [ Sat 23 Sep, 2006 17:37 ]
Post subject: Re: Errors With KB And UPI2DB
i've got the same problem when merging topics
Could not delete topic reads
DEBUG MODE
DELETE FROM phpbb_upi2db_unread_posts WHERE topic_id IN ()
Line : 846
File : modcp.php
It is possible to solve this problem? I know that topics are merged anyway, but....
I love perfection..
Mighty Gorgon [ Sun 01 Oct, 2006 20:52 ]
Post subject: Re: Errors With KB And UPI2DB
Try this:
OPEN
modcp.php
FIND
$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_sql)";
REPLACE WITH
$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_list[$i])";
Let me know.
andrea75 [ Tue 03 Oct, 2006 14:09 ]
Post subject: Re: Errors With KB And UPI2DB
Try this:
OPEN
modcp.php
FIND
$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_sql)";
REPLACE WITH
$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_list[$i])";
Let me know.
Doesn't work... a ttopics merge the error is this
Could not delete topic reads
DEBUG MODE
SQL Error : 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 ')' at line 2
DELETE FROM phpbb_upi2db_unread_posts WHERE topic_id IN ()
Line : 846
File : modcp.php
Mighty Gorgon [ Mon 16 Oct, 2006 01:53 ]
Post subject: Re: Errors With KB And UPI2DB
I'll checck, but I think that my code should solve that problem, because I've already fixed it some weeks ago.
Mighty Gorgon [ Fri 08 Dec, 2006 11:45 ]
Post subject: Re: Errors With KB And UPI2DB
Please stop opening new topics for this error.
Can you try this file please?
andrea75 [ Sat 09 Dec, 2006 09:37 ]
Post subject: Re: Errors With KB And UPI2DB
Please stop opening new topics for this error.
Can you try this file please?
Tested this morning... now all works fine. I dont't know if this problem was only mine, but now, with this last solution I don't have any errors.
THANKS MG!
Mighty Gorgon [ Tue 12 Dec, 2006 01:35 ]
Post subject: Re: SOLVED -Errors With KB And UPI2DB
Please stop opening new topics for this error.
Can you try this file please?
Tested this morning... now all works fine. I dont't know if this problem was only mine, but now, with this last solution I don't have any errors.
THANKS MG!
Great... the file I've attached should only include the few modifications listed above... anyway what is important is that this bug is now definitely gone.