Strange Problem With Database.

The time now is Tue 16 Apr, 2024 23:49 • All times are UTC + 1 Hour [DST enabled]

Strange Problem With Database.

Page 1 of 1

Danielc

Joined: August 2006
Posts: 248
Location:

Strange Problem With Database.

Hello everybody..

My web is www.miiconsola.com .

I noticed a problem when i was seeing the statistics. Just after "Top Posters" module, there is a message like this:

Quote:
Unable to update DB Cache

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 'Copyright 2008,2009 Team Twiizers.' tmd ends at 0x802884ac, data starts at 0x80' at line 2

After, there is so much text related to posts.

Screenshot:

How can i solve it?

Thanks!

#1 Thu 08 Jul, 2010 19:37

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

Costa Joined: August 2009 Posts: 175 Location: Athens Hellas	Re: Strange Problem With Database. I am not a expert Have you tried clear cashe from ACP? or Optimize Database from ACP/ DB And Security/Optimize Database?
#2 Fri 09 Jul, 2010 01:43

Danielc Joined: August 2006 Posts: 248 Location:	Re: Strange Problem With Database. Yes, i tried that two things before ask. Thanks!
#3 Fri 09 Jul, 2010 20:29

Mighty Gorgon Luca Libralato Joined: August 2006 Posts: 7191 Location: Borgo San Michele	Re: Strange Problem With Database. Do you have the Smileys statistics block enabled? Can you please try to disable it to check if it is that causing the issue? ____________ Luca SEARCH is the quickest way to get support. Icy Phoenix ColorizeIt - CustomIcy - HON
#4 Tue 27 Jul, 2010 23:42

Danielc Joined: August 2006 Posts: 248 Location:	Re: Strange Problem With Database. Yes, in fact, i had enabled it and that was causing the problem.. I just disabled it.. Do you know what's the problem? Thanks!!
#5 Thu 29 Jul, 2010 00:55

Mighty Gorgon Luca Libralato Joined: August 2006 Posts: 7191 Location: Borgo San Michele	Re: Strange Problem With Database. Smileys block is really tricky, and uses a lot of resources (it searches all the WORDS table). I wouldn't use that, because it could also lead to out of memory error. Anyway I'll have a look at the source code when I have some free time. ____________ Luca SEARCH is the quickest way to get support. Icy Phoenix ColorizeIt - CustomIcy - HON
#6 Mon 02 Aug, 2010 23:12

Danielc Joined: August 2006 Posts: 248 Location:	Re: Strange Problem With Database. Thanks!!!! I just disabled it.
#7 Tue 03 Aug, 2010 00:34

Page 1 of 1

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Tue 16 Apr, 2024 23:49 • 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

Icy Phoenix

Strange Problem With Database.

Was this topic useful?

Was this topic useful?