+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: General Questions (https://community.letodms.com/forumdisplay.php?fid=15)
+--- Thread: Update from v2.0.2 to v3.4.0RC4 (/showthread.php?tid=594)
RE: Update from v2.0.2 to v3.4.0RC4 - John_k22 - 11-28-2012
Hi Uwe, input the line and got th following message
Code:
(mysql): SHOW TABLES
(mysql): SELECT * FROM tblVersion order by major,minor,subminor limit 1
(mysql): SELECT * FROM tblSessions WHERE id = '119fb2d541bbc366f7b95f490674854c'
(mysql): UPDATE tblSessions SET lastAccess = 1354103919 WHERE id = '119fb2d541bbc366f7b95f490674854c'
(mysql): SELECT * FROM tblUsers WHERE id = 1
(mysql): SELECT * FROM tblFolders WHERE id = 1
(mysql): SELECT * FROM tblACLs WHERE targetType = 1 AND target = 1 AND mode<=1 ORDER BY targetType
(mysql): (SELECT `tblUsers`.* FROM `tblUsers` WHERE (`tblUsers`.`id` = 1) OR (`tblUsers`.`role` = 1))UNION (SELECT `tblUsers`.* FROM `tblUsers` WHERE `tblUsers`.`role` != 2 ) ORDER BY `login`
(mysql): SELECT * FROM tblUsers WHERE id = 1
(mysql): SELECT `tblGroups`.* FROM `tblGroups`
(mysql): SELECT * FROM tblMandatoryReviewers WHERE userID = 1
(mysql): SELECT * FROM tblMandatoryApprovers WHERE userID = 1
(mysql): INSERT INTO tblDocuments (name, comment, date, expires, owner, folder, folderList, inheritAccess, defaultAccess, locked, keywords, sequence) VALUES ('ddd', '', 1354103919, 0, 1, 1,':1:', 1, 2, -1, '', 1)
(mysql): SELECT LAST_INSERT_ID()
(mysql): SELECT * FROM tblDocuments WHERE id = 3
(mysql): SELECT * FROM tblDocumentLocks WHERE document = 3
(mysql): INSERT INTO tblDocumentContent (document, version, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (3, 1,'', 1354103919, 1, '3/', 'Neu Textdokument (5).txt', '.txt', 'text/plain')
(mysql): DELETE FROM tblDocuments WHERE id = 3John
RE: Update from v2.0.2 to v3.4.0RC4 - steinm - 11-28-2012
(11-28-2012, 05:44 PM)John_k22 Wrote: Hi Uwe, input the line and got th following messageThe last insert statement must be the problem. Can you take you favorite mysql client and execute it. The statements looks right but somethink must go wrong, so maybe you get an error message when executing it on its own.
Code:(mysql): INSERT INTO tblDocuments (name, comment, date, expires, owner, folder, folderList, inheritAccess, defaultAccess, locked, keywords, sequence) VALUES ('ddd', '', 1354103919, 0, 1, 1,':1:', 1, 2, -1, '', 1)
(mysql): SELECT LAST_INSERT_ID()
(mysql): SELECT * FROM tblDocuments WHERE id = 3
(mysql): SELECT * FROM tblDocumentLocks WHERE document = 3
(mysql): INSERT INTO tblDocumentContent (document, version, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (3, 1,'', 1354103919, 1, '3/', 'Neu Textdokument (5).txt', '.txt', 'text/plain')
(mysql): DELETE FROM tblDocuments WHERE id = 3
John
Uwe
RE: Update from v2.0.2 to v3.4.0RC4 - John_k22 - 11-28-2012
Meanwhile I upgraded from v2.0.2 to v3.2.2 and it works great
(exept Zend which I didn't install) Thanks for your help The only thing that is not working is the 'Add multiple documents' function. But if I am right it uses the jumploader java applet and I do not have the Java plugin installed in my Firefox.
Next step will be to go for the v3.4. Is it tricky to update from 3.2.2.? Do I have to take care on somthing special?
John
RE: Update from v2.0.2 to v3.4.0RC4 - steinm - 11-28-2012
(11-28-2012, 11:12 PM)John_k22 Wrote: Meanwhile I upgraded from v2.0.2 to v3.2.2 and it works great
The only thing that is not working is the 'Add multiple documents' function. But if I am right it uses the jumploader java applet and I do not have the Java plugin installed in my Firefox.
Next step will be to go for the v3.4. Is it tricky to update from 3.2.2.? Do I have to take care on somthing special?
3.4.0 will use many more table constraints which require the innodb engine. So, make sure you use innodb instead of myisam.
Uwe
RE: Update from v2.0.2 to v3.4.0RC4 - John_k22 - 12-03-2012
thanks
For the moment I will stay on 3.2.2 and will update a later.
John
RE: Update from v2.0.2 to v3.4.0RC4 - John_k22 - 12-04-2012
Hi again
Found some time today and tried to update to the latest stable version 3.3.11. It went good so on and also switching to the new content directory format went fine.
I created a new DB and imported the old DB into the new one and run the update.sql. Then I tried to switch the DB to innoDB like "ALTER TABLE `tblDirPath` ENGINE = InnoDB" for each single table but on some tables I got an error.
The Error is (e.g. when altering tblDirPath to innoDB)
'#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key'
update.php is also not working. It says
Fatal error: Call to a member function Execute() on a non-object in /volume1/web/letoDMS-3.3.11/install/update-3.3.0/update.php on line 48
Table Field Old Value New Value Update statement
How can I switch my database from MyISAM to innoDB?
John
RE: Update from v2.0.2 to v3.4.0RC4 - steinm - 12-04-2012
(12-04-2012, 05:55 AM)John_k22 Wrote: Hi againtblDirPath (and tblPathList) are obsolete, Do the other tables work?
Found some time today and tried to update to the latest stable version 3.3.11. It went good so on and also switching to the new content directory format went fine.
I created a new DB and imported the old DB into the new one and run the update.sql. Then I tried to switch the DB to innoDB like "ALTER TABLE `tblDirPath` ENGINE = InnoDB" for each single table but on some tables I got an error.
The Error is (e.g. when altering tblDirPath to innoDB)
'#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key'
(12-04-2012, 05:55 AM)John_k22 Wrote: update.php is also not working. It says
Fatal error: Call to a member function Execute() on a non-object in /volume1/web/letoDMS-3.3.11/install/update-3.3.0/update.php on line 48
Table Field Old Value New Value Update statement
The database could not be opened. This could be an error in the install script. I have to check.
Uwe
RE: Update from v2.0.2 to v3.4.0RC4 - John_k22 - 12-05-2012
(12-04-2012, 01:38 PM)steinm Wrote: tblDirPath (and tblPathList) are obsolete, Do the other tables work?
I got this error with 2 tables tblDirPath and tblDocumentContent.
Error: #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
John
mulberry alexa - cheisf - 12-06-2012
If you contemplate the sheer quantity of new purses introduced each and every 12 months there are only a handful of bags that attain iconic standing and the Mulberry Bayswater bag falls into that group.
Introduced in 2003 the Bayswater bag hit the correct observe by mixing quintessential English style with sensible features.
Mulberry ended up so successful in translating the "Amazing Britannia" ethos into a handbag that Britain's very very own poster woman, Kate Moss, manufactured the Bayswater bag her personal trend declaration and has been snapped by a variety of paparazzi keeping her Mulberry bag, at times as a shield !!!
The mulberry bayswater
style property was born in 1971 and was the mind child of Roger Saul whom was presently included in the fashion sector as a male model.
On his 21st birthday party, Saul determined the time was correct to strike out on his very own and started searching round at distinct organization ventures. He eventually decided to go into enterprise with his mom producing leather bags and other products.
Saul wanted to produce a style brand name that experienced echoes of a classic English place, gentry way of life but also was cutting edge ample to draw in style conscious women of the day. Coupled with beautiful leather workmanship the Mulberry bag before long grew to become famous for fashion and high quality.Even so, Mulberry did not sacrifice practicality and functionality over fashion and style and Mulberry bags shortly grew to become coveted for their style and useability.
Though Mulberry loved stunning achievement with it's range of designer purses, the company struck gold with the launch of the Mulberry Bayswater bag.
Contacting upon all their many years of expertise, Mulberry produced a bag that appealed to the fashionistas and celebrities nevertheless wasn't just about great looks as Mulberry made the bag with a practical eye.
The Bayswater is very a roomy bag and measures roughly 36cms x 26cms x 16cms.  This sets it apart from many of the other girly looking bags on the market. The two handles on the bag are extended ample to enable you to use the bag above your shoulder, in your hand or above your forearm and this assortment of techniques in which you can carry the bag appears to give the Bayswater a distinct seem and sense about it.
Like all Mulberry bags, the mulberry men bag
is exquisitely made from the finest leather-based. Usually described as "Darwin leather" this is a smooth, vegetable tanned leather which lightens or darkens in excess of time. This "ageing" approach enhances the look of the Bayswater giving it it's personal unique character.
The bag features a leather-based flap closure which can then be secured making use of either a postman's lock or the small lockable padlock at the entrance of the bag. All this kind of fixtures on the bag are produced from brass like the brass toes on the bottom of the bag which are helpful for protecting the leather-based at the bottom of the Bayswater from getting scratched and scuffed.
The Mulberry Bayswater retails for approximately 450 - 650 lbs relying on which model of the Bayswater it is. Though this price tag may seem to be extreme it becomes very clear after possessing a Mulberry bag for any length of time that it's money nicely invested. The craftsmanship and components utilized in Mulberry bags are always to the best regular and merged with the vintage patterns that have created the Bayswater so popular then you know you have one thing in your wardrobe that will by no means go out of type or vogue.
Handbags have a distinctive story to explain to about each feminine carrying them. Handbags increase beauty and grace to the personality of girls. The purses have its distinctive type of reflecting the style statement of the particular person, and 1 easily choose the taste of the person by getting a seem at the purse.
mulberry messenger bag
RE: Update from v2.0.2 to v3.4.0RC4 - John_k22 - 12-09-2012
(12-05-2012, 02:35 AM)John_k22 Wrote:Hi Uwe, can you please give me an advise how I should go on with this problem?(12-04-2012, 01:38 PM)steinm Wrote: tblDirPath (and tblPathList) are obsolete, Do the other tables work?
I got this error with 2 tables tblDirPath and tblDocumentContent.
Error: #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
John
John