Icy Phoenix

Old Support Topics - Errors With KB And UPI2DB

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

When did you get this error? :shock:

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

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.

KugeLSichA [ Sat 02 Sep, 2006 23:03 ]
Post subject: Re: Errors With KB And UPI2DB

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

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

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

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

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:

Mighty Gorgon [ Sun 01 Oct, 2006 20:52 ]
Post subject: Re: Errors With KB And UPI2DB

Try this:
OPEN modcp.php
FIND

Code: [Hide] [Select]

						$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "

							WHERE topic_id IN ($topic_id_sql)";

REPLACE WITH

Code: [Hide] [Select]

						$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

Mighty Gorgon wrote: [View Post]
Try this:
OPEN modcp.php
FIND

Code: [Hide] [Select]
Code: [Show]
$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_sql)";

REPLACE WITH

Code: [Hide] [Select]
Code: [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

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

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

Mighty Gorgon wrote: [View Post]
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

andrea75 wrote: [View Post]
Mighty Gorgon wrote: [View Post]
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. :wink: