1054: Unknown column '660D02' in 'field list'

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

1054: Unknown column '660D02' in 'field list'

Postby doom » Tue Nov 14, 2006 6:54 pm

Hello,

I have managed to install wow roster and it even runs most of the time without problems!

However, on several occasions the roster has decided not to work both for myself and my guild members. It displays the wow roster menu but in the server status box it comes up with the following error and the rest of the page does not display...

1054: Unknown column '660D02' in 'field list'

Does anybody have any clues as to what may be going wrong so that i can fix it? The problem seems to come and go and i have no idea what causes or fixes it each time.

Many thanks in advance :compress:
doom
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Wed Nov 08, 2006 7:29 am

1054: Unknown column '660D02' in 'field list'

Postby doom » Tue Nov 21, 2006 5:08 pm

Gratuitous *bump*

Has nobody ever experienced this problem?
doom
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Wed Nov 08, 2006 7:29 am

1054: Unknown column '660D02' in 'field list'

Postby doom » Thu Nov 23, 2006 6:13 pm

At the risk of pissing somebody off... *bump*

My apologies, I am just hoping somebody will see this as the roster seems to go down at least once a day with the exact same error message each time.

Many thanks.
doom
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Wed Nov 08, 2006 7:29 am

1054: Unknown column '660D02' in 'field list'

Postby zanix » Thu Nov 23, 2006 6:51 pm

This may have something to do with realmstatus updating the a color in the database
I'm too tired to think of a fix right now, catch ya in about 8-10 hours
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

1054: Unknown column '660D02' in 'field list'

Postby doom » Fri Nov 24, 2006 5:53 am

Ooh, so even if you can't think of a fix, i can turn realm status off and it should cure the problem? :D
doom
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Wed Nov 08, 2006 7:29 am

1054: Unknown column '660D02' in 'field list'

Postby zanix » Sun Nov 26, 2006 2:49 pm

Find this function in lib/wowdb.php
Code: Select all
function add_value$row_name$row_data 


Replace the entire function with this
Code: Select all
    function add_value$row_name$row_data )
    {
        if( 
$this->assignstr != '' )
            
$this->assignstr .= ',';

        
$row_data "'" $this->escape$row_data ) . "'";

        
$this->assignstr .= " `$row_name` = $row_data";
    } 
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

1054: Unknown column '660D02' in 'field list'

Postby doom » Mon Dec 18, 2006 10:35 am

Thank you sir, you are a legend ^_^
doom
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Wed Nov 08, 2006 7:29 am


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 0 guests

cron