+ Post New Thread
Results 1 to 2 of 2
EduGeek Joomla 1.5 Package Thread, Phoca gallery problems in Projects:; We've just upgraded our server to 2008 64bit, and have decided to go down the IIS7 route rather than WAMP. ...
  1. #1

    beeswax's Avatar
    Join Date
    Jul 2005
    Location
    England
    Posts
    2,285
    Thank Post
    285
    Thanked 225 Times in 153 Posts
    Rep Power
    131

    Phoca gallery problems

    We've just upgraded our server to 2008 64bit, and have decided to go down the IIS7 route rather than WAMP. I have been trying to install the Phoca Gallery this morning and I'm getting some errors, the main one of which seems to be that the jos_phocagallery_categories table hasn't been created. Could someone please help me with the correct syntax for creating this table?

  2. #2

    Join Date
    Jul 2008
    Location
    wyoming, usa
    Posts
    71
    Thank Post
    21
    Thanked 18 Times in 15 Posts
    Rep Power
    16
    Quote Originally Posted by beeswax View Post
    We've just upgraded our server to 2008 64bit, and have decided to go down the IIS7 route rather than WAMP. I have been trying to install the Phoca Gallery this morning and I'm getting some errors, the main one of which seems to be that the jos_phocagallery_categories table hasn't been created. Could someone please help me with the correct syntax for creating this table?
    I see the commands for creating the table in this file: com_phocagallery_v2.5.5\controllers\phocagalleryin stall.php

    Code:
    Line 29: DROP TABLE IF EXISTS `#__phocagallery_categories`;
    	Line 30: CREATE TABLE `#__phocagallery_categories` (
    	Line 144: -- ALTER TABLE `#__phocagallery_categories` ADD `hits` INT( 11 ) NOT NULL DEFAULT '0' AFTER `count` ;
    	Line 151: -- ALTER TABLE `#__phocagallery_categories` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `description` ;
    	Line 154: -- ALTER TABLE `#__phocagallery_categories` ADD `geotitle` varchar(255) NOT NULL default '' AFTER `hits` ;
    	Line 155: -- ALTER TABLE `#__phocagallery_categories` ADD `zoom` int(3) NOT NULL default '0' AFTER `hits` ;
    	Line 156: -- ALTER TABLE `#__phocagallery_categories` ADD `longitude` varchar(20) NOT NULL default '' AFTER `hits` ;
    	Line 157: -- ALTER TABLE `#__phocagallery_categories` ADD `latitude` varchar(20) NOT NULL default '' AFTER `hits` ;
    	Line 158: -- ALTER TABLE `#__phocagallery_categories` ADD `deleteuserid` text AFTER `hits` ;
    	Line 159: -- ALTER TABLE `#__phocagallery_categories` ADD `uploaduserid` text AFTER `hits` ;
    	Line 160: -- ALTER TABLE `#__phocagallery_categories` ADD `accessuserid` text AFTER `hits` ;
    Jeff

SHARE:
+ Post New Thread

Similar Threads

  1. Gallery
    By FN-GM in forum EduGeek Joomla 1.5 Package
    Replies: 5
    Last Post: 4th August 2009, 06:12 PM
  2. joomla image gallery
    By THERADIOTUBBY in forum Web Development
    Replies: 1
    Last Post: 6th July 2009, 07:35 PM
  3. Gallery Creator
    By uselessnerd in forum How do you do....it?
    Replies: 9
    Last Post: 4th August 2008, 12:32 PM
  4. Simple Gallery
    By Scotmk in forum Web Development
    Replies: 2
    Last Post: 5th March 2008, 12:14 PM
  5. [CLOSED] Missing Content: Gallery
    By BaccyNet in forum EduGeek.net Site Problems
    Replies: 2
    Last Post: 14th January 2008, 09:40 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •