MySQL Problems

Well I am quite a newb when it comes to mySQL, and I am getting a few errors after restoring my backed up .sql files on a new domain.

The story: Old domain expired, new domain bought and set up with new hosting account. All .sql query files readded.

My script: IPB site integration

I am basically having an error on each part of my site where the integration is involved. Take a look: zetaanime.net/index.php

Please help, I don't know why after the restoration it turned out like this.

Here is an EXAMPLE error:
mySQL query error: SELECT t.*, p.*, g.g_dohtml AS usedohtml FROM ipb_topics t LEFT JOIN ipb_posts p ON (t.tid=p.topic_id) LEFT JOIN ipb_members m ON (p.author_id=m.id) LEFT JOIN ipb_groups g ON (m.mgroup=g.g_id) WHERE t.tid='102' AND p.new_topic='1'

mySQL error:
mySQL error code:
Date: Monday 21st of March 2005 09:01:41 PM

You're writing the following
Here is an EXAMPLE error:
mySQL query error: SELECT t.*, p.*, g.g_dohtml AS usedohtml FROM ipb_topics t LEFT JOIN ipb_posts p ON (t.tid=p.topic_id) LEFT JOIN ipb_members m ON (p.author_id=m.id) LEFT JOIN ipb_groups g ON (m.mgroup=g.g_id) WHERE t.tid='102' AND p.new_topic='1'

mySQL error:
mySQL error code:
Date: Monday 21st of March 2005 09:01:41 PM

Could you be more specific ? Normally the MySQL error is a string describing what goes wrong.
Here, it only gives the date and hour.

ANother thing : you should try to run this SQL instruction in a mySQL GUI, like Navicat, just to see whether
the SQL instruction itself returns one or more records. That way, you're sure the SQL statement is OK
and the error is inside your program.