Database management package

Permalink
Created a package to manage the c5 mysql database...

Extract to "packages" and go to "Add functionality" and select "SQL Buddy".

Have fun!

1 Attachment

Remo
View Replies:
Mnkras replied on at Permalink Reply
Mnkras
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 at Permalink Reply
Remo
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 at Permalink Reply
pvs
Awesome Remo! :)
Remo replied on at Permalink Reply
Remo
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 at Permalink Reply 1 Attachment
pvs
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 at Permalink Reply
Remo
okay, submitted to the marketplace...
thanks
PhilipWitte replied on at Permalink Reply
PhilipWitte
Cooooooollll... thanks man
synlag replied on at Permalink Reply
synlag
Pretty useful Remo!!!

Thaaaaanks :)
olacom replied on at Permalink Reply
olacom
very nice!
ScottC replied on at Permalink Reply
ScottC
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 at Permalink Reply
Remo
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 at Permalink Reply
craftyCS
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


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 at Permalink Reply
Remo
check your log files
craftyCS replied on at Permalink Reply
craftyCS
excuse my ignorance but where would these reside?

;-(
Remo replied on at Permalink Reply
Remo
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 at Permalink Reply
rickxu
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.