It appears you have not yet registered with our community. To register please click here...

vbulletin-skins-forum
| Discussions: 2,597 | Messages: 7,448 | Members: 10,713 | Online: 19 | Newest : Occuddy (Welcome!)
Logo
All times are GMT -5. The time now is 07:47 PM.

Go Back   Forums Help - vBulletin, IPB, phpBB, SMF skins and community > Forums Help Services & Products Area > Forums Help Support Center > Members Support

Members Support Forums Help members support

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 08-12-2007, 02:47 PM   #1 (permalink)
User Profile
evicerator11
Junior Member
 

Join Date: Aug 2007
Posts: 1
Total Points: 159
Donate
My Photos: (0)
Problem - IPB forum error/mysql? Help if you can

Not sure if I can post this here or not. I'm just making some rounds from links I found from a Google search.

Anyways, about a month ago my IPB forum went on the fritz for no apparent reason (I am the only one with admin access and had not used or done anything from the admin panel in almost 6 months.). The forums are all there and intact, but upon logging in, I and other members receive the white error screen with the "Mysql Error" box and this is the error it gives.

I am completely unable to decipher this and am hoping that someone with a better knowledge of Mysql or IPB can translate and prescribe a fix (if there is one). This is a community forum for gaming friends that has been online and active for over 2 years now and we have a good deal of memories on it. Sadly I neglected my admin duties of making backups of the forum in the event that this happened.

Thanks for any and all help that can be offered.



Code:
mySQL query error: SELECT mod.mid as is_mod, m.id, m.name, m.mgroup, m.password, m.email, m.allow_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,
                              m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
            				  m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, g.*
            				  FROM ibf_members m
            				    LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
            				    LEFT JOIN ibf_moderators mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup )
            				  WHERE m.id='1'

mySQL error: 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 'mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup )
            				  WHERE m.' at line 6
mySQL error code: 1064
Date: Sunday 12th of August 2007 02:37:19 PM
evicerator11 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Points Per Thread View: 1
Points Per Thread: 15
Points Per Reply: 5


Similar Threads
Thread Thread Starter Forum Replies Last Post
8 Tips for Starting and Maintaining a Successful Online Forum ForumsHelp Forums Articles 1 08-21-2008 03:17 AM
[3.6.2]Cyb - Advanced Forum Rules Cybernetec Add-ons 2 01-06-2008 01:47 PM
What is Beehive Forum? ForumsHelp Beehive Forum 0 03-09-2007 01:47 AM
General Tips for Running your Forum ("Ways to Make Your Forum A Hit") King Kovifor Forums Articles 4 02-08-2007 12:24 AM
Before advertising your forum ForumsHelp vBulletin Guides 25 02-07-2007 02:19 AM


Links: Babyforum.com | Deejayforum.com | Hometalkcafe.com | Equineboard.com | Evboard.com


Forums Help: Forum Skin Design and Professional Services RSS Feeds



Powered by vBulletin® Version 3.6.7
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Forums Help - All Rights Reserved