upgrade

Started by Bert Heijenga, 10 January 2013, 22:27:51

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

Bert Heijenga


QuoteUPDATE #__abbook SET image = CONCAT( 'images/abook/', image ) WHERE image != ''
substitute "#_" to your prefix. eg. sdd_abbook
do you mean with " prefix"  the local storage location?
Bert

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

Bert Heijenga

Quote


Morning Bert,

Or at least it is morning here on the east coast of the U.S.A.  It seems that Federica has the correct solution to your problem.  Or at least as much as I understand about MySql databases.  She's pretty smart in that regard.

As to the comment you made in regards to the "Location" field you are setting yourself up for a heartache later on.
Maybe, but in version 1.1.2 there was no such thing as a Tag

QuoteFor the "Location" field, that is intended to indicate the physical location of where the book is stored.
I got that, but don't need it, all books are stored in one place.

QuoteBut since you already have it mixed up I am sure that Federica could come up with a MySql query correcting this oversight.  A few kronors, lire, dollars, etc. would definitely help to grease the wheels to use an American euphemism.  In other words, take the "Location" field, copy all those entries, and paste them into a "Tag" called Publisher.  I'm assuming that a routine would check to ensure that in the "ablocations" database it would check to make sure the data was correctly copied to the "abtag" database by the ID.  It would also need to take into account the "abbooktag" database.  This last database appears to be where the "abbook" and "abtag" databases meet, through the "idbook" and "idtag" fields.

What you are suggesting requires a knowledge of Mysql I suppose, that I do not have


QuoteMeanwhile you may be familiar with WorldCat.Org.  This link is for the same partial title showing all their items.  Their numbering system is their own but since the organization is world wide it lists items not normally to be found here in America.  Again, they do not catalog everything. To be specific, and taking directly from your site I offer your listing from WorldCat for the first item in your catalog, "The Atlas of Huguenin, 1819-1829."  It can be found here.  I would highly recommend that you use this site to fill in your database.

I'll have a look into that, but first things first.

thanx again for your cooperation!

Bert

federica

In the old database (ABL 1.1.2) there isn't the complete path for the images but the filename only. You have to run the query for add the path before the filename for each book.
You can see the database table prefix in the joomla global configuration->server->database settings->Database Tables Prefix
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]

dario

Hi Bert, i'll try to help you if possible.
Quote from: Bert Heijenga on 12 January 2013, 19:38:49
QuoteUPDATE #__abbook SET image = CONCAT( 'images/abook/', image ) WHERE image != ''
substitute "#_" to your prefix. eg. sdd_abbook
do you mean with " prefix"  the local storage location?
Bert

QuoteWhat you are suggesting requires a knowledge of Mysql I suppose, that I do not have
Yes, but also not so much. There are some programs that can help you to do that job. For example there is one called PhpMyAdmin that i can be very useful for that.

Follow what Federica said :
QuoteYou can see the database table prefix in the joomla global configuration->server->database settings->Database Tables Prefix

Then use PhpMyAdmin to execute the query:
UPDATE #__abbook SET image = CONCAT( 'images/abook/', image ) WHERE image != ''
the two characters "#" and the second "_" must be substituted with the prefix you found in configuration, then, for example if your prefix is "aaa" the query will be
UPDATE aaa_abbook SET image = CONCAT( 'images/abook/', image ) WHERE image != ''

If you have access to the console of the server in which joomla is installed you can input the query from command line. But let us to know if you can use PhpMyAdmin.

I hope I have made less confusion!
[url=http://www.knoppix.it]Knoppix italia[/url]
[url=http://www.disconnessi.org]Stacca la spina![/url]
[url=http://www.informatizzati.org]Informatizzati.org: Computer, Linux, Windows, VMware[/url]

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

Bert Heijenga

#11
Federica and Dario,
Thank you. I misunderstood the term prefix, of course it's the prefix for the Mysql-table - j17 in my case. I have indeed access to PhpMyadmin on the server, and was able to fix the path to the folder containing the covers. That' s working now. Only four problems left now, the "author", "editor" , " library"  and " location " issues.
If that could also be solved with mysql queries you would make me very happy!
and FYI: after I imported all the books via CVS, the mysql -tables j17_abauthor, j17_abbookauthor,  j17_abeditor, j17_ablibrary and j17_ablocations all seem to be empty. (Most of) the bookinfo is in j17_abbook. The corresponding  Joomla 1.5 tables with prefix jos_ are still in the database and they contain the right data. Might it - mayby after some mods - be possible to rename them to j17_ tables, or is this a stupid remark?

Bert

dario

Well Bert, yes, after some mods those tables can be used on behalf of new tables. In particular you have to check which column are present in new tables and add them. Also there are some column to rename. After that you can rename to j17_ prefix.
Keep in mind that: you can create (in new tables of abook) a sample book,author,category, and so on for every tables. Then compare what you find here with what you have in old tables. Make appropriate modification for colums ad relative content. This will give you abook working.

I'm working to make a tutorial to do that or to make a script that automate this. But I don't know when this will or could be done.
Then I think you can achieve successful results in minor time with managing tables by yourself  :)
[url=http://www.knoppix.it]Knoppix italia[/url]
[url=http://www.disconnessi.org]Stacca la spina![/url]
[url=http://www.informatizzati.org]Informatizzati.org: Computer, Linux, Windows, VMware[/url]

Bert Heijenga

#13
Do you have a solution already for my problem? You said you were working on a script. I tried to convert the old tables in the database; it's a hell of a job, and some worked, others did not, so I still do not have a working library in Joomla 2.5 - and my provider is urging me to upgrade!I had to  upgrade the site to Joomla 2,5, so now we do not have a working library!

greetz,
Bert