|
Link
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"
|
waixingren


Registered: 03/14/05
Posts: 2,644
Loc: SW Florida
Last seen: 8 days, 18 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.
--------------------
|
Stein
Stranger


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.
|
Maverick
Lover of Earwigs!




Registered: 12/18/05
Posts: 13,437
Loc: Valleys of Willamette
Last seen: 15 hours, 16 seconds
|
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.
|
sui
I love you.



Registered: 08/20/04
Posts: 31,853
Loc: Cali, Contra Costa Co.
|
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
|
spock1
Stranger

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 spock1Reason for deletion: .
Edited by spock1 (10/07/07 10:59 AM)
|
a_guy_named_ai
Stranger

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
|
Individual
Bass Addict


Registered: 12/20/06
Posts: 6,666
Loc: Reality Loophole
|
|
It's fixed now.
-------------------- THE PHILOSOPHY OF LIBERTY <---
|
Nalim
OTD Kelly Girl



Registered: 01/13/06
Posts: 15,033
Last seen: 1 year, 3 months
|
|
And Ythan just came online... Yayyy for ythan!
--------------------
    Rodney Brooks on Robots Nalim said: "Quoting yourself is retarded."
|
Ythan
ᕕ( ᐛ )ᕗ



Registered: 08/08/97
Posts: 18,774
Loc: NY/MA/VT Borderlands
Last seen: 23 minutes, 5 seconds
|
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.
|
Individual
Bass Addict


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 <---
|
Ythan
ᕕ( ᐛ )ᕗ



Registered: 08/08/97
Posts: 18,774
Loc: NY/MA/VT Borderlands
Last seen: 23 minutes, 5 seconds
|
|
Fixed, thanks.
|
spock1
Stranger

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 spock1Reason for deletion: .
Edited by spock1 (10/07/07 01:26 PM)
|
Ythan
ᕕ( ᐛ )ᕗ



Registered: 08/08/97
Posts: 18,774
Loc: NY/MA/VT Borderlands
Last seen: 23 minutes, 5 seconds
|
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.
|
spock1
Stranger

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 spock1Reason for deletion: .
|
Ythan
ᕕ( ᐛ )ᕗ



Registered: 08/08/97
Posts: 18,774
Loc: NY/MA/VT Borderlands
Last seen: 23 minutes, 5 seconds
|
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.
|
spock1
Stranger

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 spock1Reason for deletion: .
|
ShroomieGirl
What are these god damn animals



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.
--------------------
I'm ok, really.
|
drSE
Pseudo Reality




Registered: 12/19/03
Posts: 4,432
Loc: Twighlight Zone
|
|
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
|
ShroomieGirl
What are these god damn animals



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
--------------------
I'm ok, really.
|
|