You are here: Index

Forums

Phpnuke Database Forum

home post reply threaded view rules help

Forum List

Modules and blocks problems

Mods and blocks

<< Start < Prev 1 2 3 4 5 6 Next > End >>

Guardian
User

Platinum Boarder

Posts: 51

Karma: 3

Re:"Access Denied" error message - 2007/02/23 19:27 This is something I have come across with the 'change key' for some reason it does get executed but never shows up when you run the compare again so just ignore it.

| | The administrator has disabled public write access.

Banzai
User

Expert Boarder

Posts: 29

Karma: 0

Re:"Access Denied" error message - 2007/02/23 20:04 Let me just check...

You mean if, besides the Delete Tables section, those are the only instructions I have on the compare page, I shouldn't worry because the DB is now fully compatible?

And while you're at it, why the syntax error? In fact, is there actually a syntax error?

Again, thanks for your support!

Post edited by: Banzai, at: 2007/02/23 20:06

| | The administrator has disabled public write access.

Guardian
User

Platinum Boarder

Posts: 51

Karma: 3

Re:"Access Denied" error message - 2007/02/23 20:16 The script throws that out as it doesn't have a pre set error message indicating what the issue really is - thats one of the reasons I released this 'as is' for mostly developers to work on.

The error is generated either because the key is already set but the script just doesnt know how to handle it properly or the table is in use which prevents it from getting changed.

If you are in any doubts at all you can do what I did and just copy the sql code, paste it into phpmyadmin and run it, then the message will disappear and running compare.php will show eveything is cleared.

| | The administrator has disabled public write access.

Banzai
User

Expert Boarder

Posts: 29

Karma: 0

Re:"Access Denied" error message - 2007/02/23 22:49 Thing is I did use phpmyadmin to run the sql code and it was in phpmyadmin I got that error...

If you're wiling to spare a couple of minutes, I can give you access to this new test database or send you a print screen so you can see/test the code and see the error. Or, if you have any better sugestion, let me know

Post edited by: Banzai, at: 2007/02/23 22:51

| | The administrator has disabled public write access.

Guardian
User

Platinum Boarder

Posts: 51

Karma: 3

Re:"Access Denied" error message - 2007/02/23 23:33 Sorry my wife just got back from her camping trip in the mountains on the Czech republic / Polish border so I'm not going to have any free time for a while now.

| | The administrator has disabled public write access.

Banzai
User

Expert Boarder

Posts: 29

Karma: 0

Re:"Access Denied" error message - 2007/03/02 20:21 I think I just solved my DB problem�

When looking at the compare.php, in the section �Columns to Alter�, I had a bunch of lines with SQL instructions to run. All those instructions had among them a line with the �Change Key� command. First I tried running them, by using the [Execute SQL] button that appears next to each instruction, but that didn�t work, because once I ran one instruction it didn�t disappear from the compare.php page� So, I thought running the instructions using the phpmyadmin. Using the phpmyadmin, I copy/paste the instruction and tried to run it, but I kept getting the SQL syntax I mentioned earlier.
At this point I thought I couldn�t do anything more without help due to my extremely limited technical knowledge. That�s when my noobish mind came up with a noobish idea� I opened two phpmyadmin windows, each with a database I was comparing. Then I opened a table that compare.php was saying there were differences between the two databases. When looking at them and at their structure, I noticed that the old DB had a message below the fields saying something like �Primary and Index should/must not be assigned to same field�, and the new database had nothing like this. So, I decided to risk it and change the old DB manually and delete the Index line, leaving only the Primary line, so it would stay the same as the new DB.

Fact is, that after this change, the SQL instruction disappeared from the compare.php page and apparently the error was gone�
So, I did this for all the instructions on the Alter Columns section and now I have no errors at all as you can see by checking this url: http://www.new.dancefactor.net/db_util/compare.php.

I don�t really know what that means, but I realized that the DB Compare Utility was appointing differences between the databases, but the SQL instruction it was showing to run was, in fact, not correct.
Maybe it needs some minor adjustments (if anyone is interested in making them) to work even better, I don�t know. But anyway I wanted to share this information with you.

| | The administrator has disabled public write access.