JOOM::GALLERY::FORUM

JoomGallery 2.x ACL => Backend / Administration => Topic started by: winnetouch on 20-04-2013 23:13:23



Title: 0 error - invalid parrent ID
Post by: winnetouch on 20-04-2013 23:13:23
I'm having a huge issue with joomgallery that baffles me. Last week, everything was working fine. I didn't change anything in the backend of joomla, I'm the only admin and all of a sudden I keep getting this error when I try to create a new category:

0 - An error has occurred.

Invalid parent ID.

Return to Control Panel

The category is then created but I can't delete it in the backend (I have to delete the tables in mysql) and I can't upload any images in to it. Could this be a permissions problem?


Title: Re: 0 error - invalid parrent ID
Post by: Chraneco on 20-04-2013 23:50:35
Hi,

most probably the assets table is broken.

Do you have already any images in your gallery or would it be fine to remove anything and reinstall it?

Regards
Chraneco


Title: Re: 0 error - invalid parrent ID
Post by: winnetouch on 21-04-2013 07:48:16
The gallery is HUGE! Simply removing the images and reinstalling anything would be a big hassle.


Title: Re: 0 error - invalid parrent ID
Post by: Chraneco on 21-04-2013 21:29:33
Hi,

then, it would be necessary for me to have access to your backend and your database.
I cannot imagine what's wrong there.

Regards
Chraneco


Title: Re: 0 error - invalid parrent ID
Post by: winnetouch on 22-04-2013 08:58:38
Acces to backend is no problem, but what if I export my database tables and send you that?


Title: Re: 0 error - invalid parrent ID
Post by: Chraneco on 22-04-2013 11:00:12
Hi,

yes, the export of the database could be helpful, too.
You can send it to the e-mail address in my forum profile.

Important are all tables of JoomGallery, the '#__extensions' table and the '#__assets' table.

Regards
Chraneco


Title: Re: 0 error - invalid parrent ID
Post by: winnetouch on 24-04-2013 19:27:17
I've esnt you the exports. Have you recived them?


Title: Re: 0 error - invalid parrent ID
Post by: Chraneco on 24-04-2013 23:24:41
Hi,

yes, but unfortunately I didn't find any problems in it.
Would it be possible to get backend access and FTP access to your site?
If you agree with that please send me the details via PM.

Regards
Chraneco


Title: Re: 0 error - invalid parrent ID
Post by: winnetouch on 26-04-2013 22:50:07
Hm... If the tables are alright is it possible to manually migrate the galleries, I mean what if I backup the files and tables, uninstall joomgallery, reinsert the tables and just reupload the originals, thumbnails and details folders? Is that possible? Maybe something is wrong with the core files of joomgallery. I have no patience to manually reupload all the galleries via java upload, etc. But simply reuploading them via ftp... That's doable :P


Title: Re: 0 error - invalid parrent ID
Post by: winnetouch on 06-05-2013 18:39:29
Ok... I got in contact with our server provider... He told me he changed the tmp folder locations that's why some other stuff wasn't working (I tried reinstalling joomgallery), but when we solved that issue the gallery still won't let me upload images. It still gives me 0 error- invalid parrent ID. It creates the category and uploads one image but after that it aborts the upload. It also isn't a space issue since we have more than enough.


Title: Re: 0 error - invalid parrent ID
Post by: winnetouch on 07-05-2013 19:59:48
Anyone? I'm not going to give FTP acces to someone that I don't know so that option is out of the question...


Title: Re: 0 error - invalid parrent ID
Post by: Chraneco on 07-05-2013 20:38:12
Hi,

you said that you reinstalled JoomGallery. If the problem still persists now the reinstallation was not successful.
After uninstalling you have to clean the database completely from JoomGallery.

Regards
Chraneco


Title: Re: 0 error - invalid parrent ID
Post by: winnetouch on 08-05-2013 21:54:25
You were right... I reinstalled joomgallery again and everything worked fine... Then what I did was replace the new tables in MySql with the ones I exported from the old install. And the same error poped up. So something has to be wrong with the tables not joomgallery itself.


Title: Re: 0 error - invalid parrent ID
Post by: winnetouch on 08-05-2013 22:17:15
Ok... Something new... I just figured out I can make a category as a standalone but can't assign it to a parent category and I'm pretty sure there's something wrong with the joomgallery_catg table. I've tried switching this table out with a fresh table and the fresh table worked fine... When I put this table back in the error poped up again. I think this should make things easier since I at least narrowed down the problem.

While on the topic I had a problem a few weeks ago that was solved on these boards:
http://www.forum.en.joomgallery.net/index.php?topic=6083.msg19100#msg19100

Could it be possible that these are somehow connected?


Title: Re: 0 error - invalid parrent ID
Post by: Chraneco on 09-05-2013 12:43:56
Hi,

it's not possible to import database tables of JoomGallery from another Joomla! installation.
That's because JoomGallery is using the ACL of Joomla!, so the database tables of JoomGallery are connected to a core table of Joomla!.

If you import the tables into a new Joomla! installation this connection will be lost and so there are errors.

Regards
Chraneco


Title: Re: 0 error - invalid parrent ID
Post by: winnetouch on 10-05-2013 10:11:04
Yes I understand that but the same error pops up only when I interchange that one specific table. Fresh install or old install... That can't be a coincidence. I get that there are going to be errors with images and such but the categories worked fine unless I tried to make a new one...


Title: Re: 0 error - invalid parrent ID
Post by: Chraneco on 10-05-2013 12:11:21
Hi,

which specific table do you mean?

Regards
Chraneco


Title: Re: 0 error - invalid parrent ID
Post by: winnetouch on 12-05-2013 23:41:37
Ok... This is going to be really stupid now but the problem is solved. What I did was open the parent category and saved it without making any changes... Now everything works fine... All that hassle for such a simple solution is just crazy :P


Title: Re: 0 error - invalid parrent ID
Post by: Chraneco on 13-05-2013 11:11:31
Hi,

I didn't know of this solution. So, thank you very much for the feedback.

Regards
Chraneco


Title: Re: 0 error - invalid parrent ID
Post by: nickel on 13-03-2015 18:08:13
Hi,

it's not possible to import database tables of JoomGallery from another Joomla! installation.
That's because JoomGallery is using the ACL of Joomla!, so the database tables of JoomGallery are connected to a core table of Joomla!.

If you import the tables into a new Joomla! installation this connection will be lost and so there are errors.

Regards
Chraneco

Is this still true from JoomGallery 3.2?
So no way to move JoomGallery from one Joomla installation to another?


Title: Re: 0 error - invalid parrent ID
Post by: MrMusic on 20-03-2015 21:48:51
Here you will find a migration script: http://www.forum.en.joomgallery.net/index.php?topic=7130.0


Title: Re: 0 error - invalid parrent ID
Post by: nickel on 29-03-2015 14:07:58
Thanks, so I guess the script can be also used to move a JG-installation from one Joomla-installation to another?
Without changing any Joomla version?
Here you will find a migration script: http://www.forum.en.joomgallery.net/index.php?topic=7130.0


Title: Re: 0 error - invalid parrent ID
Post by: MrMusic on 31-03-2015 16:10:24
This Scripts works only for migration JoomGallery 2.1 to 3.x.
For 3.x -> 3.x you must modify the script (version check).