next »

[perkiset]

personally I don't use quotes at all on those commands... if I am doing them via phpMyAdmin and require them then you must use the backquote ( ` ) instead of regular quotes.

Dink I was commenting on the difference between create/drop TABLE and create/drop DATABASE - you'll need super to add a database to the MySQL instance I believe.

I'm sorry but lots as flown around and I'm confused about exactly what is still the trouble... is it still when you click on the Views radio button?

[dink]

personally I don't use quotes at all on those commands... if I am doing them via phpMyAdmin and require them then you must use the backquote ( ` ) instead of regular quotes.

Tried the sql with backquotes instead.  Same resulting error statement.

Dink I was commenting on the difference between create/drop TABLE and create/drop DATABASE - you'll need super to add a database to the MySQL instance I believe.

I can add a database via the mySql section of cPanel.

I'm sorry but lots as flown around and I'm confused about exactly what is still the trouble... is it still when you click on the Views radio button?

When I try click on the views radio button, then click the 'add' icon, I get the default view name, click ok, then get this error:

Error: ANY command denied to user 'dink@localhost' for table 'preferences'

Sorry to be such a bother, brother.

[perkiset]

When I try click on the views radio button, then click the 'add' icon, I get the default view name, click ok, then get this error:

Error: ANY command denied to user 'dink@localhost' for table 'preferences'

Sorry to be such a bother, brother.

Tisn't a bother, my brother from another mother.

AHA, is the word of the day here, I missed the "New" button click...

Here's the code from that portion of the handler:

case 'view':
   $sql = "CREATE VIEW $dbName.$newName AS SELECT * FROM phpmyide.preferences";
   break;

         

When I create the "default" view, I have to "tie it" to something, so I assumed that since phpmyide would be installed (at least at the moment) we could build a view against that database and the preferences table simply so I can "save" the new default view code. See, I actually create a dummy view and save it, then open it and let you edit it. This was the best way to work through a variety of GUI issues.

So I started playing around and had a D'oh moment... I can just select "nothing."

Please try this and I'll implement it immediately (works for me here):
Line 208 of ajax.scriptexplorer.php says

            $sql = "CREATE VIEW $dbName.$newName AS SELECT * from phpmyide.preferences";

change it to:
            $sql = "CREATE VIEW $dbName.$newName AS SELECT 0";

It is the only "CREATE VIEW" line in that code, so there shouldn't be any easy way to screw this up.

Thanks!

[dink]

Please try this and I'll implement it immediately (works for me here):
Line 208 of ajax.scriptexplorer.php says

            $sql = "CREATE VIEW $dbName.$newName AS SELECT * from phpmyide.preferences";

change it to:
            $sql = "CREATE VIEW $dbName.$newName AS SELECT 0";

Done deal.  HoooRaaay.  It workie works now.  Good work   

so there shouldn't be any easy way to screw this up.

Oh ye of little faith.   

I just made a cursory check to see that it's working.  I've got a line of extreme thunder-bumpers right over my right shoulder......so I'll be offline for a while.

Thanks again.  Oh, yeah.  You done good.

[thedarkness]

Sorry if I sold you a red herring Dinker.

Cheers,
td

[perkiset]

Sorry if I sold you a red herring Dinker.

Dude you're the juice. No worries ever at Perk's house.

[dink]

Sorry if I sold you a red herring Dinker.

Cheers,
td

Herring being one of my very fav baits for fresh water striped bass == no worries.  It's all good.

As always, thanks for your help.  I need it a lot.

[dink]

I think we have gotten past the major problem that started this thread.  I still have an issue with permissions, but think we would be better served if I start a new support thread for that.

All in favor?

The eyes have it. Cool.