Block Requests

 

Mnkras replied on Jan 3, 2010 at 8:02 pm Permalink Reply

what exactly does it do? also on install

Fatal error: Class 'SinglePage' not found in /mounted-storage/home115c/sub007/sc66353-ZWZK/c54/packages/remo_sqlbuddy/controller.php on line 23

Remo replied on Jan 4, 2010 at 2:32 am Permalink Reply

You probably have to add these lines to the controller (install method)

Loader::model('collection_types');
      Loader::model('single_page');

it adds sqlbuddy to the dashboard and automatically connects to the c5 database. I've got a few projects where I often have to access the database and this is nice because I only need the c5 user, one password less to remember..

pvs replied on Jan 4, 2010 at 3:22 am Permalink Reply

Awesome Remo! :)

Remo replied on Jan 4, 2010 at 4:47 am Permalink Reply

Do you think it might be useful to have in the marketplace?

I would have to do some tests, not sure if the iframe resize method I've used works well. It's ugly for sure (:

Anyone fancy to create a nice database icon with rounded corners?

pvs replied on Jan 4, 2010 at 5:10 am Permalink Reply 1 Attachment

I think it is... I always have a phpmyadmin window or tab open when i do development..
About the icon, I found this, (check attachments) onhttp://wefunction.com/2008/07/function-free-icon-set/... . Will that do? its free ;)

Remo replied on Jan 4, 2010 at 6:33 am Permalink Reply

okay, submitted to the marketplace...
thanks

PhilipWitte replied on Jan 7, 2010 at 7:40 pm Permalink Reply

Cooooooollll... thanks man

synlag replied on Jan 8, 2010 at 1:13 am Permalink Reply

Pretty useful Remo!!!

Thaaaaanks :)

olacom replied on Jan 14, 2010 at 11:30 pm Permalink Reply

very nice!

ScottC replied on Jan 15, 2010 at 1:05 pm Permalink Reply

pretty sweet. The zipped version above is missing the Loader::model('single_page') which Remo mentioned below.

This is a pretty cool package, great idea :)

-Scott

Remo replied on Jan 17, 2010 at 5:25 pm Permalink Reply

Thanks Scott! I submitted it, but it doesn't perform well on Andrew's server and he wanted me to restrict it to a single database.. This is unfortunately not that easy without touching sql buddy (I'd like to keep sql buddy as it is to allow easy updates).

I'm probably going to publish it somewhere else but I wanted to wait for Andrew's feedback first.

craftyCS replied on Jan 17, 2010 at 8:27 pm Permalink Reply

Hi Remo,
This package sounds Ideal for my purposes and I have installed it after adding in the code you mentioned above in the top level controller.php like so:

<?php
defined('C5_EXECUTE') or die(_("Access Denied."));
class RemoSqlbuddyPackage extends Package {
   protected $pkgHandle = 'remo_sqlbuddy';
   protected $appVersionRequired = '5.3.3';
   protected $pkgVersion = '1.0';
   public function getPackageDescription() {
      return t("Installs the SQL Buddy package.");
   }
   public function getPackageName() {
      return t("SQL Buddy");
   }
   public function install() {
      $pkg = parent::install();
      // install pages

Viewing 15 lines of 22 lines. View entire code block.

 
<?php
 
defined('C5_EXECUTE') or die(_("Access Denied."));
 
class RemoSqlbuddyPackage extends Package {
 
   protected $pkgHandle = 'remo_sqlbuddy';
   protected $appVersionRequired = '5.3.3';
   protected $pkgVersion = '1.0';
 
   public function getPackageDescription() {
      return t("Installs the SQL Buddy package.");
   }
 
   public function getPackageName() {
      return t("SQL Buddy");
   }
 
   public function install() {
      $pkg = parent::install();
 
      // install pages
     Loader::model('collection_types');
      Loader::model('single_page'); 
      $sp1 = SinglePage::add('/dashboard/remo_sqlbuddy', $pkg);
      $sp1->update(array('cName'=>t('SQL Buddy'), 'cDescription'=>t('Database management.')));
 
   }
}
 
?>
 

but when I go to the dashboard and click on the left hand nav for sqlbuddy I get the following error:

500 Internal Server Error

The page cannot be displayed.

Return to home page.

I know this isn't an official release and I'm being rather cheeky asking for support on installing it but is there somehting obvious I haven't done?

cheers
Paul

Remo replied on Jan 18, 2010 at 3:36 am Permalink Reply

check your log files

craftyCS replied on Jan 19, 2010 at 8:08 pm Permalink Reply

excuse my ignorance but where would these reside?

;-(

Remo replied on Jan 20, 2010 at 2:58 am Permalink Reply

It's your server, not mine!

Often in /var/log/apache2 .. but there are tons of situations where you can't find them there

rickxu replied on Jun 15, 2010 at 11:27 am Permalink Reply

Check your server log Paul.

I'd guess it's the file permission issue. Try to change from 0777 to 0755 or even 0644 if you just installed the package.