Mae Posted March 17, 2007 Share Posted March 17, 2007 Hi There *waving* I just switched servers and several of my scripts for forums aren't working, the SQL version on the new server is 4.0.27-standard and the old version was the same...this is an error for one of my forums below any help would be sooo much appreciated!! Thank you Mae **************************************************************** 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='2' 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 ) ' at line 6 mySQL error code: 1064 ******************************************************************* This is another error that I am receiving on another forum... Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'tropika'@'localhost' (using password: YES) in /home/tropika/public_html/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/tropika/public_html/db/mysql4.php on line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/tropika/public_html/db/mysql4.php on line 331 phpBB : Critical Error Could not connect to the database Quote Link to comment https://forums.phpfreaks.com/topic/43141-help-forum-not-working/ Share on other sites More sharing options...
artacus Posted March 17, 2007 Share Posted March 17, 2007 First one doesn't work because MOD is a reserved word. Second one is not even connecting to the db. Quote Link to comment https://forums.phpfreaks.com/topic/43141-help-forum-not-working/#findComment-209507 Share on other sites More sharing options...
Mae Posted March 17, 2007 Author Share Posted March 17, 2007 Thanks for answering Does that mean that I need to take out anything that has the word MOD in it? Also, on the second one I figured out that if I change the cPanel password, I get that error, but if I do a restore on the forum and don't change the password to cPanel,the forum works....have you ever heard of that happening? Quote Link to comment https://forums.phpfreaks.com/topic/43141-help-forum-not-working/#findComment-209519 Share on other sites More sharing options...
artacus Posted March 17, 2007 Share Posted March 17, 2007 well you can get around using reserved words by quoting them `mod` But its better to just avoid using them. Quote Link to comment https://forums.phpfreaks.com/topic/43141-help-forum-not-working/#findComment-209649 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.