Phoca Forum

Posted: **08 Oct 2011, 19:18**

Hello Jan,

i updated my phocagallery to the new beta version from 3.0.2
after that i tried to tests the functions, but i get an error

Joomla!

Code: Select all

500 - Es ist ein Fehler aufgetreten

Tabelle 'db_prefix_PhocaGallery_tags' existiert nicht SQL=SELECT a.*,uc.name AS editor FROM `photos_PhocaGallery_tags` AS a LEFT JOIN photos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc Tabelle 'db_prefix_PhocaGallery_tags' existiert nicht SQL=SELECT a.*,uc.name AS editor FROM `photos_PhocaGallery_tags` AS a LEFT JOIN photos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc LIMIT 0, 20 Tabelle 'db_prefix_PhocaGallery_tags' existiert nicht SQL=SELECT a.*,uc.name AS editor FROM `photos_PhocaGallery_tags` AS a LEFT JOIN photos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc Tabelle 'db_prefix_PhocaGallery_tags' existiert nicht SQL=SELECT a.*,uc.name AS editor FROM `photos_PhocaGallery_tags` AS a LEFT JOIN photos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc

I think the table is missing, i can create it. But is this all what i should do?

Posted: **09 Oct 2011, 15:06**

Hi, yes, if there was a problem while installing the table you need to add it manually, you will find sql query in install.sql.bak file - in root of the ZIP installation file.

Jan

Posted: **11 Oct 2011, 13:15**

okay i checked the database and the script and i see the table exists, but there is a little error with the tablename.

In the code above you see the table name written as PhocaGallery_tags but in the database the table name is phocagallery_tags without the capital Letter P & G.

i fixed the tablename in my database, perhaps i must changed it back after the betatest

Posted: **12 Oct 2011, 17:52**

Hi, testing now, all characters in installation script have lower cases

so yes, the characters should have lower cases all, try to change them.

Jan

Posted: **13 Oct 2011, 00:21**

Hi, found it, was problem in code not in installation queries.

Thank you very much for the info.

PhocaGallery_tags fixed in 3.1.0 RC.

Jan

Phoca Forum

Beta 3.1.0

Beta 3.1.0

Re: Beta 3.1.0

Re: Beta 3.1.0

Re: Beta 3.1.0

Re: Beta 3.1.0