#93 Bookmark sorting...

[Anonymous]

Hi,

Finally finished upgrading from Booby (don't know which version- one of the first ones) to version 2.

I'm getting an error when trying to sort bookmarks:

GetAllPublicSortedItems: 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 'DESC' at line 1 SELECT * FROM brim_bookmarks WHERE (owner='admin' OR visibility='public') AND parent_id=0 AND (is_deleted=0 || IsNull(is_deleted)) ORDER BY DESC

Could you please tell me where's Mysql for this function, so I can look over it.. Is it possible that, because I imported old bookmarks that did not have "Last visited" (and had created some new nes too, to test), the script chokes on the lack of date/time?

My Mysql version is 4.3.

Thanks!

[Nobody/Anonymous]

I get the same error when I want to sort my bookmarks.

It's in .../framework/model/Services.php on line 179

I didn't do any update of brim since the release of 2.0.0.
Maybe this is some MySQL incompatibility. The MySQL version is 5.0.32.

Stefan

[Nobody/Anonymous]

It suddenly works again. Still same brim version and same MySQL version.
Strange.

[Nobody/Anonymous]

The bookmark problem reoccured several times. But I figured out that it's probably a browser problem.
I'm using Mozilla Firefox. When I restart the browser the bookmark sorting works again.
I don't know if that happens with other browsers too.

So maybe the bug can be closed.

Stefan