HELP Forum not working :(

[Mae]

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

 

[artacus]

First one doesn't work because MOD is a reserved word.

 

Second one is not even connecting to the db.

[Mae]

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?

[artacus]

well you can get around using reserved words by quoting them `mod` But its better to just avoid using them.