By tcaduto on

I am having a issue with Drupal 4.7 and MySQL 5.22

When I install 4.7 on MySQL 5.22 the Navigation block disappears when I change the theme or I go to edit the blocks.

I then decided to try Drupal 5 RC1 on the same server and everything worked fine.

I then tried the 4.7 PGSQL support on a PG 8.2 server and the navigation block did not disappear.

I might have missed it, but I didn't see anything that said drupal 4.7 is not compatible with MySQL 5.x

When I installed I used the 4.1 MySQL Script as that was the highest version one in the database directory.

Thanks,

Tony Caduto
AM Software Design
Your best bet for MySQL and Postgresql Admin tools.
http://www.amsoftwaredesign.com

⋅ Categories: Drupal 4.7.x

Comments

deathgod’s picture

deathgod commented

I use 5.x and everything works fine, try reinstalling 4.7 with 5.22 and if its still the scenario maybe a good place to start is to check what is different between 5.22 and the rest 5.x, maybe waiting to see if other 5.22 people have the same problem is a good option as well. My 2 cents
------------------------------
Naruto - narutomonkey.net - Naruto Forums

vm’s picture

vm commented

http://www.drupal.org

Edit: these releases do not support PHP 5.2 yet, but the next minor releases will.

you may try installing to see if the patches already applied to the next minor release have solved the problem. http://drupal.org/drupal-4.7.x-dev

tcaduto’s picture

tcaduto commented

I am using the Dev version and it's still having the same problem.
I think I will just uninstall MySQL 5 and install 4 instead.

Tony Caduto
http://www.amsoftwaredesign.com
Home Of Lightning Admin for MySQL and Postgresql

vm’s picture

vm commented

my eyes need to move slower. I've tried to guide so many forum posts to the patches that came up because of PHP 5.2 that I never even saw you type MySQL multiple times. my apologies.

tcaduto’s picture

tcaduto commented

No problem.

Well, I downgraded to MySQL 4.1 (centos) and php 4 and I am still getting the same darn issue.
as soon as I change the theme or go to the blocks page the navigation block disappears.

I then restart the web server and go back to the page and the logon block is also gone, so I can't even log into the server after this happens.

None of this happens with Drupal 5 RC1, I don't want to run that though because all the modules I want to use are not ported yet.

There is nothing in the logs either, I am about ready to give up on this install.

Does anyone else have Drupal 4.7 running on CentOS 4.4?

I have tried the latest 4.7 release and the dev release and it happens on both. I have everything setup and I followed the install directions to the letter.

Tony Caduto
http://www.amsoftwaredesign.com
Home Of Lightning Admin for MySQL and Postgresql

voipfc’s picture

voipfc commented

What is the output from the PHP, MySQL and Drupal error logs?

Such reports without any info from the logs (if they contain any) don't help much.

Al least they will be of help if there some problems ahead.

tcaduto’s picture

tcaduto commented

Thanks everyone.
It turned out to be a mysql permission problem.

I had created the database remotely using Lightning Admin and that cause the permissions to be set to
'drupal_user'@'%' instead of 'drupal_user@'localhost'

Tony Caduto
http://www.amsoftwaredesign.com
Home Of Lightning Admin for MySQL and Postgresql