Home | Community | Message Board


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!

Shop: Kraken Kratom Red Vein Kratom   PhytoExtractum Maeng Da Thai Kratom Leaf Powder   Bridgetown Botanicals Bridgetown Botanicals   Unfolding Nature Unfolding Nature: Being in the Implicate Order

Jump to first unread post Pages: 1 | 2  [ show all ]
InvisibleLinkA
Intrinsically No Good


Registered: 07/28/99
Posts: 2,314
Loc: Lost Woods, Hyrule
mysql upgrade
    #7493599 - 10/07/07 05:39 AM (16 years, 3 months ago)

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
Offlinewaixingren
Male User Gallery

Registered: 03/14/05
Posts: 2,644
Loc: SW Florida
Last seen: 9 days, 8 hours
Re: mysql upgrade [Re: Link]
    #7493752 - 10/07/07 08:39 AM (16 years, 3 months ago)

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


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


Extras: Filter Print Post Top
InvisibleStein
Stranger
 User Gallery

Registered: 07/02/03
Posts: 35,129
Re: mysql upgrade [Re: Link]
    #7493820 - 10/07/07 09:27 AM (16 years, 3 months ago)

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
OfflineMaverick
Lover of Earwigs!
Male User Gallery


Folding@home Statistics
Registered: 12/18/05
Posts: 13,437
Loc: Valleys of Willamette Flag
Last seen: 1 day, 4 hours
Re: mysql upgrade [Re: Stein]
    #7493923 - 10/07/07 10:34 AM (16 years, 3 months ago)

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
Invisiblesui
I love you.
Male User Gallery


Registered: 08/20/04
Posts: 31,853
Loc: Cali, Contra Costa Co. Flag
Re: mysql upgrade [Re: Maverick]
    #7493971 - 10/07/07 10:51 AM (16 years, 3 months ago)

Error in threads link.


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

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



Extras: Filter Print Post Top
Offlinespock1
Stranger
Male User Gallery
Registered: 04/14/07
Posts: 589
Last seen: 15 years, 7 months
Re: mysql upgrade *DELETED* [Re: sui]
    #7493982 - 10/07/07 10:56 AM (16 years, 3 months ago)

Post deleted by spock1

Reason for deletion: .



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


Extras: Filter Print Post Top
Offlinea_guy_named_ai
Stranger
Male
Registered: 09/24/07
Posts: 767
Last seen: 15 years, 7 months
Re: mysql upgrade [Re: spock1]
    #7494298 - 10/07/07 12:41 PM (16 years, 3 months ago)

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
InvisibleIndividual
Bass Addict
Male User Gallery

Registered: 12/20/06
Posts: 6,666
Loc: Reality Loophole
Re: mysql upgrade [Re: a_guy_named_ai]
    #7494351 - 10/07/07 01:00 PM (16 years, 3 months ago)

It's fixed now.


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



Extras: Filter Print Post Top
OfflineNalim
OTD Kelly Girl
Female User Gallery


Registered: 01/13/06
Posts: 15,033
Last seen: 1 year, 3 months
Re: mysql upgrade [Re: Individual]
    #7494354 - 10/07/07 01:00 PM (16 years, 3 months ago)

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


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

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


Extras: Filter Print Post Top
OfflineYthanA
ᕕ( ᐛ )ᕗ
Male User Gallery


Registered: 08/08/97
Posts: 18,774
Loc: NY/MA/VT Borderlands Flag
Last seen: 3 hours, 34 minutes
Re: mysql upgrade [Re: Link]
    #7494359 - 10/07/07 01:03 PM (16 years, 3 months ago)

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
InvisibleIndividual
Bass Addict
Male User Gallery

Registered: 12/20/06
Posts: 6,666
Loc: Reality Loophole
Re: mysql upgrade [Re: Ythan]
    #7494370 - 10/07/07 01:07 PM (16 years, 3 months ago)

The smiley problem mentioned in this thread remains.


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



Extras: Filter Print Post Top
OfflineYthanA
ᕕ( ᐛ )ᕗ
Male User Gallery


Registered: 08/08/97
Posts: 18,774
Loc: NY/MA/VT Borderlands Flag
Last seen: 3 hours, 34 minutes
Re: mysql upgrade [Re: Individual]
    #7494392 - 10/07/07 01:14 PM (16 years, 3 months ago)

Fixed, thanks. :smile:


Extras: Filter Print Post Top
Offlinespock1
Stranger
Male User Gallery
Registered: 04/14/07
Posts: 589
Last seen: 15 years, 7 months
Re: mysql upgrade *DELETED* [Re: Ythan]
    #7494408 - 10/07/07 01:18 PM (16 years, 3 months ago)

Post deleted by spock1

Reason for deletion: .



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


Extras: Filter Print Post Top
OfflineYthanA
ᕕ( ᐛ )ᕗ
Male User Gallery


