Simple Machines Community Forum

General Community => Scripting Help => Aiheen aloitti: jurdim - tammikuu 15, 2008, 05:05:25 IP

Otsikko: SMF skinned with subdreamer database error
Kirjoitti: jurdim - tammikuu 15, 2008, 05:05:25 IP
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

Otsikko: Re: SMF skinned with subdreamer database error
Kirjoitti: vbgamer45 - tammikuu 19, 2008, 12:04:39 AP
Does the khvinfo database contain table called smf_forums?
Otsikko: Re: SMF skinned with subdreamer database error
Kirjoitti: jurdim - tammikuu 19, 2008, 07:23:28 AP
Hi

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

Gr Jurgen
Otsikko: Re: SMF skinned with subdreamer database error
Kirjoitti: vbgamer45 - tammikuu 19, 2008, 11:27:12 AP
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
Otsikko: Re: SMF skinned with subdreamer database error
Kirjoitti: jurdim - tammikuu 19, 2008, 06:29:08 IP
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
Otsikko: Re: SMF skinned with subdreamer database error
Kirjoitti: SleePy - helmikuu 10, 2008, 11:47:03 IP
Have you asked the author of subdreamer this? they will know more than we can only guess at on there coding.