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
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
Gr Jurgen
Does the khvinfo database contain table called smf_forums?
Hi
No it doesn't is that the problem? and if so how do i make this database is that difficult?
Gr Jurgen
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
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
Have you asked the author of subdreamer this? they will know more than we can only guess at on there coding.