Registered: 08/08/97
Posts: 18,774
Loc: NY/MA/VT Borderlands Flag
Last seen: 3 hours, 34 minutes
Re: mysql upgrade [Re: spock1]
    #7494431 - 10/07/07 01:26 PM (16 years, 3 months ago)

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
Offlinespock1
Stranger
Male User Gallery
Registered: 04/14/07
Posts: 589
Last seen: 15 years, 7 months
Re: mysql upgrade *DELETED* [Re: Ythan]
    #7494442 - 10/07/07 01:28 PM (16 years, 3 months ago)

Post deleted by spock1

Reason for deletion: .



Extras: Filter Print Post Top
OfflineYthanA
ᕕ( ᐛ )ᕗ
Male User Gallery


Registered: 08/08/97
Posts: 18,774
Loc: NY/MA/VT Borderlands Flag
Last seen: 3 hours, 34 minutes
Re: mysql upgrade [Re: spock1]
    #7494456 - 10/07/07 01:32 PM (16 years, 3 months ago)

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
Offlinespock1
Stranger
Male User Gallery
Registered: 04/14/07
Posts: 589
Last seen: 15 years, 7 months
Re: mysql upgrade *DELETED* [Re: Ythan]
    #7494468 - 10/07/07 01:36 PM (16 years, 3 months ago)

Post deleted by spock1

Reason for deletion: .



Extras: Filter Print Post Top
OfflineShroomieGirl
What are these god damn animals
Female User Gallery


Registered: 05/29/07
Posts: 1,938
Last seen: 11 years, 10 months
Re: mysql upgrade [Re: spock1]
    #7494598 - 10/07/07 02:19 PM (16 years, 3 months ago)

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
InvisibledrSE
Pseudo Reality
Male User Gallery


Folding@home Statistics
Registered: 12/19/03
Posts: 4,432
Loc: Twighlight Zone
Re: mysql upgrade [Re: ShroomieGirl]
    #7494606 - 10/07/07 02:22 PM (16 years, 3 months ago)

Quote:

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?


--------------------
Grow Room



Extras: Filter Print Post Top
OfflineShroomieGirl
What are these god damn animals
Female User Gallery


Registered: 05/29/07
Posts: 1,938
Last seen: 11 years, 10 months
Re: mysql upgrade [Re: drSE]
    #7494615 - 10/07/07 02:24 PM (16 years, 3 months ago)

no, internet explorer.. the newest version


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

I'm ok, really.


Extras: Filter Print Post Top
OfflineShroomieGirl
What are these god damn animals
Female User Gallery


Registered: 05/29/07
Posts: 1,938
Last seen: 11 years, 10 months
Re: mysql upgrade [Re: ShroomieGirl]
    #7494621 - 10/07/07 02:26 PM (16 years, 3 months ago)

just started working after i did that last post... crazy. it wasnt working since the upgrade before that. I guess ask and i shall recieve... Thanks if someone fixed it, and awesome! if it just fixed itself.


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

I'm ok, really.


Extras: Filter Print Post Top
OfflineYthanA
ᕕ( ᐛ )ᕗ
Male User Gallery


Registered: 08/08/97
Posts: 18,774
Loc: NY/MA/VT Borderlands Flag
Last seen: 3 hours, 34 minutes
Re: mysql upgrade [Re: ShroomieGirl]
    #7494622 - 10/07/07 02:27 PM (16 years, 3 months ago)

Okay I think this should be fixed please let me know if you're still having problems.


Extras: Filter Print Post Top
OfflineShroomieGirl
What are these god damn animals
Female User Gallery


Registered: 05/29/07
Posts: 1,938
Last seen: 11 years, 10 months
Re: mysql upgrade [Re: Ythan]
    #7494627 - 10/07/07 02:27 PM (16 years, 3 months ago)

thanks ythan! youre the best


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

I'm ok, really.


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

Shop: Kraken Kratom Red Vein Kratom   PhytoExtractum Maeng Da Thai Kratom Leaf Powder   Bridgetown Botanicals Bridgetown Botanicals   Unfolding Nature Unfolding Nature: Being in the Implicate Order


Similar ThreadsPosterViewsRepliesLast post
* BB upgrade problems, questions? Post here.
( 1 2 3 4 all )
ThorA 11,358 69 01/22/03 12:34 PM
by goldtop
* MySql error: Colonel Kurtz Ph.D 572 0 03/13/07 09:25 AM
by Colonel Kurtz Ph.D
* Lost connection to MySQL server during query when using... daussaulit 1,143 3 01/16/04 04:42 PM
by 3DSHROOM
* Holy crap! Fuck MySQL!! Yarry 1,662 11 01/20/04 05:22 PM
by TinMan
* MySQL 5 Slow? DiploidM 543 1 01/02/08 05:30 AM
by Seuss
* Shroomery Server Upgrades - Report Bugs Here! **Updated 9/8**
( 1 2 all )
YthanA 8,313 39 09/10/05 11:28 PM
by Vampire999
* Upgrades This Weekend Vampire999S 850 5 09/03/05 01:08 AM
by Vampire999
* Bulletin Board upgrade
( 1 2 3 all )
3DSHROOM 6,987 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,205 topic views. 0 members, 8 guests and 1 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2024 Mind Media. Some rights reserved.

Generated in 0.029 seconds spending 0.007 seconds on 14 queries.