News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Database Error

Started by newtoallthis, April 18, 2011, 09:58:19 AM

Previous topic - Next topic

newtoallthis

SMF 2 RC5

Getting the following error:-

Unknown column 'b.id_board' in 'field list'
File: /home/leighlan/public_html/forum/Sources/Subs-BoardIndex.php
Line: 82

Boards cannot be seen.

Incidentally, test forum (restored late yesterday) showing same error.
SMF 2.0.11
Simple Portal 2.3.3
Aeva Media 1.4c
MediaWiki 1.24.0


newtoallthis

Aeva Media 1.4c, SimplePortal and (standalone but linked by navbutton) Dokuwiki.

The database was restored and worked for a short while then the forum went down again. Lot's of file permissions had somehow been set too high and the server wouldn't run the software.

As soon as permissions were reset from 777 to 755, forum came back on line.

All server passwords have been changed but I am concerned about the wiki which I can't get to work properly and tells me that it isn't secure. I want to uninstall Dokuwiki because I suspect it may be providing a back door to the server.
SMF 2.0.11
Simple Portal 2.3.3
Aeva Media 1.4c
MediaWiki 1.24.0

NanoSector

Probably DokuWiki needs to have 777 permissions which the server does not accept :)

You can install MediaWiki as replacement, its the software Wikipedia uses.
My Mods / Mod Builder - A tool to easily create mods / Blog
"I've heard from a reliable source that the Answer is 42. But, still no word on what the question is."

Illori

can you verify in your database if the table {yourprefix}_boards has a column named id_board in it? if you use phpmyadmin view the structure of that table and first row should be id_board.

Masterd

Can you attach your Subs-BoardIndex.php?

Illori

i dont think it is a problem with the file, but the line numbers dont add up so a mod may be in use that has edited this file.

Masterd

Well, maybe there's a problem with a query in that file.

Illori

which is why we need to know if that column is still in the database or if the database has been effected in anyway.

newtoallthis

Quote from: Illori on April 18, 2011, 04:05:52 PM
can you verify in your database if the table {yourprefix}_boards has a column named id_board in it? if you use phpmyadmin view the structure of that table and first row should be id_board.

Yes, the first column is called id_board.
SMF 2.0.11
Simple Portal 2.3.3
Aeva Media 1.4c
MediaWiki 1.24.0

newtoallthis

SMF 2.0.11
Simple Portal 2.3.3
Aeva Media 1.4c
MediaWiki 1.24.0

newtoallthis

Forgot to mention, when the error occurred, a couple of members got a 'stack overflow 1322' error.
SMF 2.0.11
Simple Portal 2.3.3
Aeva Media 1.4c
MediaWiki 1.24.0

Illori

strage line 82 of the file you attached is ); i am not sure why that would throw an error. what mods do you have installed?

kat

Quote from: Illori on April 19, 2011, 06:00:58 AM
strage line 82 of the file you attached is ); i am not sure why that would throw an error. what mods do you have installed?

Quote from: newtoallthis on April 18, 2011, 03:31:51 PM
Aeva Media 1.4c, SimplePortal and (standalone but linked by navbutton) Dokuwiki.

Sure is a weirdy, this...

newtoallthis

My site has previously been hit by a base_64 attack and, as I wrote earlier, permissions were remotely changed yesterday. When malicious script was removed from the server, some files were corrupted so I had a fresh set of SMF files upped to the server.

Thing is though, this wouldn't have solved any problems in the database, so could the problem be an aftermath of previous attacks?
SMF 2.0.11
Simple Portal 2.3.3
Aeva Media 1.4c
MediaWiki 1.24.0

kat

This is a totally off-the-wall suggestion, this...

How good is your host?

Would they be able to give your database a scan, to check it out?

I know mine can and it's been really useful, at times.

newtoallthis

Quote from: K@ on April 19, 2011, 10:57:24 AM
This is a totally off-the-wall suggestion, this...

How good is your host?

Would they be able to give your database a scan, to check it out?

I know mine can and it's been really useful, at times.

He'd better be a good host...he's a well known member on here!

I'll see what he says, thanks.
SMF 2.0.11
Simple Portal 2.3.3
Aeva Media 1.4c
MediaWiki 1.24.0

kat

Let us know how it goes, OK?

newtoallthis

Quote from: Yoshi2889 on April 18, 2011, 04:01:27 PM
Probably DokuWiki needs to have 777 permissions which the server does not accept :)

You can install MediaWiki as replacement, its the software Wikipedia uses.

Thanks for the pointer. I'm now looking into MediaWiki, cheers.
SMF 2.0.11
Simple Portal 2.3.3
Aeva Media 1.4c
MediaWiki 1.24.0

NanoSector

Quote from: newtoallthis on April 19, 2011, 11:50:50 AM
Quote from: Yoshi2889 on April 18, 2011, 04:01:27 PM
Probably DokuWiki needs to have 777 permissions which the server does not accept :)

You can install MediaWiki as replacement, its the software Wikipedia uses.

Thanks for the pointer. I'm now looking into MediaWiki, cheers.
I have been running MediaWiki some time now on a server which does not support 777, and it's all fine :)
My Mods / Mod Builder - A tool to easily create mods / Blog
"I've heard from a reliable source that the Answer is 42. But, still no word on what the question is."

Advertisement: