Lost Guestbook Items after update 1.1.1 to 1.1.4

Phoca Guestbook - creating guestbooks in Joomla! CMS
ErwinDeGroot
Phoca Member
Phoca Member
Posts: 12
Joined: 14 Feb 2008, 03:27
Location: Netherlands
Contact:

Hello,I

Post by ErwinDeGroot »

Hello,

I lost my Guestbook Items after de-installing Phoca Guestbook 1.1 and immediatly after that installing 1.4.

That is very disappointing...!

Is there a possibility to retrieve it? I think it s in the MySQL database stored, isn't it? I got a recent sql-dump (done with SQL-DUMPER) so there should be a way to restore those items,.... is there not?

Cheers,... Erwin de Groot
ErwinDeGroot
Phoca Member
Phoca Member
Posts: 12
Joined: 14 Feb 2008, 03:27
Location: Netherlands
Contact:

Ok,... d

Post by ErwinDeGroot »

Ok,...

did a partial Database restore (only the Phoca Guestbook tables which I extracted from the SQL-DUMPER backup) via Plesk and that saved me .... Phieeeuwww

But Still,.... This should not be happening when updating !!!
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48689
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Please if you uninst

Post by Jan »

Please if you uninstall some component, all data will be removed. Phoca Guestbook cannot leave data in database if you want to uninstall it.

The upgrading script is not made yet, but you can upgrade via FTP:
https://www.phoca.cz/phocaguestbook/user ... dex.php#a6

Jan
If you find Phoca extensions useful, please support the project
ErwinDeGroot
Phoca Member
Phoca Member
Posts: 12
Joined: 14 Feb 2008, 03:27
Location: Netherlands
Contact:

Hello Jan,

Post by ErwinDeGroot »

Hello Jan,

Yes I noticed that de-installing flushed my data,... but it was not clear for me before,...

Why does de-installing delete my PhocaGuestbookItems table? Why is that needed?
I saw in my database that other components which I allready de-intalled had left the data,... so it IS possible to leave the data untouched.
Or should that give more troubles when there is allready data and PhocaGuestbook Installation can't replace (instead of Drop Table , Than Recreate it and Than re-insert Values) ?

Furthermore,... I am VERY pleased with this component... Thank you VERY much !

Erwin
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48689
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

First. Phoca Guestbo

Post by Jan »

First. Phoca Guestbook is not Windows programme. So if you want to remove this component, it should be removed with all data. Not leaving disorder in database or on disc ... But you right, there should be an uninstall question, e.g.: Do you want to leave data in your database. But there isn't still the upgrading script. I hoped, if Joomla has an install and uninstall procedure, it can implement this in this procedure, because I have no influence on this install resp. unistall procedure...
If you find Phoca extensions useful, please support the project
ErwinDeGroot
Phoca Member
Phoca Member
Posts: 12
Joined: 14 Feb 2008, 03:27
Location: Netherlands
Contact:

Ah ok,... so it is n

Post by ErwinDeGroot »

Ah ok,... so it is not PhocaGuestbook that regulates this data-purge!

Did not know that,... hmmmm
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48689
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

No, but I can do a s

Post by Jan »

No, but I can do a specially installation script e.g. as Virtuemart has one.... but what with uninstall. I don't have any influence on this... But I can change the DROP TABLE... But what to do if I do it:

- Some users wants to leave old data in database
- Some users wants to remove old data in database...

The best solution will be some Joomla! framework uninstall script...
If you find Phoca extensions useful, please support the project
ErwinDeGroot
Phoca Member
Phoca Member
Posts: 12
Joined: 14 Feb 2008, 03:27
Location: Netherlands
Contact:

Well,...

Post by ErwinDeGroot »

Well,...

would it be really in some-one s way if the data should still exist after de-installing???
In the majority of the occasions there would only be a few items (not more than 100 is probably right)...
and IF some-one would re-install it AND they would not like the entries, they also could get rid of them in Phoca-Guestbook Back-end.... wouldn't they?

But actually you are saying that de-installing is not under your control..
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48689
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Now I am creating a

Post by Jan »

Now I am creating a update script... It is not problem. If user install the component he can select if he wants to:

- install (new tables will be created in database)
- upgrade (no new tables will be created, old tables with old data will be used)

NO PROBLEM

but before updating, user must uninstall the old component first, but it is problem, because here I cannot use my uninstall script...

if user install component, component files will be saved on disc first and then user can use the installation script but
if user uninstall component, component files will be removed first and the user cannot use the uninstallation script because it doesn't exists more...

This is the problem of updating.
If you find Phoca extensions useful, please support the project
ErwinDeGroot
Phoca Member
Phoca Member
Posts: 12
Joined: 14 Feb 2008, 03:27
Location: Netherlands
Contact:

Hello Jan,

Post by ErwinDeGroot »

Hello Jan,

when one installs a component or module than the component XML-file will be accessed,... is it not?
Can you make a script in phocaguestbook.xml that will be executed on installation? If so,.. can you not tell the Joomla-installation-script to upgrade when those files allready exist on the server instead of just trying to copy those Component files to the server, which will result in an error "not able to install"

just a thought....
Post Reply