Icy Phoenix

     
 

Home » Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

The time now is Thu 18 Apr, 2024 02:56 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Disable KB mode Download Topic Printable Version Email to a Friend View next topic

Strange Problem With Database.

Strange Problem With Database.

Article
Reply with quote    Download Post  
Post 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:

miiconsola_error


How can i solve it?

Thanks!



 
Danielc - View user's profile Send private message  
Danielc [ 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.

Support us


Strange Problem With Database.

Comments
Reply with quote    Download Post  
Post 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?



 
Costa - View user's profile Send private message  
Costa [ Fri 09 Jul, 2010 01:43 ]
Reply with quote    Download Post  
Post Re: Strange Problem With Database. 
 
Yes, i tried that two things before ask.

Thanks!



 
Danielc - View user's profile Send private message  
Danielc [ Fri 09 Jul, 2010 20:29 ]
Reply with quote    Download Post  
Post 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?



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Tue 27 Jul, 2010 23:42 ]
Reply with quote    Download Post  
Post 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!!



 
Danielc - View user's profile Send private message  
Danielc [ Thu 29 Jul, 2010 00:55 ]
Reply with quote    Download Post  
Post 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.



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Mon 02 Aug, 2010 23:12 ]
Reply with quote    Download Post  
Post Re: Strange Problem With Database. 
 
Thanks!!!! I just disabled it.



 
Danielc - View user's profile Send private message  
Danielc [ Tue 03 Aug, 2010 00:34 ]
Display posts from previous:    

HideWas this topic useful?

Post new topic  Reply to topic  Page 1 of 1
 
 

Home » Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

The time now is Thu 18 Apr, 2024 02:56 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Disable KB mode Download Topic Printable Version Email to a Friend View next topic




 


 
 Powered by Icy Phoenix based on phpBB
Lo-Fi Version - Privacy Policy - Cookie Policy
Generation Time: 0.8085s (PHP: 2% SQL: 98%)
SQL queries: 31 - Debug Off - GZIP Enabled
Design by Luca Libralato 
  cron