next »

[dink]

Funny thing.  I never had the problem you guys outlined.  Prolly because I'm a just a leeetle bit paranoid.  (Perk taught me)

When I set up the ide, I pass protected the directory.  So when I type in the url for the ide I get a login box.  As soon as the js starts to load, I get a login box for cPanel (which is where my phpadmin loads from).  When linux verifies that I'm supposed to be there, the ide home page is ready for my stuff.

[rsevero]

So the patch, for those reading along, is to go ahead and log into phpMyAdmin, then go to the URL for phpMyIDE again because its the login screen that is causing the bounce.

Unfortunatelly I don't have to login in phpMyAdmin (my phpMyAdmin config doesn't require a login) but still having the bounce to phpMyAdmin problem.

Any ideas?


Rodrigo Severo

[perkiset]

I think there are some versions of phpMyAdmin that did some frame busting, and that's why it bounces out.

Is this *every* time you load phpMyIDE? So you can't see the phpMyIDE page because phpMyAdmin pulls up over it? Would you please let me know which version of phpMyAdmin you're using and on what browser?

Thanks!

[cafescott]

Hey Perk,

I'd like to reopen this thread as i can't get phpMyIDE to work anymore.

After finishing my stored procedures I installed another MySQL data dump.  This wiped out all my existing tables (except for the ones that phpMyIDE) makes, and recreated them.  I tried to make sure that all the routines were retained.

With the new data dump, i attempt to view my data objects.  Using phpAdmin, I can see the tables and the data that they have.

For the routines, they show up in phpAdmin's list.  However, if I click on the "structure" icon next to the name, all i see is the command 'drop' {my procedure name}.  (I can't recall if phpAdmin used to let me see the structures of the routines.)

Using phpMyIDE, I can't get my MySQL database to show up under "information schema" on the far left.  So, first I reran the testinstall.php.  The output showed "OK" for everything.  Then I ran the build2.php that you helped me to get running (this thread was about that event).  The output created the tables that phpMyIDE uses.  It also had output like this:

select "Built triggers";
select "All Done";
Query Executed
Store Result Failed
Error (1):
Store Result Failed
Error (1):
Store Result Succeeded
Built long_commands
Store Result Failed
...
Built triggers
Store Result Succeeded
All Done
Process Completed

However, I still can't get my database to show up under "Information Schema" after I click the refresh button.

Do you have any advice?

thanks,

[perkiset]

Hey CScott -

After finishing my stored procedures I installed another MySQL data dump.  This wiped out all my existing tables (except for the ones that phpMyIDE) makes, and recreated them.  I tried to make sure that all the routines were retained.

Sorry mang, I have no idea what you just said or did there.

With the new data dump, i attempt to view my data objects.  Using phpAdmin, I can see the tables and the data that they have.

For the routines, they show up in phpAdmin's list.  However, if I click on the "structure" icon next to the name, all i see is the command 'drop' {my procedure name}.  (I can't recall if phpAdmin used to let me see the structures of the routines.)

phpMyAdmin will not let you view stored code - you can, however, type "show create procedure mydb.procname" and it will get spit out like you had selected rows from a table. You should try that and see if you can see your procedures. You can also say "show procedure status where like '%'" to see all procedures in a certain database.

Using phpMyIDE, I can't get my MySQL database to show up under "information schema" on the far left.  So, first I reran the testinstall.php.  The output showed "OK" for everything.  Then I ran the build2.php that you helped me to get running (this thread was about that event).  The output created the tables that phpMyIDE uses.  It also had output like this:

select "Built triggers";
select "All Done";
Query Executed
Store Result Failed
Error (1):
Store Result Failed
Error (1):
Store Result Succeeded
Built long_commands
Store Result Failed
...
Built triggers
Store Result Succeeded
All Done
Process Completed

However, I still can't get my database to show up under "Information Schema" after I click the refresh button.

Looks like a permissions problem. Is this on a new machine? Is phpMyIDE on the same machine? Are you pointing at it from a different machine? Way too many questions to just give you an answer.

I'd go back to the testinstall.php routine and see what it reports.

[geekct]

Yep it is a frame breaker.

Do a search on phpMyAdmin (version 2.11.7) on

Code:

window.top.location.href=location;

.

you should get it in the ./scripts/setup.php and the ./libraries/auth/cookie.auth.lib.php of the phpMyAdmin root.

I commented it out. works good. I'm on an internal ONLY server so I didnt take the time to think about security but I think it could be bad. Also won't work on hosted platforms of phpMyAdmin. 

PS love phpMYIDE.

[perkiset]

Nice geekct - thanks much for the tip and the compliment I've been working on a maintenance release for quite a while now and I'll add you to the list for when it's ready.

Welcome to The Cache BTW.

[408wij]

I'm sorry, what's the resolution to this? I just installed phpmyide and am suffering from this problem of bouncing to phpmyadmin.

[perkiset]

Quickest easiest way to do it is to disconnect phpMyAdmin from it. There's a bouncer in the beginning of some of the versions of phpMyAdmin code that will pop out of the frame and redirect.

If you're intrepid you could look at the front of your phpMyAdmin code to see where the framebuster is and halt it - but that's definitely not for the n00b.