Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Update from v2.0.2 to v3.4.0RC4
11-28-2012, 05:44 PM,
#11
RE: Update from v2.0.2 to v3.4.0RC4
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 = 3

John
Reply
11-28-2012, 09:56 PM,
#12
RE: Update from v2.0.2 to v3.4.0RC4
(11-28-2012, 05:44 PM)John_k22 Wrote: Hi Uwe, input the line and got th following message

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
The 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.

Uwe
Reply
11-28-2012, 11:12 PM, (This post was last modified: 11-28-2012, 11:12 PM by John_k22.)
#13
RE: Update from v2.0.2 to v3.4.0RC4
Meanwhile I upgraded from v2.0.2 to v3.2.2 and it works great Smile (exept Zend which I didn't install) Thanks for your help Smile
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
Reply
11-28-2012, 11:31 PM,
#14
RE: Update from v2.0.2 to v3.4.0RC4
(11-28-2012, 11:12 PM)John_k22 Wrote: Meanwhile I upgraded from v2.0.2 to v3.2.2 and it works great Smile (exept Zend which I didn't install) Thanks for your help Smile
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
Reply
12-03-2012, 06:28 AM,
#15
RE: Update from v2.0.2 to v3.4.0RC4
thanks Smile

For the moment I will stay on 3.2.2 and will update a later.

John
Reply
12-04-2012, 05:55 AM,
#16
RE: Update from v2.0.2 to v3.4.0RC4
Hi again Wink

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
Reply
12-04-2012, 01:38 PM,
#17
RE: Update from v2.0.2 to v3.4.0RC4
(12-04-2012, 05:55 AM)John_k22 Wrote: Hi again Wink

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'
tblDirPath (and tblPathList) are obsolete, Do the other tables work?

(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
Reply
12-05-2012, 02:35 AM,
#18
RE: Update from v2.0.2 to v3.4.0RC4
(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
Reply
12-06-2012, 11:58 AM,
#19
mulberry alexa
If you contemplate&nbspthe sheer quantity of new purses introduced each and every 12 months there are only a handful of&nbspbags 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&nbspquintessential 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&nbspworkmanship the Mulberry bag before long grew to become famous for fashion and high quality.Even so, Mulberry&nbspdid not&nbspsacrifice practicality and functionality over fashion and style and&nbspMulberry bags shortly grew to become&nbspcoveted 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&nbsppractical eye.

The Bayswater is very a roomy bag and measures roughly 36cms x 26cms x 16cms. &nbspThis 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
[url=http://www.cheapmulberrysales.co.uk/mulberry-clutch-pouch-c-8.html]mulberry wallet[/url]
Reply
12-09-2012, 07:53 PM,
#20
RE: Update from v2.0.2 to v3.4.0RC4
(12-05-2012, 02:35 AM)John_k22 Wrote:
(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
Hi Uwe, can you please give me an advise how I should go on with this problem?

John
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)

Contact Us | LetoDMS Community Forum | Return to Top | | Lite (Archive) Mode | RSS Syndication