Lifelesspeople.com
Home Hosting News Forum Links Status Support About

 Forum FAQsForum FAQs  Knowledge BaseKnowledge Base  RulesRules   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   HostingHosting   RegisterRegister 
 DonateDonate   WikiWiki   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

SQL Error - Help Please

 
Lifelesspeople.com Forum Index -> Support Questions
Post new topic   Reply to topic View previous topic :: View next topic  
Author Message
Graeme
Grandmaster Poster


Joined: 12 Apr 2003
Posts: 321
Location: Dublin
PostPosted: Tue Apr 10, 2007 5:18 pm    Post subject: SQL Error - Help Please Reply with quote
Since the server move, loads of my topics with more than 2-3 pages are out of sync and says

Quote:
Information

No posts exist for this topic


I tried to use the script that i have installed to fix this (as it happened with 2-3 threads that had 100s of pages but it came up with this error

Code:
Could not update forum stats

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 'WHERE topic_id = 49482' at line 1

UPDATE phpbb_topics SET topic_replies = -1, topic_last_post_id = WHERE topic_id = 49482

Line : 390
File : admin_resync_forum_stats.php


So i tried to log into my cpanel as normal through www.socceram.net/cpanel but nothing was there so i logged into the cpanel through lifelesspeople.com/cpanel which worked. But i cant seem to find PhpMyAdmin in order to try and fix this error

Any ideas?
Back to top
 
LP-Trel
Zen


Joined: 02 Dec 2002
Posts: 5751
Location: Nirvana by Boredom
PostPosted: Fri Apr 13, 2007 3:12 am    Post subject: Reply with quote
You'll have to put in a support ticket.

Your website is handled differently than every other website hosted here due to its size.
_________________
* Knowledge Base * Wiki * Forum FAQs *
Back to top
 
Display posts from previous:   
Post new topic   Reply to topic    Lifelesspeople.com Forum Index -> Support Questions All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


[ Home | Hosting | News | Forum | Links | System Status | About | Archive | Donate ]
Powered by phpBB © 2001, 2002 phpBB Group
All trademarks and copyrights on this page are owned by their respective owners. Posts and comments are owned by the poster. Everything else © 2001 - 2007 Lifelesspeople.com