Icy Phoenix

I've fixed the UPI2DB problem when merging topic... about KB I should need more info... :roll:

When did you get this error? :shock:

In ACP / Knowledge Base / Articles Management and clicking on the title of one of the article's title ...

Lucky wrote: [View Post]

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.

andrea75 wrote: [View Post]

Lucky wrote: [View Post]

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

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 !

If you don't have too many articles, you can try to drop KB tables and add them again from scratch!

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

:(

I confirm this error.
But topics are merged, anyway.

ganesh wrote: [View Post]

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" ?

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 ...

Zuker wrote: [View Post]

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.... :oops: I love perfection.. :roll:

Try this:
OPEN modcp.php
FIND

REPLACE WITH


Let me know.

Mighty Gorgon wrote: [View Post]

Try this:
OPEN modcp.php
FIND

Code: [Download] [Hide] [Select]

Code: [Download] [Show]

$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_sql)";

REPLACE WITH

Code: [Download] [Hide] [Select]

Code: [Download] [Show]

$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

I'll checck, but I think that my code should solve that problem, because I've already fixed it some weeks ago. :roll:

Please stop opening new topics for this error.

Can you try this file please?