Forum Hosting  

Go Back   Forum Hosting > IPB Support > IPB Bug Reports
Reload this Page Portal Database Broken?
Register fBuck$ / fStore ProjectsBlogs FAQ Members List Calendar Mark Forums Read

IPB Bug Reports Only errors & bugs should be submitted here


Reply
 
LinkBack Thread Tools Display Modes
Old 06-06-2007, 01:52 PM   #1 (permalink)
Member
 
TankKiller's Avatar
 
Join Date: Jun 2007

Posts: 10
Rep Power: 0 TankKiller is on a distinguished road
fTrader: (0)
fBuck$: 173.0
Bank: 0.0
Total fBuck$: 173.0

My Forumer
My Country:
Red face Portal Database Broken?
Hi,

I'm having a problem with my portal database, I'm sure I'm just doing something wrong, but any help would be nice!

When I enter http://thefusions.30.forumer.com/index.php?act=home

the follow page appears.



Any help would be appreciated! Thanks in advance


Edit: The full message is this

Quote:
mySQL query error: SELECT t.*, f.read_perms, f.use_html, p.*, m.avatar, m.view_avs, m.avatar_size,
m.id as member_id, m.name as member_name, m.mgroup, g.g_id, g.g_dohtml
FROM thefusions_topics t
LEFT JOIN thefusions_members m ON (t.starter_id=m.id)
LEFT JOIN thefusions_groups g ON (g.g_id=m.mgroup)
LEFT JOIN thefusions_posts p ON (p.topic_id=t.tid AND p.new_topic=1)
LEFT JOIN thefusions_forums f on (f.id=p.forum_id)
WHERE t.forum_id IN (-1,thefusions)
AND t.approved=1 AND (t.moved_to IS NULL or t.moved_to='')
ORDER BY t.pinned DESC, t.start_date DESC
LIMIT 0,9

mySQL error: Unknown column 'thefusions' in 'where clause'
mySQL error code:
Date: Wednesday 06th of June 2007 02:46:28 PM
Last edited by TankKiller; 06-06-2007 at 01:53 PM. Reason: Add more info
TankKiller is offline   Reply With Quote
Old 06-07-2007, 12:04 PM   #2 (permalink)
Member
 
TankKiller's Avatar
 
Join Date: Jun 2007

Posts: 10
Rep Power: 0 TankKiller is on a distinguished road
fTrader: (0)
fBuck$: 173.0
Bank: 0.0
Total fBuck$: 173.0

My Forumer
My Country:
Default Re: Portal Database Broken?
Hi, it's still broken =) Just wondering if there's anything I can do?
TankKiller is offline   Reply With Quote
Old 06-08-2007, 06:28 AM   #3 (permalink)
Member
 
TankKiller's Avatar
 
Join Date: Jun 2007

Posts: 10
Rep Power: 0 TankKiller is on a distinguished road
fTrader: (0)
fBuck$: 173.0
Bank: 0.0
Total fBuck$: 173.0

My Forumer
My Country:
Default Re: Portal Database Broken?
Anyone? =(
TankKiller is offline   Reply With Quote
Old 06-08-2007, 02:15 PM   #4 (permalink)
Member
 
TankKiller's Avatar
 
Join Date: Jun 2007

Posts: 10
Rep Power: 0 TankKiller is on a distinguished road
fTrader: (0)
fBuck$: 173.0
Bank: 0.0
Total fBuck$: 173.0

My Forumer
My Country:
Default Re: Portal Database Broken?
Has anyone else had this problem?
TankKiller is offline   Reply With Quote
Old 06-08-2007, 10:14 PM   #5 (permalink)
Junior Forumer
 
collin1000's Avatar
 
Join Date: Jan 2006

Posts: 198
Rep Power: 3 collin1000 is on a distinguished road
fTrader: (0)
fBuck$: 92.0
Bank: 2,464.5
Total fBuck$: 2,556.5

My Forumer
My Country:
Send a message via Yahoo to collin1000
Default Re: Portal Database Broken?
Quote:
Originally Posted by TankKiller View Post
Has anyone else had this problem?
Yes, there are quite a few topics on it already, and forumer is working as fast as they can to resolve everything.

FREE domain names for your forum or site! 100% free domain names! Compatible with forumer!
collin1000 is offline   Reply With Quote
Old 06-09-2007, 12:18 AM   #6 (permalink)
Senior Forumer
 
MasterVision's Avatar
 
Join Date: Nov 2006

Posts: 1,065
Rep Power: 3 MasterVision is on a distinguished road
fTrader: (0)
fBuck$: 756.0
Bank: 4,247.1
Total fBuck$: 5,003.1

My Forumer
My Country:
Send a message via MSN to MasterVision Send a message via Yahoo to MasterVision Send a message via Skype™ to MasterVision
Default Re: Portal Database Broken?
Its not forumer side... it is always happening in a portal when you do some changes and missed some codes in it... it doesn't have debugger to check if the changes that you made is correct.. so you have to check all the codes and the changes

Hi TankKiller, can you post the whole code of your Portal HTML? and what skin you are using?
MasterVision is offline   Reply With Quote
Old 06-11-2007, 05:00 AM   #7 (permalink)
Member
 
TankKiller's Avatar
 
Join Date: Jun 2007

Posts: 10
Rep Power: 0 TankKiller is on a distinguished road
fTrader: (0)
fBuck$: 173.0
Bank: 0.0
Total fBuck$: 173.0

My Forumer
My Country:
Default Re: Portal Database Broken?
Sure =) But all I've done is put in the URLs

