Home | Community | Message Board

Magic Mushrooms Zamnesia
This site includes paid links. Please support our sponsors.


Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Unfolding Nature Shop: Unfolding Nature: Being in the Implicate Order

Jump to first unread post Pages: 1 | 2 |  [ show all ]
mysql upgrade
    #7493599 -

mysql got upgraded from 4.1 to 5.0. post here if you see any posts that get cut off or are missing content. last time we did a major mysql upgrade it screwed up on special characters and truncated posts.

-Link


--------------------
Wonder had gone away, and he had forgotten that all life is only a set of pictures in the brain, among which there is no difference betwixt those born of real things and those born of inward dreamings, and no cause to value the one above the other.  -- H.P. Lovecraft "The Silver Key"

Extras: Filter Print Post Top
Re: mysql upgrade [Re: Link]
    #7493752 -

maybe i did something but the mouse over preview is gone now.


--------------------

Extras: Filter Print Post Top
Re: mysql upgrade [Re: Link]
    #7493820 -

I get this in the "my posts" link in the my home page


Quote:
Script: /var/www/shroomery/forums/userposts.php
Line#: 199
SQL Error: Unknown column 'B_Board' in 'on clause'
SQL Error #: 1054
Query: SELECT SQL_CALC_FOUND_ROWS B_Number, B_Subject, B_Icon, B_Board, B_PosterId, B_Posted, B_Last_Post, B_Journal, U_Username FROM w3t_Posts AS t1, w3t_Users AS t2 LEFT JOIN w3t_Boards AS t3 ON B_Board = Bo_Number WHERE t1.B_Journal = t2.U_Number AND t1.B_PosterId = '114427' AND B_Board IN ('255','1','2','3','4','5','6','87','7','18','17','10','11','12','13','14','16','19','22','23','30','42','70','34','35','37','41','43','46','48','50','91','58','59','60','61','62','63','67','64','65','71','72','74','75','76','79','81','82','85','86','77','92') ORDER BY B_Posted DESC LIMIT 0, 25

Please use your back button to return to the previous page.



Extras: Filter Print Post Top
Re: mysql upgrade [Re: Stein]
    #7493923 -

A lot is wrong, you can't search posts (it brings up the stuff to input it, but when you hit Search after entering what you want to search for it brings up SQL errors).

You can't view a certain person's posts or threads either, probably do to it using the search engine to gather their posts. So it's probably the search engine.

When I upgraded my MySQL was the day my entire sight never went back up. :P Man I suck at php. Doing anything to the engine makes everything wack.

Extras: Filter Print Post Top
Re: mysql upgrade [Re: Maverick]
    #7493971 -

Error in threads link.


--------------------

"There is never a wrong note, bend it."
Jimi Hendrix


Extras: Filter Print Post Top
Re: mysql upgrade *DELETED* [Re: sui]
    #7493982 -

Post deleted by spock1

Reason for deletion: .


Edited by spock1 (10/07/07 10:59 AM)

Extras: Filter Print Post Top
Re: mysql upgrade [Re: spock1]
    #7494298 -

I got it too:
Quote:
Script: /var/www/shroomery/forums/userposts.php
Line#: 199
SQL Error: Unknown column 'B_Board' in 'on clause'
SQL Error #: 1054
Query: SELECT SQL_CALC_FOUND_ROWS B_Number, B_Subject, B_Icon, B_Board, B_PosterId, B_Posted, B_Last_Post, B_Journal, U_Username FROM w3t_Posts AS t1, w3t_Users AS t2 LEFT JOIN w3t_Boards AS t3 ON B_Board = Bo_Number WHERE t1.B_Journal = t2.U_Number AND t1.B_PosterId = '175973' AND B_Board IN ('255','1','2','3','4','5','6','7','18','11','12','13','14','19','22','23','42','34','35','37','46','48','91','58','59','60','61','62','63','67','64','65','75','76','79','81','82','85','86','77') ORDER BY B_Posted DESC LIMIT 0, 25



Extras: Filter Print Post Top
Re: mysql upgrade [Re: a_guy_named_ai]
    #7494351 -

It's fixed now.


--------------------
THE PHILOSOPHY OF LIBERTY <---                                               


Extras: Filter Print Post Top
Re: mysql upgrade [Re: Individual]
    #7494354 -

And Ythan just came online...
Yayyy for ythan!


--------------------

Rodney Brooks on Robots
Nalim said: "Quoting yourself is retarded."

Extras: Filter Print Post Top
Re: mysql upgrade [Re: Link]
    #7494359 -

