https://www.icyphoenix.com/viewtopic.php?f=35&t=215
-----------------------------------
Lucky
Tue 29 Aug, 2006 17:25

Errors With KB And UPI2DB
-----------------------------------
I have this error message

[code]
Could not delete topic reads

DEBUG MODE

DELETE FROM phpbb_upi2db_unread_posts WHERE topic_id IN ()

Line : 846
File : modcp.php
[/code]

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

[code]
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
[/code]


-----------------------------------
Lucky
Tue 29 Aug, 2006 20:26

Re: Errors With KB And UPI2DB
-----------------------------------
Ops !

 :oops: 

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

Re: Errors With KB And UPI2DB
-----------------------------------
this one is for Tom  :mrviolet:


-----------------------------------
Lucky
Wed 30 Aug, 2006 13:52

Re: Errors With KB And UPI2DB
-----------------------------------
Tom ?


-----------------------------------
Tom
Wed 30 Aug, 2006 16:35

Re: Errors With KB And UPI2DB
-----------------------------------
[quote user="Lucky" post="1789"]Tom ?[/quote]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

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

Re: Errors With KB And UPI2DB
-----------------------------------
I'll check these when I have some free time... :wink:


-----------------------------------
Tom
Thu 31 Aug, 2006 14:12

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

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

Re: Errors With KB And UPI2DB
-----------------------------------
[quote user="Lucky" post="1955"]How have you fixed this error ?[/quote]I don't remember. :oops:


-----------------------------------
Lucky
Thu 31 Aug, 2006 22:22

Re: Errors With KB And UPI2DB
-----------------------------------
Any other could help me ?


-----------------------------------
KugeLSichA
Fri 01 Sep, 2006 13:58

Re: Errors With KB And UPI2DB
-----------------------------------
[quote user="Lucky" post="1955"]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 ?[/quote]

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

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

Re: Errors With KB And UPI2DB
-----------------------------------
[quote user="Lucky" post="1997"]and now I have not other errors ...[/quote]

ok so now you can enjoy XS  :mrorange:


-----------------------------------
Lucky
Fri 01 Sep, 2006 14:28

Re: Errors With KB And UPI2DB
-----------------------------------
Yes !  :D 

But I'm continuing to have KB error in 058 like in 049 ...  :|


-----------------------------------
Mighty Gorgon
Sat 02 Sep, 2006 05:25

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

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

Re: Errors With KB And UPI2DB
-----------------------------------
[quote user="Lucky" post="2211"]In ACP / Knowledge Base / Articles Management and clicking on the title of one of the article's title ...[/quote]

This is not a bug... I don't have any error.


-----------------------------------
KugeLSichA
Sat 02 Sep, 2006 23:03

Re: Errors With KB And UPI2DB
-----------------------------------
[quote user="andrea75" post="2215"][quote user="Lucky" post="2211"]In ACP / Knowledge Base / Articles Management and clicking on the title of one of the article's title ...[/quote]

This is not a bug... I don't have any error.[/quote]

same here, no error in ACP


-----------------------------------
Lucky
Sun 03 Sep, 2006 00:16

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

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

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

Re: Errors With KB And UPI2DB
-----------------------------------
I confirm this error.
But topics are merged, anyway.


-----------------------------------
Lucky
Mon 04 Sep, 2006 14:33

Re: Errors With KB And UPI2DB
-----------------------------------
[quote user="ganesh" post="2367"]I confirm this error.
But topics are merged, anyway.[/quote]

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

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

Re: Errors With KB And UPI2DB
-----------------------------------
[quote user="Zuker" post="2366"]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

 :([/quote]

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

Re: Errors With KB And UPI2DB
-----------------------------------
Try this:
OPEN [b]modcp.php[/b]
FIND
[codeblock]						$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
							WHERE topic_id IN ($topic_id_sql)";[/codeblock]
REPLACE WITH
[codeblock]						$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
							WHERE topic_id IN ($topic_id_list[$i])";[/codeblock]

Let me know.


-----------------------------------
andrea75
Tue 03 Oct, 2006 14:09

Re: Errors With KB And UPI2DB
-----------------------------------
[quote user="Mighty Gorgon" post="3558"]Try this:
OPEN [b]modcp.php[/b]
FIND
[codeblock]						$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
							WHERE topic_id IN ($topic_id_sql)";[/codeblock]
REPLACE WITH
[codeblock]						$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
							WHERE topic_id IN ($topic_id_list[$i])";[/codeblock]

Let me know.[/quote]

Doesn't work... a ttopics merge the error is this

[b]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[/b]


-----------------------------------
Mighty Gorgon
Mon 16 Oct, 2006 01:53

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

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

Re: Errors With KB And UPI2DB
-----------------------------------
[quote user="Mighty Gorgon" post="5623"]Please stop opening new topics for this error.

Can you try this file please?[/quote]

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

Re: SOLVED -Errors With KB And UPI2DB
-----------------------------------
[quote user="andrea75" post="5718"][quote user="Mighty Gorgon" post="5623"]Please stop opening new topics for this error.

Can you try this file please?[/quote]

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![/quote]
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:


