RSGallery2 Support Forums
Welcome, Guest. Please login or register.

Login with username, password and session length
  Home    Forum    Help    Search    Login    Register  
*
News : December 04, 2008, 10:43:55 pm
+  RSGallery2 Support Forums
|-+  RSgallery2 support forums
| |-+  RSgallery2 modules and plugins (mambots) (Moderators: Jonah, Tomislav Ribicic, Daniel Tulp, Ronald Smit)
| | |-+  RSGallery component for joomFish problem
Advanced search
  « previous next »
Pages 1
Author
Topic: RSGallery component for joomFish problem  (Read 6755 times)
« on: November 15, 2007, 01:32:15 pm »
Kris Offline
Newbie
*
Posts: 2



Hi, after installing the RSGallery component for joomfish I'm trying to open RSGallery Catagories in Joomfish. The following error is being given:

Code:
DB function failed with error number 1146
Tabel '20336joom.jos_rsgallery2_cats' bestaat niet SQL=SELECT c.id, c.catname as title, c.catname, c.description, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.name as language, jfc.reference_id as jfc_refid FROM jos_rsgallery2_cats as c LEFT JOIN jos_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='catname' AND jfc.reference_table='rsgallery2_cats' AND jfc.language_id=3 LEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.id ORDER BY c.catname LIMIT 0, 30

Wo knows how to resolve this?

Cheers,
Kris
Logged
 
Reply #1
« on: November 15, 2007, 01:49:39 pm »
Kris Offline
Newbie
*
Posts: 2



Nevermind.

Had to change: rsgallery.categories.xml

From:
Code:
<?xml version="1.0" ?>
<joomfish type="contentelement">
  <name>RSGallery Categories</name>
  <author>Geraint Edwards</author>
  <version>1.0</version>
  <description>Definition for RS Gallery</description>
  <reference>
  <table name="rsgallery2_cats">
  <field type="referenceid" name="id" translate="0">ID</field>
<field type="titletext" name="catname" translate="1">Title</field>
<field type="textarea" name="description" translate="1">Description</field>
  </table>
  </reference>
</joomfish>

Into:

Code:
<?xml version="1.0" ?>
<joomfish type="contentelement">
  <name>RSGallery Categories</name>
  <author>Geraint Edwards</author>
  <version>1.0</version>
  <description>Definition for RS Gallery</description>
  <reference>
  <table name="rsgallery2_galleries">
  <field type="referenceid" name="id" translate="0">ID</field>
<field type="titletext" name="name" translate="1">Title</field>
<field type="textarea" name="description" translate="1">Description</field>
  </table>
  </reference>
</joomfish>
Logged
 
Reply #2
« on: January 25, 2008, 10:53:59 am »
mirjam Offline
Dev Team
Newbie
*
Posts: 33



Works like a charm!

Once I noticed that I had to change two lines instead of one   Wink
rsgallery2_cats -> rsgallery2_galleries
catname -> name

Joomla 1.0.13; RSGallery 1.13.2/3; JoomFish 1.8.2
Logged
 
Print  Pages 1
« previous next »
Jump to: