Posted by Martin Johnson ![]() |
|
Yes, I did try something like that, but didn't get it quite right. Your code above works fine, but strangely, the problem seems to have gone away on its own. Very strange.
I have come across a MySQL error though, in the showThread view (this happens with latest django and either Sphene 0.3 or repository latest Sphene, on a clean install on my desktop machine): Template error In template /home/martin/python/sphene/templates/sphene/sphboard/showThread.html, error at line 35 Caught an exception while rendering: (1064, "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 '1.0' at line 1") and the stacktrace: Traceback (most recent call last): File "/home/martin/python/django/template/__init__.py" in render_node 810. result = node.render(context) File "/home/martin/python/django/template/defaulttags.py" in render 112. len_values = len(values) File "/home/martin/python/django/db/models/query.py" in __len__ 111. return len(self._get_data()) File "/home/martin/python/django/db/models/query.py" in _get_data 482. self._result_cache = list(self.iterator()) File "/home/martin/python/django/db/models/query.py" in iterator 189. cursor.execute("SELECT " + (self._distinct and "DISTINCT " or "") + ",".join(select) + sql, params) File "/home/martin/python/django/db/backends/util.py" in execute 18. return self.cursor.execute(sql, params) File "build/bdist.linux-i686/egg/MySQLdb/cursors.py" in execute 166. self.errorhandler(self, exc, value) File "build/bdist.linux-i686/egg/MySQLdb/connections.py" in defaulterrorhandler 35. raise errorclass, errorvalue ProgrammingError at /QQ/forum/thread/3/ (1064, "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 '1.0' at line 1") This appears to have something to do with ordering of the posts in the thread view thread.get_all_posts().order_by('postdate'),in sphene.sphboard.views showThread. However, when I work through the database interactions in showThread in the django-admin python shell, everything works fine with no errors at all. Very strange indeed. |
|
Posted by Herbert Poul ![]() |
|
the mysql error came also up in another thread .. i just didn't commit it yet since i wasn't sure if it worked.
if you're using SCT trunk, try an update.. it should work now.. (you can also set SPH_SETTINGS['board_post_paging'] = 10 in your settings.py .. (this is now default) ... the problem was, that previously it was: 10. and so it was treated as a float ... (weird that i never had this error with postgresql)) Hey, we have Signatures !!! Great, isn't it ? ;) |
|
Posted by Martin Johnson ![]() |
|
Many thanks Herbert. Works fine now.
Can I just say once again that sphene is brilliant! I'll work on the 'add category' form for group admins over the weekend and send you a copy as soon as it's working. All the best Martin |
|
Posted by Herbert Poul ![]() |
|
great, let me know when you encounter any problems/questions ;) Hey, we have Signatures !!! Great, isn't it ? ;) |
|
Posted by Martin Johnson ![]() |
|
Weekend turned into months... ah well, such is life! For many reasons my web development work had to take a back seat. I'm just about to get stuck in again. Would the 'add category' facility still be useful, or have things moved on from there? Hope you haven't been waiting on me.
Best regards Martin |
|
Posted by Herbert Poul ![]() |
|
hehe, happens to me too quite often ;) .. anyhow .. nothing has been done in that direction yet .. (although i have been searching for someone to do such an admin interface through sourceforge a while ago .. without any luck :( ) .. so it would still be very useful
actually .. more useful because i added a bit more complexity to the forum's 'Category' model than the django admin could possible handle (beside the obvious permission limitation) :) - every Category can now have a different "category type" .. this is a simple extension mechanism to allow customizations on how the forum works (adding fields to the post/reply form, modifying thread and post lists, etc.) - i use this for example for the "Who's using SCT" forum category: http://sct.sphene.net/board/show/20/ or my personal blog i'm currently working on. but.. you probably don't need to care :) if you would be able to create and contribute a "simple" admin interface to add (modify?) categories for privileged users .. this would be great already .. i could later add this magic stuff for category types & co so .. you are still planning on using SCT for your site ? :) Hey, we have Signatures !!! Great, isn't it ? ;) |
|
Posted by Martin Johnson ![]() |
|
Hi Herbert. I need to have a bit of a think about exactly what I want to do. But I will definitely be using the forum and so will definitely have to have a category add / edit option for group admins. Will get cracking in the next week hopefully and will keep you posted so what I do is useful for you in the future.
First I must remember what I already did... |