Addon Release: CorantoSQL 6.0 Alpha 1

All new Coranto Addons, updates and patches to addons, will be released here...also, get support for addons within!

Moderators: Spunkmeyer, Dale Ray, SrNupsen, Bluetooth, Jackanape

Addon Release: CorantoSQL 6.0 Alpha 1

Postby Lawrence » Mon Mar 13, 2006 10:43 pm

After an eternity of little activity, here's my next major addon release: CorantoSQL 6.0 Alpha 1. Alot of changes have occured. Most of the big stuff is done now. From here on out, my focus is on tidying up code and fixing bugs.

Link: http://lcwilliam1.freeownhost.com/cra_c ... 0a1.tar.gz

Upload ALL files to your coranto folder.

Here's a changelog:
* Cleaned up readme.txt and copyright information
* Cleaned up the SQL Settings addon
* Cleaned up some variable usage
* Added SF link for addon
* Removed some code that was never even used :)
* Added new dynamically generated INSERT, DELETE and UPDATE
statements. No more need for csql-devsubs.txt as well :)
* Cleaned up default settings usage for cSQL settings
Now checks to see if config key exists.
* Removed catch-all SQL table field creation option. If an addon
introduces a new Coranto field type, it is responsible for using the
CorantoSQL_AddAField and CorantoSQL_AddAField2 hooks to ensure
the new field is added to the SQL database table. THIS WILL BREAK
SOME ADDONS!!

Please do not use this addon on a live site. Code is definitely alpha quality. If someone could please test with 1.3x, do so, as I don't have a working 1.3x install to check myself at the moment. Post all feedback in this thread, so I can keep track of things :)

Lawrence
Stuff I'm working on:
- nothing

Addons:
http://sourceforge.net/projects/lw-craddons/
Lawrence
 
Posts: 1524
Joined: Sun Sep 16, 2001 4:24 am

Postby Lawrence » Mon Mar 13, 2006 11:58 pm

Hot on the heels of the first alpha, here's a 2nd.

Link: http://lcwilliam1.freeownhost.com/cra_c ... 0a2.tar.gz

Changelog:
* Enabled usage of $CConfig{'sql_enabled'}. No more
unneeded editing of coranto.cgi :)
* Made the SQL Settings addon privacy compatible
* Require Coranto 1.24 (aka build 39) or newer, as
it's known to be compatible with this version of
cSQL.

Lawrence
Stuff I'm working on:
- nothing

Addons:
http://sourceforge.net/projects/lw-craddons/
Lawrence
 
Posts: 1524
Joined: Sun Sep 16, 2001 4:24 am

Postby Lawrence » Wed Mar 15, 2006 4:21 am

I have thought of something nice to add to cSQL: A call to OPTIMIZE TABLE, just to make sure we are getting the best db possible.

This could be done in 2 places:
1) Just before finishing the initial news transfer. It would require something like the following:

Code: Select all
if ($dbtype eq 'mysql'){
$corantosql_dbh->do("OPTIMIZE TABLE coranto");
}


It could also be made available via a link under the transfer news link on the CorantoSQL Settings page, for users with admin access.
Stuff I'm working on:
- nothing

Addons:
http://sourceforge.net/projects/lw-craddons/
Lawrence
 
Posts: 1524
Joined: Sun Sep 16, 2001 4:24 am

Postby Lawrence » Thu Mar 16, 2006 12:42 am

Another thing I am going to do is make it (hopefully) so that transaction support is enabled by default AND automatically disable it if the SQL server doesn't support it.

Lawrence
Stuff I'm working on:
- nothing

Addons:
http://sourceforge.net/projects/lw-craddons/
Lawrence
 
Posts: 1524
Joined: Sun Sep 16, 2001 4:24 am

Postby web » Thu Mar 16, 2006 10:26 am

that's what i'm receiving on psudo-transfer
Code: Select all
Error: Could not execute prepared SQL statement. 1054. Unknown column 'xMultiSubmitSP' in 'field list'
User avatar
web
 
Posts: 176
Joined: Sun Nov 30, 2003 3:39 pm

Postby Lawrence » Thu Mar 16, 2006 3:49 pm

web wrote:that's what i'm receiving on psudo-transfer
Code: Select all
Error: Could not execute prepared SQL statement. 1054. Unknown column 'xMultiSubmitSP' in 'field list'


Hi web, thanks for reporting the error. As I mentioned above, this release will break some addons that depended upon broken functionality in the past. Now that I've addressed that, some addons will unfortunately break as well.

I am currently seeing what addons depended on this broken design, and will work to release fixes.

In the meantime, you can use CorantoSQL 5.0 Beta 18 (which should work for you). I will try to release a fix for XMS this evening, provided everything goes well :)
Stuff I'm working on:
- nothing

Addons:
http://sourceforge.net/projects/lw-craddons/
Lawrence
 
Posts: 1524
Joined: Sun Sep 16, 2001 4:24 am

Postby web » Thu Mar 16, 2006 5:16 pm

Thanks Lawrence. I'll be waiting for fixes.
As i have noticed else, this cersion of CraSQL don't create some tables that earlear version did..
User avatar
web
 
Posts: 176
Joined: Sun Nov 30, 2003 3:39 pm

Postby Lawrence » Fri Mar 17, 2006 4:33 am

You mean it doesn't create some fields that the previous one did?? If so, that is because of the fixed functionality of the database creation now. I am working on fixes for several addons, as we speak.
Stuff I'm working on:
- nothing

Addons:
http://sourceforge.net/projects/lw-craddons/
Lawrence
 
Posts: 1524
Joined: Sun Sep 16, 2001 4:24 am


Return to Addon Release and Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron