[Solved] Bug while upgrading

Maxthon

Fatal Error in Gdn_DatabaseDebug.Query();

Unknown column 'AllIPAddresses' in 'field list'

update GDN_User User set LastIPAddress = :LastIPAddress, AllIPAddresses = :AllIPAddresses where UserID = :UserID
The error occurred on or near: /home/miuiaust/public_html/forum/library/database/class.database.php

289:
290: if (!is_object($PDOStatement)) {
291: trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);
292: } else if ($PDOStatement->execute($InputParameters) === FALSE) {
293: trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
294: }
295: } else {
296: $PDOStatement = $this->Connection()->query($Sql);
297: }

Maxthon

Sorry, here is bug.

Tama

Try navigating to utility/structure

Maxthon

@Tama said:
Try navigating to utility/structure

I logged in there.

Maxthon

@Tama said:
Try navigating to utility/structure

I just tried several more times, shows the same thing.

Tama

@Maxthon said:
I just tried several more times, shows the same thing.

Did you complete the process on the page

Maxthon

@Tama said:

I can't see it anywhere...

Tama

@Maxthon said:
I can't see it anywhere...

Do you have a screenshot of the page ( utility/structure )

Maxthon

@Tama said:
Do you have a screenshot of the page ( utility/structure )

I appreciate your help, my screenshot is attached.

Tama

Okay log onto phpmyadmin on your host and do the following

GDN_User > Structure

Maxthon

@Tama said:
Okay log onto phpmyadmin on your host and do the following

GDN_User > Structure

Done and then.

Tama

@Maxthon said:
Done and then.

Does the error go away or change, the error explains that the AllIPAddresses column is missing from GDN_User

Edit : @Maxthon

Looked at your forum and you should remove Minify, it's breaking your styling

UnderDog

@Maxthon said:
Done and then.

And then you search a little and follow all these search results:

http://vanillaforums.org/search?adv=&search=AllIPAddresses&title=&author=&cat=all&tags=&discussion_d=1&discussion_question=1&comment_c=1&comment_answer=1&page_p=1&within=1+day&date=

Maxthon

@Tama said:
Looked at your forum and you should remove Minify, it's breaking your styling

Thanks! It is working!!! How can I thank you??
PS: That wasn't my actual forum, it was my demo.

R_J

@Tama said:
Try navigating to utility/structure

@Tama: could you please tell something about utility/structure? I've never read anything about that before and I've get the message update V20188_User User set Permissions = '' where Permissions <> ''; for my test forum.
When should that be run? And should theadvices always be followed?

Tama

@R_J said:
When should that be run? And should theadvices always be followed?

I see it as a database repair script, creating tables if they have been accidentally deleted and filling other blanks. I've rarely had to use ( though if you are on a small forum and you want to purge something like drafts, this can regenerate the table with the correct values ( usually executed when vanilla is installed ).

Shadowdare

@Tama said:
I see it as a database repair script, creating tables if they have been accidentally deleted and filling other blanks. I've rarely had to use ( though if you are on a small forum and you want to purge something like drafts, this can regenerate the table with the correct values ( usually executed when vanilla is installed ).

@R_J, it's also useful when applications and plugins update their database structures.

R_J

Thanks for the info!