Forums / QdbS Support / cannot change theme via admin pages - QdbS

Forums

QdbS - Quote database System :: Forums :: QdbS Support

<< Previous thread | Next thread >>

cannot change theme via admin pages

Author

Post

csc2ya

Thu Feb 04 2010, 19:41:50

Registered Member #23
Joined: Mon Aug 03 2009, 19:14:21
Posts: 10

Ever since I made the changes to enable ip's to be shown, I can no longer change themes via the admin pages.

Whenever I try, I get:


Fatal error: Database::_sql(); -> Query error: in /home/csc2ya/public_html/classes.php on line 198

I've had a look at the referenced line in classes.php, and it appears to be something in the third line of the following part:


function _sql($sql) {

        if (!$this->result = mysql_query($sql)) {

            trigger_error("Database::_sql(); -> Query error: ", E_USER_ERROR);

        }

        $this->q_count++;

        return $this->result;

    }

I can still change the themes manually by editing the qdbs_settings table in the database, but it's quicker to just log in to the admin page and change it that way.

Does anyone have any idea how to fix it?

Jobe

Wed Feb 10 2010, 08:21:30

Joined: Mon Oct 08 2007, 16:54:30
Posts: 35

The line you reference is the line that actually generates the error.

To find out what the actual error is can you change:
trigger_error("Database::_sql(); -> Query error: ", E_USER_ERROR);

To:
trigger_error("Database::_sql(); -> Query error: " . mysql_error(), E_USER_ERROR);

Please?

csc2ya

Thu Feb 11 2010, 12:57:59

Registered Member #23
Joined: Mon Aug 03 2009, 19:14:21
Posts: 10

The error it's giving is:

Fatal error: Database::_sql(); -> Query error: Unknown column 'bannedwords' in 'field list' in /home/csc2ya/public_html/classes.php on line 198

Jobe

Mon Feb 15 2010, 12:56:02

Joined: Mon Oct 08 2007, 16:54:30
Posts: 35

That looks to me like you're using some modification as there is no SQL in the official release of QdbS that even mentions "bannedwords"

So I believe you will need to speak to Eck about that.

Also sorry for the delay in replying.

Eck

Mon Feb 15 2010, 17:13:48

Joined: Mon Sep 01 2008, 09:09:23
Posts: 10

I'm not sure how that is, you'll have to explain it a little bit better.

The admin panel modification for submitter IP addresses to be shown uses an existing table, qdbs_queue. I don't see how it could affect any other table or function.

[ Edited Mon Feb 15 2010, 17:14:45 ]

Jobe

Mon Feb 15 2010, 20:31:56

Joined: Mon Oct 08 2007, 16:54:30
Posts: 35

Meh I thought I remembered you saying something about bad words.

csc2ya

Tue Feb 16 2010, 01:26:12

Registered Member #23
Joined: Mon Aug 03 2009, 19:14:21
Posts: 10

I've just done a search of the database via phpmyadmin, and can find nothing that includes a 'bannedwords' column.

The only change made to the default install was to add the bash theme, and the modification to show ip's on the admin page.

It seems to be affecting any changes that are made to the website settings section of the admin page. I can still add admins and moderators via that page with no problems.

If I make any site settings changes via the sql database, those work fine, although it's a pain to have to do it that way.

One thing that may or may not be causing it...when I made the changes to show ip's, I forgot the database password, so dropped the qdbs_queue table and imported the file via phpmyadmin to recreate it with the ip column added.

Jobe

Tue Feb 16 2010, 12:06:10

Joined: Mon Oct 08 2007, 16:54:30
Posts: 35

Nah, this does appear to be a bug with Eck's IP logging modification. It appears he forgot to remove both remaining references to "bannedwords".

Have notified him of the issue so he can upload a new copy ASAP.

Eck

Tue Feb 16 2010, 12:16:27

Joined: Mon Sep 01 2008, 09:09:23
Posts: 10

I'm sorry about that. I didn't realize, i've fixed and reuploaded it. qdbs-ip.zip (it will be available on data.* soon, jobe will take care of that ;))

[ Edited Tue Feb 16 2010, 12:38:45 ]

Jobe

Tue Feb 16 2010, 12:36:44

Joined: Mon Oct 08 2007, 16:54:30
Posts: 35

It's done now. :) http://data.qdbs.org/qdbs-ip.zip

Moderators: Jobe, Eck

Main Menu

Search QdbS - Quote database System

Date / Time

Forums

Welcome

Online

Latest Forum Posts