our shit is broke

Please post all suggestions and help topics here for the forum or main website.

our shit is broke

Postby BILLYjp2 on Wed Mar 10, 2010 5:54 pm

I can get to the UJ forum, but when I try to read anything I get a SQL error, from home and at work, with FF and IE.


Ive always had that problem with UJ
When it comes to armeggedon, i'll drive my jeep cherokee right outta that mess
User avatar
BILLYjp2
Vice President
 
Posts: 4284
Joined: Thu Dec 13, 2007 11:50 pm
Location: Wilbraham
Primary Rig: 94 Station Wagon
Secondary Rig: 99 Danger Ranger

Re: our shit is broke

Postby Rafikie on Wed Mar 10, 2010 5:59 pm

works for me :grin:
I got some stuff, but it'll never be enough
User avatar
Rafikie
 
Posts: 58
Joined: Wed Jan 21, 2009 12:08 pm
Location: Lunenburg, MA
Primary Rig: 97 TJ

Re: our shit is broke

Postby Chris_Ryan on Wed Mar 10, 2010 6:42 pm

It is an issue with the view option in User control panel... unfortunately, the fix to SQL I was given doesn't fix it for everyone. They have to manually change the option.

Go to user control panel > Board Preferences > Edit Display options

Change - Display topics ordering by: to "Post Time"
Change - Display posts ordering by: to "Post Time"

This all happened from the last update. There is another new update out that I am hoping when it is applied it fixes this issue.
Please ignore this post. I have nothing productive to add.
Chris_Ryan
 
Posts: 1357
Joined: Thu Dec 13, 2007 6:47 pm
Location: Woburn MA
Primary Rig: 2002 Jeep Wrangler X

Re: our shit is broke

Postby Chris_Ryan on Wed Mar 10, 2010 6:46 pm

I will send this out as a mass email blast if the update does not fix it.
Please ignore this post. I have nothing productive to add.
Chris_Ryan
 
Posts: 1357
Joined: Thu Dec 13, 2007 6:47 pm
Location: Woburn MA
Primary Rig: 2002 Jeep Wrangler X

Re: our shit is broke

Postby Chris_Ryan on Wed Mar 10, 2010 7:11 pm

I think I fixed it...


***Ignore the end of this post, it is honestly just there so if I have to undo the change I have it written down somewhere. :lol:

I went into the SQL DB and changed the default of user_topic_sortby_type from b to t on the phpbb_user table
Please ignore this post. I have nothing productive to add.
Chris_Ryan
 
Posts: 1357
Joined: Thu Dec 13, 2007 6:47 pm
Location: Woburn MA
Primary Rig: 2002 Jeep Wrangler X

Re: our shit is broke

Postby Chris_Ryan on Thu Mar 11, 2010 12:58 am

Need someone to confirm it works
Please ignore this post. I have nothing productive to add.
Chris_Ryan
 
Posts: 1357
Joined: Thu Dec 13, 2007 6:47 pm
Location: Woburn MA
Primary Rig: 2002 Jeep Wrangler X

Re: our shit is broke

Postby BILLYjp2 on Thu Mar 11, 2010 1:53 pm

Still getting the same error...
When it comes to armeggedon, i'll drive my jeep cherokee right outta that mess
User avatar
BILLYjp2
Vice President
 
Posts: 4284
Joined: Thu Dec 13, 2007 11:50 pm
Location: Wilbraham
Primary Rig: 94 Station Wagon
Secondary Rig: 99 Danger Ranger

Re: our shit is broke

Postby Chris_Ryan on Thu Mar 11, 2010 2:26 pm

Can you get me their user name? What error are they getting? Can they view forums if they are not logged in? Can they verify the settings in UCP?
Please ignore this post. I have nothing productive to add.
Chris_Ryan
 
Posts: 1357
Joined: Thu Dec 13, 2007 6:47 pm
Location: Woburn MA
Primary Rig: 2002 Jeep Wrangler X

Re: our shit is broke

Postby Chris_Ryan on Thu Mar 11, 2010 2:45 pm

I just tested it with a new fake account... new accounts do not have an issue it seems. Get me their user name and I will check their settings in SQL against the default.
Please ignore this post. I have nothing productive to add.
Chris_Ryan
 
Posts: 1357
Joined: Thu Dec 13, 2007 6:47 pm
Location: Woburn MA
Primary Rig: 2002 Jeep Wrangler X

Re: our shit is broke

Postby Smtty58 on Sat Mar 13, 2010 11:53 am

I think its working now.
90 YJ 258, AX-15
86 GMC K1500
Smtty58
 
Posts: 112
Joined: Fri Jan 30, 2009 9:37 pm
Location: Monson
Primary Rig: 90 YJ
Secondary Rig: 86 K1500

Re: our shit is broke

Postby Chris_Ryan on Sat Mar 13, 2010 12:07 pm

Smtty58 wrote:I think its working now.


Sweet!
Please ignore this post. I have nothing productive to add.
Chris_Ryan
 
Posts: 1357
Joined: Thu Dec 13, 2007 6:47 pm
Location: Woburn MA
Primary Rig: 2002 Jeep Wrangler X

Re: our shit is broke

Postby Bump on Sat Mar 13, 2010 4:31 pm

But not if your not registered. It still says general error if your not registered and just tryin to click on anything.
Its not the trail but the ride home that'll kill ya!

Paypal - jebumpjr@msn.com - Add $1 for every $25 sent, unless its from a bank or your balance. Thanks
User avatar
Bump
Treasurer
 
Posts: 2648
Joined: Fri Dec 14, 2007 1:18 am
Location: Lakeville Ma
Primary Rig: Jeeps
Tow Rig: Fords

Re: our shit is broke

Postby mmerlina on Sat Mar 13, 2010 7:10 pm

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 25' at line 7 [1064]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

---

Chris if you want to give me access I can probably get to the bottom of that. That's a MySQL database error and not a PHP problem.. which is good cause I'm good with mysql, and not php. :grin:

Let me know..
User avatar
mmerlina
 
Posts: 994
Joined: Tue Jan 27, 2009 10:07 pm
Location: North Reading
Primary Rig: 86 CJ7

Re: our shit is broke

Postby Chris_Ryan on Sat Mar 13, 2010 8:22 pm

Just changed setting for Anonymous. Logged out and that one is working now.

Thanks for the offer Mike... I have the problem figured out now, just keep missing people when I go to fix it.
Please ignore this post. I have nothing productive to add.
Chris_Ryan
 
Posts: 1357
Joined: Thu Dec 13, 2007 6:47 pm
Location: Woburn MA
Primary Rig: 2002 Jeep Wrangler X

Re: our shit is broke

Postby Bump on Sat Mar 13, 2010 10:19 pm

Your the bestest Chris.
Its not the trail but the ride home that'll kill ya!

Paypal - jebumpjr@msn.com - Add $1 for every $25 sent, unless its from a bank or your balance. Thanks
User avatar
Bump
Treasurer
 
Posts: 2648
Joined: Fri Dec 14, 2007 1:18 am
Location: Lakeville Ma
Primary Rig: Jeeps
Tow Rig: Fords

Re: our shit is broke

Postby Chris_Ryan on Sun Mar 14, 2010 8:57 am

Just updated the forum, looks like it took without any issues. Let me know if you have any more issues.

Hoping the update stops some of these spammers.
Please ignore this post. I have nothing productive to add.
Chris_Ryan
 
Posts: 1357
Joined: Thu Dec 13, 2007 6:47 pm
Location: Woburn MA
Primary Rig: 2002 Jeep Wrangler X

Re: our shit is broke

Postby XJMA on Sun Mar 14, 2010 10:45 pm

why do we get so much spam?
"Guns don't kill people. The Government does." - Dale
User avatar
XJMA
President
 
Posts: 3847
Joined: Fri Dec 14, 2007 2:27 pm
Location: on the rocks, MA
Primary Rig: '99 XJ on Q78s
Secondary Rig: '96 XJ on 32s
3rd Rig: '04 KJ stock
4th Rig: '00 blasters

Re: our shit is broke

Postby mmerlina on Sun Mar 14, 2010 11:45 pm

Hey Chris while you're fixing stuff, can you change the time on the board? :grin:
User avatar
mmerlina
 
Posts: 994
Joined: Tue Jan 27, 2009 10:07 pm
Location: North Reading
Primary Rig: 86 CJ7

Re: our shit is broke

Postby Bump on Mon Mar 15, 2010 12:48 am

Actually Mike you need to go into the UCP under Board Preferences and change the DST
Its not the trail but the ride home that'll kill ya!

Paypal - jebumpjr@msn.com - Add $1 for every $25 sent, unless its from a bank or your balance. Thanks
User avatar
Bump
Treasurer
 
Posts: 2648
Joined: Fri Dec 14, 2007 1:18 am
Location: Lakeville Ma
Primary Rig: Jeeps
Tow Rig: Fords

Re: our shit is broke

Postby mmerlina on Mon Mar 15, 2010 1:01 am

Oh okay.. I thought it was a global type thing.. I guess it does make more sense that it's per user. I'll do that now.
User avatar
mmerlina
 
Posts: 994
Joined: Tue Jan 27, 2009 10:07 pm
Location: North Reading
Primary Rig: 86 CJ7

Re: our shit is broke

Postby Chris_Ryan on Mon Mar 15, 2010 10:30 am

I just changed it globally... It is a manual change.
Please ignore this post. I have nothing productive to add.
Chris_Ryan
 
Posts: 1357
Joined: Thu Dec 13, 2007 6:47 pm
Location: Woburn MA
Primary Rig: 2002 Jeep Wrangler X


Return to Website / Forum help and suggestions

Who is online

Users browsing this forum: No registered users and 1 guest