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.