Peter
11-07-2005, 03:58 AM
ILance 3.0.0 Final Beta
ILance 3.0.0 Final Beta is now available to beta testers from within the store/license area. As always, it's recommended to backup your existing install and do full fresh installation of the latest releases.
Due to the complete overhaul of the database connectors within ILance v3.0.0 using a new OOP approach (to speed things up) as well as a unique "Database Caching" feature now implemented, we are having minor issues with LiveSync from ILance 3.0.0 Beta 2.9 to Final Beta. While this issue is being reviewed, it causes a blank screen at least half way down the sync process resulting in a incomplete upgrade to the Final Beta of ILance 3.0.0.
If you are only upgrading from ILance 3.0.0 Beta 2.9 to the Final Beta, please ensure you use LiveSync's new SQL sync feature to prepare your 2.9 database to the Final Beta database structure. A few new tables have been added such as:
db_cache
register_answers
register_questions
If you do not see these tables in your 2.9 install, please ensure you use LiveSync to upgrade the sql patterns so you do see these 3 tables before you install Final Beta.
If you don't see these tables, and you cannot use SQLSync within LiveSync to upgrade your db to these new settings, please review the following table schema for those 3 tables:
db_cache
CREATE TABLE `v3_db_cache` (
`id` varchar(255) NOT NULL default '',
`data` blob,
PRIMARY KEY (`id`),
UNIQUE KEY `BTREE` (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
register_answers
CREATE TABLE `v3_register_answers` (
`answerid` int(10) NOT NULL auto_increment,
`questionid` int(10) NOT NULL default '0',
`user_id` int(10) NOT NULL default '0',
`answer` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`visible` int(1) NOT NULL default '0',
PRIMARY KEY (`answerid`)
) TYPE=MyISAM;
register_questions
CREATE TABLE `v3_register_questions` (
`questionid` int(10) NOT NULL auto_increment,
`pageid` int(5) NOT NULL default '0',
`question_eng` varchar(250) NOT NULL default '',
`description_eng` varchar(250) NOT NULL default '',
`formname` varchar(100) NOT NULL default '',
`formdefault` varchar(100) NOT NULL default '',
`inputtype` enum('yesno','int','textarea','text','multiplechoice') NOT NULL default 'text',
`multiplechoice` varchar(100) NOT NULL default '',
`sort` int(3) NOT NULL default '0',
`visible` int(1) NOT NULL default '1',
`required` int(1) NOT NULL default '0',
`canremove` int(1) NOT NULL default '1',
PRIMARY KEY (`questionid`)
) TYPE=MyISAM;
Note: remember to replace the v3_ in those tables to your own prefix. If you see v3_ at the beginning of each table in your database, the above will work fine for you.
If you are not sure how to upgrade to Final Beta from 2.9, it's always recommended that you first backup your files and database for your 2.9 install, and do a completely fresh installation of ILance 3.0.0 Final Beta.
Bugs Fixed For This Release
388 - Attachment problems (PMB) (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=388)
312 - Templates in admin - Should re-direct back to page working on (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=312)
367 - LiveSync Backup Path - Needs Attention (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=367)
307 - Image upload - Reporting wrong error (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=307)
322 - LiveUpdate issue (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=322)
349 - LiveUpdate doesnt work when "Maintenance mode" enabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=349)
352 - Distribution (admincp) doesnt show when running ILance on PHP 4.3.11 (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=352)
315 - Area of Expertise doesn't appear to save (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=315)
320 - US$ present in want ad (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=320)
314 - More than one seller's bid accepted for want ad after it was sold (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=314)
319 - Post product auction link still possible when Product auction is disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=319)
317 - enable/disable want ad (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=317)
324 - Escrow payment advise issued today expires 1999 (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=324)
328 - Enable/Disable storefronts not working (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=328)
326 - LanceKB (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=326)
316 - Enable/Disable Stores (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=316)
318 - Country-- Bid filter permissions (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=318)
321 - Product Want Adoption still present in Create Want Ad when product auction is disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=321)
311 - Product feedback history present even though Product auction is disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=311)
296 - Want Ad - Self offer possible (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=296)
298 - Store front : Product search still possible when product is disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=298)
301 - Want Ad should be Disabled when Product Auction is Disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=301)
303 - Post New Offer from detailed want ad detail page should disable if found (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=303)
378 - Password Reset in AdminCP for Subscribers (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=378)
104 - Date shown as year 1999 for unpaid invoice (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=104)
337 - Registration fields (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=337)
334 - Compressing the registration process from 7 to 4 steps (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=334)
300 - MISSING CURRENCIES IN LANCE AD (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=300)
302 - LiveSync - Fresh Install of Beta 2.9a = Javascript Alert? (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=302)
295 - Disabling product auction - not completely disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=295)
291 - Error: Admin CP ->Settings ->Marketplace (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=291)
Feature Requests for ILance 2.9 (not implemented until after RC 1)
389 - Menu (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=389)
387 - Search by Main Categories (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=387)
379 - Ability to edit bid in admincp Bid Manager (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=379)
376 - List age in profiles (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=376)
373 - Questions for RFP (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=373)
372 - Fee per category system similar to features based on category (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=372)
371 - Not require RFP approval for certain users (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=371)
366 - Poll system (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=366)
370 - Feedbacks (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=370)
363 - Reviews (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=363)
358 - Budget (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=358)
355 - Placing a Bid (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=355)
348 - Instant debiting of auction percentage in online account (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=348)
346 - Ability to set various charges independent of plans missing (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=346)
340 - Email templates (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=340)
339 - Toggle LiveBid option (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=339)
338 - Shortlist? (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=338)
332 - "Outside of Marketplace" toggle to disable escrow (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=332)
305 - Advanced CSS Editor -- Beauty of CSS / Color Management (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=305)
297 - Service focused Want Ads section (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=297)
293 - Development Teams (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=293)
289 - Flood Protection (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=289)
Other Features Added to Final Beta
Custom Fields for Registration support was added (there is no admin interface yet to create these questions to be answered) - To be Completed for RC 1
Registration System Cut down to 3 steps rather than 8
Proper Registration / Email Verification Logic was Implemented (admin may also allow new registrations to bypass the full email verification checkup)
Color-coded the service and product auction area templates. Blue theme for service related info (categories, rfps, etc) and Green for Product Auction related infos (this will provide a easy way to tell difference apart for your auctions and marketplace listings to the end user
Questions for this new release can be made within the Beta Testing Community Forums.
Regards,
Peter Salzmann
http://www.ilance.ca (http://www.ilance.ca/)
ILance 3.0.0 Final Beta is now available to beta testers from within the store/license area. As always, it's recommended to backup your existing install and do full fresh installation of the latest releases.
Due to the complete overhaul of the database connectors within ILance v3.0.0 using a new OOP approach (to speed things up) as well as a unique "Database Caching" feature now implemented, we are having minor issues with LiveSync from ILance 3.0.0 Beta 2.9 to Final Beta. While this issue is being reviewed, it causes a blank screen at least half way down the sync process resulting in a incomplete upgrade to the Final Beta of ILance 3.0.0.
If you are only upgrading from ILance 3.0.0 Beta 2.9 to the Final Beta, please ensure you use LiveSync's new SQL sync feature to prepare your 2.9 database to the Final Beta database structure. A few new tables have been added such as:
db_cache
register_answers
register_questions
If you do not see these tables in your 2.9 install, please ensure you use LiveSync to upgrade the sql patterns so you do see these 3 tables before you install Final Beta.
If you don't see these tables, and you cannot use SQLSync within LiveSync to upgrade your db to these new settings, please review the following table schema for those 3 tables:
db_cache
CREATE TABLE `v3_db_cache` (
`id` varchar(255) NOT NULL default '',
`data` blob,
PRIMARY KEY (`id`),
UNIQUE KEY `BTREE` (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
register_answers
CREATE TABLE `v3_register_answers` (
`answerid` int(10) NOT NULL auto_increment,
`questionid` int(10) NOT NULL default '0',
`user_id` int(10) NOT NULL default '0',
`answer` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`visible` int(1) NOT NULL default '0',
PRIMARY KEY (`answerid`)
) TYPE=MyISAM;
register_questions
CREATE TABLE `v3_register_questions` (
`questionid` int(10) NOT NULL auto_increment,
`pageid` int(5) NOT NULL default '0',
`question_eng` varchar(250) NOT NULL default '',
`description_eng` varchar(250) NOT NULL default '',
`formname` varchar(100) NOT NULL default '',
`formdefault` varchar(100) NOT NULL default '',
`inputtype` enum('yesno','int','textarea','text','multiplechoice') NOT NULL default 'text',
`multiplechoice` varchar(100) NOT NULL default '',
`sort` int(3) NOT NULL default '0',
`visible` int(1) NOT NULL default '1',
`required` int(1) NOT NULL default '0',
`canremove` int(1) NOT NULL default '1',
PRIMARY KEY (`questionid`)
) TYPE=MyISAM;
Note: remember to replace the v3_ in those tables to your own prefix. If you see v3_ at the beginning of each table in your database, the above will work fine for you.
If you are not sure how to upgrade to Final Beta from 2.9, it's always recommended that you first backup your files and database for your 2.9 install, and do a completely fresh installation of ILance 3.0.0 Final Beta.
Bugs Fixed For This Release
388 - Attachment problems (PMB) (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=388)
312 - Templates in admin - Should re-direct back to page working on (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=312)
367 - LiveSync Backup Path - Needs Attention (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=367)
307 - Image upload - Reporting wrong error (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=307)
322 - LiveUpdate issue (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=322)
349 - LiveUpdate doesnt work when "Maintenance mode" enabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=349)
352 - Distribution (admincp) doesnt show when running ILance on PHP 4.3.11 (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=352)
315 - Area of Expertise doesn't appear to save (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=315)
320 - US$ present in want ad (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=320)
314 - More than one seller's bid accepted for want ad after it was sold (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=314)
319 - Post product auction link still possible when Product auction is disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=319)
317 - enable/disable want ad (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=317)
324 - Escrow payment advise issued today expires 1999 (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=324)
328 - Enable/Disable storefronts not working (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=328)
326 - LanceKB (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=326)
316 - Enable/Disable Stores (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=316)
318 - Country-- Bid filter permissions (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=318)
321 - Product Want Adoption still present in Create Want Ad when product auction is disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=321)
311 - Product feedback history present even though Product auction is disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=311)
296 - Want Ad - Self offer possible (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=296)
298 - Store front : Product search still possible when product is disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=298)
301 - Want Ad should be Disabled when Product Auction is Disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=301)
303 - Post New Offer from detailed want ad detail page should disable if found (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=303)
378 - Password Reset in AdminCP for Subscribers (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=378)
104 - Date shown as year 1999 for unpaid invoice (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=104)
337 - Registration fields (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=337)
334 - Compressing the registration process from 7 to 4 steps (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=334)
300 - MISSING CURRENCIES IN LANCE AD (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=300)
302 - LiveSync - Fresh Install of Beta 2.9a = Javascript Alert? (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=302)
295 - Disabling product auction - not completely disabled (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=295)
291 - Error: Admin CP ->Settings ->Marketplace (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=291)
Feature Requests for ILance 2.9 (not implemented until after RC 1)
389 - Menu (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=389)
387 - Search by Main Categories (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=387)
379 - Ability to edit bid in admincp Bid Manager (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=379)
376 - List age in profiles (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=376)
373 - Questions for RFP (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=373)
372 - Fee per category system similar to features based on category (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=372)
371 - Not require RFP approval for certain users (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=371)
366 - Poll system (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=366)
370 - Feedbacks (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=370)
363 - Reviews (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=363)
358 - Budget (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=358)
355 - Placing a Bid (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=355)
348 - Instant debiting of auction percentage in online account (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=348)
346 - Ability to set various charges independent of plans missing (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=346)
340 - Email templates (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=340)
339 - Toggle LiveBid option (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=339)
338 - Shortlist? (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=338)
332 - "Outside of Marketplace" toggle to disable escrow (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=332)
305 - Advanced CSS Editor -- Beauty of CSS / Color Management (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=305)
297 - Service focused Want Ads section (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=297)
293 - Development Teams (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=293)
289 - Flood Protection (http://www.ilance.ca/forum/bugs.php?do=showdetails&id=289)
Other Features Added to Final Beta
Custom Fields for Registration support was added (there is no admin interface yet to create these questions to be answered) - To be Completed for RC 1
Registration System Cut down to 3 steps rather than 8
Proper Registration / Email Verification Logic was Implemented (admin may also allow new registrations to bypass the full email verification checkup)
Color-coded the service and product auction area templates. Blue theme for service related info (categories, rfps, etc) and Green for Product Auction related infos (this will provide a easy way to tell difference apart for your auctions and marketplace listings to the end user
Questions for this new release can be made within the Beta Testing Community Forums.
Regards,
Peter Salzmann
http://www.ilance.ca (http://www.ilance.ca/)