Fields with * are mandatory

Dios - Do It Open Source
 

Discussion fbgallery

This page is dedicated to fbgallery:
#4
Mark Moltzan writes in: 2013-11-11 20:32:44
Subject: DB error help - thanks
0
0
avatar
Looking for help with fbgallery db error.

Installed FBG.

I don't use SQL table prefixes and ran the supplied SQL script after removing the table prefixes. I verified the tables are in the DB without the prefixes. 


put the widget in the sitecontroler.php

public function actionMMNP()
$this->widget('application.extensions.fbgallery.fbgallery');
$this->render('mmnp');
} // New Page

This is the MMNP view php.

<?php $this->pageTitle=Yii::app()->name. " | New Page"; ?>
<div class="faq-container">
<h1>New Page</h1>
</div>


Loaded the MMNP in browser and  threw this error...


CDbCommand::fetchAll() failed: SQLSTATE[42S02]: Base table or view not
found: 1146 Table 'hdnet.{{galleryconfig}}' doesn't exist. The SQL
statement executed was: SHOW COLUMNS FROM `{{galleryConfig}}`.

exception 'CDbException' with message 'The table "{{galleryConfig}}" for
active record class "GalleryConfig" cannot be found in the database.' in
C:\Webroot\QA_HD\framework\db\ar\CActiveRecord.php:2276
Stack trace:
#0 C:\Webroot\QA_HD\framework\db\ar\CActiveRecord.php(372):
CActiveRecordMetaData->__construct(Object(GalleryConfig))
#1
C:\Webroot\QA_HD\protected\extensions\fbgallery\libs\general\GalleryConfig.php(14):
CActiveRecord::model('GalleryConfig')
#2
C:\Webroot\QA_HD\protected\extensions\fbgallery\libs\general\conf.php(17):
GalleryConfig::model()
#3 C:\Webroot\QA_HD\protected\extensions\fbgallery\fbgallery.php(64):
conf->__construct()
#4 C:\Webroot\QA_HD\framework\web\CBaseController.php(140):
fbgallery->init()
#5 C:\Webroot\QA_HD\framework\web\CBaseController.php(165):
CBaseController->createWidget('application.ext...', Array)
#6 C:\Webroot\QA_HD\protected\controllers\SiteController.php(99):
CBaseController->widget('application.ext...')
#7 C:\Webroot\QA_HD\framework\web\actions\CInlineAction.php(50):
SiteController->actionMMNP()
#8 C:\Webroot\QA_HD\framework\web\CController.php(300):
CInlineAction->runWithParams(Array)
#9 C:\Webroot\QA_HD\framework\web\filters\CFilterChain.php(134):
CController->runAction(Object(CInlineAction))
#10 C:\Webroot\QA_HD\framework\web\filters\CFilter.php(41):
CFilterChain->run()
#11 C:\Webroot\QA_HD\framework\web\CController.php(1144):
CFilter->filter(Object(CFilterChain))
#12 C:\Webroot\QA_HD\framework\web\filters\CInlineFilter.php(59):
CController->filterAccessControl(Object(CFilterChain))
#13 C:\Webroot\QA_HD\framework\web\filters\CFilterChain.php(131):
CInlineFilter->filter(Object(CFilterChain))
#14 C:\Webroot\QA_HD\framework\web\CController.php(283):
CFilterChain->run()
#15 C:\Webroot\QA_HD\framework\web\CController.php(257):
CController->runActionWithFilters(Object(CInlineAction), Array)
#16 C:\Webroot\QA_HD\framework\web\CWebApplication.php(277):
CController->run('mmnp')
#17 C:\Webroot\QA_HD\framework\web\CWebApplication.php(136):
CWebApplication->runController('site/mmnp')
#18 C:\Webroot\QA_HD\framework\base\CApplication.php(158):
CWebApplication->processRequest()
#19 C:\Webroot\QA_HD\public_html\index.php(10): CApplication->run()
#20 {main} REQUEST_URI=/QA_HD/public_html/mmnp


db config

'db'=>array(
'connectionString' => DB_CONN_STRING,
'emulatePrepare' => true,
'username' => DB_USERNAME,
'password' => DB_PASSWORD,
'charset' => 'utf8',
),

DB table dump
-- phpMyAdmin SQL Dump
-- version 3.5.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 11, 2013 at 12:25 PM
-- Server version: 5.5.23
-- PHP Version: 5.3.10

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `hdnet`
--

DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `load_uniques`()
BEGIN
 DECLARE count INT DEFAULT 0;
 WHILE count < 5000 DO
   insert into challenge_enrollment_uid (unique_id) values (MD5(UUID()));
   SET count = count + 1;
 END WHILE;
END$$

DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `albums`
--

CREATE TABLE IF NOT EXISTS `albums` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `pid` int(4) NOT NULL,
  `url` text NOT NULL,
  `translations` text NOT NULL,
  `imgsOrder` text NOT NULL,
  `imgsInfo` text NOT NULL,
  `cover` varchar(256) NOT NULL,
  `itemInfoShop` text NOT NULL,
  `author` varchar(128) NOT NULL,
  `tags` varchar(256) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ;

-- --------------------------------------------------------

--
-- Table structure for table `collections`
--

CREATE TABLE IF NOT EXISTS `collections` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `pid` int(4) NOT NULL,
  `url` text NOT NULL,
  `translations` text NOT NULL,
  `albums` varchar(128) NOT NULL,
  `author` varchar(128) NOT NULL,
  `tags` varchar(256) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;

-- --------------------------------------------------------

--
-- Table structure for table `galleryconfig`
--

CREATE TABLE IF NOT EXISTS `galleryconfig` (
  `type` varchar(16) NOT NULL,
  `config` text NOT NULL,
  PRIMARY KEY (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `galleryconfig`
--

INSERT INTO `galleryconfig` (`type`, `config`) VALUES
('gallery', 'a:25:{s:8:"cssTheme";s:6:"simple";s:10:"thumbStyle";s:9:"landscape";s:10:"thumbWidth";i:160;s:10:"ratioThumb";d:0.6999999999999999555910790149937383830547332763671875;s:8:"imgWidth";i:900;s:7:"thWidth";i:200;s:7:"quality";i:75;s:7:"sharpen";i:20;s:7:"gFolder";s:9:"galleries";s:12:"keepOriginal";b:0;s:10:"useWysiwyg";b:1;s:9:"usedTitle";s:8:"filename";s:15:"predefinedTitle";s:114:"<strong>Title:</strong> Product title <br/><strong>Model:</strong> Product model<br/><strong>Price:</strong> $ 100";s:17:"editorCreateAlbum";b:1;s:13:"editorOfOther";b:1;s:23:"editorOperateCollection";b:1;s:18:"editorSeeAllAlbums";b:1;s:16:"coreScriptPosEnd";b:0;s:14:"isMultilingual";b:1;s:15:"defaultLanguage";s:2:"en";s:9:"languages";s:6:"en, ro";s:11:"isShopStyle";b:0;s:15:"hCollectionShop";b:1;s:23:"itemWidthCollectionShop";i:140;s:12:"itemInfoShop";s:61:"ProductID\nAvailability\nName\nModel\nPrice\nCoin\nVTA\nQuantity\nUrl";}'),
('album', 'a:8:{s:14:"showAlbumTitle";b:1;s:25:"showAlbumTitleDescription";b:1;s:13:"showAlbumTags";b:1;s:11:"thTitleShow";b:0;s:10:"useInfoBox";b:1;s:15:"itemsOnPaginate";i:12;s:11:"itemsOnLine";i:4;s:12:"hideTooltips";b:0;}'),
('fancybox', 'a:10:{s:13:"titlePosition";s:6:"inside";s:13:"easingEnabled";b:1;s:12:"mouseEnabled";i:1;s:12:"transitionIn";s:7:"elastic";s:13:"transitionOut";s:7:"elastic";s:7:"speedIn";i:600;s:8:"speedOut";i:200;s:11:"overlayShow";b:1;s:5:"width";i:350;s:6:"height";s:4:"auto";}'),
('uploader', 'a:6:{s:3:"max";i:-1;s:6:"accept";s:16:"jpg|png|gif|jpeg";s:12:"unique_names";b:0;s:13:"max_file_size";i:3;s:16:"pluploadLanguage";s:4:"auto";s:8:"runtimes";s:12:"html5, flash";}'),
('collection', 'a:7:{s:19:"showCollectionTitle";b:1;s:25:"showCollectionDescription";b:1;s:18:"showCollectionTags";b:1;s:18:"combinedAlbumsTags";b:1;s:13:"showCoverName";b:1;s:20:"showCoverDescription";b:1;s:13:"showCoverTags";b:1;}');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

#3
Soumya Dev writes in: 2012-10-12 09:30:09
Subject: FB gallery Error
1
0
avatar
Followed all the instructions to install the FBgallery extension. Created the database. But as I call the gallery the following PHP Error pops up

Non-static method FBAccess::setLevelAccess() should not be called statically, assuming $this from incompatible context

What should be done to overcome this error???
#2
Ankit Modi writes in: 2012-07-18 09:32:14
Subject: Error
1
0
avatar
Hello,

I have downloaded the extension and just put the 
<?php $this->widget('application.extensions.fbgallery.fbgallery');?> in my code file but i getting the below error..

Error 500

Non-static method FBAccess::setLevelAccess() should not be called statically, assuming $this from incompatible context

please help me ...
#1
Karmraj Zala writes in: 2012-05-04 14:28:38
Subject: Steps to create album and collection cover using fbgallery
0
0
avatar
Hello,

I have install fbgallery extenstion in my application. But i can not create multiple as well as collection in fbgallery.

Also, admin user only can create fbgallery in application.

I am new in Yii framework so please guild me some steps to create fbgallery.

Thanks,
Karmraj Zala
Add comment
Citation will be added automatically at the top of your message!