our shit is broke

[BILLYjp2]

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

[Rafikie]

works for me

[Chris_Ryan]

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.

[Chris_Ryan]

I will send this out as a mass email blast if the update does not fix it.

[Chris_Ryan]

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.

I went into the SQL DB and changed the default of user_topic_sortby_type from b to t on the phpbb_user table

[Chris_Ryan]

Need someone to confirm it works

[BILLYjp2]

Still getting the same error...

[Chris_Ryan]

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?

[Chris_Ryan]

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.

[Smtty58]

I think its working now.

[Chris_Ryan]

I think its working now.

Sweet!

[Bump]

But not if your not registered. It still says general error if your not registered and just tryin to click on anything.

[mmerlina]

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.

Let me know..

[Chris_Ryan]

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.

[Bump]

Your the bestest Chris.

[Chris_Ryan]

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.

[XJMA]

why do we get so much spam?

[mmerlina]

Hey Chris while you're fixing stuff, can you change the time on the board?

[Bump]

Actually Mike you need to go into the UCP under Board Preferences and change the DST

[mmerlina]

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.

[Chris_Ryan]

I just changed it globally... It is a manual change.