SMF skinned with subdreamer database error

[jurdim]

Hi
i am new here and dont know a thing about MySQL or PHP and need help with a problem.
I skinned my forum with the skin function in my subdreamer website wich works great the only problem i have with the intregation is the news item of the forum if i want to display it on a page in the subdreamer website i get the following error
Database error in Subdreamer

Invalid SQL: SELECT forum_id AS id, forum_name AS name FROM smf_forums ORDER BY forum_name ASC
Error: Table 'khvinfo.smf_forums' doesn't exist
Error number: 1146
Date: Monday 14th of January 2008 08:19:39 PM
File: http://www.khvinfo.nl/admin/myplugins.php [nofollow]

All other functions like latest posts work fine just this one doesn't
Can someone help me with this ?
My website Url is http://www.koi-keur.nl [nofollow]

Gr Jurgen

[vbgamer45]

Does the khvinfo database contain table called smf_forums?

[jurdim]

Hi

No it doesn't is that the problem? and if so how do i make this database is that difficult?

Gr Jurgen

[vbgamer45]

NOt really sure how subdreamer works but you can change the query
SELECT forum_id AS id, forum_name AS name FROM smf_forums ORDER BY forum_name ASC
The query
SELECT forum_id AS id, forum_name AS name FROM databasename.smf_forums ORDER BY forum_name ASC

[jurdim]

Sorry but as i said i have absolutely no knowledge of datbases en query's
what you wrote could very wel be the solution but how do i do that
I can come as far ad viewing the database but thats it
Can you explain what i need to do and how to do it.

Gr Jurgen

[SleePy]

Have you asked the author of subdreamer this? they will know more than we can only guess at on there coding.