I think I fixed everything that's been reported so far, please let me know if you encounter any more errors (I'll be watching the log too). The problem is that mySQL 5 has a slightly different syntax for joins so we need to rewrite some queries.

Extras: Filter Print Post Top
Re: mysql upgrade [Re: Ythan]
    #7494370 -

The smiley problem mentioned in this thread remains.


--------------------
THE PHILOSOPHY OF LIBERTY <---                                               


Extras: Filter Print Post Top
Re: mysql upgrade [Re: Individual]
    #7494392 -

Fixed, thanks. :smile:

Extras: Filter Print Post Top
Re: mysql upgrade *DELETED* [Re: Ythan]
    #7494408 -

Post deleted by spock1

Reason for deletion: .


Edited by spock1 (10/07/07 01:26 PM)

Extras: Filter Print Post Top
Re: mysql upgrade [Re: spock1]
    #7494431 -

Well for instance you can no longer do:

SELECT * FROM t1, t2 LEFT JOIN t3 ON t1.Id = t3.Id WHERE t1.Number = t2.Number

It has to be changed to:

SELECT * FROM t1 JOIN t2 ON t1.Number = t2.Number LEFT JOIN t3 ON t1.Id = t3.Id

It has something to do with the order in which the new version processes joins, I don't really understand the explanation from mySQL's site but I can fix it and that's all that matters. :wink:

Extras: Filter Print Post Top
Re: mysql upgrade *DELETED* [Re: Ythan]
    #7494442 -

Post deleted by spock1

Reason for deletion: .


Extras: Filter Print Post Top
Re: mysql upgrade [Re: spock1]
    #7494456 -

What I don't understand is why I can't throw out the aliases and do

FROM w3t_Posts, w3t_Users LEFT JOIN w3t_Boards ON w3t_Posts.B_Board = w3t_Boards.Bo_Keyword

But hey I trust the mySQL guys to change things for the better. If all I need to fix are a few errant queries I think the new version is pretty good.

Extras: Filter Print Post Top
Re: mysql upgrade *DELETED* [Re: Ythan]
    #7494468 -

Post deleted by spock1

Reason for deletion: .


Extras: Filter Print Post Top
Re: mysql upgrade [Re: spock1]
    #7494598 -

the threads link is fixed, but I still have the blinking message icon, but when I click messages, it will come up with an empty inbox (just nothing listed at all), and i know i have a ton of messages.


--------------------
:bouncysmoke:

I'm ok, really.

Extras: Filter Print Post Top
Re: mysql upgrade [Re: ShroomieGirl]
    #7494606 -

ShroomieGirl said:
the threads link is fixed, but I still have the blinking message icon, but when I click messages, it will come up with an empty inbox (just nothing listed at all), and i know i have a ton of messages.



i don't have this problem, do you use firefox?

Extras: Filter Print Post Top
Re: mysql upgrade [Re: drSE]
    #7494615 -

no, internet explorer.. the newest version


--------------------
:bouncysmoke:

I'm ok, really.

Extras: Filter Print Post Top
Jump to top Pages: 1 | 2 |  [ show all ]

Unfolding Nature Shop: Unfolding Nature: Being in the Implicate Order


Similar ThreadsPosterViewsRepliesLast post
* BB upgrade problems, questions? Post here.
( 1 2 3 4 all )
ThorA 12,014 69 01/22/03 12:34 PM
by goldtop
* MySql error: Colonel Kurtz Ph.D 576 0 03/13/07 09:25 AM
by Colonel Kurtz Ph.D
* Lost connection to MySQL server during query when using... daussaulit 1,177 3 01/16/04 04:42 PM
by 3DSHROOM
* Holy crap! Fuck MySQL!! Yarry 1,693 11 01/20/04 05:22 PM
by TinMan
* MySQL 5 Slow? DiploidM 553 1 01/02/08 05:30 AM
by Seuss
* Shroomery Server Upgrades - Report Bugs Here! **Updated 9/8**
( 1 2 all )
YthanA 8,504 39 09/10/05 11:28 PM
by Vampire999
* Upgrades This Weekend Vampire999S 884 5 09/03/05 01:08 AM
by Vampire999
* Bulletin Board upgrade
( 1 2 3 all )
3DSHROOM 7,172 51 12/10/03 05:20 AM
by Asante

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Ythan, Thor, Seuss, geokills
3,272 topic views. 0 members, 30 guests and 1 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2026 Mind Media. Some rights reserved.

Generated in 0.032 seconds spending 0.009 seconds on 16 queries.