SOLVED Errors With KB And UPI2DB

The time now is Sun 15 Jun, 2025 22:03 • All times are UTC + 1 Hour [DST enabled]

SOLVED Errors With KB And UPI2DB

Page 2 of 3
Goto page Previous 1, 2, 3 Next

Mighty Gorgon Luca Libralato Joined: August 2006 Posts: 7192 Location: Borgo San Michele	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? ____________ Luca SEARCH is the quickest way to get support. Icy Phoenix ColorizeIt - CustomIcy - HON
#16 Sat 02 Sep, 2006 05:25

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Lucky Joined: August 2006 Posts: 106	Re: Errors With KB And UPI2DB In ACP / Knowledge Base / Articles Management and clicking on the title of one of the article's title ...
#17 Sat 02 Sep, 2006 18:36

andrea75 Joined: August 2006 Posts: 379 Location: Perugia	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. ____________ My Icy forum: www.lineameteo.it Staff Member @ IcyPhoenix.com & IcyPhoenix.it
#18 Sat 02 Sep, 2006 20:02

KugeLSichA Joined: August 2006 Posts: 803 Location: Dresden	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 ____________ Play Games at GamesCampus!
#19 Sat 02 Sep, 2006 23:03

Lucky Joined: August 2006 Posts: 106	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 !
#20 Sun 03 Sep, 2006 00:16

Mighty Gorgon Luca Libralato Joined: August 2006 Posts: 7192 Location: Borgo San Michele	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! ____________ Luca SEARCH is the quickest way to get support. Icy Phoenix ColorizeIt - CustomIcy - HON
#21 Sun 03 Sep, 2006 01:05

Zuker Joined: August 2006 Posts: 2134 Location: BA	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 ____________ ? Zuker - EDDB - LPM - Sharefields
#22 Mon 04 Sep, 2006 04:40

ganesh Joined: August 2006 Posts: 221 Location: Somewhere... over the Rainbow...	Re: Errors With KB And UPI2DB I confirm this error. But topics are merged, anyway. ____________ Megabass
#23 Mon 04 Sep, 2006 09:25

Lucky Joined: August 2006 Posts: 106	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" ?
#24 Mon 04 Sep, 2006 14:33

Lucky

Joined: August 2006
Posts: 106

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

ottimizza_tabelle.jpg
Description:
Filesize:	14.42 KB
Viewed:	6954 Time(s)

#25 Mon 04 Sep, 2006 23:41

andrea75

Joined: August 2006
Posts: 379
Location:

Perugia

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

I love perfection..

____________
My Icy forum: www.lineameteo.it
Staff Member @ IcyPhoenix.com & IcyPhoenix.it

#26 Sat 23 Sep, 2006 17:37

Mighty Gorgon

Luca Libralato

Joined: August 2006
Posts: 7192
Location:

Borgo San Michele

Re: Errors With KB And UPI2DB

Try this:
OPEN modcp.php
FIND

Code: [Download] [Hide] [Select]

                        $sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "

                            WHERE topic_id IN ($topic_id_sql)";

REPLACE WITH

Code: [Download] [Hide] [Select]

                        $sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "

                            WHERE topic_id IN ($topic_id_list[$i])";

Let me know.

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON

#27 Sun 01 Oct, 2006 20:52

andrea75

Joined: August 2006
Posts: 379
Location:

Perugia

Re: Errors With KB And UPI2DB

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

____________
My Icy forum: www.lineameteo.it
Staff Member @ IcyPhoenix.com & IcyPhoenix.it

#28 Tue 03 Oct, 2006 14:09

Mighty Gorgon Luca Libralato Joined: August 2006 Posts: 7192 Location: Borgo San Michele	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. ____________ Luca SEARCH is the quickest way to get support. Icy Phoenix ColorizeIt - CustomIcy - HON
#29 Mon 16 Oct, 2006 01:53

Mighty Gorgon

Luca Libralato

Joined: August 2006
Posts: 7192
Location:

Borgo San Michele

Re: Errors With KB And UPI2DB

Please stop opening new topics for this error.

Can you try this file please?

modcp.rar
Description:	Modified MODCP	Download
Filename:	modcp.rar
Filesize:	9.79 KB
Downloaded:	204 Time(s)

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON

#30 Fri 08 Dec, 2006 11:45

Page 2 of 3
Goto page Previous 1, 2, 3 Next

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Sun 15 Jun, 2025 22:03 • All times are UTC + 1 Hour [DST enabled]

Permissions List

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events