Quote:
{http://thefusions.30.forumer.com} [Forums]
{http://thefusions.30.forumer.com}act=Search&CODE=getactive [Today's Active Topics]
{http://thefusions.30.forumer.com}act=Stats [Today's Top 10 Posters]
{http://thefusions.30.forumer.com}act=Stats&CODE=leaders [Contact Staff]
I'm sure that's not all of it =/
That's for the navigation box, but I was unable to find any other html codes with relation to the actual forum set up.
And the skin I'm using is smoothblu

Thanks =)
TankKiller is offline   Reply With Quote
Old 06-14-2007, 08:33 AM   #8 (permalink)
Senior Forumer
 
MasterVision's Avatar
 
Join Date: Nov 2006

Posts: 1,065
Rep Power: 3 MasterVision is on a distinguished road
fTrader: (0)
fBuck$: 756.0
Bank: 4,247.1
Total fBuck$: 5,003.1

My Forumer
My Country:
Send a message via MSN to MasterVision Send a message via Yahoo to MasterVision Send a message via Skype™ to MasterVision
Default Re: Portal Database Broken?
I don't understand why you change it to Actual URL. those URL should be {ibf.script_url}

And if you want to use the complete URL, it should be http://thefusions.30.forumer.com/index.php? and not {http://thefusions.30.forumer.com}

but still, it wont work. for the correct usage of hyperlink it should be like this
Quote:
<a href="{ibf.script_url}"> [Forums]</a>
<a href="{ibf.script_url}act=Search&amp;CODE=getactive"> [Today's Active Topics]</a>
<a href="{ibf.script_url}act=Stats"> [Today's Top 10 Posters]</a>
<a href="{ibf.script_url}act=Stats&amp;CODE=leaders"> [Contact Staff]</a>
hope this helps and sorry for late response
MasterVision is offline   Reply With Quote
Old 06-14-2007, 08:59 AM   #9 (permalink)
Member
 
TankKiller's Avatar
 
Join Date: Jun 2007

Posts: 10
Rep Power: 0 TankKiller is on a distinguished road
fTrader: (0)
fBuck$: 173.0
Bank: 0.0
Total fBuck$: 173.0

My Forumer
My Country:
Default Re: Portal Database Broken?
Hmm Thanks for the reply

In all honesty I HAD left that code as the default code... I only changed it to www.etc when I noticed "URL" written in it, I thought maybe I had to manually put in the sites URL

Anyway, I tried that code and the error still appears. I also tried the "correct" URLs you showed, and {ibf.script_url} instead of the URLs in the original post I made.

Also, it says that "{board_url} will convert into your board"
TankKiller is offline   Reply With Quote
Old 06-14-2007, 06:06 PM   #10 (permalink)
Senior Forumer
 
MasterVision's Avatar
 
Join Date: Nov 2006

Posts: 1,065
Rep Power: 3 MasterVision is on a distinguished road
fTrader: (0)
fBuck$: 756.0
Bank: 4,247.1
Total fBuck$: 5,003.1

My Forumer
My Country:
Send a message via MSN to MasterVision Send a message via Yahoo to MasterVision Send a message via Skype™ to MasterVision
Default Re: Portal Database Broken?
ok... try to use your way but this time use the complete URL with /index.php?

like this
Quote:
<a href="http://thefusions.30.forumer.com/index.php?"> [Forums]</a>
<a href="http://thefusions.30.forumer.com/index.php?act=Search&amp;CODE=getactive"> [Today's Active Topics]</a>
<a href="http://thefusions.30.forumer.com/index.php?act=Stats"> [Today's Top 10 Posters]</a>
<a href="http://thefusions.30.forumer.com/index.php?act=Stats&amp;CODE=leaders"> [Contact Staff]</a>
then if it's still not working... you probably have missed some part of the code.

-------------
copy all the codes from here and save it as smoothblu.skin_csite.html (this is your skin, as what I've seen in your board)

Then go to your AdminCP->HTML Templates->Manage HTML->IPDynamic lite and click on Upload... then browse the file you saved.

Good luck
Last edited by MasterVision; 06-14-2007 at 06:09 PM.
MasterVision is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Please Help! My Forum Is Broken! 0701 IPB General Support 1 04-01-2007 01:52 PM
Links broken sfbp IPB General Support 1 02-12-2006 10:51 AM
its broken!!!! Barricuda IPB General Support 3 09-15-2005 10:30 AM