TinyPortal

Development => Support => Topic started by: mattb on June 10, 2010, 02:55:29 PM

Title: blocks wont switch
Post by: mattb on June 10, 2010, 02:55:29 PM
My blocks won't switch

tinyportal > blocks im trying to order them up they won't switch before it worked now it just stopped working

im using sm 2.0 rc3 and tinyportal 1.0 beta 5-1

error:
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 's Online' WHERE id = 5' at line 1
File: /home/mattb/public_html/Sources/TPortalAdmin.php
Line: 2284


this error came up while i was using the arrow up and down to order them

and when i switch only the numbers around that does not work either. Also saving it but that never worked

saving error:
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 's Online' WHERE id = 5' at line 1
File: /home/mattb/public_html/Sources/TPortalAdmin.php
Line: 2284
Title: Re: blocks wont switch
Post by: IchBin on June 10, 2010, 09:45:17 PM
I think this is a bug in that version of TP where if you are using an apostrophe in a title of the block it throws that error. Do you have any apostrophes in the title of any of your blocks?
Title: Re: blocks wont switch
Post by: mattb on June 10, 2010, 10:18:43 PM
no
Title: Re: blocks wont switch
Post by: Freddy on June 11, 2010, 02:19:25 PM
Are you sure one of them is not called :

User's Online

See the apostrophe ?

???
Title: Re: blocks wont switch
Post by: mattb on June 11, 2010, 02:58:01 PM
all the titles have small and capital letters except for one title which has /

and thats about it.

and i can't have ' in my titles?

like you said users online instead of user's online
Title: Re: blocks wont switch
Post by: IchBin on June 12, 2010, 10:43:53 PM
no
Title: Re: blocks wont switch
Post by: JPDeni on June 12, 2010, 11:36:49 PM
Since "User's online" is wrong grammatically, it's probably better that the bug exists. It forces people to use correct grammar. (You never use an apostrophe to make a plural. Apostrophes are only used to show possession. "User's online" would be an online that belongs to a user, which makes no sense.)
Title: Re: blocks wont switch
Post by: ZarPrime on June 14, 2010, 02:04:04 PM
So, is this topic solved or not?  In this version of TinyPortal, there can also be an issue moving the blocks if there is bad code in the block as well, not just in the titles.  You should be able to move the blocks by manipulating the numbers under the "pos" column.  In any case, these problems should be fixed in the next update that Bloc will release.

ZarPrime
Title: Re: blocks wont switch
Post by: mattb on June 14, 2010, 03:30:46 PM
thanks,

can i know how you add more names under your forum name like hero member and that picture tp support and stuff.
Title: Re: blocks wont switch
Post by: ZarPrime on June 14, 2010, 04:40:56 PM
Well, even though these are just standard SMF functions, sure, I can tell you about them. ;) As an example, take a look at my avatar in this post.  Above my avatar, in order from the top, you should see the following ...
1.  My UserName ~ ZarPrime
2.  TP Support ~ this is the primary MemberGroup that I am in.
3.  Hero Member ~ this indicates the post based group that I am.  For instance, right now you are a Jr. Member.  Once you have over a certain number of posts, you will become a Full Member.  Once you have a lot of posts, like me, you will become a Hero Member.
4.  TP Support Badge ~ This is simply the image that is being used by anyone who is in the TP Support MemberGroup, which I am.  If you have badges that you want to use instead of Stars, you change this in the  MemberGroups area of the Admin section of your site.


ZarPrime
Title: Re: blocks wont switch
Post by: mattb on June 14, 2010, 09:40:59 PM
Thanks ZarPrime :)