Ok, I think I'm ready to release this baby, but I need a sanity check before I do so. Before downloading this release, please read the notes below. This is not intended for production, nor is it a good idea to apply this over existing Galleon Forums (I'll explain why in the notes). But if you want to give 2.0 a test drive, now is the time to do so.
So what does Galleon 2 have?
- New logo by Murat Kgirgin. Because I have the graphical skills of a drunk one handed mentally handicapped monkey, I made the poor guy do about 10 revs, so thank you Murat for dealing with me.
- New table system to handle stats. (See notes below.)
- Avatars. You can now upload an image for an avatar, or use your gravatar.
- You can now edit your settings in the Admin.
- BBML thanks to Depressed Press
- New security system. You can now make truly private conferences.
So now for the release notes. Read this carefully before downloading.
- The zip contains updated SQL scripts for MySQL and SQL Server. These are for new installs. The Access DB is not updated.
- There is no way to 'migrate' an old Galleon install, but that is what I'm working on next.
- When you set up security for a conference/forum, you want to explicitly set who has permission to edit. Right now it defaults to Everyone.
- In terms of Security, "Everyone" means any person, BUT, they must be logged in. So if a forum has Write access Everyone, it doesn't mean non-authenticated users can post. Basically - security begins after you are logged in. (Or should, if not, let me know.)
Please post bug reports here - but read the comments first so as to not duplicate.
Archived Comments
I will give it a whirl. Is the download link going to be updated on riaforge?
No. I will update RIAForge when Galleon 2 Final is ready.
Sorry Ray, just realized it was attached to the post.
I downloaded it for a wee test run. The MySQL script wouldn't work with all the GO statements (running it via MySQL Query Analyser) but I fixed that soon enough.
Can't seem to log into the admin section now though - it shows me as logged in at the top of the screen, but any attempt to get to /admin simply redirects back to the start.
This is on Railo 2 by the way...
Ray,
Loaded it and ran into four MSSQL errors. It was trying to add two galleon_forum tables (galleon_threads is missing), reserved word group and right were missing [], and it was tryning to constrain and existing PK in the conferences table. I can e-mail you the modified script, but I don't know what the galleon_threads table is supposed to look like.
Front end is "functional" but admin erea throws and error because it cannot find the threads table.
... and apparently I need to learn how to type.
The threads table was defined in the MySQL script and I added it to the MSSQL script. Threads are still causing errors (more to follow).
When trying to add a user through the admin I get the following error "Element AVATAR is undefined in ARGUMENTS". Trying to join from the front I get General DB Error.
http://www.swphoto.net/g2 if you want to take a look.
congrats Ray! As always, thanks for sharing via Open Source.
Problem with threads was the timestamp field. Changed the datatype to datetime and all is functioning.
Related to the user, it sends a confirmation e-mail before it adds it to the database. I can't register because of the General DB error, but a few moments later I get a confirmation e-mail that doesn't work.
typo line 40 of conferences_edit.cfm and lines 100, 116, and 161 of conference.cfc should be "Conference" and not "Conferfence"
User error is:
[empty string] Element AVATAR is undefined in ARGUMENTS.
Just downloading it now, and will report back with any findings. Nice logo BTW.
Thanks Ray.
Hi Ray, my version of MySQL (5.11.1) didn't like your mysql.sql script all.
Firstly all the SQL queries required a semicolon ; at the end of their enclosing brackets
Also there are a few MySQL reserved words being used as column names that need `escaping` ..
group .. in the galleon_groups table
right .. in the galleon_rights table
password .. in the galleon_users table
I.e.
CREATE TABLE galleon_groups (
Id varchar(35) NOT NULL,
`group` varchar(50) NOT NULL
);
Regarding Ben's post above, I think I tried to do an Oracle port of this once and ran into the same issue. Oracle refuses to allow columns to be named with SQL reserved words like 'select', 'update', and in this case, 'group'. Otherwise you could end up with weird SQL like
select count(*), group from galleon_groups group by group
'group_id' or similar would be a better choice for a column name, IMHO.
I want to thank everyone for the posts above. I'm going to try to get a new build out tonight with fixes. Joel - as for Oracle - I know I had an unsupported mod for Oracle in the past. I don't think I'm going to try to support Oracle for 2.0. I may try for 2.1, where I wanted to also add Derby support.
MySQL Users:
Please download:
http://www.coldfusionjedi.c...
I confirmed it worked ok here, but if you guys can confirm, I will copy over into zip.
Note - the MySQL script included ranks. I've removed that. Galleon doesn't ship (shouldn't ship) with default ranks.
SQL Server users:
Please download:
http://www.coldfusionjedi.c...
This script was done by Shane Zehnder.
As before, if you can confirm this fixes, I'll update the zip.
User edit bug is fixed.
Typos fixed.
Will be in next zip. Next zip will be after I get confirmations on the new install scripts.
http://www.coldfusionjedi.c...
It's still pretty early in the morning. :)
OOps - thanks. I've got mysql on the brain.
MSSQL script still has two CREATE TABLE [dbo].[galleon_forums] entries.
Shane sent me a fix and I reuploaded.
I removed the extra galleon_forums table from the mssql script. Just waiting for the file to be updated in downloads.
It already is.
Well, I have been playing with the forums and talking to myself a lot and everything appears to be working fine. One thing I have noticed is user rank does not appear to be appearing while viewing posts. I went back through quickly and checked my settings, but I may have missed something.
I've been watching the galleon_threads table and I have had no problems with it or errors thrown on the board. Hopefully no one else has had any problems.
Shane - do you have ranks defined in the admin? Ranks won't show unless you create some.
VERY IMPORTANT:
Zip has been updated. Includes fixes and new SQL files.
Please retest.
It was my fault. I didn't have a minpost set to 0 for "Noobs" so when they were below the threshhold for the first rank it was correctly returning a blank string. Not one of my brighter moments.
Ray,
Deleted all the files and the database tables. Still getting the "General DB error" when I try to register on the public side and "Element AVATAR is undefined in ARGUMENTS." when I try to add a user from the admin.
I was able to edit the admin user without errors.
Crap - I didn't test new user on the front side. But the admin DID work. Are you sure you refreshed cache?
I didn't clear the form cache, now that I have, all is functioning correctly.
Need help guys!
Please download this zip:
www.coldfusionjedi.com/down...
It contains a migration guide and a CFM that will update your database. It doesn't add the columns, but after you have done it manually, it will update the new metadata columns.
PLEASE BACK UP FIRST!
As a general FYI, this is what is left to do:
1) Update main docs
2) Update design (I've seen it - it kicks major butt)
3) Update all files - this is just a reset of the code headers for v2.
4) Update readme.
2 is being done by an outside firm. I'll probably do 1 tonight. We are really, really close now.
Hmm my link above is wrong. Just go here:
http://www.coldfusionjedi.c...
I love this forum script. However one of the suggestions would be to add a block of statistics under the forums section such as how many active users ther are, newest member, now online, total topics, total posts and total members.
just a suggestion anyway.
cheers,
Simon
Why not file an ER at galleon.riaforge.org? :)